01Relates to the patient
INVOICE matches CLAIMS.INVOICE on a row of CLAIMS that relates to the patient
Single-patient export: the patient's rows.
02References
INVOICE→CLAIMS.INVOICEINSURANCE_ID,COMPANY_CODE→INSURANCE_POLICIES.INSURANCE_ID,COMPANY_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | INVOICE PK | integer | int | no | |
| 2 | CLAIM_PAYOR_SEQUENCE PK | integer | int | no | |
| 3 | PAT_RELATION_TO_INSURED | integer | int | yes | |
| 4 | COMPANY_CODE | string | varchar(20) | no | |
| 5 | INSURANCE_ID | string | varchar(25) | no | |
| 6 | CLAIM_BILLING_CODE | string | char(1) | yes | |
| 7 | AUTHORIZATION_NUMBER | string | varchar(40) | yes | |
| 8 | AUTH_LINE_NO | integer | int | yes | |
| 9 | FROM_DATE | datetime | smalldatetime | yes | |
| 10 | NUMBER_USED | integer | int | yes | |
| 11 | REFERRAL_NUMBER | string | varchar(15) | yes | |
| 12 | REF_LINE_NO | integer | int | yes | |
| 13 | AUTH_OVERRIDE | string | char(1) | yes | |
| 14 | REF_OVERRIDE | string | char(1) | yes |