ID |
Internal primary key |
HIST_CONTACT_ID |
Refers to the contact, this record is a child of. |
SKS_CODE_TYPE_ID |
Type of code, e.g. most important diagnose is called V. Refers to one of the two small classifications Diagnoseart and Operationsart. Maps to field ART |
CODE_ID |
Refers to the SKS classification. Maps to field KODE |
OPERATING_UNIT_ID |
Refers to the ward performing the operation (only when art = V or P). Maps to field PROCAFD |
PROC_DATETIME |
Date and time (hour and minute) of performed procedure (only when art = V or P) Maps to fields PROCDTO, PROCTIM and PROCMIN. |
ERROR_FLAG |
Flag indicating if any validation errors exist, related to this record. = Y means that at least one error was detected and related to this part of the contact data structure. = N means that this record has no errors attached. |
SORT_ORDER |
The order must be preserved from the original data source, because older contacts do not have timestamps on the primary codes, so this is the only way to ensure a meaningfull presentation of the data. |