01Relates to the patient
INVOICE matches ACCOUNTS_RECEIVABLE.INVOICE on a row of ACCOUNTS_RECEIVABLE that relates to the patient
Single-patient export: the patient's rows.
02References
DIAG_1→DIAGNOSIS_CODES.DIAG_CODEDIAG_2→DIAGNOSIS_CODES.DIAG_CODEDIAG_3→DIAGNOSIS_CODES.DIAG_CODEDIAG_4→DIAGNOSIS_CODES.DIAG_CODEINVOICE→ACCOUNTS_RECEIVABLE.INVOICEICD_PROC_CODE,ICD_CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODPROC_CODE,CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODPROVIDER_CODE→PROVIDERS.PROVIDER_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | INVOICE PK | integer | int | no | |
| 2 | LINE_NO PK | integer | int | no | |
| 3 | PROC_CODE | string | varchar(20) | yes | |
| 4 | DESCRIPTION | string | varchar(40) | yes | |
| 5 | PROVIDER_CODE | string | varchar(20) | yes | |
| 6 | DATE_OF_SERVICE | datetime | datetime | yes | |
| 7 | DATE_OF_SERVICE_THRU | datetime | datetime | yes | |
| 8 | ICD_PROC_CODE | string | varchar(20) | yes | |
| 9 | ICD_CODING_METHOD | string | varchar(5) | yes | |
| 10 | CODING_METHOD | string | varchar(5) | yes | |
| 11 | DIAG_1 | string | varchar(8) | yes | |
| 12 | DIAG_2 | string | varchar(8) | yes | |
| 13 | DIAG_3 | string | varchar(8) | yes | |
| 14 | DIAG_4 | string | varchar(8) | yes | |
| 15 | UNITS | decimal | numeric(10,2) | yes |