Data Dictionary: Socialstyrelsen National Patient Register: Difference between revisions

From Beacon
No edit summary
No edit summary
Line 1: Line 1:
Go back to [[Sweden]] page.
Go back to [[Sweden]] page.
Source: [https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/ovrigt/register-variabelforteckning-patientregistret.xlsx Click here to learn more].
{| class="wikitable"
{| class="wikitable"
|-
|-
! Specialized outpatient care
! Specialized outpatient care !!
|-
! Variable Name !! Definition
|-
| ALDER || Age at visit
|-
|-
| Age at visit
| ALDER_S || Age at the end of the year
|-
|-
| Age at the end of the year
| ANE1 || Anesthesia code 1
|-
|-
| Anesthesia code 1
| ANE2 || Anesthesia code 2
|-
|-
| Anesthesia code 2
| AR || Year of visit
|-
|-
| Year of visit
| ATC || ATC code in case of poisoning. Medicines according to FASS. Max 30 codes
|-
|-
| ATC code in case of poisoning, for medicines according to FASS (maximum 30 codes)
| ATCO || ATC code for drug delivery. Medicines according to FASS. Max 30 codes
|-
|-
| ATC code for drug delivery, for medicines according to FASS (maximum 30 codes)
| AVBR_AKUT || Interrupted care at the emergency department
|-
|-
| Interrupted care at the emergency department
| BED_AKUT_TIDPUNKT || Time for medical assessment at the emergency department
|-
|-
| Time for medical assessment at the emergency department
| CIVIL || Marital status of the patient
|-
|-
| Marital status of the patient
| DIA_ANT || Number of reported diagnoses, may be more than 30
|-
|-
| Number of reported diagnoses (may be more than 30)
| DIAGNOS || Diagnoses according to ICD. Max 30 diagnoses
|-
|-
| Diagnoses according to ICD (maximum 30 diagnoses)
| DISTRIKT || The patient's home district, data from Statistics Sweden
|-
|-
| The patient's home district (data from Statistics Sweden)
| DRG || Diagnosis-related grouping, can assume approx. 550 values
|-
|-
| Diagnosis-related grouping, which can assume approximately 550 values
| EKOD1 || External reason code 1
|-
|-
| External reason code 1
| EKOD2 || External reason code 2
|-
|-
| External reason code 2
| EKOD3 || External reason code 3
|-
|-
| External reason code 3
| EKOD4 || External reason code 4
|-
|-
| External reason code 4
| EKOD5 || External reason code 5
|-
|-
| External reason code 5
| EKOD6 || External reason code 6
|-
|-
| External reason code 6
| EKOD7 || External reason code 7
|-
|-
| External reason codes 1-5
| EKOD || External reason codes 1-5
|-
|-
| The patient's country of birth
| FLAND || The patient's country of birth
|-
|-
| The patient's year of birth
| FODAR || The patient's year of birth
|-
|-
| The patient's date of birth (numerical)
| FODDAT || The patient's date of birth
|-
|-
| The patient's date of birth (text)
| FODDATN || The patient's date of birth (text)
|-
|-
| Stated main diagnosis
| HDIA || Stated main diagnosis
|-
|-
| A unique serial number for each visit to a healthcare facility (used, among other things, for DRG grouping and created by the National Board of Health and Welfare)
| IDNR || A unique serial number for each visit to a healthcare facility. Used, among other things, for DRG grouping. Created by the National Board of Health and Welfare
|-
|-
| Time for the start of outpatient contact at the emergency department
| IN_AKUT_TIDPUNKT || Time for the start of outpatient contact at the emergency department
|-
|-
| Date of outpatient contact (numerical)
| INDATUM || Date of outpatient contact (numerical)
|-
|-
| Date of outpatient contact (text)
| INDATUMA || Date of outpatient contact (text)
|-
|-
| Gender of the patient
| KON || Gender of the patient
|-
|-
| Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data (for each care contact, it is possible to see when this was last submitted to the National Board of Health and Welfare)
| KONTROLL_DATUM || Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data. For each care contact, it is possible to see when this was last submitted to the National Board of Health and Welfare. The variable is mainly useful for internal quality controls.
|-
|-
| Form of outpatient contact
| KTYP || Form of outpatient contact
|-
|-
| The patient's place of registration (information from Statistics Norway)
| LK || The patient's place of registration, information from Statistics Norway
|-
|-
| The patient's place of national registration (after checking with Statistics Sweden)
| LKF || The patient's place of registration after checking with Statistics Sweden
|-
|-
| The patient's place of registration according to the informant
| LKF_IN || The patient's place of registration according to the informant
|-
|-
| Who submitted the data - Private healthcare provider or region
| LT_IN || Who submitted the data - Private healthcare provider or region
|-
|-
| Clinic from which the patient was discharged
| LT_KLIN || Clinic from which the patient was discharged
|-
|-
| Diagnosis-related grouping, which can assume approximately 550 values
| MDC || Diagnosis-related grouping, can assume approx. 550 values
|-
|-
| Medical area of activity visited by the patient
| MVO || Medical practice area visited by the patient
|-
|-
| The patient's country of citizenship
| NATION || The patient's country of citizenship
|-
|-
| Action codes (maximum 30 actions)
| OP || Action codes, max 30 actions
|-
|-
| Number of reported measures (may be more than 30)
| OP_ANT || Number of reported measures, may be more than 30
|-
|-
| Pseudonymized social security number (created by the National Board of Health and Welfare)
| PSEUDO || Pseudonymized social security number. Created by the National Board of Health and Welfare
|-
|-
| The patient's social security number
| PNR || The patient's social security number
|-
|-
| A variable that shows the quality of a personal identification number (PNR) according to certain predetermined rules, the variable is created using the standard macro checking
| PNRQ || Variable showing quality of personal identification number (PNR), created using standard macro checking
|-
|-
| Psychiatric form of care
| PSVARD || Psychiatric form of care
|-
|-
| Indicates whether the visit was planned or not
| PVARD || Indicates whether the visit was planned or not
|-
|-
| Indicates if the patient does not have a social security number
| RNR || Indicates if the patient does not have a social security number
|-
|-
| An error list that lists registry errors by percentage distribution
| RTC || An error list that lists registry errors by percentage distribution
|-
|-
| Last immigration (year-month or year-month-day)
| SENINV || Last immigration, year-month or year-month-day
|-
|-
| Last emigration (year-month or year-month-day)
| SENUTV || Last emigration, year-month or year-month-day
|-
|-
| Hospital at which the patient visited
| SJUKHUS || Hospital at which the patient visited
|-
|-
| Date when the register was posted
| SKAPAD || Date when the register was posted
|-
|-
| Marks whether a care contact was reported for the last time in accordance with the regulation
| Slutrapporterad || Marks whether a care contact was reported for the last time in accordance with the regulation
|-
|-
| Time for the end of outpatient contact at the emergency department
| UT_AKUT_TIDPUNKT || Time for the end of outpatient contact at the emergency department
|-
|-
| Indicates whether the visit was an emergency visit and the type of emergency operation
| VERKS_AKUT || Indicates whether the visit was an emergency visit and the type of emergency operation
|-
|-
| Sequential number, which is the care contact's unique identification as created by the informant
| VTF_ID || Sequential number, which is the care contact's unique identification as created by the informant
|}
|}


