01Relates to the patient
FAMILY_HEAD_ACCOUNT is the patient's ACCOUNT; or FAMILY_ID matches PEOPLE.FAMILY_ID on a row of PEOPLE that relates to the patient
Single-patient export: only rows the patient's records refer to.
02References
FAMILY_HEAD_ACCOUNT→PEOPLE.ACCOUNT
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | FAMILY_ID PK | integer | int | no | |
| 2 | FAMILY_HEAD_ACCOUNT | string | varchar(12) | no | |
| 3 | FAMILY_NAME | string | varchar(35) | no | |
| 4 | FAMILY_DESCRIPTION | string | varchar(100) | yes | |
| 5 | FAMILY_DATE_FROM | datetime | datetime | yes | |
| 6 | FAMILY_DATE_THRU | datetime | datetime | yes | |
| 7 | OTHER_FAMILY_DETAILS | string | varchar(100) | yes |