Søgning » Landspatientregisteret » HIST_OUTPATIENT_VISIT
Tabel

HIST_OUTPATIENT_VISIT


Beskrivelse ?

This table stores data of visits from an outpatient. Maps to record type BESؘG (DK: Besøgsoplysninger) in the raw data format

Størrelse (Antal rækker) ?

68516905

Indhold (Kolonner/variable) ?

Navn Indhold
ID Internal primary key
HIST_CONTACT_ID Refers to the contact, this record is a child of.
VISIT_DATE Date of visit. Maps to field DTOBES
PERSONAL_TYPE_1_ID Personel type, field 1. Refers to small classification Personalekategori. Maps to field PERSKAT1
PERSONAL_TYPE_2_ID Personel type, field 2. Refers to small classification Personalekategori. Maps to field PERSKAT2
PERSONAL_TYPE_3_ID Personel type, field 3. Refers to small classification Personalekategori. Maps to field PERSKAT3
SERVICE_LOCATION_ID Specifies where the visit took place (at a hospital, at the patients home, ..). Refers to small classification Ydelsessted. Maps to field YDESTED
PSYCHIATRIC_SERVICE_ID If this visit relates to a psychiatric service, the type of service is specified here. Refers to small classification Psykiatrisk ydelse. Maps to field PSYKYD
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.