Line 124: Line 131:
{| class="wikitable"
{| class="wikitable"
|-
|-
! Inpatient care
! Inpatient care !!
|-
! Variable Name !! Definition
|-
| ALDER || Age at discharge date
|-
| ALDER_S || Age at the end of the year
|-
| ANE1 || Anesthesia code 1
|-
| ANE2 || Anesthesia code 2
|-
| AR || Discharge year
|-
|-
| Age at date of discharge
| ATC || ATC code in case of poisoning. Medicines according to FASS. Max 30 codes
|-
|-
| Age at the end of the year
| ATCO || ATC code for drug delivery. Medicines according to FASS. Max 30 codes
|-
|-
| Anesthesia code 1
| AVTAL || The care allowance is regulated according to the agreement
|-
|-
| Anesthesia code 2
| CIVIL || Marital status of the patient
|-
|-
| Discharge year
| DIA_ANT || Number of reported diagnoses, may be more than 30
|-
|-
| ATC code in case of poisoning. Medicines according to FASS. Max 30 codes
| DIAGNOS || Diagnoses according to ICD. Max 30 diagnoses
|-
|-
| ATC code for drug delivery. Medicines according to FASS. Max 30 codes
| DISTRIKT || The patient's home district, data from Statistics Sweden
|-
|-
| The care allowance is regulated according to the agreement
| DRG || Diagnosis-related grouping, can assume approx. 550 values
|-
|-
| Marital status of the patient
| EKOD1 || External cause code 1. See ICD code list
|-
|-
| Number of reported diagnoses, may be more than 30
| EKOD2 || External cause code 2. See ICD code list
|-
|-
| Diagnoses according to ICD. Max 30 diagnoses
| EKOD3 || External cause code 3. See ICD code list
|-
|-
| The patient's home district, data from Statistics Sweden
| EKOD4 || External cause code 4. See ICD code list
|-
|-
| Diagnosis-related grouping, can assume approx. 550 values
| EKOD5 || External cause code 5. See ICD code list
|-
|-
| External cause code 1. See ICD code list
| EKOD || External reason code 1-5
|-
|-
| External cause code 2. See ICD code list
| FLAND || The patient's country of birth
|-
|-
| External cause code 3. See ICD code list
| FODAR || The patient's year of birth
|-
|-
| External cause code 4. See ICD code list
| FODDAT || The patient's date of birth
|-
|-
| External cause code 5. See ICD code list
| FODDATN || The patient's date of birth
|-
|-
| External reason code 1-5
| HDIA || Stated main diagnosis
|-
|-
| The patient's country of birth
| IDNR || A unique serial number for each vtf. Used, among other things, for DRG grouping. Created by the National Board of Health and Welfare
|-
|-
| The patient's year of birth
| INDATUM || The date the patient is enrolled. Number of days from the year 1960-01-01 up to and including INDATUM
|-
|-
| The patient's date of birth
| INDATUMA || The date the patient is enrolled
|-
|-
| Stated main diagnosis
| INSATT || How the patient was enrolled
|-
|-
| A unique serial number for each vtf. Used, among other things, for DRG grouping. Created by the National Board of Health and Welfare
| KON || Gender of the patient
|-
|-
| The date the patient is enrolled
| KONTROLL_DATUM || Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data. For each care contact, it is thus possible to see when this was last submitted to the National Board of Health and Welfare. The variable is mainly useful for internal quality controls
|-
|-
| Number of days from the year 1960-01-01 up to and including INDATUM
| LK || The patient's place of registration information from Statistics Norway
|-
|-
| The date the patient is enrolled
| LKF || The patient's place of registration after checking with Statistics Sweden
|-
|-
| How the patient was enrolled
| LKF_IN || The patient's place of registration according to the informant
|-
|-
| Gender of the patient
| LT_IN || Who submitted the data - Private healthcare provider or region
|-
|-
| Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data. For each care contact, it is thus possible to see when this was last submitted to the National Board of Health and Welfare. The variable is mainly useful for internal quality controls
| LT_KLIN || Clinic from which the patient was discharged
|-
|-
| The patient's place of registration information from Statistics Norway
| MDC || Care opportunities grouped at chapter level
|-
|-
| The patient's place of registration after checking with Statistics Sweden
| MVO || Medical practice area from which the patient was discharged
|-
|-
| The patient's place of registration according to the informant
| NATION || The patient's country of citizenship
|-
|-
| Who submitted the data - Private healthcare provider or region
| OP || Action codes max. 30 actions
|-
|-
| Clinic from which the patient was discharged
| OP_ANT || Number of reported measures, may be more than 30
|-
|-
| Care opportunities grouped at chapter level
| OPD1 || Date when action 1 was performed
|-
|-
| Medical practice area from which the patient was discharged
| OPD10 || Date when action 10 was performed
|-
|-
| The patient's country of citizenship
| OPD11 || Date when action 11 was performed
|-
|-
| Action codes max. 30 actions
| OPD12 || Date when action 12 was performed
|-
|-
| Number of reported measures, may be more than 30
| OPD13 || Date when action 13 was performed
|-
|-
| Date when action 1 was performed
| OPD14 || Date when action 14 was performed
|-
|-
| Date when action 10 was performed
| OPD15 || Date when action 15 was performed
|-
|-
| Date when action 11 was performed
| OPD16 || Date when action 16 was performed
|-
|-
| Date when action 12 was performed
| OPD17 || Date when action 17 was performed
|-
|-
| Date when action 13 was performed
| OPD18 || Date when action 18 was performed
|-
|-
| Date when action 14 was performed
| OPD19 || Date when action 19 was performed
|-
|-
| Date when action 15 was performed
| OPD2 || Date when action 2 was performed
|-
|-
| Date when action 16 was performed
| OPD20 || Date when action 20 was performed
|-
|-
| Date when action 17 was performed
| OPD21 || Date when action 21 was performed
|-
|-
| Date when action 18 was performed
| OPD22 || Date when action 22 was performed
|-
|-
| Date when action 19 was performed
| OPD23 || Date when action 23 was performed
|-
|-
| Date when action 2 was performed
| OPD24 || Date when action 24 was performed
|-
|-
| Date when action 20 was performed
| OPD25 || Date when action 25 was performed
|-
|-
| Date when action 21 was performed
| OPD26 || Date when action 26 was performed
|-
|-
| Date when action 22 was performed
| OPD27 || Date when action 27 was performed
|-
|-
| Date when action 23 was performed
| OPD28 || Date when action 28 was performed
|-
|-
| Date when action 24 was performed
| OPD29 || Date when action 29 was performed
|-
|-
| Date when action 25 was performed
| OPD3 || Date when action 3 was performed
|-
|-
| Date when action 26 was performed
| OPD30 || Date when action 30 was performed
|-
|-
| Date when action 27 was performed
| OPD4 || Date when action 4 was performed
|-
|-
| Date when action 28 was performed
| OPD5 || Date when action 5 was performed
|-
|-
| Date when action 29 was performed
| OPD6 || Date when action 6 was performed
|-
|-
| Date when action 3 was performed
| OPD7 || Date when action 7 was performed
|-
|-
| Date when action 30 was performed
| OPD8 || Date when action 8 was performed
|-
|-
| Date when action 4 was performed
| OPD9 || Date when action 9 was performed
|-
|-
| Date when action 5 was performed
| PSEUDO || Pseudonymized social security number. Created by the National Board of Health and Welfare
|-
|-
| Date when action 6 was performed
| PNR || The patient's social security number
|-
|-
| Date when action 7 was performed
| PNRQ || Variable that shows the quality of a personal identification number (PNR) according to certain predetermined rules. The variable is created with the help of the standard macro checkpnr.
|-
|-
| Date when action 8 was performed
| PSVARD || Psychiatric form of care
|-
|-
| Date when action 9 was performed
| PVARD || Indicates whether the visit was planned or not
|-
|-
| Pseudonymized social security number. Created by the National Board of Health and Welfare
| RNR || Indicated if the patient does not have a social security number
|-
|-
| The patient's social security number
| RTC || A list of errors that lists the register's errors after percentage distribution
|-
|-
| Variable that shows the quality of a personal identification number (PNR) according to certain predetermined rules
| SENINV || Latest immigration
|-
| SENUTV || Latest emigration
|-
| SJUKHUS || Hospital from which the patient was discharged
|-
| SKAPAD || Date the register was created
|-
| SLUT || End date for psychiatric form of care
|-
| Slutrapporterad || Indicates whether a care contact has been reported for the last time in accordance with the regulation
|-
| START || Start date for psychiatric form of care
|-
| UTDATUM || The date the patient is discharged
|-
| UTDATUMA || The date the patient is discharged
|-
| UTSATT || Discharge method
|-
| VTF_ID || Serial number. The unique identification of the care contact created by the data provider.
|-
| VTID || Discharge date - admission date, number of days
|}
|}
The variable is created using the standard macro-checking; Psychiatric form.

