Søgning » Landspatientregisteret » HIST_SKSCODE_PRIMARY
Tabel

HIST_SKSCODE_PRIMARY


Beskrivelse ?

This table stores the primary SKS codes, i.e. codes, that are not additional codes. The data describes Diagnos, Surgery etc.

Størrelse (Antal rækker) ?

294993193

Indhold (Kolonner/variable) ?

Navn Indhold
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.