01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNT
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | INITIAL_TREATMENT_DATE | datetime | datetime | yes | |
| 3 | NO_IN_SERIES | integer | int | yes | |
| 4 | SUBLUXATION_TOP | string | varchar(3) | yes | |
| 5 | SUBLUXATION_BOTTOM | string | varchar(3) | yes | |
| 6 | TREATMENT_MONTHS | integer | int | yes | |
| 7 | TREATMENT_YEARS | integer | int | yes | |
| 8 | TREATMENTS_PER_MONTH | integer | int | yes | |
| 9 | NATURE_OF_CONDITION | string | char(1) | yes | |
| 10 | DATE_OF_MANIFESTATION | datetime | datetime | yes | |
| 11 | COMPLICATION_INDICATOR | string | char(1) | yes | |
| 12 | DATE_OF_LAST_XRAY | datetime | datetime | yes | |
| 13 | LENGTH_OF_SERIES | integer | int | yes |