Surgical site infections (Surgical site infections)
- from 01/01/2020 - 31/12/2020
- Status: inactive
- How to create a CSV file for this data collection?
- Start date: 01/01/2020
- End date creation: 09/05/2023
- End date submission: 09/05/2023
- End date comments: 09/05/2023
1 Patient
Patient identificator
Help
Please encode a social security identification number (SSIN). Please note that the patient ID is always pseudonymised before being transferred to Healthdata.
Technical specs
CSV column name:
patient_id
Required:
true
Validation
The validity of the national register number is checked with the mod97 check.
Fields
Section help
Please encode a social security identification number (SSIN). Please note that the patient ID is always pseudonymised before being transferred to Healthdata.
Internal patient ID
Help
This field can be used to enter an internal ID or reference number. It is available for internal use only and is not transferred to Healthdata. If there is an integration between HD4DP and your organisation's patient administration system, additional patient identification information such as date of birth, sex and SSIN can be automatically enriched based on this internal patient ID. Please do not encode the social security identification number (SSIN) in this field. The SSIN must be encoded in the field 'National registry ID of the patient'.
Technical specs
CSV column name:
patient_id|internal_patient_id
Required:
false
Generated
Help
The patient_id|generated column can be set to 'TRUE' for an automatically generated patient_id.This column should only be added in case the patient_id is empty. If the column is set to 'TRUE', a patient_id is automatically generated based on the name, first name, date of birth and sex of the patient.
Technical specs
CSV column name:
patient_id|generated
Required:
false
Options
| Label | Value |
| Yes | TRUE |
| No | FALSE |
Last name
Help
The name of the patient is never transferred to Healthdata and is available for your information only.
Technical specs
CSV column name:
patient_id|name
Required:
noSSIN(Needed only if no national register number is entered)
First name
Help
The first name of the patient is never transferred and is available for your information only.
Technical specs
CSV column name:
patient_id|first_name
Required:
noSSIN(Needed only if no national register number is entered)
Date of birth
Technical specs
Format:
DD/MM/YYYY
CSV column name:
patient_id|date_of_birth
Required:
noSSIN(Needed only if no national register number is entered)
Validation
- The date of birth cannot be in the future (error)
- Date of birth cannot be after date of death (error)
Sex
Technical specs
CSV column name:
patient_id|sex
Required:
noSSIN(Needed only if no national register number is entered)
Options
| Label | Value |
| Female | F |
| Male | M |
| Unknown | U |
Place of residence
Technical specs
CSV column name:
patient_id|place_of_residence
Reference list:
POSTAL_CODE
Required:
false
Deceased?
Technical specs
CSV column name:
patient_id|deceased
Required:
false
Options
| Label | Value |
| Yes | TRUE |
| No | FALSE |
Date of death
Technical specs
Format:
DD/MM/YYYY
CSV column name:
patient_id|date_of_death
Only when:
Required:
false
Validation
- The date of death cannot be in the future (error)
- Date of birth cannot be after date of death (error)
2 Procedure
Section help
Variables 'Date of surgical interventions', 'NHSN operation category', and 'Surgical intervention number' MUST correspond with those of an existing operation declared in the 'Surgical interventions' data collection.
Date of surgical intervention
Technical specs
Format:
DD/MM/YYYY
CSV column name:
DT_SURG_INTVENT
Required:
true
Validation
- The date of surgical intervention cannot be in the future (error)
NHSN operation category
Help
NHSN Operation category, must refer to a NHSN code declared for this surveillance period in the participation screen
Technical specs
CSV column name:
CD_NHSN_OP_CAT
Length:
10
Reference list:
SSI_NHSN
Required:
true
Surgical intervention number
Help
Surgical intervention number (1-3, use 1 as default), in case of multiple interventions of same NHSN category with different incisions on this patient on the same date
Technical specs
CSV column name:
NR_SURG_INTVENT
Length:
3
Required:
true
3 Infection
Surgical site infection date
Technical specs
Format:
DD/MM/YYYY
CSV column name:
DT_INFCT_SURG_SITE
Required:
true
Validation
- The infection date cannot be in the future (error)
Surgical site infection type
Technical specs
CSV column name:
CD_TPE_INFCT_SURG_SITE
Required:
true
Options
| Label | Value |
| Superficial / incisional infection (1) | 1 |
| Deep incisional infection (2) | 2 |
| Organ-space surgical site infection (3) | 3 |
If CBGB, surgical site infection superficial at chest?
Technical specs
CSV column name:
CD_CBGB_SSI_SUPERF_CHEST
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
If CBGB, surgical site infection superficial at leg?
Technical specs
CSV column name:
CD_CBGB_SSI_SUPERF_LEG
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
Location of detection of infection
Technical specs
CSV column name:
CD_LOC_DETECT_INFCT
Required:
false
Options
| Label | Value |
| During hospital stay (1) | 1 |
| Outpatient department (2) | 2 |
| Private surgeon (3) | 3 |
| General practitioner (4) | 4 |
| Hospital readmission (5) | 5 |
| Other (6) | 6 |
| Unknown (9) | 9 |
Secondary septicemia?
Technical specs
CSV column name:
CD_SECY_SEP
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
Reintervention related to surgical site infection?
Technical specs
CSV column name:
CD_REINTVENT_RELTO_SSI
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
Readmission related to surgical site infection or secondary admission?
Technical specs
CSV column name:
CD_READMI_RELTO_SSI_OR_SECADMI
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
4 Laboratory
Culture taken?
Technical specs
CSV column name:
CD_CULT_TAKEN
Required:
false
Options
| Label | Value |
| Yes (1) | 1 |
| No (0) | 0 |
| Unknown (9) | 9 |
Sample origin
Not to be included in the CSV.
Help
This field should not be provided and will only be activated in the future.
Technical specs
CSV column name:
CD_SAMPLE_ORIG
Length:
200
Required:
false
Read only
Sample ID
Not to be included in the CSV.
Help
This field should not be provided and will only be activated in the future.
Technical specs
CSV column name:
TX_SAMPLE_ID
Length:
200
Required:
false
Read only
Sample date
Not to be included in the CSV.
Help
This field should not be provided and will only be activated in the future.
Technical specs
Format:
DD/MM/YYYY
CSV column name:
DT_SAMPLE
Required:
false
Read only
Validation
- The sample date cannot be in the future (error)
Results (isolate & antimicrobial resistance)
This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container
Help
Choose "Add new item" to add another isolate and its test results
List items
Section help
Choose "Add new item" to add another isolate and its test results
Isolate (SNOMED code)
Technical specs
CSV column name:
pathogen_1|0|CD_PATHOG
Length:
20
Reference list:
SSI_PATHOGEN
Required:
false
DU_PATHOGEN
Not to be included in the CSV.
Help
Please ignore. This field is for technical purposes only
Technical specs
CSV column name:
pathogen_1|0|du_pathogen
Default value:
DU-001
Required:
true
Read only
Antimicrobial resistance
This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container
Help
Choose "Add new item" to add other results for this isolate
Element conditions
| Message | Expression |
List items
Section help
Choose "Add new item" to add other results for this isolate
Test (LOINC code)
Technical specs
CSV column name:
pathogen_1|0|TEST_1|0|CD_PATHOG_ANTBIO_TST
Length:
20
Reference list:
SSI_ANTIBIOTIC_MARKER
Required:
false
Result
Technical specs
CSV column name:
pathogen_1|0|TEST_1|0|CD_PATHOG_ANTBIO_TST_RESULT
Required:
true
Options
| Label | Value |
| Sensitive (1) | 1 |
| Intermediate (2) | 2 |
| Resistant (3) | 3 |
| Positive (4) | 4 |
| Negative (5) | 5 |
| Unknown (9) | 9 |