01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
CATEGORY_MASTER_ID→EMR_V_CATEGORIES_MASTER.CATEGORY_MASTER_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | CATEGORY_DETAIL_ID PK | integer | int | no | |
| 2 | CATEGORY_MASTER_ID | integer | int | no | |
| 3 | CATEGORY_DETAIL_NAME | string | varchar(175) | yes | |
| 4 | ALIAS_NAME | string | varchar(175) | yes | |
| 5 | CREATED_DATE | datetime | datetime | no | |
| 6 | CREATED_USER_ID | string | varchar(20) | no | |
| 7 | MODIFIED_DATE | datetime | datetime | yes | |
| 8 | MODIFIED_USER_ID | string | varchar(20) | yes | |
| 9 | IS_DELETED | boolean | bit | no |