Brug for hjælp?
Skriv til data@sa.dk og få hjælp til at:

  • finde det, du søger
  • forstå det, du har fundet

Søgning » Landspatientregisteret » ALL_PATIENT

Landspatientregisteret

Tabeloversigt ?
HIST_CONTACT
ALL_CONTACT_IDENTIFIER
CLS_UNIT
CLS_SKS
HIST_OUTPATIENT_VISIT
SYS_DATA_PRODUCER
HIST_SKSCODE_PRIMARY
HIST_WAIT_PASSIVE
HIST_EMERGENCY_LOCATION
HIST_OBSTRETRIC_MOTHER
CLS_LEGACY
CLS_SMALL
HIST_OBSTRETRIC_CHILD
HIST_PAT_WAIT
HIST_PSYCHIATRIC_INFO
HIST_OPERATION_LEGACY
HIST_OPERCOMBI_LEGACY
HIST_SKSCODE_ADDITIONAL
ALL_PATIENT
HIST_DIAGNOSIS_LEGACY
HIST_REMOTE_OUTPATIENT
CLS_ART
CLS_DATA_SOURCE
CLS_EJER
CLS_REGION
CLS_SPEC
Tabel

ALL_PATIENT


Beskrivelse ?

The patient table is the master for active as well as historical contact data.

Størrelse (Antal rækker) ?

5260269

Indhold (Kolonner/variable) ?

Navn Indhold
ID Internal primary key
CPR_NUMBER Personal Identification Number. Maps to attribute INDUD.CPRNR in the raw data file format.
LAST_CHANGE Timestamp - updated each time data for this patient is changed.
PATIENT_SEX Defines the sex of the patient based on the cpr_number. This field is not in the original LPR schema. The value of this column is calculated and is added for performance reasons.