ADR Metadata Catalogue

ADR  > Covid Vaccination Dataset (CVVD) @ 309

https://saildatabank.com/about-us/, https://www.youtube.com/watch?v=ZK9-Jw3uVkw, https://ukserp.atlassian.net/wiki/spaces/SATP/pages/16973960/CVVD+-+Covid+Vaccination+Dataset

This dataset covers all patients and vaccinations administered or planned for Covid-19, in or funded by the NHS. Dataset is a de-identified record-level data of people who have received a vaccination for COVID-19, including details of the type of vaccine and date of vaccination.

SAIL Databank (Wales)

DHCW

Anonymised Linking Field (ALF), Encrypted. This field is derived from by double encryption after splitting demographic information and clinical information; the first encryption occurs in NHS Wales Informatics Service (NWIS), and the second in SAIL. If the NHS number is not supplied in the data extract, then matching methods are applied; please refer to ALF_MTCH_PCT.

ALF_E

This table contains details of the cohort

DF_WIS_ALLCOHORTDATA

AVAIL_FROM_DT

CREATED_DT

ETHNIC_ORIGIN

This is the sex (gender) of person, employee or patient. Can potentially assist in correct identification of gender-specific primary cancer sites. Can potentially be different from gender identity as stated/assigned at birth. This might potentially be in conflict with other GNDR columns present in this dataset.

GNDR_CD

Location code for where immunisation was given

IMMUNISATION_LOC

PRAC_CD_E

Code for the priority group of the person

PRIORITY_GRP

UPDATED_DT

Gender as coded in WDS. This might potentially be in conflict with other GNDR columns or as otherwise linked via ALF.

WDS_GNDR

The date of the Monday that occurs prior, or on, the actual date of birth. Access to this data item is limited, however, as it can be used to calculate age at specific events. Possible errors in extract may include patients with events and event dates before WOB.

This table contains booking details of vaccination appointment

DF_WIS_BOOKINGDATA

APPT_APPT_DT

APPT_APPT_TM

APPT_DT

APPT_DTTM

APPT_OUTCOME

DT_OFDEATH

EVENT_ID_E

Local Authority name - this is for the resident

LA_RES_NAME

Local Authority of the resident - this uses the ONS code

LA_RES_ONS_CD

The code for the Local Health Board - this is for the resident

LHB_RES_CD

The name of the Local Health Board - this is for the resident

LHB_RES_NAME

The name of the Local Health Board of the resident - this uses the ONS code

LHB_RES_ONS_CD

Location code for booking, where immunisation was confirmed to take place

LOC_CD

Location name for facility that will administer the booking and/or immunisation

LOC_NAME

The code for the 2011 Local Super Output Area [LSOA] of residence; this is a code created and maintained by Office for National Statistics. Not to be confused with LSOA name or other LSOA fields.

LSOA2011_CD

MSOA Code - this is for the resident. For more reference see ONS datasets or website.

MSOA_CD

OPT_TYPE_CD

OPT_VACCINE

OPT_VACCINE_DT

Priority group description, e.g. Care Home Worker; this should match code in the PRS_PRIORITY_GRP column

PRIORITY_GRP_DESC

PRS_AGE

Flag to determine if the person who will attend the booking is a member of a care home or care facility

PRS_CARE_HOME_RESIDENT

PRS_ETHNIC_ORIGIN

End of suspension date. I.e. not avaible for appointment until this date or contraindicated due to pregnancy until this date, recent infection, vaccination etc.

PRS_IMM_SUSPENSE_DT

PRS_OCC_FRONTLINE_IND

PRS_OCC_JOB_ROLE_CAT

Location of work, as described by the frontline worker

PRS_OCC_LOC_OF_WORK

PRS_OCC_ORG_NAME

PRS_OCC_SECTOR

Encrypted staff ID for the frontline worker

PRS_OCC_STAFF_ID_E

PRS_PRAC_CD_E

Code for the preferred language of the person to be treated

PRS_PREFERRED_LANGUAGE

PRS_PRIORITY_GRP

PRS_SEX

USOA Code - this is the Upper Super Output area code

UPPERSUPEROUTPUTAREA_CD

Code for the Local Health Board where the vaccination took place or is booked to take place

VACCINATINGLHB

Full code for the Local Health Board facility where the vaccination took place or is booked to take place

VACCINATION_LOC_FULL_CD

VACC_COURSE_ID_E

The name of the specific vaccine used - this is both for the disease AND the company/maker, e.g. AstraZeneca

VACC_VACCINE_NAME

WIMD Decile as a number. NOTE - Not clear which WIMD version this pertains to.

WIMDDECILE

Not relevant to anlaysis. Which WIS partition data sits in for front end access purposes. i.e. AB UHB residents loaded into AB UHB partition.

WIS_AREA

WIS_PATIENT_AREA

This table contains details of cohort staging

DF_WIS_COHORTSTAGINGDATA

AUDIT_DTTM

Unique identifier for cohort staging table.

CIS_ID_E

DT_CREATED

DT_UPDADTED

This is the sex (gender) of person, employee or patient. Can potentially assist in correct identification of gender-specific primary cancer sites. Can potentially be different from gender identity as stated/assigned at birth.

GNDR

Identifies which organisation submitted this individual and therefore who they work for. Relavent for staff cohorts only.

ROWSUBMITTEDBY

Whtether the staff member is a frontline worker

STAFF_FRONTLINE_IND

STAFF_ID_E

STAFF_JOB_ROLE_CAT

STAFF_MAIN_WORK_LOC

STAFF_ORG_NAME

STAFF_WORK_SECTOR

Data has been moved from staging table into the WIS system. Not relevant for analysis.

SUCCESSFULLYPUSHED

WDS_GENDER

This table contains details of the vaccine demographics

DF_WIS_DEMOGRAPHICS

DECEASED_FLG

IMM_LOC_TYP

IMPORT_DTTM

PRAC_LHB

PRS_MAIN_IMM_LOC_CODE

Record has been deleted from information system

RECORDDELETEDFROMWIS

SUSPENSE_DT

UPDATE_DTTM

This dataset covers all patients and vaccinations administered or planned for Covid-19, in or funded by the NHS.

Covid Vaccination Dataset (CVVD)

This table contains details of the Covid Vaccination received

DF_WIS_VACCINATIONDATA

The table contains further details of the appointment outcome

DF_WIS_OUTCOMEENRICHEDDATA

This table contains details of the vaccine appointment and outcome

DF_WIS_OUTCOMEDATAV2

This table contains details of Flu Vaccinations in the United Kingdom.

Covid Vaccination Dataset (CVVD)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin