01Relates to the patient
not linked to a patient
Single-patient export: not included.
02References
ENCOUNTER_ID→EMR_ENCOUNTERS.ENCOUNTER_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCESS_PK PK | integer | bigint | no | |
| 2 | DATA_ELEMENT_ID | integer | int | no | |
| 3 | TEMPLATE_ID | integer | int | no | |
| 4 | ENCOUNTER_ID | integer | int | no | |
| 5 | GOC_ID | integer | int | yes | |
| 6 | SEQUENCE_NO | integer | int | yes | |
| 7 | OLD_VALUE | string | varchar(max) | yes | |
| 8 | NEW_VALUE | string | varchar(max) | yes | |
| 9 | CREATED_USER_ID | string | varchar(20) | no | |
| 10 | CREATED_DATE | datetime | datetime | yes |