HI Everyone,
I am importing a 835 form of payments to a doctor. I want to be able to pull the data that I need from this form to put into the payment section of a table that I wrote.
I import the file from the clearinghouse. I have been able to identify the patient involved in each line by adding a field to the import and putting in the patient ID number, by having alpha copy the previous field.
Now I need to associate each line with a "line control number" which is a number that is assigned when the charge is sent out to the billing company. Unfortunately, this number is down about 6 lines in the file(and its position is not always the same number of lines down), as well as the billing date-so I cannot find a way to get this number into the previous lines. I have not found an operation that looks past the field it needs to fill in and then go back.
For example:
CLP*Patient ID #* Last Name*First Name*Ins ID#
SVC*HC:CODE*Charge*Paid
DTM*Date of Service
HL*Location
XX*Line Control Number
AMT*Amt Approved
I can assign the patient ID # to each line, but that does not help with linking this payment to a charge in the table-because there can be many open charges for the same patient. The line control number is unique to this charge, so that is the best way to link it.
Any suggestions are greatly appreciated
Debbie
I am importing a 835 form of payments to a doctor. I want to be able to pull the data that I need from this form to put into the payment section of a table that I wrote.
I import the file from the clearinghouse. I have been able to identify the patient involved in each line by adding a field to the import and putting in the patient ID number, by having alpha copy the previous field.
Now I need to associate each line with a "line control number" which is a number that is assigned when the charge is sent out to the billing company. Unfortunately, this number is down about 6 lines in the file(and its position is not always the same number of lines down), as well as the billing date-so I cannot find a way to get this number into the previous lines. I have not found an operation that looks past the field it needs to fill in and then go back.
For example:
CLP*Patient ID #* Last Name*First Name*Ins ID#
SVC*HC:CODE*Charge*Paid
DTM*Date of Service
HL*Location
XX*Line Control Number
AMT*Amt Approved
I can assign the patient ID # to each line, but that does not help with linking this payment to a charge in the table-because there can be many open charges for the same patient. The line control number is unique to this charge, so that is the best way to link it.
Any suggestions are greatly appreciated
Debbie
Comment