Revision as of 16:05, 19 May 2024

Go back to Sweden page.

Source: Click here to learn more.

Specialized outpatient care
Variable Name Definition
ALDER Age at visit
ALDER_S Age at the end of the year
ANE1 Anesthesia code 1
ANE2 Anesthesia code 2
AR Year of visit
ATC ATC code in case of poisoning. Medicines according to FASS. Max 30 codes
ATCO ATC code for drug delivery. Medicines according to FASS. Max 30 codes
AVBR_AKUT Interrupted care at the emergency department
BED_AKUT_TIDPUNKT Time for medical assessment at the emergency department
CIVIL Marital status of the patient
DIA_ANT Number of reported diagnoses, may be more than 30
DIAGNOS Diagnoses according to ICD. Max 30 diagnoses
DISTRIKT The patient's home district, data from Statistics Sweden
DRG Diagnosis-related grouping, can assume approx. 550 values
EKOD1 External reason code 1
EKOD2 External reason code 2
EKOD3 External reason code 3
EKOD4 External reason code 4
EKOD5 External reason code 5
EKOD6 External reason code 6
EKOD7 External reason code 7
EKOD External reason codes 1-5
FLAND The patient's country of birth
FODAR The patient's year of birth
FODDAT The patient's date of birth
FODDATN The patient's date of birth (text)
HDIA Stated main diagnosis
IDNR A unique serial number for each visit to a healthcare facility. Used, among other things, for DRG grouping. Created by the National Board of Health and Welfare
IN_AKUT_TIDPUNKT Time for the start of outpatient contact at the emergency department
INDATUM Date of outpatient contact (numerical)
INDATUMA Date of outpatient contact (text)
KON Gender of the patient
KONTROLL_DATUM Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data. For each care contact, it is possible to see when this was last submitted to the National Board of Health and Welfare. The variable is mainly useful for internal quality controls.
KTYP Form of outpatient contact
LK The patient's place of registration, information from Statistics Norway
LKF The patient's place of registration after checking with Statistics Sweden
LKF_IN The patient's place of registration according to the informant
LT_IN Who submitted the data - Private healthcare provider or region
LT_KLIN Clinic from which the patient was discharged
MDC Diagnosis-related grouping, can assume approx. 550 values
MVO Medical practice area visited by the patient
NATION The patient's country of citizenship
OP Action codes, max 30 actions
OP_ANT Number of reported measures, may be more than 30
PSEUDO Pseudonymized social security number. Created by the National Board of Health and Welfare
PNR The patient's social security number
PNRQ Variable showing quality of personal identification number (PNR), created using standard macro checking
PSVARD Psychiatric form of care
PVARD Indicates whether the visit was planned or not
RNR Indicates if the patient does not have a social security number
RTC An error list that lists registry errors by percentage distribution
SENINV Last immigration, year-month or year-month-day
SENUTV Last emigration, year-month or year-month-day
SJUKHUS Hospital at which the patient visited
SKAPAD Date when the register was posted
Slutrapporterad Marks whether a care contact was reported for the last time in accordance with the regulation
UT_AKUT_TIDPUNKT Time for the end of outpatient contact at the emergency department
VERKS_AKUT Indicates whether the visit was an emergency visit and the type of emergency operation
VTF_ID Sequential number, which is the care contact's unique identification as created by the informant


