Data Dictionary: Socialstyrelsen National Patient Register: Difference between revisions

From Beacon
No edit summary
No edit summary
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Go back to [[Sweden]] page.
<span style="display:none">forresearchers</span>
<span style="display:none">swedencountry</span>
Go back to [[Database: Socialstyrelsen National Patient Register (Sweden)]] page.
 
Source: [https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/ovrigt/register-variabelforteckning-patientregistret.xlsx Click here to learn more].
 
'''Table 1: Specialized outpatient care.'''
{| class="wikitable"
{| class="wikitable"
|-
|-
! 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
|}
|}


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

Latest revision as of 17:23, 4 December 2025

forresearchers swedencountry Go back to Database: Socialstyrelsen National Patient Register (Sweden) page.

Source: Click here to learn more.

Table 1: 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

Table 2: 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
Retrieved from "https://wiki.beaconcancer.org/index.php?title=Data_Dictionary:_Socialstyrelsen_National_Patient_Register&oldid=30300"
Powered by MediaWiki
Powered by Semantic MediaWiki