01Relates to the patient
ACCOUNT is the patient's ACCOUNT; or INSURANCE_ID + COMPANY_CODE matches PAT_INSURANCES.INSURANCE_ID + PAT_INSURANCES.COMPANY_CODE on a row of PAT_INSURANCES that relates to the patient
Single-patient export: the patient's rows.
02References
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | INSURANCE_ID PK | string | varchar(25) | no | |
| 2 | COMPANY_CODE PK | string | varchar(20) | no | |
| 3 | POLICY_EFFECTIVE_DATE | datetime | datetime | yes | |
| 4 | POLICY_THRU_DATE | datetime | datetime | yes | |
| 5 | ACCOUNT | string | varchar(12) | no | Account of the policy holder (subscriber), who may be someone other than the patient. |
| 6 | GROUP_NO | string | varchar(20) | yes | |
| 7 | GROUP_NAME | string | varchar(33) | yes | |
| 8 | EMP_NAME | string | varchar(30) | yes | |
| 9 | INS_TYPE_CODE | string | varchar(2) | yes | |
| 10 | ENTRY_USER_ID | string | varchar(20) | no | |
| 11 | ENTRY_DATE | datetime | datetime | no | |
| 12 | CHANGE_USER_ID | string | varchar(20) | no | |
| 13 | CHANGE_DATE | datetime | datetime | no | |
| 14 | EXPECTED_PERCENT | decimal | numeric(7,4) | yes | |
| 15 | USE_PLAN | string | char(1) | no | |
| 16 | REPL_COMPANY_CODE | string | varchar(20) | yes | |
| 17 | CARVE_OUT | string | char(1) | no | |
| 18 | SEQUENCE_NUMBER | string | varchar(10) | yes | |
| 19 | NOTES | string | text | yes | |
| 20 | DEDUCTIBLE | decimal | decimal(19,4) | yes | |
| 21 | RECERT_DATE | datetime | datetime | yes | |
| 22 | DED_MONTH | integer | int | yes | |
| 23 | DEDUCTIBLE_AMOUNT | decimal | money | yes |