Inpatient care
Variable Name Definition
ALDER Age at discharge date
ALDER_S Age at the end of the year
ANE1 Anesthesia code 1
ANE2 Anesthesia code 2
AR Discharge year
ATC ATC code in case of poisoning. Medicines according to FASS. Max 30 codes
ATCO ATC code for drug delivery. Medicines according to FASS. Max 30 codes
AVTAL The care allowance is regulated according to the agreement
CIVIL Marital status of the patient
DIA_ANT Number of reported diagnoses, may be more than 30
DIAGNOS Diagnoses according to ICD. Max 30 diagnoses
DISTRIKT The patient's home district, data from Statistics Sweden
DRG Diagnosis-related grouping, can assume approx. 550 values
EKOD1 External cause code 1. See ICD code list
EKOD2 External cause code 2. See ICD code list
EKOD3 External cause code 3. See ICD code list
EKOD4 External cause code 4. See ICD code list
EKOD5 External cause code 5. See ICD code list
EKOD External reason code 1-5
FLAND The patient's country of birth
FODAR The patient's year of birth
FODDAT The patient's date of birth
FODDATN The patient's date of birth
HDIA Stated main diagnosis
IDNR A unique serial number for each vtf. Used, among other things, for DRG grouping. Created by the National Board of Health and Welfare
INDATUM The date the patient is enrolled. Number of days from the year 1960-01-01 up to and including INDATUM
INDATUMA The date the patient is enrolled
INSATT How the patient was enrolled
KON Gender of the patient
KONTROLL_DATUM Refers to the date on which automatic delivery control (LOK) was carried out, which takes place in connection with data providers submitting data. For each care contact, it is thus possible to see when this was last submitted to the National Board of Health and Welfare. The variable is mainly useful for internal quality controls
LK The patient's place of registration information from Statistics Norway
LKF The patient's place of registration after checking with Statistics Sweden
LKF_IN The patient's place of registration according to the informant
LT_IN Who submitted the data - Private healthcare provider or region
LT_KLIN Clinic from which the patient was discharged
MDC Care opportunities grouped at chapter level
MVO Medical practice area from which the patient was discharged
NATION The patient's country of citizenship
OP Action codes max. 30 actions
OP_ANT Number of reported measures, may be more than 30
OPD1 Date when action 1 was performed
OPD10 Date when action 10 was performed
OPD11 Date when action 11 was performed
OPD12 Date when action 12 was performed
OPD13 Date when action 13 was performed
OPD14 Date when action 14 was performed
OPD15 Date when action 15 was performed
OPD16 Date when action 16 was performed
OPD17 Date when action 17 was performed
OPD18 Date when action 18 was performed
OPD19 Date when action 19 was performed
OPD2 Date when action 2 was performed
OPD20 Date when action 20 was performed
OPD21 Date when action 21 was performed
OPD22 Date when action 22 was performed
OPD23 Date when action 23 was performed
OPD24 Date when action 24 was performed
OPD25 Date when action 25 was performed
OPD26 Date when action 26 was performed
OPD27 Date when action 27 was performed
OPD28 Date when action 28 was performed
OPD29 Date when action 29 was performed
OPD3 Date when action 3 was performed
OPD30 Date when action 30 was performed
OPD4 Date when action 4 was performed
OPD5 Date when action 5 was performed
OPD6 Date when action 6 was performed
OPD7 Date when action 7 was performed
OPD8 Date when action 8 was performed
OPD9 Date when action 9 was performed
PSEUDO Pseudonymized social security number. Created by the National Board of Health and Welfare
PNR The patient's social security number
PNRQ Variable that shows the quality of a personal identification number (PNR) according to certain predetermined rules. The variable is created with the help of the standard macro checkpnr.
PSVARD Psychiatric form of care
PVARD Indicates whether the visit was planned or not
RNR Indicated if the patient does not have a social security number
RTC A list of errors that lists the register's errors after percentage distribution
SENINV Latest immigration
SENUTV Latest emigration
SJUKHUS Hospital from which the patient was discharged
SKAPAD Date the register was created
SLUT End date for psychiatric form of care
Slutrapporterad Indicates whether a care contact has been reported for the last time in accordance with the regulation
START Start date for psychiatric form of care
UTDATUM The date the patient is discharged
UTDATUMA The date the patient is discharged
UTSATT Discharge method
VTF_ID Serial number. The unique identification of the care contact created by the data provider.
VTID Discharge date - admission date, number of days