ID |
Internal primary key |
DATA_SOURCE |
The source of the contact. This flag defines, from where the contact was reported: L=LPR contact I=DUSAS International S=DUSAS Specialist |
PATIENT_ID |
Patient identication reference |
PATIENT_TYPE_ID |
Defines patient type relevant when Datasource=L or I |
PATIENT_TYPE |
Contains the patient type code value |
HOSPITAL_ID |
Defines the hospital responsible for the contact |
HOSPITAL_CODE |
Contains the hospital code value |
WARD_ID |
Defines the ward responsible for the contact |
WARD_CODE |
Contains the ward code value |
COUNTY_ID |
The county (DK: Kommune) |
COUNTY_CODE |
Contains the county code value |
REGION_CODE |
The region which is the owner of the hospital. Null for private hospitals. |
PRACTITIONER_NO |
The practitionar number (DK:Yder nummer) Identifies the specialist or clinic, who treated the patient. This is not an ID, as the "yder"-tabel is not p |
PRACTITIONER_SPECIALITY_ID |
The speciality code (DK: Speciale) |
CONTACT_NO |
A sequence number, manually assigned to DUSAS Internatinal contacts. |
ADMISSION_DATETIME |
Date and time of admission. |
ADMISSION_TIME_MISSING |
Flag indicating if the time part of ADMISSION_DATETIME is relevant or not. If the field has the value "Y" the flag is said to be set, only the date pa |
REFERRAL_DATE |
The date the patient were referred (DK: Henvist) |