01Relates to the patient
PATIENT_ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | CLAIM_BATCH_NUMBER PK | integer | int | no | |
| 2 | INVOICE PK | integer | int | no | |
| 3 | PROCESS_DATE PK | datetime | datetime | no | |
| 4 | PATIENT_ACCOUNT | string | varchar(20) | yes | |
| 5 | AGE | integer | int | yes | |
| 6 | SEX | string | char(1) | yes | |
| 7 | DATE_OF_BIRTH | datetime | datetime | yes | |
| 8 | FROM_DATE | datetime | datetime | yes | |
| 9 | THRU_DATE | datetime | datetime | yes | |
| 10 | TYPE_OF_BILL | string | varchar(3) | yes | |
| 11 | LEN_STAY | integer | int | yes | |
| 12 | TOTAL_CHARGES | decimal | decimal(19,4) | yes | |
| 13 | RATE_CODE | string | varchar(4) | yes | |
| 14 | USER_KEY_1 | string | varchar(10) | yes | |
| 15 | USER_KEY_2 | string | varchar(10) | yes | |
| 16 | SCHED_BEGIN_DATE | datetime | datetime | yes | |
| 17 | SCHED_END_DATE | datetime | datetime | yes | |
| 18 | PRINC_DIAG | string | varchar(5) | yes | |
| 19 | SECNDRY_DIAG1 | string | varchar(5) | yes | |
| 20 | SECNDRY_DIAG2 | string | varchar(5) | yes | |
| 21 | SECNDRY_DIAG3 | string | varchar(5) | yes | |
| 22 | SECNDRY_DIAG4 | string | varchar(5) | yes | |
| 23 | SECNDRY_DIAG5 | string | varchar(5) | yes | |
| 24 | GROUPER_VERSION | string | varchar(12) | yes | |
| 25 | CLAIM_PROCESSED_WARNING | string | varchar(10) | yes | |
| 26 | NPI | string | varchar(13) | yes | |
| 27 | PAT_STATUS | string | varchar(2) | yes | |
| 28 | PROV_ZIP | string | varchar(9) | yes | |
| 29 | PAT_ADMIT_ORG | string | char(1) | yes | |
| 30 | CLAIM_PROC_FLAG_1 | string | char(10) | yes | |
| 31 | CLAIM_PROC_FLAG_2 | string | char(1) | yes |