dbTalk Databases Forums  

Hipaa 834

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Hipaa 834

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Hipaa 834 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
greenmtnsun
 
Posts: n/a

Default Hipaa 834 - 03-25-2008 , 10:14 AM





I have been assigned to get an EDI written for enrollment of health insurance
from my HR system to a major insurance carrier; in fact, I need to create
about 5 Hipaa 834 files for other insurance companies too. They want me to
send them data in a HIPAA 834 file format which I believe is in XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?

Reply With Quote
  #2  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM





On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #3  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #4  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #5  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #6  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #7  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #8  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
  #9  
Old   
jeff
 
Posts: n/a

Default Re: Hipaa 834 - 03-27-2008 , 08:57 AM


On 3/25/2008 11:14:03 AM, greenmtnsun wrote:
Quote:
I have been assigned to get an EDI written for enrollment of health
insurance from my HR system to a major insurance carrier; in fact, I need
to create about 5 Hipaa 834 files for other insurance companies too. They
want me to send them data in a HIPAA 834 file format which I believe is in
XML.

Has anyone developed a hipaa solution through SSIS?

I can see that there is a BizTalk way of going at this but before I ask my
supervisor for a huge chunk of cash, I want to exhaust my existing options
and SSIS is my favorite one.

Any advice?
its not even close to xml
here is an example of the format:

ST*834*0001~BGN*00*1234*20001227*838*PT***2~N1*P5* *F1*954529603~INS*Y*18*021*28*A*E**FT~REF*0F*12345 6789~REF*1
L*G86W553~DTP*356*D8*20001220~NM1*IL*1*STEPHENS*MA RIE*V***34*123456789~PER*IP**HP*4152296748*WP4*415 2968732
~N3*123 MAIN STREET~N4*SAN

FRANCISCO*CA*94515~DMG*D8*19691017*F*M~HD*021**HLT *01A3*EMP~DTP*348*D8*20001220~LX*1~NM1*P3*1*FREDRI CKSO
N*STEVE****XX*1234567891*25~SE*17*0001~

no CR/LF, tons of rules and it wouldn't be much fun.
easist solution would be to purchase software to do the converting for you

I had the 'joy' of converting NSF2.01 to 837/835 [sending/receiving]. Have
fun


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top