01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNTPROC_CODE,CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHOD
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | START_DATE PK | datetime | datetime | no | |
| 3 | END_DATE PK | datetime | datetime | no | |
| 4 | PROC_CODE PK | string | varchar(20) | no | |
| 5 | PROC_GROUP | integer | int | no | |
| 6 | PROC_TIER | integer | int | no | |
| 7 | HOURS_USED | integer | int | no | |
| 8 | CODING_METHOD | string | varchar(5) | no |