OpenSAFELY
Reports

OpenSAFELY-TPP database schema

Description
This report displays the schema of the OpenSAFELY-TPP database.
Contact
Get in touch and tell us how you use this report or new features you'd like to see: team@opensafely.org
First published
06 Jan 2021
Last released
17 May 2023
Links

OpenSAFELY-TPP Database Schema

This report displays the schema of the OpenSAFELY-TPP database. It is part of the OpenSAFELY platform's technical documentation and is published at https://reports.opensafely.org/.

The schema is read from the OpenSAFELYSchemaInformation table, which is refreshed at the same time as the core SystmOne primary care datasets. There are some non-automated steps required to update the schema information when a new table is added to the database — if you can't see a table that you are expecting to see, then please speak to TPP.

If you would like to use the OpenSAFELY platform, then you should read our documentation, our principles, and our process for onboarding new users. If you would like to see the code we used to create this report, then you can view it on GitHub.

Data Sources

The core SystmOne primary care datasets are stored in the S1 tables in the database. The table below lists other, externally-linked datasets:

Dataset Source Tables
All positive or negative SARS-CoV2 tests SGSS SGSS_AllTests_Positive, SGSS_AllTests_Negative
First-ever positive or negative SARS-CoV2 test SGSS SGSS_Positive, SGSS_Negative
A&E attendances SUS Emergency Care EC
In-patient hospital admissions SUS Admitted Patient Care Spells APCS
Out-patient hospital appointments SUS OPA
Covid-related ICU admissions ICNARC ICNARC
Covid-related in-hospital deaths CPNS CPNS
COVID-19 Infection Survey ONS ONS_CIS
All-cause registered deaths ONS ONS_Deaths
High cost drugs HighCostDrugs
Unique Property Reference Number1 UPRN
Master Patient Index MPI
Health and Social Care Worker identification2 HealthCareWorker

1Used for deriving household variables
2Collected at the point of vaccination

Some of these tables are accompanied by additional tables. For example, the OPA table contains the core out-patient appointment event data, and is accompanied by the OPA_Cost, OPA_Diag, and OPA_Proc tables.

Report Run Date

This report was run on 2023-05-16. It reflects the state of the database on this date.

Table Names by Data Source

DataSource TableName
Airmid OpenPROMPT
ICNARC ICNARC
ISARIC ISARIC_New
NHSD_HIGH_COST_DRUGS HighCostDrugs
NHSE_APCS APCS
NHSE_APCS APCS_Cost
NHSE_APCS APCS_Der
NHSE_CPNS CPNS
NHSE_EC EC
NHSE_EC EC_AlcoholDrugInvolvement
NHSE_EC EC_Comorbidities
NHSE_EC EC_Cost
NHSE_EC EC_Diagnosis
NHSE_EC EC_Investigation
NHSE_EC EC_PatientMentalHealth
NHSE_EC EC_Treatment
NHSE_ECDS ECDS
NHSE_ECDS ECDS_EC_Diagnoses
NHSE_HEALTH_CARE_WORKER HealthCareWorker
NHSE_MPI MPI
NHSE_MPI UPRN
NHSE_OPA OPA
NHSE_OPA OPA_Cost
NHSE_OPA OPA_Diag
NHSE_OPA OPA_Proc
NHSE_SGSS SGSS_AllTests_Negative
NHSE_SGSS SGSS_AllTests_Positive
NHSE_SGSS SGSS_Negative
NHSE_SGSS SGSS_Positive
NHSE_Therapeutics Therapeutics
NHSE_WL WL_ClockStops
NHSE_WL WL_Diagnostics
NHSE_WL WL_OpenPathways
ONS_CIS ONS_CIS
ONS_CIS ONS_CIS_New
ONS_CIS ONS_CIS_New_Swab_Clearance
ONS_CIS ONS_CIS_New_Swab_Clearance_Pos_All
ONS_CIS ONS_CIS_New_Swab_Clearance_Pos_TnT
ONS_DEATHS ONS_Deaths
OS_BUILD BuildInfo
OS_BUILD CodeCountIndicator
OS_BUILD LatestBuildTime
OS_BUILD OpenSAFELYSchemaInformation
OS_DERIVED Household
OS_DERIVED HouseholdMember
OS_DERIVED MSOA_PopulationEstimates_2019
OS_DERIVED PotentialCareHomeAddress
S1 Appointment
S1 CodedEvent
S1 CodedEventRange
S1 Consultation
S1 CTV3Dictionary
S1 CTV3Hierarchy
S1 DataDictionary
S1 ICD10Dictionary
S1 MedicationDictionary
S1 MedicationIssue
S1 MedicationRepeat
S1 MedicationSensitivity
S1 Organisation
S1 Patient
S1 PatientAddress
S1 QOFClusterReference
S1 RegistrationHistory
S1 UnitDictionary
S1 Vaccination
S1 VaccinationReference
S1 YCodeToSnomedMapping
UK_Renal_Register UKRR

Table Schemas

The table schemas contain the following information:

Use the links in the list below to jump to a table schema.

Airmid

OpenPROMPT

ColumnName ColumnType Precision Scale MaxLength IsNullable
CodedEvent_ID varchar 0 0 50 False
CodeSystemId int 10 0 4 False
ConceptId varchar 0 0 50 True
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
NumericValue real 24 0 4 False
Patient_ID int 10 0 4 False

ICNARC

ICNARC

ColumnName ColumnType Precision Scale MaxLength IsNullable
AdvancedDays_CardiovascularSupport int 10 0 4 True
AdvancedDays_RespiratorySupport int 10 0 4 True
ahsurv int 10 0 4 True
AP2score int 10 0 4 True
ausurv int 10 0 4 True
BasicDays_CardiovascularSupport int 10 0 4 True
BasicDays_RespiratorySupport int 10 0 4 True
CalculatedAge int 10 0 4 True
DateOfDeath datetime 23 3 8 True
EstimatedAge int 10 0 4 True
HighestLevelFirst24Hours int 10 0 4 True
HospitalAdmissionDate datetime 23 3 8 True
HospitalDischargeDate datetime 23 3 8 True
HRG varchar 0 0 50 True
ICNARC_ID bigint 19 0 8 True
IcuAdmissionDateTime datetime 23 3 8 True
IcuDischargeDateTime datetime 23 3 8 True
IMscore int 10 0 4 True
Level0days int 10 0 4 True
Level1days int 10 0 4 True
Level2days int 10 0 4 True
Level3days int 10 0 4 True
OriginalHospitalAdmissionDate datetime 23 3 8 True
OriginalIcuAdmissionDate datetime 23 3 8 True
Patient_ID bigint 19 0 8 False
pfratio real 24 0 4 True
Sex varchar 0 0 10 True
SupportDays_Dermatological int 10 0 4 True
SupportDays_Gastrointestinal int 10 0 4 True
SupportDays_Liver int 10 0 4 True
SupportDays_Neurological int 10 0 4 True
SupportDays_Renal int 10 0 4 True
TransferredIn varchar 0 0 10 True
TransferredOut varchar 0 0 10 True
UltimateHospitalDischargeDate datetime 23 3 8 True
UltimateIcuDischargeDate datetime 23 3 8 True
Ventilator int 10 0 4 True
yhsurv int 10 0 4 True
yusurv int 10 0 4 True

ISARIC

ISARIC_New

ColumnName ColumnType Precision Scale MaxLength IsNullable
abdopain_ceoccur_v2 varchar 0 0 1000 True
abdopain_ceoccur_v3 varchar 0 0 1000 True
adeno_mbcat varchar 0 0 1000 True
adeno_mbcat_v2 varchar 0 0 1000 True
adm_no_symp varchar 0 0 1000 True
admission_diabp_vsorres varchar 0 0 1000 True
admission_signs_and_symptoms_complete varchar 0 0 1000 True
age varchar 0 0 1000 True
age.factor varchar 0 0 1000 True
age_estimateyears varchar 0 0 1000 True
age_estimateyearsu varchar 0 0 1000 True
agedatyn varchar 0 0 1000 True
ageusia_ceoccur_v2 varchar 0 0 1000 True
ageusia_ceoccur_v3 varchar 0 0 1000 True
aidshiv_mhyn varchar 0 0 1000 True
aneamia_ceterm varchar 0 0 1000 True
animal_erdat varchar 0 0 1000 True
animal_erdat_2 varchar 0 0 1000 True
animal_erterm varchar 0 0 1000 True
animal_erterm_2 varchar 0 0 1000 True
animal_eryn varchar 0 0 1000 True
animal_eryn_2 varchar 0 0 1000 True
anosmia_ceoccur_v2 varchar 0 0 1000 True
anosmia_ceoccur_v3 varchar 0 0 1000 True
antibiotic_cmtrt varchar 0 0 1000 True
antibiotic_cmyn varchar 0 0 1000 True
antibiotic2_cmtrt varchar 0 0 1000 True
antibiotic2_cmyn varchar 0 0 1000 True
antibiotic3_cmtrt varchar 0 0 1000 True
antibiotic3_cmyn varchar 0 0 1000 True
antibiotic4_cmtrt varchar 0 0 1000 True
antibiotic4_cmyn varchar 0 0 1000 True
antibiotic5_cmtrt varchar 0 0 1000 True
antibiotic5_cmyn varchar 0 0 1000 True
antibiotic6_cmtrt varchar 0 0 1000 True
antibiotic6_cmyn varchar 0 0 1000 True
antibiotic7_cmtrt varchar 0 0 1000 True
antibiotic7_cmyn varchar 0 0 1000 True
antifung_cmyn varchar 0 0 1000 True
antifungal_cmtrt varchar 0 0 1000 True
antiviral_cmtrt___1 varchar 0 0 1000 True
antiviral_cmtrt___10 varchar 0 0 1000 True
antiviral_cmtrt___11 varchar 0 0 1000 True
antiviral_cmtrt___12 varchar 0 0 1000 True
antiviral_cmtrt___2 varchar 0 0 1000 True
antiviral_cmtrt___3 varchar 0 0 1000 True
antiviral_cmtrt___4 varchar 0 0 1000 True
antiviral_cmtrt___5 varchar 0 0 1000 True
antiviral_cmtrt___6 varchar 0 0 1000 True
antiviral_cmtrt___7 varchar 0 0 1000 True
antiviral_cmtrt___8 varchar 0 0 1000 True
antiviral_cmtrt___9 varchar 0 0 1000 True
antiviral_cmyn varchar 0 0 1000 True
any_daily_fio2_21 varchar 0 0 1000 True
any_daily_fio2_28 varchar 0 0 1000 True
any_daily_hoterm varchar 0 0 1000 True
any_daily_invasive_prtrt varchar 0 0 1000 True
any_daily_nasaloxy_cmtrt varchar 0 0 1000 True
any_daily_noninvasive_prtrt varchar 0 0 1000 True
any_icu varchar 0 0 1000 True
any_icu_hoterm varchar 0 0 1000 True
any_invasive varchar 0 0 1000 True
any_invasive_proccur varchar 0 0 1000 True
any_noninvasive varchar 0 0 1000 True
any_noninvasive_proccur varchar 0 0 1000 True
any_oxygen varchar 0 0 1000 True
any_oxygen_cmoccur varchar 0 0 1000 True
any_oxygenhf_cmoccur varchar 0 0 1000 True
any_trach varchar 0 0 1000 True
anydat.day1 varchar 0 0 1000 True
anydat.disch varchar 0 0 1000 True
apdm_age varchar 0 0 1000 True
aplb_lbmethod varchar 0 0 1000 True
aplb_lbmethodoth varchar 0 0 1000 True
aplb_lborres varchar 0 0 1000 True
aplb_lborres_out varchar 0 0 1000 True
aplb_lbperf varchar 0 0 1000 True
aplb_lbperf_out varchar 0 0 1000 True
apsc_brdisdat varchar 0 0 1000 True
apsc_brfedind varchar 0 0 1000 True
apsc_brfedindy varchar 0 0 1000 True
apsc_dvageind varchar 0 0 1000 True
apsc_gestout varchar 0 0 1000 True
apsc_vcageind varchar 0 0 1000 True
apvs_weight varchar 0 0 1000 True
apvs_weightnk varchar 0 0 1000 True
apvs_weightu varchar 0 0 1000 True
ards_ceoccur varchar 0 0 1000 True
ari varchar 0 0 1000 True
arm varchar 0 0 1000 True
arm_n varchar 0 0 1000 True
arm_participant varchar 0 0 1000 True
arrhythmia_ceterm varchar 0 0 1000 True
asthma_mhyn varchar 0 0 1000 True
asymptomatic varchar 0 0 1000 True
avpu_vsorres.day1 varchar 0 0 1000 True
avpu_vsorres.disch varchar 0 0 1000 True
bact_mborres varchar 0 0 1000 True
bacteraemia_ceterm varchar 0 0 1000 True
bacteria_mborres varchar 0 0 1000 True
bactpneu_ceoccur varchar 0 0 1000 True
bleed_ceoccur_v2 varchar 0 0 1000 True
bleed_ceoccur_v3 varchar 0 0 1000 True
bleed_ceterm_v2 varchar 0 0 1000 True
bleed_cetermy_v2 varchar 0 0 1000 True
bleed_cetermy_v3 varchar 0 0 1000 True
bloodgroup varchar 0 0 1000 True
bronchio_ceterm varchar 0 0 1000 True
calc_age varchar 0 0 1000 True
cardiacarrest_ceterm varchar 0 0 1000 True
cardiomyopathy_ceterm varchar 0 0 1000 True
casiriv_cmtrt_first varchar 0 0 1000 True
ccg varchar 0 0 1000 True
cestdat varchar 0 0 1000 True
chestpain_ceoccur_v2 varchar 0 0 1000 True
chestpain_ceoccur_v3 varchar 0 0 1000 True
chrincard varchar 0 0 1000 True
chronic_ace_cmoccur varchar 0 0 1000 True
chronic_arb_cmoccur varchar 0 0 1000 True
chronic_nsaid_cmoccur varchar 0 0 1000 True
chronichaemo_mhyn varchar 0 0 1000 True
chronicneu_mhyn varchar 0 0 1000 True
chronicpul_mhyn varchar 0 0 1000 True
clinical_frailty varchar 0 0 1000 True
clinicalpneu_mborres varchar 0 0 1000 True
coagulo_ceterm varchar 0 0 1000 True
comorb_none varchar 0 0 1000 True
comorbidities_complete varchar 0 0 1000 True
complications_complete varchar 0 0 1000 True
complications_none varchar 0 0 1000 True
confirmed_negative_pcr varchar 0 0 1000 True
confirmed_negative_pcr_complete varchar 0 0 1000 True
confusion_ceoccur_v2 varchar 0 0 1000 True
confusion_ceoccur_v3 varchar 0 0 1000 True
conjunct_ceoccur_v2 varchar 0 0 1000 True
conjunct_ceoccur_v3 varchar 0 0 1000 True
consent_ctu_dms_complete varchar 0 0 1000 True
consent_daterec varchar 0 0 1000 True
consent_given varchar 0 0 1000 True
consent_mode___1 varchar 0 0 1000 True
consent_mode___10 varchar 0 0 1000 True
consent_mode___11 varchar 0 0 1000 True
consent_mode___2 varchar 0 0 1000 True
consent_mode___3 varchar 0 0 1000 True
consent_mode___4 varchar 0 0 1000 True
consent_mode___5 varchar 0 0 1000 True
consent_mode___6 varchar 0 0 1000 True
consent_mode___7 varchar 0 0 1000 True
consent_mode___8 varchar 0 0 1000 True
consent_mode___9 varchar 0 0 1000 True
consent_optcondit___1 varchar 0 0 1000 True
consent_optcondit___2 varchar 0 0 1000 True
consent_optcondit___3 varchar 0 0 1000 True
consent_optcondit___4 varchar 0 0 1000 True
consent_phone varchar 0 0 1000 True
conv_plasma_cmyn varchar 0 0 1000 True
core_additional_information_complete varchar 0 0 4000 True
coriona_ieorres2 varchar 0 0 1000 True
coriona_ieorres3 varchar 0 0 1000 True
corna_mbcat varchar 0 0 1000 True
corna_mbcaty varchar 0 0 1000 True
corona_ieorres varchar 0 0 1000 True
coronaother_mborres varchar 0 0 1000 True
corticost_cmdose varchar 0 0 1000 True
corticost_cmroute varchar 0 0 1000 True
corticost_cmtrt varchar 0 0 1000 True
corticost_cmtrt_type varchar 0 0 1000 True
corticost_cmyn varchar 0 0 1000 True
corticost2_cmdose varchar 0 0 1000 True
corticost2_cmroute varchar 0 0 1000 True
corticost2_cmtrt varchar 0 0 1000 True
corticost2_cmtrt_type varchar 0 0 1000 True
corticost2_cmyn varchar 0 0 1000 True
corticost3_cmdose varchar 0 0 1000 True
corticost3_cmroute varchar 0 0 1000 True
corticost3_cmtrt varchar 0 0 1000 True
corticost3_cmtrt_type varchar 0 0 1000 True
corticost3_cmyn varchar 0 0 1000 True
corticost4_cmdose varchar 0 0 1000 True
corticost4_cmroute varchar 0 0 1000 True
corticost4_cmtrt varchar 0 0 1000 True
corticost4_cmtrt_type varchar 0 0 1000 True
corticost4_cmyn varchar 0 0 1000 True
corticost5_cmdose varchar 0 0 1000 True
corticost5_cmroute varchar 0 0 1000 True
corticost5_cmtrt varchar 0 0 1000 True
corticost5_cmtrt_type varchar 0 0 1000 True
corticost5_cmyn varchar 0 0 1000 True
cough varchar 0 0 1000 True
cough_ceoccur_v2 varchar 0 0 1000 True
cough_ceoccur_v3 varchar 0 0 1000 True
coughhb_ceoccur_v2 varchar 0 0 1000 True
coughhb_ceoccur_v3 varchar 0 0 1000 True
coughsput_ceoccur_v2 varchar 0 0 1000 True
coughsput_ceoccur_v3 varchar 0 0 1000 True
country varchar 0 0 1000 True
country_pcds.day1 varchar 0 0 1000 True
country_pcds.disch varchar 0 0 1000 True
cov19sars_mbyn_v2 varchar 0 0 1000 True
covid19_new varchar 0 0 1000 True
covid19_vaccine varchar 0 0 1000 True
covid19_vaccine_other_type varchar 0 0 1000 True
covid19_vaccine_type varchar 0 0 1000 True
covid19_vaccine2d varchar 0 0 1000 True
covid19_vaccine2d_nk varchar 0 0 1000 True
covid19_vaccined varchar 0 0 1000 True
covid19_vaccined_nk varchar 0 0 1000 True
cryptogenic_ceterm varchar 0 0 1000 True
daily_alt_lborres.day1 varchar 0 0 1000 True
daily_alt_lborres.disch varchar 0 0 1000 True
daily_alt_lbyn.day1 varchar 0 0 1000 True
daily_alt_lbyn.disch varchar 0 0 1000 True
daily_altop_lbyn.day1 varchar 0 0 1000 True
daily_altop_lbyn.disch varchar 0 0 1000 True
daily_aptt_lborres.day1 varchar 0 0 1000 True
daily_aptt_lborres.disch varchar 0 0 1000 True
daily_aptt_lbyn.day1 varchar 0 0 1000 True
daily_aptt_lbyn.disch varchar 0 0 1000 True
daily_apttop_lborres.day1 varchar 0 0 1000 True
daily_apttop_lborres.disch varchar 0 0 1000 True
daily_ast_lborres.day1 varchar 0 0 1000 True
daily_ast_lborres.disch varchar 0 0 1000 True
daily_ast_lbyn.day1 varchar 0 0 1000 True
daily_ast_lbyn.disch varchar 0 0 1000 True
daily_astop_lborres.day1 varchar 0 0 1000 True
daily_astop_lborres.disch varchar 0 0 1000 True
daily_baseex_lborres.day1 varchar 0 0 1000 True
daily_baseex_lborres.disch varchar 0 0 1000 True
daily_baseex_lbyn.day1 varchar 0 0 1000 True
daily_baseex_lbyn.disch varchar 0 0 1000 True
daily_bil_lborres.day1 varchar 0 0 1000 True
daily_bil_lborres.disch varchar 0 0 1000 True
daily_bil_lborresu.day1 varchar 0 0 1000 True
daily_bil_lborresu.disch varchar 0 0 1000 True
daily_bil_lbyn.day1 varchar 0 0 1000 True
daily_bil_lbyn.disch varchar 0 0 1000 True
daily_bilop_lborres.day1 varchar 0 0 1000 True
daily_bilop_lborres.disch varchar 0 0 1000 True
daily_bun_lborres.day1 varchar 0 0 1000 True
daily_bun_lborres.disch varchar 0 0 1000 True
daily_bun_lborresu.day1 varchar 0 0 1000 True
daily_bun_lborresu.disch varchar 0 0 1000 True
daily_bun_lbyn.day1 varchar 0 0 1000 True
daily_bun_lbyn.disch varchar 0 0 1000 True
daily_bunop_lborres.day1 varchar 0 0 1000 True
daily_bunop_lborres.disch varchar 0 0 1000 True
daily_cpk_lby.day1 varchar 0 0 1000 True
daily_cpk_lby.disch varchar 0 0 1000 True
daily_cpk_lbyn_2.day1 varchar 0 0 1000 True
daily_cpk_lbyn_2.disch varchar 0 0 1000 True
daily_cpkop_lbyn_2.day1 varchar 0 0 1000 True
daily_cpkop_lbyn_2.disch varchar 0 0 1000 True
daily_creat_lborres.day1 varchar 0 0 1000 True
daily_creat_lborres.disch varchar 0 0 1000 True
daily_creat_lborresu.day1 varchar 0 0 1000 True
daily_creat_lborresu.disch varchar 0 0 1000 True
daily_creat_lbyn.day1 varchar 0 0 1000 True
daily_creat_lbyn.disch varchar 0 0 1000 True
daily_creatop_lborres.day1 varchar 0 0 1000 True
daily_creatop_lborres.disch varchar 0 0 1000 True
daily_crp_lborres.day1 varchar 0 0 1000 True
daily_crp_lborres.disch varchar 0 0 1000 True
daily_crp_lborresu.day1 varchar 0 0 1000 True
daily_crp_lborresu.disch varchar 0 0 1000 True
daily_crp_lbyn.day1 varchar 0 0 1000 True
daily_crp_lbyn.disch varchar 0 0 1000 True
daily_crpop_lborres.day1 varchar 0 0 1000 True
daily_crpop_lborres.disch varchar 0 0 1000 True
daily_dop5to15_cmtrt.day1 varchar 0 0 1000 True
daily_dop5to15_cmtrt.disch varchar 0 0 1000 True
daily_dopgr15_cmtrt.day1 varchar 0 0 1000 True
daily_dopgr15_cmtrt.disch varchar 0 0 1000 True
daily_dopless5_cmtrt.day1 varchar 0 0 1000 True
daily_dopless5_cmtrt.disch varchar 0 0 1000 True
daily_dsstdat.day1 varchar 0 0 1000 True
daily_dsstdat.disch varchar 0 0 1000 True
daily_ecmo_prtrt.day1 varchar 0 0 1000 True
daily_ecmo_prtrt.disch varchar 0 0 1000 True
daily_egfr_equation___1.day1 varchar 0 0 1000 True
daily_egfr_equation___1.disch varchar 0 0 1000 True
daily_egfr_equation___2.day1 varchar 0 0 1000 True
daily_egfr_equation___2.disch varchar 0 0 1000 True
daily_egfr_equation___3.day1 varchar 0 0 1000 True
daily_egfr_equation___3.disch varchar 0 0 1000 True
daily_egfr_equation___4.day1 varchar 0 0 1000 True
daily_egfr_equation___4.disch varchar 0 0 1000 True
daily_egfr_lborres.day1 varchar 0 0 1000 True
daily_egfr_lborres.disch varchar 0 0 1000 True
daily_egfr_lbyn.day1 varchar 0 0 1000 True
daily_egfr_lbyn.disch varchar 0 0 1000 True
daily_egfrop_lborres.day1 varchar 0 0 1000 True
daily_egfrop_lborres.disch varchar 0 0 1000 True
daily_esr_lborres.day1 varchar 0 0 1000 True
daily_esr_lborres.disch varchar 0 0 1000 True
daily_esr_lbyn.day1 varchar 0 0 1000 True
daily_esr_lbyn.disch varchar 0 0 1000 True
daily_esrop_lbyn.day1 varchar 0 0 1000 True
daily_esrop_lbyn.disch varchar 0 0 1000 True
daily_ferr_lborres.day1 varchar 0 0 1000 True
daily_ferr_lborres.disch varchar 0 0 1000 True
daily_ferr_lborresu.day1 varchar 0 0 1000 True
daily_ferr_lborresu.disch varchar 0 0 1000 True
daily_ferr_lbyn.day1 varchar 0 0 1000 True
daily_ferr_lbyn.disch varchar 0 0 1000 True
daily_ferrop_lbyn.day1 varchar 0 0 1000 True
daily_ferrop_lbyn.disch varchar 0 0 1000 True
daily_fi02_lbyn.day1 varchar 0 0 1000 True
daily_fi02_lbyn.disch varchar 0 0 1000 True
daily_fio2_combined.day1 varchar 0 0 1000 True
daily_fio2_combined.disch varchar 0 0 1000 True
daily_fio2_lborres.day1 varchar 0 0 1000 True
daily_fio2_lborres.disch varchar 0 0 1000 True
daily_fio2b_lborres.day1 varchar 0 0 1000 True
daily_fio2b_lborres.disch varchar 0 0 1000 True
daily_fio2c_lborres.day1 varchar 0 0 1000 True
daily_fio2c_lborres.disch varchar 0 0 1000 True
daily_fio2c_lborres_converted.day1 varchar 0 0 1000 True
daily_fio2c_lborres_converted.disch varchar 0 0 4000 True
daily_form_complete.day1 varchar 0 0 1000 True
daily_form_complete.disch varchar 0 0 1000 True
daily_gcs_lbyn.day1 varchar 0 0 1000 True
daily_gcs_lbyn.disch varchar 0 0 1000 True
daily_gcs_vsorres.day1 varchar 0 0 1000 True
daily_gcs_vsorres.disch varchar 0 0 1000 True
daily_glucose_lborres.day1 varchar 0 0 1000 True
daily_glucose_lborres.disch varchar 0 0 1000 True
daily_glucose_lborresu.day1 varchar 0 0 1000 True
daily_glucose_lborresu.disch varchar 0 0 1000 True
daily_glucose_lbyn.day1 varchar 0 0 1000 True
daily_glucose_lbyn.disch varchar 0 0 1000 True
daily_glucoseop_lborres.day1 varchar 0 0 1000 True
daily_glucoseop_lborres.disch varchar 0 0 1000 True
daily_haematocrit_lborres.day1 varchar 0 0 1000 True
daily_haematocrit_lborres.disch varchar 0 0 1000 True
daily_haematocrit_lborresu.day1 varchar 0 0 1000 True
daily_haematocrit_lborresu.disch varchar 0 0 1000 True
daily_haematocrit_lbyn.day1 varchar 0 0 1000 True
daily_haematocrit_lbyn.disch varchar 0 0 1000 True
daily_hb_lborres.day1 varchar 0 0 1000 True
daily_hb_lborres.disch varchar 0 0 1000 True
daily_hb_lborresu.day1 varchar 0 0 1000 True
daily_hb_lborresu.disch varchar 0 0 1000 True
daily_hb_lbyn.day1 varchar 0 0 1000 True
daily_hb_lbyn.disch varchar 0 0 1000 True
daily_hba1c_lborres.day1 varchar 0 0 1000 True
daily_hba1c_lborres.disch varchar 0 0 1000 True
daily_hba1c_lborresd.day1 varchar 0 0 1000 True
daily_hba1c_lborresd.disch varchar 0 0 1000 True
daily_hba1c_lborresnk.day1 varchar 0 0 1000 True
daily_hba1c_lborresnk.disch varchar 0 0 1000 True
daily_hba1c_lborresu.day1 varchar 0 0 1000 True
daily_hba1c_lborresu.disch varchar 0 0 1000 True
daily_hba1cop_lborres.day1 varchar 0 0 1000 True
daily_hba1cop_lborres.disch varchar 0 0 1000 True
daily_hbop_lborres.day1 varchar 0 0 1000 True
daily_hbop_lborres.disch varchar 0 0 1000 True
daily_hco3_lborres.day1 varchar 0 0 1000 True
daily_hco3_lborres.disch varchar 0 0 1000 True
daily_hco3_lborresu.day1 varchar 0 0 1000 True
daily_hco3_lborresu.disch varchar 0 0 1000 True
daily_hco3_lbyn.day1 varchar 0 0 1000 True
daily_hco3_lbyn.disch varchar 0 0 1000 True
daily_hoterm.day1 varchar 0 0 1000 True
daily_hoterm.disch varchar 0 0 1000 True
daily_inotrope_cmyn.day1 varchar 0 0 1000 True
daily_inotrope_cmyn.disch varchar 0 0 1000 True
daily_inr_lborres.day1 varchar 0 0 1000 True
daily_inr_lborres.disch varchar 0 0 1000 True
daily_inrop_lborres.day1 varchar 0 0 1000 True
daily_inrop_lborres.disch varchar 0 0 1000 True
daily_invasive_prtrt.day1 varchar 0 0 1000 True
daily_invasive_prtrt.disch varchar 0 0 1000 True
daily_lactate_lborres.day1 varchar 0 0 1000 True
daily_lactate_lborres.disch varchar 0 0 1000 True
daily_lactate_lborresu.day1 varchar 0 0 1000 True
daily_lactate_lborresu.disch varchar 0 0 1000 True
daily_lactate_lbyn.day1 varchar 0 0 1000 True
daily_lactate_lbyn.disch varchar 0 0 1000 True
daily_lactateop_lbyn.day1 varchar 0 0 1000 True
daily_lactateop_lbyn.disch varchar 0 0 1000 True
daily_lbdat.day1 varchar 0 0 1000 True
daily_lbdat.disch varchar 0 0 1000 True
daily_lbperf.day1 varchar 0 0 1000 True
daily_lbperf.disch varchar 0 0 1000 True
daily_ldh_lborres.day1 varchar 0 0 1000 True
daily_ldh_lborres.disch varchar 0 0 1000 True
daily_ldh_lbyn.day1 varchar 0 0 1000 True
daily_ldh_lbyn.disch varchar 0 0 1000 True
daily_ldhop_lborres.day1 varchar 0 0 1000 True
daily_ldhop_lborres.disch varchar 0 0 1000 True
daily_lymp_lborres.day1 varchar 0 0 1000 True
daily_lymp_lborres.disch varchar 0 0 1000 True
daily_lymp_lborresu.day1 varchar 0 0 1000 True
daily_lymp_lborresu.disch varchar 0 0 1000 True
daily_lymp_lbyn.day1 varchar 0 0 1000 True
daily_lymp_lbyn.disch varchar 0 0 1000 True
daily_lympop_lbyn.day1 varchar 0 0 1000 True
daily_lympop_lbyn.disch varchar 0 0 1000 True
daily_meanart_lbyn.day1 varchar 0 0 1000 True
daily_meanart_lbyn.disch varchar 0 0 1000 True
daily_meanart_vsorres.day1 varchar 0 0 1000 True
daily_meanart_vsorres.disch varchar 0 0 1000 True
daily_nasaloxy_cmtrt.day1 varchar 0 0 1000 True
daily_nasaloxy_cmtrt.disch varchar 0 0 1000 True
daily_neuro_cmtrt.day1 varchar 0 0 1000 True
daily_neuro_cmtrt.disch varchar 0 0 1000 True
daily_neutro_lborres.day1 varchar 0 0 1000 True
daily_neutro_lborres.disch varchar 0 0 1000 True
daily_neutro_lborresu.day1 varchar 0 0 1000 True
daily_neutro_lborresu.disch varchar 0 0 1000 True
daily_neutro_lbyn.day1 varchar 0 0 1000 True
daily_neutro_lbyn.disch varchar 0 0 1000 True
daily_neutroop_lbyn.day1 varchar 0 0 1000 True
daily_neutroop_lbyn.disch varchar 0 0 1000 True
daily_nitritc_cmtrt.day1 varchar 0 0 1000 True
daily_nitritc_cmtrt.disch varchar 0 0 1000 True
daily_noninvasive_prtrt.day1 varchar 0 0 1000 True
daily_noninvasive_prtrt.disch varchar 0 0 1000 True
daily_other_prtrt.day1 varchar 0 0 1000 True
daily_other_prtrt.disch varchar 0 0 1000 True
daily_pao2_lborres.day1 varchar 0 0 1000 True
daily_pao2_lborres.disch varchar 0 0 1000 True
daily_pao2_lborresu.day1 varchar 0 0 1000 True
daily_pao2_lborresu.disch varchar 0 0 1000 True
daily_pao2_lbspec.day1 varchar 0 0 1000 True
daily_pao2_lbspec.disch varchar 0 0 1000 True
daily_pao2_lbyn.day1 varchar 0 0 1000 True
daily_pao2_lbyn.disch varchar 0 0 1000 True
daily_pco2_lborres.day1 varchar 0 0 1000 True
daily_pco2_lborres.disch varchar 0 0 1000 True
daily_pco2_lborresu.day1 varchar 0 0 1000 True
daily_pco2_lborresu.disch varchar 0 0 1000 True
daily_pco2_lbyn.day1 varchar 0 0 1000 True
daily_pco2_lbyn.disch varchar 0 0 1000 True
daily_ph_lborres.day1 varchar 0 0 1000 True
daily_ph_lborres.disch varchar 0 0 1000 True
daily_ph_lbyn.day1 varchar 0 0 1000 True
daily_ph_lbyn.disch varchar 0 0 1000 True
daily_plt_lborres.day1 varchar 0 0 1000 True
daily_plt_lborres.disch varchar 0 0 1000 True
daily_plt_lborresu.day1 varchar 0 0 1000 True
daily_plt_lborresu.disch varchar 0 0 1000 True
daily_plt_lbyn.day1 varchar 0 0 1000 True
daily_plt_lbyn.disch varchar 0 0 1000 True
daily_pltop_lborres.day1 varchar 0 0 1000 True
daily_pltop_lborres.disch varchar 0 0 1000 True
daily_potassium_lborres.day1 varchar 0 0 1000 True
daily_potassium_lborres.disch varchar 0 0 1000 True
daily_potassium_lborresu.day1 varchar 0 0 1000 True
daily_potassium_lborresu.disch varchar 0 0 1000 True
daily_potassium_lbyn.day1 varchar 0 0 1000 True
daily_potassium_lbyn.disch varchar 0 0 1000 True
daily_potassiumop_lborres.day1 varchar 0 0 1000 True
daily_potassiumop_lborres.disch varchar 0 0 1000 True
daily_procal_lborres.day1 varchar 0 0 1000 True
daily_procal_lborres.disch varchar 0 0 1000 True
daily_procal_lbyn.day1 varchar 0 0 1000 True
daily_procal_lbyn.disch varchar 0 0 1000 True
daily_procalop_lborres.day1 varchar 0 0 1000 True
daily_procalop_lborres.disch varchar 0 0 1000 True
daily_prone_cmtrt.day1 varchar 0 0 1000 True
daily_prone_cmtrt.disch varchar 0 0 1000 True
daily_prperf.day1 varchar 0 0 1000 True
daily_prperf.disch varchar 0 0 1000 True
daily_pt_inr_lbyn.day1 varchar 0 0 1000 True
daily_pt_inr_lbyn.disch varchar 0 0 1000 True
daily_pt_lborres.day1 varchar 0 0 1000 True
daily_pt_lborres.disch varchar 0 0 1000 True
daily_pt_lborres_add_inr.day1 varchar 0 0 1000 True
daily_pt_lborres_add_inr.disch varchar 0 0 1000 True
daily_ptop_lborres.day1 varchar 0 0 1000 True
daily_ptop_lborres.disch varchar 0 0 1000 True
daily_rr.day1 varchar 0 0 1000 True
daily_rr.disch varchar 0 0 1000 True
daily_rr_nk.day1 varchar 0 0 1000 True
daily_rr_nk.disch varchar 0 0 1000 True
daily_rrt_cmtrt.day1 varchar 0 0 1000 True
daily_rrt_cmtrt.disch varchar 0 0 1000 True
daily_sa02_lbyn.day1 varchar 0 0 1000 True
daily_sa02_lbyn.disch varchar 0 0 1000 True
daily_samples.day1 varchar 0 0 1000 True
daily_samples.disch varchar 0 0 1000 True
daily_samples_kitno.day1 varchar 0 0 1000 True
daily_samples_kitno.disch varchar 0 0 1000 True
daily_sao2_lborres.day1 varchar 0 0 1000 True
daily_sao2_lborres.disch varchar 0 0 1000 True
daily_sodium_lborres.day1 varchar 0 0 1000 True
daily_sodium_lborres.disch varchar 0 0 1000 True
daily_sodium_lborresu.day1 varchar 0 0 1000 True
daily_sodium_lborresu.disch varchar 0 0 1000 True
daily_sodium_lbyn.day1 varchar 0 0 1000 True
daily_sodium_lbyn.disch varchar 0 0 1000 True
daily_sodiumop_lborres.day1 varchar 0 0 1000 True
daily_sodiumop_lborres.disch varchar 0 0 1000 True
daily_temp_vsorres.day1 varchar 0 0 1000 True
daily_temp_vsorres.disch varchar 0 0 1000 True
daily_temp_vsorresnk.day1 varchar 0 0 1000 True
daily_temp_vsorresnk.disch varchar 0 0 1000 True
daily_temp_vsorresu.day1 varchar 0 0 1000 True
daily_temp_vsorresu.disch varchar 0 0 1000 True
daily_trach_prperf.day1 varchar 0 0 1000 True
daily_trach_prperf.disch varchar 0 0 1000 True
daily_urine_lborres.day1 varchar 0 0 1000 True
daily_urine_lborres.disch varchar 0 0 1000 True
daily_urine_lbyn.day1 varchar 0 0 1000 True
daily_urine_lbyn.disch varchar 0 0 1000 True
daily_wbc_lborres.day1 varchar 0 0 1000 True
daily_wbc_lborres.disch varchar 0 0 1000 True
daily_wbc_lborresu.day1 varchar 0 0 1000 True
daily_wbc_lborresu.disch varchar 0 0 1000 True
daily_wbc_lbyn.day1 varchar 0 0 1000 True
daily_wbc_lbyn.disch varchar 0 0 1000 True
daily_wbcop_lborres.day1 varchar 0 0 1000 True
daily_wbcop_lborres.disch varchar 0 0 1000 True
dehydration_vsorres varchar 0 0 1000 True
dementia_mhyn varchar 0 0 1000 True
demographics_complete varchar 0 0 1000 True
dexamethasone varchar 0 0 1000 True
dexamethasone_days varchar 0 0 1000 True
dexamethasone_dose varchar 0 0 1000 True
dexamethasone_freq varchar 0 0 1000 True
dexamethasone_other_freq varchar 0 0 1000 True
dexamethasone_route varchar 0 0 1000 True
dexamethasone2 varchar 0 0 1000 True
dexamethasone2_days varchar 0 0 1000 True
dexamethasone2_dose varchar 0 0 1000 True
dexamethasone2_freq varchar 0 0 1000 True
dexamethasone2_other_freq varchar 0 0 1000 True
dexamethasone2_route varchar 0 0 1000 True
dexamethasone3 varchar 0 0 1000 True
dexamethasone3_days varchar 0 0 1000 True
dexamethasone3_dose varchar 0 0 1000 True
dexamethasone3_freq varchar 0 0 1000 True
dexamethasone3_other_freq varchar 0 0 1000 True
dexamethasone3_route varchar 0 0 1000 True
dexamethasone4 varchar 0 0 1000 True
dexamethasone4_days varchar 0 0 1000 True
dexamethasone4_dose varchar 0 0 1000 True
dexamethasone4_freq varchar 0 0 1000 True
dexamethasone4_other_freq varchar 0 0 1000 True
dexamethasone4_route varchar 0 0 1000 True
dexamethasone5 varchar 0 0 1000 True
dexamethasone5_days varchar 0 0 1000 True
dexamethasone5_dose varchar 0 0 1000 True
dexamethasone5_freq varchar 0 0 1000 True
dexamethasone5_other_freq varchar 0 0 1000 True
dexamethasone5_route varchar 0 0 1000 True
diabetes_mhyn varchar 0 0 1000 True
diabetes_type_mhyn varchar 0 0 1000 True
diabetescom_mhyn varchar 0 0 1000 True
diabp_vsyn varchar 0 0 1000 True
diarrhoea_ceoccur_v2 varchar 0 0 1000 True
diarrhoea_ceoccur_v3 varchar 0 0 1000 True
diastolic_vsorres.day1 varchar 0 0 1000 True
diastolic_vsorres.disch varchar 0 0 1000 True
diastolic_vsyn.day1 varchar 0 0 1000 True
diastolic_vsyn.disch varchar 0 0 1000 True
dlvrdtc_rptestcd varchar 0 0 1000 True
dlvrdtc_rptestcd_out varchar 0 0 1000 True
dshosp varchar 0 0 1000 True
dsstdat varchar 0 0 1000 True
dsstdtc varchar 0 0 1000 True
dsstdtc_v2 varchar 0 0 1000 True
dsstdtc_v2_nk varchar 0 0 1000 True
dsstdtcyn varchar 0 0 1000 True
dsterm varchar 0 0 1000 True
dsterm_v2 varchar 0 0 1000 True
dvt_ceterm varchar 0 0 1000 True
dyspnoe varchar 0 0 1000 True
earpain_ceoccur_v2 varchar 0 0 1000 True
earpain_ceoccur_v3 varchar 0 0 1000 True
egestage_rptestcd varchar 0 0 1000 True
endocarditis_aeterm varchar 0 0 1000 True
erendat varchar 0 0 1000 True
erendat_2 varchar 0 0 1000 True
estgest varchar 0 0 1000 True
ethnic___1 varchar 0 0 1000 True
ethnic___10 varchar 0 0 1000 True
ethnic___2 varchar 0 0 1000 True
ethnic___3 varchar 0 0 1000 True
ethnic___4 varchar 0 0 1000 True
ethnic___5 varchar 0 0 1000 True
ethnic___6 varchar 0 0 1000 True
ethnic___7 varchar 0 0 1000 True
ethnic___8 varchar 0 0 1000 True
ethnic___9 varchar 0 0 1000 True
ethnicity varchar 0 0 1000 True
excorp_prdur varchar 0 0 1000 True
excorp_still_on varchar 0 0 1000 True
extracorp_prtrt varchar 0 0 1000 True
fatigue_ceoccur_v2 varchar 0 0 1000 True
fatigue_ceoccur_v3 varchar 0 0 1000 True
fever varchar 0 0 1000 True
fever_ceoccur_v2 varchar 0 0 1000 True
fever_ceoccur_v3 varchar 0 0 1000 True
final_outcome_complete varchar 0 0 1000 True
flw_any.day1 varchar 0 0 1000 True
flw_any.disch varchar 0 0 1000 True
gastro_ceterm varchar 0 0 1000 True
headache_ceoccur_v2 varchar 0 0 1000 True
headache_ceoccur_v3 varchar 0 0 1000 True
healthwork_erterm varchar 0 0 1000 True
heartfailure_ceterm varchar 0 0 1000 True
hodur varchar 0 0 1000 True
hooccur varchar 0 0 1000 True
hostdat varchar 0 0 1000 True
hostdat_transfer varchar 0 0 1000 True
hostdat_transfernk varchar 0 0 1000 True
hosttim varchar 0 0 1000 True
hr_vsorres varchar 0 0 1000 True
hr_vsyn varchar 0 0 1000 True
hyperglycemia_aeterm varchar 0 0 1000 True
hypertension_mhyn varchar 0 0 1000 True
hypoglycemia_ceterm varchar 0 0 1000 True
icu_hoendat varchar 0 0 1000 True
icu_hoendat2 varchar 0 0 1000 True
icu_hoendat2_nk varchar 0 0 1000 True
icu_hoendat3 varchar 0 0 1000 True
icu_hoendat3_nk varchar 0 0 1000 True
icu_hoendatnk varchar 0 0 1000 True
icu_hostdat varchar 0 0 1000 True
icu_hostdat2 varchar 0 0 1000 True
icu_hostdat2_nk varchar 0 0 1000 True
icu_hostdat3 varchar 0 0 1000 True
icu_hostdat3_nk varchar 0 0 1000 True
icu_hostdatnk varchar 0 0 1000 True
icu_hostillin varchar 0 0 1000 True
icu_hoterm varchar 0 0 1000 True
icu_no varchar 0 0 1000 True
il6_cmtrt varchar 0 0 1000 True
il6_cmtrt_first varchar 0 0 1000 True
il6_cmtrt_last varchar 0 0 1000 True
il6_cmtrt_other varchar 0 0 1000 True
imd_quintile varchar 0 0 1000 True
immno_cmtrt varchar 0 0 1000 True
inclusion_criteria_complete varchar 0 0 1000 True
infect varchar 0 0 1000 True
infect_cmtrt varchar 0 0 1000 True
infectious_respiratory_disease_pathogen_diagnosis_complete varchar 0 0 1000 True
infectuk_mborres varchar 0 0 1000 True
infiltrates_faorres.day1 varchar 0 0 1000 True
infiltrates_faorres.disch varchar 0 0 1000 True
inflammatory_mss varchar 0 0 1000 True
influ_mbcat varchar 0 0 1000 True
influ_mbyn varchar 0 0 1000 True
influ_mbyn_v2 varchar 0 0 1000 True
influenza_2021_vaccine varchar 0 0 1000 True
influenza_2021_vaccined varchar 0 0 1000 True
influenza_2021_vaccined_nk varchar 0 0 1000 True
influother_mborres varchar 0 0 1000 True
influothera_mborres varchar 0 0 1000 True
inhalednit_cmtrt varchar 0 0 1000 True
inotrop_cmtrt varchar 0 0 1000 True
inotrope_cmdur varchar 0 0 1000 True
inotrope_still_on varchar 0 0 1000 True
interleukin_cmtrt varchar 0 0 1000 True
interleukin_cmyn varchar 0 0 1000 True
invasive_prdur varchar 0 0 1000 True
invasive_proccur varchar 0 0 1000 True
invasive_still_on varchar 0 0 1000 True
ischaemia_ceterm varchar 0 0 1000 True
jointpain_ceoccur_v2 varchar 0 0 1000 True
jointpain_ceoccur_v3 varchar 0 0 1000 True
labwork_erterm varchar 0 0 1000 True
liverdysfunction_ceterm varchar 0 0 1000 True
lowerchest_ceoccur_v2 varchar 0 0 1000 True
lowerchest_ceoccur_v3 varchar 0 0 1000 True
lymp_ceoccur_v2 varchar 0 0 1000 True
lymp_ceoccur_v3 varchar 0 0 1000 True
malignantneo_mhyn varchar 0 0 1000 True
malnutrition_mhyn varchar 0 0 1000 True
mbperf varchar 0 0 1000 True
meningitis_ceterm varchar 0 0 1000 True
mildliver varchar 0 0 1000 True
modliv varchar 0 0 1000 True
myalgia_ceoccur_v2 varchar 0 0 1000 True
myalgia_ceoccur_v3 varchar 0 0 1000 True
myocarditis_ceterm varchar 0 0 1000 True
neuro_cmtrt varchar 0 0 1000 True
neuro_comp varchar 0 0 1000 True
nhs_region varchar 0 0 1000 True
ni_site varchar 0 0 1000 True
no_symptoms varchar 0 0 1000 True
no_symptoms_v3 varchar 0 0 1000 True
noncorona_expphi varchar 0 0 1000 True
noninvasive_proccur varchar 0 0 1000 True
obesity_mhyn varchar 0 0 1000 True
offlabel_cmtrt varchar 0 0 1000 True
offlabel_cmyn varchar 0 0 1000 True
onset_and_admission_complete varchar 0 0 1000 True
onset2admission varchar 0 0 1000 True
othantiviral_cmtrt varchar 0 0 1000 True
othantiviral2_cmyn varchar 0 0 1000 True
othantiviral3_cmtrt varchar 0 0 1000 True
othantiviral3_cmyn varchar 0 0 1000 True
othantiviral4_cmtrt varchar 0 0 1000 True
othantiviral4_cmyn varchar 0 0 1000 True
othantiviral5_cmtrt varchar 0 0 1000 True
othantiviral5_cmyn varchar 0 0 1000 True
other_ceoccur varchar 0 0 1000 True
other_ceterm varchar 0 0 4000 True
other_cm varchar 0 0 1000 True
other_cmoccur varchar 0 0 1000 True
other_cmtrt varchar 0 0 1000 True
other_cmyn varchar 0 0 1000 True
other_ethnic varchar 0 0 1000 True
other_mborres varchar 0 0 1000 True
other_mbyn varchar 0 0 1000 True
other_mhyn varchar 0 0 1000 True
othhantiviral2_cmtrt varchar 0 0 1000 True
outcome_complete varchar 0 0 1000 True
oxy_vsorres varchar 0 0 1000 True
oxy_vsorresu varchar 0 0 1000 True
oxy_vsyn varchar 0 0 1000 True
oxygen_cmoccur varchar 0 0 1000 True
oxygen_proccur varchar 0 0 1000 True
oxygen_proccur_v2 varchar 0 0 1000 True
oxygenhf_cmoccur varchar 0 0 1000 True
pancreat_ceterm varchar 0 0 1000 True
participant_identification_number_pin_complete varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
pcr_path_diag___0 varchar 0 0 1000 True
pcr_path_diag___1 varchar 0 0 1000 True
pcr_path_diag___10 varchar 0 0 1000 True
pcr_path_diag___2 varchar 0 0 1000 True
pcr_path_diag___3 varchar 0 0 1000 True
pcr_path_diag___4 varchar 0 0 1000 True
pcr_path_diag___5 varchar 0 0 1000 True
pcr_path_diag___6 varchar 0 0 1000 True
pcr_path_diago varchar 0 0 1000 True
pleuraleff_ceterm varchar 0 0 1000 True
pneumothorax_ceterm varchar 0 0 1000 True
postpart_rptestcd varchar 0 0 1000 True
postpart_rptestcd_out varchar 0 0 1000 True
preadmission_treatment_complete varchar 0 0 1000 True
pregout_rptestcd varchar 0 0 1000 True
pregout_rptestcd_out varchar 0 0 1000 True
pregyn_rptestcd varchar 0 0 1000 True
prev_subjid varchar 0 0 1000 True
prev_subjid_nk varchar 0 0 1000 True
pronevent_prtrt varchar 0 0 1000 True
pulmthromb_ceterm varchar 0 0 1000 True
rash_ceoccur_v2 varchar 0 0 1000 True
rash_ceoccur_v3 varchar 0 0 1000 True
readm_cov19 varchar 0 0 1000 True
readminreas varchar 0 0 1000 True
readminreasnk varchar 0 0 1000 True
reason_for_withdrawal varchar 0 0 1000 True
recruitment varchar 0 0 1000 True
reinf_antigen varchar 0 0 1000 True
reinf_antigend varchar 0 0 1000 True
reinf_asymptomatic varchar 0 0 1000 True
reinf_cestdat varchar 0 0 1000 True
reinf_pcr varchar 0 0 1000 True
reinf_pcrd varchar 0 0 1000 True
reinf_pre_adm_hosp varchar 0 0 1000 True
reinf_pre_casiriv varchar 0 0 1000 True
reinf_pre_chloro_hchlo varchar 0 0 1000 True
reinf_pre_conv_plasma varchar 0 0 1000 True
reinf_pre_dexameth varchar 0 0 1000 True
reinf_pre_ecmo varchar 0 0 1000 True
reinf_pre_hdu_icu varchar 0 0 1000 True
reinf_pre_interferon varchar 0 0 1000 True
reinf_pre_inv_vent varchar 0 0 1000 True
reinf_pre_lopin_riton varchar 0 0 1000 True
reinf_pre_oxygen varchar 0 0 1000 True
reinf_pre_remdesivir varchar 0 0 1000 True
reinf_pre_steroid varchar 0 0 1000 True
reinf_pre_tociliz varchar 0 0 1000 True
reinf_prev_enrol varchar 0 0 1000 True
reinf_serology varchar 0 0 1000 True
reinf_serologyd varchar 0 0 1000 True
reinf_treat_none varchar 0 0 1000 True
reinfection_form_complete varchar 0 0 1000 True
remdes_cmtrt_first varchar 0 0 1000 True
remdes_cmtrt_last varchar 0 0 1000 True
remdesivir.day1 varchar 0 0 1000 True
remdesivir.disch varchar 0 0 1000 True
remdesivir_day.day1 varchar 0 0 1000 True
remdesivir_day.disch varchar 0 0 1000 True
remdesivir_last_dose.day1 varchar 0 0 1000 True
remdesivir_last_dose.disch varchar 0 0 1000 True
renal_mhyn varchar 0 0 1000 True
renal_proccur varchar 0 0 1000 True
renalinjury_ceterm varchar 0 0 1000 True
research_samples_complete varchar 0 0 1000 True
rhabdomyolsis_ceterm varchar 0 0 1000 True
rheumatologic_mhyn varchar 0 0 1000 True
rr_vsorres varchar 0 0 1000 True
rr_vsyn varchar 0 0 1000 True
rrt_prtrt varchar 0 0 1000 True
rrt_still_on varchar 0 0 1000 True
rrt_totdur varchar 0 0 1000 True
rsv_mbcat varchar 0 0 1000 True
rsv_mbcat_v2 varchar 0 0 1000 True
runnynose_ceoccur_v2 varchar 0 0 1000 True
runnynose_ceoccur_v3 varchar 0 0 1000 True
sample_date varchar 0 0 1000 True
sample_kit varchar 0 0 1000 True
sample_obtained varchar 0 0 1000 True
seizure_ceterm varchar 0 0 1000 True
seizures_cecoccur_v2 varchar 0 0 1000 True
seizures_cecoccur_v3 varchar 0 0 1000 True
sex varchar 0 0 1000 True
shortbreath_ceoccur_v2 varchar 0 0 1000 True
shortbreath_ceoccur_v3 varchar 0 0 1000 True
site_type varchar 0 0 1000 True
siteid varchar 0 0 1000 True
siteid_transfernk varchar 0 0 1000 True
siteid_v2 varchar 0 0 1000 True
siteid_v2_nk varchar 0 0 1000 True
siteidnk varchar 0 0 1000 True
siteyn varchar 0 0 1000 True
siteyn_v2 varchar 0 0 1000 True
siteyn_v3 varchar 0 0 1000 True
skinulcers_ceoccur_v2 varchar 0 0 1000 True
skinulcers_ceoccur_v3 varchar 0 0 1000 True
smoking_mhyn varchar 0 0 1000 True
smoking_mhyn_2levels varchar 0 0 1000 True
sorethroat_ceoccur_v2 varchar 0 0 1000 True
sorethroat_ceoccur_v3 varchar 0 0 1000 True
status varchar 0 0 1000 True
stercap_vsorres varchar 0 0 1000 True
stercap_vsyn varchar 0 0 1000 True
stroke_ceterm varchar 0 0 1000 True
study_1_id varchar 0 0 1000 True
study_1_name varchar 0 0 1000 True
study_2 varchar 0 0 1000 True
study_2_id varchar 0 0 1000 True
study_2_name varchar 0 0 1000 True
study_3 varchar 0 0 1000 True
study_3_id varchar 0 0 1000 True
study_3_name varchar 0 0 1000 True
study_participation_complete varchar 0 0 1000 True
subjid_transfer varchar 0 0 1000 True
subjidcat varchar 0 0 1000 True
subjidcat_transfer varchar 0 0 1000 True
subjidcat_v2 varchar 0 0 1000 True
suppds_qval varchar 0 0 1000 True
suppds_qval_v2 varchar 0 0 1000 True
supper_trcity varchar 0 0 1000 True
supper_trcity_2 varchar 0 0 1000 True
supper_trcntry varchar 0 0 1000 True
supper_trcntry_2 varchar 0 0 1000 True
surgefacil varchar 0 0 1000 True
susp_reinf varchar 0 0 1000 True
symptoms_epi_animal varchar 0 0 1000 True
symptoms_epi_healthfac varchar 0 0 1000 True
symptoms_epi_lab varchar 0 0 1000 True
symptoms_epi_pathogen varchar 0 0 1000 True
symptoms_epi_physical varchar 0 0 1000 True
symptoms_epi_travel varchar 0 0 1000 True
sysbp_vsorres varchar 0 0 1000 True
sysbp_vsyn varchar 0 0 1000 True
systolic_vsorres.day1 varchar 0 0 1000 True
systolic_vsorres.disch varchar 0 0 1000 True
systolic_vsyn.day1 varchar 0 0 1000 True
systolic_vsyn.disch varchar 0 0 1000 True
temp_vsorres varchar 0 0 1000 True
temp_vsorresu varchar 0 0 1000 True
temp_vsyn varchar 0 0 1000 True
tiers_consent_complete varchar 0 0 1000 True
tiers_faorres___1 varchar 0 0 1000 True
tiers_faorres___2 varchar 0 0 1000 True
tiers_faorres___3 varchar 0 0 1000 True
tracheo_prtrt varchar 0 0 1000 True
transfer_subjid varchar 0 0 1000 True
travel_erterm varchar 0 0 1000 True
travel_erterm_2 varchar 0 0 1000 True
treatment_complete varchar 0 0 1000 True
vaccine_covid_trial varchar 0 0 1000 True
vaccine_covid_triald varchar 0 0 1000 True
version_9_7 varchar 0 0 1000 True
vomit_ceoccur_v2 varchar 0 0 1000 True
vomit_ceoccur_v3 varchar 0 0 1000 True
vrialpneu_ceoccur varchar 0 0 1000 True
vulnerable_cancers varchar 0 0 1000 True
vulnerable_copd varchar 0 0 1000 True
vulnerable_immuno varchar 0 0 1000 True
vulnerable_no_nk varchar 0 0 1000 True
vulnerable_preg varchar 0 0 1000 True
vulnerable_scid varchar 0 0 1000 True
vulnerable_transplant varchar 0 0 1000 True
wheeze_ceoccur_v2 varchar 0 0 1000 True
wheeze_ceoccur_v3 varchar 0 0 1000 True
withddat varchar 0 0 1000 True
withdrawal_form_complete varchar 0 0 1000 True
withdreas varchar 0 0 1000 True
withdtype varchar 0 0 1000 True
xray_prperf.day1 varchar 0 0 1000 True
xray_prperf.disch varchar 0 0 1000 True

NHSD_HIGH_COST_DRUGS

HighCostDrugs

ColumnName ColumnType Precision Scale MaxLength IsNullable
ActivityTreatmentFunctionCode varchar 0 0 100 True
DerivedSNOMEDFromName varchar 0 0 1000 True
DerivedVTM varchar 0 0 1000 True
DerivedVTMName varchar 0 0 1000 True
DispensingRoute varchar 0 0 100 True
DrugName varchar 0 0 1000 True
DrugPackSize varchar 0 0 1000 True
DrugQuanitityOrWeightProportion varchar 0 0 1000 True
DrugStrength varchar 0 0 1000 True
DrugVolume varchar 0 0 1000 True
FinancialMonth varchar 0 0 2 True
FinancialYear varchar 0 0 6 True
HighCostTariffExcludedDrugCode varchar 0 0 100 True
HomeDeliveryCharge varchar 0 0 100 True
Patient_ID bigint 19 0 8 False
PersonAge int 10 0 4 True
PersonGender int 10 0 4 True
RouteOfAdministration varchar 0 0 100 True
TherapeuticIndicationCode varchar 0 0 1000 True
TotalCost varchar 0 0 100 True
UnitOfMeasurement varchar 0 0 100 True

NHSE_APCS

APCS

ColumnName ColumnType Precision Scale MaxLength IsNullable
Administrative_Category varchar 0 0 2 True
Admission_Date date 10 0 3 True
Admission_Method varchar 0 0 2 True
APCS_Ident bigint 19 0 8 False
Carer_Support_Indicator varchar 0 0 1000 True
Der_Activity_Month varchar 0 0 6 True
Der_Admit_Treatment_Function_Code varchar 0 0 3 True
Der_Diagnosis_All varchar 0 0 4000 True
Der_Diagnosis_Count int 10 0 4 True
Der_Dischg_Treatment_Function_Code varchar 0 0 3 True
Der_Financial_Year varchar 0 0 7 True
Der_Procedure_All varchar 0 0 4000 True
Der_Procedure_Count int 10 0 4 True
Der_Pseudo_Patient_Pathway_ID bigint 19 0 8 True
Der_Spell_LoS int 10 0 4 True
Discharge_Date date 10 0 3 True
Discharge_Destination varchar 0 0 2 True
Discharge_Method varchar 0 0 2 True
Duration_of_Elective_Wait int 10 0 4 True
Ethnic_Group varchar 0 0 2 True
Hospital_Spell_Duration int 10 0 4 True
Patient_Classification varchar 0 0 2 True
Patient_ID bigint 19 0 8 False
Provider_Org_Code_Type varchar 0 0 5 True
Source_of_Admission varchar 0 0 2 True
Spell_Core_HRG_SUS varchar 0 0 10 True
Spell_HRG_Version_No_SUS varchar 0 0 20 True

APCS_Cost

ColumnName ColumnType Precision Scale MaxLength IsNullable
APCS_Ident bigint 19 0 8 False
Grand_Total_Payment_MFF real 24 0 4 True
Patient_ID bigint 19 0 8 False
Tariff_Initial_Amount real 24 0 4 True
Tariff_Total_Payment real 24 0 4 True

APCS_Der

ColumnName ColumnType Precision Scale MaxLength IsNullable
APCS_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
Spell_Dominant_Procedure varchar 0 0 100 True
Spell_LoS varchar 0 0 5 True
Spell_Main_Specialty_Code varchar 0 0 3 True
Spell_PbR_CC_Day varchar 0 0 4 True
Spell_PbR_Rehab_Days varchar 0 0 4 True
Spell_Primary_Diagnosis varchar 0 0 5 True
Spell_RE30_Admit_Type varchar 0 0 1 True
Spell_RE30_Indicator varchar 0 0 1 True
Spell_Secondary_Diagnosis varchar 0 0 5 True
Spell_Treatment_Function_Code varchar 0 0 3 True

NHSE_CPNS

CPNS

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age int 10 0 4 True
CovidTestResult varchar 0 0 100 True
DateOfAdmission date 10 0 3 True
DateOfDeath date 10 0 3 True
DateOfResult date 10 0 3 True
DateOfSwabbed date 10 0 3 True
Der_Ethnic_Category_Description varchar 0 0 100 True
Der_Latest_SUS_Attendance_Date_For_Ethnicity varchar 0 0 100 True
Der_Source_Dataset_For_Ethnicty varchar 0 0 100 True
DetainedUnderMHAct bit 1 0 1 True
HadLearningDisability varchar 0 0 10 True
Id bigint 19 0 8 False
LearningDisabilityType varchar 0 0 100 True
LocationOfDeath varchar 0 0 1000 True
NationalApproved varchar 0 0 10 True
NationalApprovedDate date 10 0 3 True
NHSworker bit 1 0 1 True
OnDeathCertificateNotice bit 1 0 1 True
OrganisationTypeLot varchar 0 0 100 True
Patient_ID bigint 19 0 8 False
PreExistingCondition varchar 0 0 10 True
PreExistingConditionList varchar 0 0 4000 True
ReceivedTreatmentForMentalHealth varchar 0 0 100 True
RegionalApprovedDate date 10 0 3 True
RegionApproved varchar 0 0 10 True
RegionCode varchar 0 0 10 True
RegionName varchar 0 0 100 True
RelativesAware varchar 0 0 100 True
Sex varchar 0 0 5 True
snapDate date 10 0 3 True
TransferredFromAMentalHealthSetting bit 1 0 1 True
TransferredFromLearningDisabilityAutismSetting bit 1 0 1 True
TravelHistory varchar 0 0 10 True

NHSE_EC

EC

ColumnName ColumnType Precision Scale MaxLength IsNullable
Arrival_Date date 10 0 3 True
Arrival_Time time 16 7 5 True
Decision_To_Admit_Treatment_Function_Code varchar 0 0 3 True
Der_Activity_Month varchar 0 0 6 True
Der_EC_Diagnosis_All varchar 0 0 4000 True
Der_EC_Investigation_All varchar 0 0 4000 True
Der_EC_Treatment_All varchar 0 0 4000 True
Der_Financial_Year varchar 0 0 7 True
Discharge_Destination_SNOMED_CT varchar 0 0 20 True
DQ_Chief_Complaint_Completed varchar 0 0 5 True
DQ_Chief_Complaint_Expected varchar 0 0 5 True
DQ_Chief_Complaint_Valid varchar 0 0 5 True
DQ_Primary_Diagnosis_Completed varchar 0 0 5 True
DQ_Primary_Diagnosis_Expected varchar 0 0 5 True
DQ_Primary_Diagnosis_Valid varchar 0 0 5 True
EC_Arrival_Mode_SNOMED_CT varchar 0 0 20 True
EC_Attendance_Source_SNOMED_CT varchar 0 0 20 True
EC_AttendanceCategory varchar 0 0 1 True
EC_Chief_Complaint_SNOMED_CT varchar 0 0 20 True
EC_Decision_To_Admit_Date date 10 0 3 True
EC_Department_Type varchar 0 0 2 True
EC_Ident bigint 19 0 8 False
EC_Injury_Date date 10 0 3 True
Ethnic_Category varchar 0 0 1 True
Patient_ID bigint 19 0 8 False
SUS_Final_Price varchar 0 0 5 True
SUS_HRG_Code varchar 0 0 5 True
SUS_Tariff varchar 0 0 5 True

EC_AlcoholDrugInvolvement

ColumnName ColumnType Precision Scale MaxLength IsNullable
EC_Alcohol_Drug_Involvement_01 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_02 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_03 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_04 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_05 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_06 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_07 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_08 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_09 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_10 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_11 varchar 0 0 20 True
EC_Alcohol_Drug_Involvement_12 varchar 0 0 20 True
EC_Ident bigint 19 0 8 False
Is_Code_Approved_01 varchar 0 0 5 True
Is_Code_Approved_02 varchar 0 0 5 True
Is_Code_Approved_03 varchar 0 0 5 True
Is_Code_Approved_04 varchar 0 0 5 True
Is_Code_Approved_05 varchar 0 0 5 True
Is_Code_Approved_06 varchar 0 0 5 True
Is_Code_Approved_07 varchar 0 0 5 True
Is_Code_Approved_08 varchar 0 0 5 True
Is_Code_Approved_09 varchar 0 0 5 True
Is_Code_Approved_10 varchar 0 0 5 True
Is_Code_Approved_11 varchar 0 0 5 True
Is_Code_Approved_12 varchar 0 0 5 True
Patient_ID bigint 19 0 8 False

EC_Comorbidities

ColumnName ColumnType Precision Scale MaxLength IsNullable
Comorbidity_01 varchar 0 0 20 True
Comorbidity_02 varchar 0 0 20 True
Comorbidity_03 varchar 0 0 20 True
Comorbidity_04 varchar 0 0 20 True
Comorbidity_05 varchar 0 0 20 True
Comorbidity_06 varchar 0 0 20 True
Comorbidity_07 varchar 0 0 20 True
Comorbidity_08 varchar 0 0 20 True
Comorbidity_09 varchar 0 0 20 True
Comorbidity_10 varchar 0 0 20 True
Comorbidity_11 varchar 0 0 20 True
Comorbidity_12 varchar 0 0 20 True
Comorbidity_13 varchar 0 0 20 True
Comorbidity_14 varchar 0 0 20 True
Comorbidity_15 varchar 0 0 20 True
Comorbidity_16 varchar 0 0 20 True
Comorbidity_17 varchar 0 0 20 True
Comorbidity_18 varchar 0 0 20 True
Comorbidity_19 varchar 0 0 20 True
Comorbidity_20 varchar 0 0 20 True
Comorbidity_21 varchar 0 0 20 True
Comorbidity_22 varchar 0 0 20 True
Comorbidity_23 varchar 0 0 20 True
Comorbidity_24 varchar 0 0 20 True
EC_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False

EC_Cost

ColumnName ColumnType Precision Scale MaxLength IsNullable
EC_Ident bigint 19 0 8 False
Grand_Total_Payment_MFF real 24 0 4 True
Patient_ID bigint 19 0 8 False
Tariff_Total_Payment real 24 0 4 True

EC_Diagnosis

ColumnName ColumnType Precision Scale MaxLength IsNullable
AEA_Diagnosis_01 varchar 0 0 100 True
AEA_Diagnosis_02 varchar 0 0 100 True
AEA_Diagnosis_03 varchar 0 0 100 True
AEA_Diagnosis_04 varchar 0 0 100 True
AEA_Diagnosis_05 varchar 0 0 100 True
AEA_Diagnosis_06 varchar 0 0 100 True
AEA_Diagnosis_07 varchar 0 0 100 True
AEA_Diagnosis_08 varchar 0 0 100 True
AEA_Diagnosis_09 varchar 0 0 100 True
AEA_Diagnosis_10 varchar 0 0 100 True
AEA_Diagnosis_11 varchar 0 0 100 True
AEA_Diagnosis_12 varchar 0 0 100 True
AEA_Diagnosis_13 varchar 0 0 100 True
AEA_Diagnosis_14 varchar 0 0 100 True
AEA_Diagnosis_15 varchar 0 0 100 True
AEA_Diagnosis_16 varchar 0 0 100 True
AEA_Diagnosis_17 varchar 0 0 100 True
AEA_Diagnosis_18 varchar 0 0 100 True
AEA_Diagnosis_19 varchar 0 0 100 True
AEA_Diagnosis_20 varchar 0 0 100 True
AEA_Diagnosis_21 varchar 0 0 100 True
AEA_Diagnosis_22 varchar 0 0 100 True
AEA_Diagnosis_23 varchar 0 0 100 True
AEA_Diagnosis_24 varchar 0 0 100 True
EC_Chief_Complaint_SNOMED_CT varchar 0 0 20 True
EC_Diagnosis_01 varchar 0 0 20 True
EC_Diagnosis_02 varchar 0 0 20 True
EC_Diagnosis_03 varchar 0 0 20 True
EC_Diagnosis_04 varchar 0 0 20 True
EC_Diagnosis_05 varchar 0 0 20 True
EC_Diagnosis_06 varchar 0 0 20 True
EC_Diagnosis_07 varchar 0 0 20 True
EC_Diagnosis_08 varchar 0 0 20 True
EC_Diagnosis_09 varchar 0 0 20 True
EC_Diagnosis_10 varchar 0 0 20 True
EC_Diagnosis_11 varchar 0 0 20 True
EC_Diagnosis_12 varchar 0 0 20 True
EC_Diagnosis_13 varchar 0 0 20 True
EC_Diagnosis_14 varchar 0 0 20 True
EC_Diagnosis_15 varchar 0 0 20 True
EC_Diagnosis_16 varchar 0 0 20 True
EC_Diagnosis_17 varchar 0 0 20 True
EC_Diagnosis_18 varchar 0 0 20 True
EC_Diagnosis_19 varchar 0 0 20 True
EC_Diagnosis_20 varchar 0 0 20 True
EC_Diagnosis_21 varchar 0 0 20 True
EC_Diagnosis_22 varchar 0 0 20 True
EC_Diagnosis_23 varchar 0 0 20 True
EC_Diagnosis_24 varchar 0 0 20 True
EC_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False

EC_Investigation

ColumnName ColumnType Precision Scale MaxLength IsNullable
AEA_Investigation_01 varchar 0 0 20 True
AEA_Investigation_02 varchar 0 0 20 True
AEA_Investigation_03 varchar 0 0 20 True
AEA_Investigation_04 varchar 0 0 20 True
AEA_Investigation_05 varchar 0 0 20 True
AEA_Investigation_06 varchar 0 0 20 True
AEA_Investigation_07 varchar 0 0 20 True
AEA_Investigation_08 varchar 0 0 20 True
AEA_Investigation_09 varchar 0 0 20 True
AEA_Investigation_10 varchar 0 0 20 True
AEA_Investigation_11 varchar 0 0 20 True
AEA_Investigation_12 varchar 0 0 20 True
AEA_Investigation_13 varchar 0 0 20 True
AEA_Investigation_14 varchar 0 0 20 True
AEA_Investigation_15 varchar 0 0 20 True
AEA_Investigation_16 varchar 0 0 20 True
AEA_Investigation_17 varchar 0 0 20 True
AEA_Investigation_18 varchar 0 0 20 True
AEA_Investigation_19 varchar 0 0 20 True
AEA_Investigation_20 varchar 0 0 20 True
AEA_Investigation_21 varchar 0 0 20 True
AEA_Investigation_22 varchar 0 0 20 True
AEA_Investigation_23 varchar 0 0 20 True
AEA_Investigation_24 varchar 0 0 20 True
EC_Ident bigint 19 0 8 False
EC_Investigation_01 varchar 0 0 20 True
EC_Investigation_02 varchar 0 0 20 True
EC_Investigation_03 varchar 0 0 20 True
EC_Investigation_04 varchar 0 0 20 True
EC_Investigation_05 varchar 0 0 20 True
EC_Investigation_06 varchar 0 0 20 True
EC_Investigation_07 varchar 0 0 20 True
EC_Investigation_08 varchar 0 0 20 True
EC_Investigation_09 varchar 0 0 20 True
EC_Investigation_10 varchar 0 0 20 True
EC_Investigation_11 varchar 0 0 20 True
EC_Investigation_12 varchar 0 0 20 True
EC_Investigation_13 varchar 0 0 20 True
EC_Investigation_14 varchar 0 0 20 True
EC_Investigation_15 varchar 0 0 20 True
EC_Investigation_16 varchar 0 0 20 True
EC_Investigation_17 varchar 0 0 20 True
EC_Investigation_18 varchar 0 0 20 True
EC_Investigation_19 varchar 0 0 20 True
EC_Investigation_20 varchar 0 0 20 True
EC_Investigation_21 varchar 0 0 20 True
EC_Investigation_22 varchar 0 0 20 True
EC_Investigation_23 varchar 0 0 20 True
EC_Investigation_24 varchar 0 0 20 True
Patient_ID bigint 19 0 8 False

EC_PatientMentalHealth

ColumnName ColumnType Precision Scale MaxLength IsNullable
EC_Ident bigint 19 0 8 False
MH_Classification_01 varchar 0 0 20 True
MH_Classification_010 varchar 0 0 20 True
MH_Classification_011 varchar 0 0 20 True
MH_Classification_012 varchar 0 0 20 True
MH_Classification_013 varchar 0 0 20 True
MH_Classification_014 varchar 0 0 20 True
MH_Classification_015 varchar 0 0 20 True
MH_Classification_016 varchar 0 0 20 True
MH_Classification_017 varchar 0 0 20 True
MH_Classification_018 varchar 0 0 20 True
MH_Classification_019 varchar 0 0 20 True
MH_Classification_02 varchar 0 0 20 True
MH_Classification_03 varchar 0 0 20 True
MH_Classification_04 varchar 0 0 20 True
MH_Classification_05 varchar 0 0 20 True
MH_Classification_06 varchar 0 0 20 True
MH_Classification_07 varchar 0 0 20 True
MH_Classification_08 varchar 0 0 20 True
MH_Classification_09 varchar 0 0 20 True
MH_Classification_20 varchar 0 0 20 True
MH_Classification_21 varchar 0 0 20 True
MH_Classification_22 varchar 0 0 20 True
MH_Classification_23 varchar 0 0 20 True
MH_Classification_24 varchar 0 0 20 True
MH_Expiry_Date_01 date 10 0 3 True
MH_Expiry_Date_010 date 10 0 3 True
MH_Expiry_Date_011 date 10 0 3 True
MH_Expiry_Date_012 date 10 0 3 True
MH_Expiry_Date_013 date 10 0 3 True
MH_Expiry_Date_014 date 10 0 3 True
MH_Expiry_Date_015 date 10 0 3 True
MH_Expiry_Date_016 date 10 0 3 True
MH_Expiry_Date_017 date 10 0 3 True
MH_Expiry_Date_018 date 10 0 3 True
MH_Expiry_Date_019 date 10 0 3 True
MH_Expiry_Date_02 date 10 0 3 True
MH_Expiry_Date_03 date 10 0 3 True
MH_Expiry_Date_04 date 10 0 3 True
MH_Expiry_Date_05 date 10 0 3 True
MH_Expiry_Date_06 date 10 0 3 True
MH_Expiry_Date_07 date 10 0 3 True
MH_Expiry_Date_08 date 10 0 3 True
MH_Expiry_Date_09 date 10 0 3 True
MH_Expiry_Date_20 date 10 0 3 True
MH_Expiry_Date_21 date 10 0 3 True
MH_Expiry_Date_22 date 10 0 3 True
MH_Expiry_Date_23 date 10 0 3 True
MH_Expiry_Date_24 date 10 0 3 True
MH_Start_Date_01 date 10 0 3 True
MH_Start_Date_010 date 10 0 3 True
MH_Start_Date_011 date 10 0 3 True
MH_Start_Date_012 date 10 0 3 True
MH_Start_Date_013 date 10 0 3 True
MH_Start_Date_014 date 10 0 3 True
MH_Start_Date_015 date 10 0 3 True
MH_Start_Date_016 date 10 0 3 True
MH_Start_Date_017 date 10 0 3 True
MH_Start_Date_018 date 10 0 3 True
MH_Start_Date_019 date 10 0 3 True
MH_Start_Date_02 date 10 0 3 True
MH_Start_Date_03 date 10 0 3 True
MH_Start_Date_04 date 10 0 3 True
MH_Start_Date_05 date 10 0 3 True
MH_Start_Date_06 date 10 0 3 True
MH_Start_Date_07 date 10 0 3 True
MH_Start_Date_08 date 10 0 3 True
MH_Start_Date_09 date 10 0 3 True
MH_Start_Date_20 date 10 0 3 True
MH_Start_Date_21 date 10 0 3 True
MH_Start_Date_22 date 10 0 3 True
MH_Start_Date_23 date 10 0 3 True
MH_Start_Date_24 date 10 0 3 True
Patient_ID bigint 19 0 8 False

EC_Treatment

ColumnName ColumnType Precision Scale MaxLength IsNullable
AEA_Treatment_01 varchar 0 0 20 True
AEA_Treatment_02 varchar 0 0 20 True
AEA_Treatment_03 varchar 0 0 20 True
AEA_Treatment_04 varchar 0 0 20 True
AEA_Treatment_05 varchar 0 0 20 True
AEA_Treatment_06 varchar 0 0 20 True
AEA_Treatment_07 varchar 0 0 20 True
AEA_Treatment_08 varchar 0 0 20 True
AEA_Treatment_09 varchar 0 0 20 True
AEA_Treatment_10 varchar 0 0 20 True
AEA_Treatment_11 varchar 0 0 20 True
AEA_Treatment_12 varchar 0 0 20 True
AEA_Treatment_13 varchar 0 0 20 True
AEA_Treatment_14 varchar 0 0 20 True
AEA_Treatment_15 varchar 0 0 20 True
AEA_Treatment_16 varchar 0 0 20 True
AEA_Treatment_17 varchar 0 0 20 True
AEA_Treatment_18 varchar 0 0 20 True
AEA_Treatment_19 varchar 0 0 20 True
AEA_Treatment_20 varchar 0 0 20 True
AEA_Treatment_21 varchar 0 0 20 True
AEA_Treatment_22 varchar 0 0 20 True
AEA_Treatment_23 varchar 0 0 20 True
AEA_Treatment_24 varchar 0 0 20 True
EC_Ident bigint 19 0 8 False
EC_Treatment_01 varchar 0 0 20 True
EC_Treatment_02 varchar 0 0 20 True
EC_Treatment_03 varchar 0 0 20 True
EC_Treatment_04 varchar 0 0 20 True
EC_Treatment_05 varchar 0 0 20 True
EC_Treatment_06 varchar 0 0 20 True
EC_Treatment_07 varchar 0 0 20 True
EC_Treatment_08 varchar 0 0 20 True
EC_Treatment_09 varchar 0 0 20 True
EC_Treatment_10 varchar 0 0 20 True
EC_Treatment_11 varchar 0 0 20 True
EC_Treatment_12 varchar 0 0 20 True
EC_Treatment_13 varchar 0 0 20 True
EC_Treatment_14 varchar 0 0 20 True
EC_Treatment_15 varchar 0 0 20 True
EC_Treatment_16 varchar 0 0 20 True
EC_Treatment_17 varchar 0 0 20 True
EC_Treatment_18 varchar 0 0 20 True
EC_Treatment_19 varchar 0 0 20 True
EC_Treatment_20 varchar 0 0 20 True
EC_Treatment_21 varchar 0 0 20 True
EC_Treatment_22 varchar 0 0 20 True
EC_Treatment_23 varchar 0 0 20 True
EC_Treatment_24 varchar 0 0 20 True
Patient_ID bigint 19 0 8 False

NHSE_ECDS

ECDS

ColumnName ColumnType Precision Scale MaxLength IsNullable
Accessible_Information_Professional_Required_Code_Approved varchar 0 0 5 True
Accessible_Information_Professional_Required_SNOMED_CT varchar 0 0 18 True
Accommodation_Status_Code_Approved varchar 0 0 5 True
Accommodation_Status_SNOMED_CT varchar 0 0 18 True
Age_At_Arrival bigint 19 0 8 True
Age_at_CDS_Activity_Date bigint 19 0 8 True
Age_Range varchar 0 0 5 True
Arrival_Date datetime 23 3 8 True
Arrival_Mode_Approved varchar 0 0 5 True
Arrival_Month bigint 19 0 8 True
Arrival_Planned varchar 0 0 5 True
Arrival_Time varchar 0 0 8 True
Attendance_Source_Organisation varchar 0 0 9 True
Cancer_Registry varchar 0 0 5 True
CDS_Activity_Date date 10 0 3 True
CDS_Group_Indicator bigint 19 0 8 True
CDS_Interchange_Sender_Identity varchar 0 0 12 True
CDS_Prime_Recipient_Identity varchar 0 0 12 True
CDS_Type varchar 0 0 3 True
Clinical_Acuity_Code_Approved varchar 0 0 5 True
Clinical_Chief_Complaint_Code_Approved varchar 0 0 5 True
Clinical_Chief_Complaint_Extended_Code varchar 0 0 18 True
Clinical_Chief_Complaint_Injury_Related varchar 0 0 5 True
Clinical_Disease_Notification varchar 0 0 50 True
Clinical_Injury_Activity_Status_Code_Approved varchar 0 0 5 True
Clinical_Injury_Activity_Type_Code_Approved varchar 0 0 5 True
Clinical_Injury_Intent_Code_Approved varchar 0 0 5 True
Clinical_Injury_Place_Type_Approved varchar 0 0 5 True
Clinical_Trial_Code varchar 0 0 50 True
Commissioner_Code varchar 0 0 12 True
Decision_To_Admit_Receiving_Site varchar 0 0 9 True
Decision_To_Admit_Treatment_Function_Code varchar 0 0 8 True
Der_Activity_Month varchar 0 0 6 True
Der_AEA_Diagnosis_All varchar 0 0 200 True
Der_AEA_Investigation_All varchar 0 0 200 True
Der_AEA_Patient_Group varchar 0 0 2 True
Der_AEA_Treatment_All varchar 0 0 200 True
Der_Age_At_CDS_Activity_Date int 10 0 4 True
Der_Commissioner_Code varchar 0 0 5 True
Der_Dupe_Flag int 10 0 4 True
Der_EC_Arrival_Date_Time datetime 23 3 8 True
Der_EC_Departure_Date_Time datetime 23 3 8 True
Der_EC_Diagnosis_All varchar 0 0 500 True
Der_EC_Duration int 10 0 4 True
Der_EC_Investigation_All varchar 0 0 500 True
Der_EC_Treatment_All varchar 0 0 500 True
Der_Financial_Year varchar 0 0 7 False
Der_Number_AEA_Diagnosis int 10 0 4 True
Der_Number_AEA_Investigation int 10 0 4 True
Der_Number_AEA_Treatment int 10 0 4 True
Der_Number_EC_Diagnosis int 10 0 4 True
Der_Number_EC_Investigation int 10 0 4 True
Der_Number_EC_Treatment int 10 0 4 True
Der_Provider_Code varchar 0 0 5 True
Der_Provider_Site_Code varchar 0 0 5 True
Der_Record_Type varchar 0 0 4 True
Discharge_Destination_SNOMED_CT varchar 0 0 18 True
Discharge_Follow_Up_Approved varchar 0 0 5 True
Discharge_Follow_Up_SNOMED_CT varchar 0 0 18 True
Discharge_Information_Given_Approved varchar 0 0 5 True
Discharge_Information_Given_SNOMED_CT varchar 0 0 18 True
DischargeDestinationApproved varchar 0 0 5 True
DQ_Chief_Complaint_Completed varchar 0 0 5 True
DQ_Chief_Complaint_Expected varchar 0 0 5 True
DQ_Chief_Complaint_Valid varchar 0 0 5 True
DQ_Primary_Diagnosis_Completed varchar 0 0 5 True
DQ_Primary_Diagnosis_Expected varchar 0 0 5 True
DQ_Primary_Diagnosis_Valid varchar 0 0 5 True
EC_Acuity_SNOMED_CT varchar 0 0 18 True
EC_Arrival_Mode_SNOMED_CT varchar 0 0 18 True
EC_Attendance_Source_SNOMED_CT varchar 0 0 18 True
EC_AttendanceCategory varchar 0 0 1 True
EC_Chief_Complaint_SNOMED_CT varchar 0 0 18 True
EC_Conclusion_Date date 10 0 3 True
EC_Conclusion_Time varchar 0 0 8 True
EC_Conclusion_Time_Since_Arrival bigint 19 0 8 True
EC_Decision_To_Admit_Date date 10 0 3 True
EC_Decision_To_Admit_Time varchar 0 0 8 True
EC_Decision_To_Admit_Time_Since_Arrival bigint 19 0 8 True
EC_Department_Type varchar 0 0 2 True
EC_Departure_Date date 10 0 3 True
EC_Departure_Time varchar 0 0 8 True
EC_Departure_Time_Since_Arrival bigint 19 0 8 True
EC_Discharge_Status_Approved varchar 0 0 5 True
EC_Discharge_Status_SNOMED_CT varchar 0 0 18 True
EC_Ident bigint 19 0 8 True
EC_Initial_Assessment_Date date 10 0 3 True
EC_Initial_Assessment_Time varchar 0 0 8 True
EC_Initial_Assessment_Time_Since_Arrival bigint 19 0 8 True
EC_Injury_Activity_Status_SNOMED_CT varchar 0 0 18 True
EC_Injury_Activity_Type_SNOMED_CT varchar 0 0 18 True
EC_Injury_Date date 10 0 3 True
EC_Injury_Intent_SNOMED_CT varchar 0 0 18 True
EC_Injury_Mechanism_SNOMED_CT varchar 0 0 18 True
EC_Injury_Time varchar 0 0 8 True
EC_PCD_Indicator int 10 0 4 True
EC_Place_Of_Injury_Latitude varchar 0 0 10 True
EC_Place_Of_Injury_Longitude varchar 0 0 10 True
EC_Place_Of_Injury_SNOMED_CT varchar 0 0 18 True
EC_Seen_For_Treatment_Date date 10 0 3 True
EC_Seen_For_Treatment_Time varchar 0 0 8 True
EC_Seen_For_Treatment_Time_Since_Arrival bigint 19 0 8 True
Ethnic_Category varchar 0 0 1 True
Exclusions varchar 0 0 100 True
Finished_Indicator bigint 19 0 8 True
Fractional_Age_At_Arrival float 53 0 8 True
HES_Age_At_Arrival bigint 19 0 8 True
HES_Age_At_Departure bigint 19 0 8 True
Index_Of_Multiple_Deprivation_Decile varchar 0 0 50 True
Index_Of_Multiple_Deprivation_Decile_Description varchar 0 0 50 True
Interpreter_Language_Code_Approved varchar 0 0 5 True
Interpreter_Language_SNOMED_CT varchar 0 0 18 True
Month_of_Birth varchar 0 0 2 True
NHS_Number_Is_Valid varchar 0 0 5 True
NHS_Number_Status_Indicator_Code varchar 0 0 2 True
Overseas_Visitor_Charging_Category varchar 0 0 1 True
Patient_ID bigint 19 0 8 False
Patient_Type varchar 0 0 4 True
Preferred_Spoken_Language_Code_Approved varchar 0 0 5 True
Preferred_Spoken_Language_SNOMED_CT varchar 0 0 18 True
Provider_Code varchar 0 0 12 True
Reason_For_Access varchar 0 0 100 True
RTT_Period_End_Date date 10 0 3 True
RTT_Period_Length bigint 19 0 8 True
RTT_Period_Start_Date date 10 0 3 True
RTT_Period_Status varchar 0 0 2 True
Rural_Urban_Indicator varchar 0 0 1 True
Sex varchar 0 0 5 True
Site_Code_of_Treatment varchar 0 0 5 True
SNOMED_Version varchar 0 0 6 True
SUS_Code_Cleaning_Applied varchar 0 0 5 True
SUS_Costing_Period varchar 0 0 20 True
SUS_Excluded varchar 0 0 5 True
SUS_Final_Price numeric 38 38 9 True
SUS_Grouper_Version varchar 0 0 8 True
SUS_HRG_Code varchar 0 0 5 True
SUS_MFAdjustment numeric 38 38 9 True
SUS_MFF varchar 0 0 10 True
SUS_Tariff numeric 38 38 9 True
SUS_Tariff_Description varchar 0 0 10 True
Wait_Time_Measurement_Type varchar 0 0 2 True
Withheld_Identity_Reason varchar 0 0 2 True
Year_of_Birth varchar 0 0 4 True

ECDS_EC_Diagnoses

ColumnName ColumnType Precision Scale MaxLength IsNullable
DiagnosisCode varchar 0 0 50 True
EC_Ident bigint 19 0 8 True
Ordinal int 10 0 4 False
Patient_ID bigint 19 0 8 False

NHSE_HEALTH_CARE_WORKER

HealthCareWorker

ColumnName ColumnType Precision Scale MaxLength IsNullable
HealthCareWorker varchar 0 0 10 False
Patient_ID bigint 19 0 8 False

NHSE_MPI

MPI

ColumnName ColumnType Precision Scale MaxLength IsNullable
Birth_Month varchar 0 0 10 True
Care_Home_Flag varchar 0 0 10 True
Data_Source varchar 0 0 100 True
Date_Added date 10 0 3 True
DateFrom date 10 0 3 True
DateTo date 10 0 3 True
Death_Month varchar 0 0 10 True
Gender varchar 0 0 1 True
Latest_Flag varchar 0 0 10 True
Living_Alone_Flag varchar 0 0 100 True
Living_with_elderly_Flag varchar 0 0 100 True
Living_with_young_Flag varchar 0 0 100 True
Original_Posting_Date date 10 0 3 True
OS_Property_Classification varchar 0 0 100 True
Patient_ID bigint 19 0 8 False
private_outdoor_space varchar 0 0 100 True
private_outdoor_space_area varchar 0 0 100 True
property_type varchar 0 0 100 True
Pseudo_parent_uprn varchar 0 0 200 True
Pseudo_uprn varchar 0 0 200 True
RP_of_Death varchar 0 0 10 True
Rural_Urban_Classification varchar 0 0 100 True
ServiceType varchar 0 0 100 True

UPRN

ColumnName ColumnType Precision Scale MaxLength IsNullable
_0to4 int 10 0 4 True
_10to14 int 10 0 4 True
_15to19 int 10 0 4 True
_20to24 int 10 0 4 True
_25to29 int 10 0 4 True
_30to34 int 10 0 4 True
_40to44 int 10 0 4 True
_45to49 int 10 0 4 True
_50to54 int 10 0 4 True
_55to59 int 10 0 4 True
_5to9 int 10 0 4 True
_60to64 int 10 0 4 True
_65to69 int 10 0 4 True
_70to74 int 10 0 4 True
_75to79 int 10 0 4 True
_80to84 int 10 0 4 True
_85Plus int 10 0 4 True
Care_Home_Flag varchar 0 0 100 True
class varchar 0 0 100 True
private_outdoor_space varchar 0 0 100 True
private_outdoor_space_area varchar 0 0 100 True
property_type varchar 0 0 100 True
Pseudo_parent_uprn varchar 0 0 200 True
Pseudo_uprn varchar 0 0 200 True
Rural_Urban_Classification varchar 0 0 100 True
ServiceType varchar 0 0 100 True
Total_Pop int 10 0 4 True

NHSE_OPA

OPA

ColumnName ColumnType Precision Scale MaxLength IsNullable
Activity_Location_Type_Code varchar 0 0 5 True
Administrative_Category varchar 0 0 2 True
Appointment_Date date 10 0 3 True
Attendance_Status varchar 0 0 2 True
Clinic_Code varchar 0 0 100 True
Consultation_Medium_Used varchar 0 0 2 True
Der_Activity_Month varchar 0 0 100 True
Der_Financial_Year varchar 0 0 100 True
Ethnic_Category varchar 0 0 2 True
First_Attendance varchar 0 0 2 True
HRG_Code varchar 0 0 10 True
HRG_Version_No varchar 0 0 10 True
Main_Specialty_Code varchar 0 0 3 True
Medical_Staff_Type_Seeing_Patient varchar 0 0 2 True
MultiProf_Ind_Code varchar 0 0 2 True
OPA_Ident bigint 19 0 8 False
OPA_Referral_Source varchar 0 0 2 True
Operation_Status varchar 0 0 2 True
Outcome_of_Attendance varchar 0 0 2 True
Patient_ID bigint 19 0 8 False
Priority_Type varchar 0 0 2 True
Provider_Code varchar 0 0 100 True
Provider_Code_Type varchar 0 0 100 True
Referral_Request_Received_Date date 10 0 3 True
Treatment_Function_Code varchar 0 0 3 True

OPA_Cost

ColumnName ColumnType Precision Scale MaxLength IsNullable
Grand_Total_Payment_MFF real 24 0 4 True
OPA_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
Tariff_OPP real 24 0 4 True
Tariff_Total_Payment real 24 0 4 True

OPA_Diag

ColumnName ColumnType Precision Scale MaxLength IsNullable
OPA_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
Primary_Diagnosis_Code varchar 0 0 100 True
Primary_Diagnosis_Code_Read varchar 0 0 5 True
Secondary_Diagnosis_Code_1 varchar 0 0 100 True
Secondary_Diagnosis_Code_1_Read varchar 0 0 5 True

OPA_Proc

ColumnName ColumnType Precision Scale MaxLength IsNullable
OPA_Ident bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
Primary_Procedure_Code varchar 0 0 100 True
Primary_Procedure_Code_Read varchar 0 0 5 True
Procedure_Code_2 varchar 0 0 100 True
Procedure_Code_2_Read varchar 0 0 5 True

NHSE_SGSS

SGSS_AllTests_Negative

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age_In_Years int 10 0 4 True
County_Description varchar 0 0 50 True
Ethnic_Category_Desc varchar 0 0 255 True
Lab_Report_Date date 10 0 3 True
LFT_Flag varchar 0 0 255 True
Organism_Species_Name varchar 0 0 200 True
Patient_ID bigint 19 0 8 False
Patient_Sex varchar 0 0 50 True
Pillar varchar 0 0 255 True
PostCode_Source varchar 0 0 50 True
Specimen_Date date 10 0 3 True
Symptomatic varchar 0 0 50 True

SGSS_AllTests_Positive

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age_In_Years int 10 0 4 True
County_Description varchar 0 0 50 True
Ethnic_Category_Desc varchar 0 0 255 True
Lab_Report_Date date 10 0 3 True
LFT_Flag varchar 0 0 255 True
Organism_Species_Name varchar 0 0 200 True
Patient_ID bigint 19 0 8 False
Patient_Sex varchar 0 0 50 True
Pillar varchar 0 0 255 True
PostCode_Source varchar 0 0 50 True
SGTF varchar 0 0 255 True
Specimen_Date date 10 0 3 True
Symptomatic varchar 0 0 50 True
Variant varchar 0 0 255 True
VariantDetectionMethod varchar 0 0 255 True

SGSS_Negative

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age_In_Years int 10 0 4 True
County_Description varchar 0 0 50 True
Earliest_Specimen_Date date 10 0 3 True
Lab_Report_Date date 10 0 3 True
Organism_Species_Name varchar 0 0 200 True
Patient_ID bigint 19 0 8 False
Patient_Sex varchar 0 0 50 True
PostCode_Source varchar 0 0 50 True

SGSS_Positive

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age_In_Years int 10 0 4 True
CaseCategory varchar 0 0 50 False
County_Description varchar 0 0 50 True
Earliest_Specimen_Date date 10 0 3 True
Lab_Report_Date date 10 0 3 True
Organism_Species_Name varchar 0 0 200 True
Patient_ID bigint 19 0 8 False
Patient_Sex varchar 0 0 50 True
PostCode_Source varchar 0 0 50 True
SGTF varchar 0 0 10 False

NHSE_Therapeutics

Therapeutics

ColumnName ColumnType Precision Scale MaxLength IsNullable
AgeAtReceivedDate int 10 0 4 True
CASIM05_date_of_symptom_onset varchar 0 0 1000 True
CASIM05_risk_cohort varchar 0 0 1000 True
Count int 10 0 4 True
COVID_indication varchar 0 0 1000 True
CurrentStatus varchar 0 0 1000 True
Der_LoadDate varchar 0 0 1000 True
Diagnosis varchar 0 0 1000 True
FormName varchar 0 0 1000 True
Intervention varchar 0 0 1000 True
MOL1_high_risk_cohort varchar 0 0 1000 True
MOL1_onset_of_symptoms varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
Received datetime 23 3 8 True
Region varchar 0 0 1000 True
SOT02_onset_of_symptoms varchar 0 0 1000 True
SOT02_risk_cohorts varchar 0 0 1000 True
TreatmentStartDate datetime 23 3 8 True

NHSE_WL

WL_ClockStops

ColumnName ColumnType Precision Scale MaxLength IsNullable
ACTIVITY_TREATMENT_FUNCTION_CODE varchar 0 0 1000 True
ADMISSION_METHOD_CODE_HOSPITAL_PROVIDER_SPELL varchar 0 0 1000 True
Cancellation_Date varchar 0 0 1000 True
Completed_Type varchar 0 0 1000 True
Date_Last_Attended varchar 0 0 1000 True
Date_Of_Last_Priority_Review varchar 0 0 1000 True
DECISION_TO_ADMIT_DATE varchar 0 0 1000 True
Diagnostic_Priority_Code varchar 0 0 1000 True
Due_Date varchar 0 0 1000 True
Inclusion_On_Cancer_Ptl varchar 0 0 1000 True
Last_Dna_Date varchar 0 0 1000 True
Local_Outcome_Of_Attendance varchar 0 0 1000 True
Local_Rtt_Status_Code varchar 0 0 1000 True
MAIN_SPECIALTY_CODE varchar 0 0 1000 True
OPCS_Code varchar 0 0 1000 True
OUTCOME_OF_ATTENDANCE_CODE varchar 0 0 1000 True
Outpatient_Appointment_Date varchar 0 0 1000 True
Outpatient_Future_Appointment_Date varchar 0 0 1000 True
Outpatient_Priority_Code varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
PRIORITY_TYPE_CODE varchar 0 0 1000 True
Procedure_Priority_Code varchar 0 0 1000 True
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT varbinary 0 0 8000 True
PSEUDO_PATIENT_PATHWAY_IDENTIFIER varbinary 0 0 8000 True
Pseudo_Referral_Identifier varbinary 0 0 8000 True
Referral_Request_Received_Date varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_END_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_START_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_STATUS varchar 0 0 1000 True
SOURCE_OF_REFERRAL_FOR_OUTPATIENTS varchar 0 0 1000 True
Tci_Date varchar 0 0 1000 True
Waiting_List_Type varchar 0 0 1000 True
Week_Ending_Date varchar 0 0 1000 True

WL_Diagnostics

ColumnName ColumnType Precision Scale MaxLength IsNullable
Diagnostic_Clock_Start_Date varchar 0 0 1000 True
Diagnostic_Modality varchar 0 0 1000 True
Diagnostic_Priority_Code varchar 0 0 1000 True
Inclusion_On_Cancer_Ptl varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
Planned_Diagnostic_Due_Date varchar 0 0 1000 True
PRIORITY_TYPE_CODE varchar 0 0 1000 True
Proposed_Procedure_Opcs_Code varchar 0 0 1000 True
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT varbinary 0 0 8000 True
PSEUDO_PATIENT_PATHWAY_IDENTIFIER varbinary 0 0 8000 True
Pseudo_Referral_Identifier varbinary 0 0 8000 True
REFERRAL_TO_TREATMENT_PERIOD_END_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_START_DATE varchar 0 0 1000 True
Waiting_List_Type varchar 0 0 1000 True
Week_Ending_Date varchar 0 0 1000 True

WL_OpenPathways

ColumnName ColumnType Precision Scale MaxLength IsNullable
ACTIVITY_TREATMENT_FUNCTION_CODE varchar 0 0 1000 True
ADMISSION_METHOD_CODE_HOSPITAL_PROVIDER_SPELL varchar 0 0 1000 True
Cancellation_Date varchar 0 0 1000 True
Current_Pathway_Period_Start_Date varchar 0 0 1000 True
Date_Last_Attended varchar 0 0 1000 True
Date_Of_Last_Priority_Review varchar 0 0 1000 True
DECISION_TO_ADMIT_DATE varchar 0 0 1000 True
Diagnostic_Priority_Code varchar 0 0 1000 True
Due_Date varchar 0 0 1000 True
Inclusion_On_Cancer_Ptl varchar 0 0 1000 True
Last_Dna_Date varchar 0 0 1000 True
Local_Outcome_Of_Attendance varchar 0 0 1000 True
Local_Rtt_Status_Code varchar 0 0 1000 True
MAIN_SPECIALTY_CODE varchar 0 0 1000 True
OUTCOME_OF_ATTENDANCE_CODE varchar 0 0 1000 True
Outpatient_Appointment_Date varchar 0 0 1000 True
Outpatient_Future_Appointment_Date varchar 0 0 1000 True
Outpatient_Priority_Code varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
PRIORITY_TYPE_CODE varchar 0 0 1000 True
Procedure_Priority_Code varchar 0 0 1000 True
Proposed_Procedure_Opcs_Code varchar 0 0 1000 True
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER varbinary 0 0 8000 True
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT varbinary 0 0 8000 True
PSEUDO_PATIENT_PATHWAY_IDENTIFIER varbinary 0 0 8000 True
Pseudo_Referral_Identifier varbinary 0 0 8000 True
REFERRAL_REQUEST_RECEIVED_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_END_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_START_DATE varchar 0 0 1000 True
REFERRAL_TO_TREATMENT_PERIOD_STATUS varchar 0 0 1000 True
SOURCE_OF_REFERRAL varchar 0 0 1000 True
Tci_Date varchar 0 0 1000 True
Waiting_List_Type varchar 0 0 1000 True
Week_Ending_Date varchar 0 0 1000 True

ONS_CIS

ONS_CIS

ColumnName ColumnType Precision Scale MaxLength IsNullable
age_at_visit int 10 0 4 True
contact_any_covid bit 1 0 1 True
contact_any_covid_dayssinceg real 24 0 4 True
contact_face_covering int 10 0 4 True
country int 10 0 4 True
covid_admitted bit 1 0 1 True
covid_date date 10 0 3 True
covid_nhs_contact bit 1 0 1 True
covid_test_blood bit 1 0 1 True
covid_test_blood_neg_last_date date 10 0 3 True
covid_test_blood_pos_first_date date 10 0 3 True
covid_test_blood_result int 10 0 4 True
covid_test_swab bit 1 0 1 True
covid_test_swab_neg_last_date date 10 0 3 True
covid_test_swab_pos_first_date date 10 0 3 True
covid_test_swab_result int 10 0 4 True
covid_think_havehad bit 1 0 1 True
ct_mean varchar 0 0 100 True
dataset int 10 0 4 True
dvhsize int 10 0 4 True
ethnicity int 10 0 4 True
geography_code varchar 0 0 100 True
geography_name varchar 0 0 100 True
gor9d varchar 0 0 100 True
gor9d_surge varchar 0 0 100 True
health_care_clean bit 1 0 1 True
health_conditions bit 1 0 1 True
health_conditions_impact int 10 0 4 True
hhsize int 10 0 4 True
imp_age int 10 0 4 True
imp_sex varchar 0 0 10 True
n_participants int 10 0 4 True
patient_facing_clean int 10 0 4 True
Patient_ID bigint 19 0 8 False
received_ox_date date 10 0 3 True
result_combined varchar 0 0 100 True
result_mk varchar 0 0 100 True
result_mk_date date 10 0 3 True
result_tdi varchar 0 0 100 True
samples_taken_date date 10 0 3 True
school_year varchar 0 0 100 True
self_isolating bit 1 0 1 True
self_isolating_v1 int 10 0 4 True
sex varchar 0 0 10 True
smoke_ever_regularly bit 1 0 1 True
smoke_now_cigar bit 1 0 1 True
smoke_now_cigarettes bit 1 0 1 True
smoke_now_pipe bit 1 0 1 True
smoke_now_vape bit 1 0 1 True
SOC_occupation varchar 0 0 100 True
surge_flag bit 1 0 1 True
sympt_covid_abdominal_pain bit 1 0 1 True
sympt_covid_any bit 1 0 1 True
sympt_covid_cough bit 1 0 1 True
sympt_covid_diarrhoea bit 1 0 1 True
sympt_covid_fatigue_weakness bit 1 0 1 True
sympt_covid_fever bit 1 0 1 True
sympt_covid_headache bit 1 0 1 True
sympt_covid_loss_of_smell bit 1 0 1 True
sympt_covid_loss_of_taste bit 1 0 1 True
sympt_covid_muscle_ache_myalgia bit 1 0 1 True
sympt_covid_nausea_vomiting bit 1 0 1 True
sympt_covid_shortness_of_breath bit 1 0 1 True
sympt_covid_sore_throat bit 1 0 1 True
sympt_now_abdominal_pain bit 1 0 1 True
sympt_now_any bit 1 0 1 True
sympt_now_cough bit 1 0 1 True
sympt_now_date date 10 0 3 True
sympt_now_diarrhoea bit 1 0 1 True
sympt_now_fatigue_weakness bit 1 0 1 True
sympt_now_fever bit 1 0 1 True
sympt_now_headache bit 1 0 1 True
sympt_now_loss_of_smell bit 1 0 1 True
sympt_now_loss_of_taste bit 1 0 1 True
sympt_now_muscle_ache_myalgia bit 1 0 1 True
sympt_now_nausea_vomiting bit 1 0 1 True
sympt_now_shortness_of_breath bit 1 0 1 True
sympt_now_sore_throat bit 1 0 1 True
tenure_group int 10 0 4 True
think_have_covid_sympt_now bit 1 0 1 True
travel_abroad bit 1 0 1 True
travel_abroad_date date 10 0 3 True
visit_date date 10 0 3 True
visit_id varchar 0 0 100 True
work_direct_contact_patients_etc bit 1 0 1 True
work_location int 10 0 4 True
work_outside_home_days real 24 0 4 True
work_sector int 10 0 4 True
work_social_distancing int 10 0 4 True
work_status int 10 0 4 True
work_status_clean int 10 0 4 True
work_status_v1 int 10 0 4 True
work_travel int 10 0 4 True

ONS_CIS_New

ColumnName ColumnType Precision Scale MaxLength IsNullable
age_at_visit int 10 0 4 True
ageg int 10 0 4 True
ageg_7 int 10 0 4 True
ageg_small int 10 0 4 True
ageg_small2 int 10 0 4 True
ageg_sy int 10 0 4 True
any_evidence_sympt_around int 10 0 4 True
any_evidence_sympt_now int 10 0 4 True
assay_mabs real 24 0 4 True
assay_mabs_n real 24 0 4 True
contact_any_covid int 10 0 4 True
contact_any_covid_date date 10 0 3 True
contact_any_covid_dayssinceg int 10 0 4 True
contact_any_covid_type int 10 0 4 True
contact_carehome int 10 0 4 True
contact_face_covering int 10 0 4 True
contact_face_covering_other int 10 0 4 True
contact_face_covering_workschool int 10 0 4 True
contact_hospital int 10 0 4 True
contact_known_covid int 10 0 4 True
contact_known_covid_date date 10 0 3 True
contact_known_covid_type int 10 0 4 True
contact_other_in_hh_carehome int 10 0 4 True
contact_other_in_hh_hospital int 10 0 4 True
contact_participant_carehome int 10 0 4 True
contact_participant_hospital int 10 0 4 True
contact_physical_18_69y int 10 0 4 True
contact_physical_18y int 10 0 4 True
contact_physical_70y int 10 0 4 True
contact_social_dist_18_to_69 int 10 0 4 True
contact_social_dist_18y int 10 0 4 True
contact_social_dist_70y int 10 0 4 True
contact_suspect_covid int 10 0 4 True
contact_suspect_covid_date date 10 0 3 True
contact_suspect_covid_type int 10 0 4 True
country int 10 0 4 True
covid_admitted int 10 0 4 True
covid_date date 10 0 3 True
covid_nhs_contact int 10 0 4 True
covid_test_blood int 10 0 4 True
covid_test_blood_neg_last_date date 10 0 3 True
covid_test_blood_pos_first_date date 10 0 3 True
covid_test_blood_result int 10 0 4 True
covid_test_swab int 10 0 4 True
covid_test_swab_neg_last_date date 10 0 3 True
covid_test_swab_pos_first_date date 10 0 3 True
covid_test_swab_result int 10 0 4 True
covid_think_havehad int 10 0 4 True
ct_mean real 24 0 4 True
ctMS2 real 24 0 4 True
ctMS2_result int 10 0 4 True
ctNgene real 24 0 4 True
ctNgene_result int 10 0 4 True
ctORF1ab real 24 0 4 True
ctORF1ab_result int 10 0 4 True
ctpattern int 10 0 4 True
ctSgene real 24 0 4 True
ctSgene_result int 10 0 4 True
dataset int 10 0 4 True
dob_is_imputed int 10 0 4 True
ethnicity int 10 0 4 True
ethnicityg int 10 0 4 True
geography_code varchar 0 0 100 True
geography_name varchar 0 0 100 True
gor_name int 10 0 4 True
gor9d int 10 0 4 True
health_care_clean int 10 0 4 True
health_conditions int 10 0 4 True
health_conditions_impact int 10 0 4 True
hh_id_fake int 10 0 4 True
hhsize int 10 0 4 True
imd_decile_E int 10 0 4 True
imd_decile_NI int 10 0 4 True
imd_decile_S int 10 0 4 True
imd_decile_W int 10 0 4 True
imd_quartile_E int 10 0 4 True
imd_quartile_NI int 10 0 4 True
imd_quartile_S int 10 0 4 True
imd_quartile_W int 10 0 4 True
last_linkage_dt date 10 0 3 True
long_covid_abdominal_pain int 10 0 4 True
long_covid_chest_pain int 10 0 4 True
long_covid_cough int 10 0 4 True
long_covid_diarrhoea int 10 0 4 True
long_covid_difficult_concentrate int 10 0 4 True
long_covid_fever int 10 0 4 True
long_covid_have_symptoms int 10 0 4 True
long_covid_headache int 10 0 4 True
long_covid_loss_of_appetite int 10 0 4 True
long_covid_loss_of_smell int 10 0 4 True
long_covid_loss_of_taste int 10 0 4 True
long_covid_low_mood_not_enjoying int 10 0 4 True
long_covid_memory_loss_confusion int 10 0 4 True
long_covid_muscle_ache int 10 0 4 True
long_covid_nausea_vomiting int 10 0 4 True
long_covid_palpitations int 10 0 4 True
long_covid_shortness_of_breath int 10 0 4 True
long_covid_sore_throat int 10 0 4 True
long_covid_trouble_sleeping int 10 0 4 True
long_covid_vertigo_dizziness int 10 0 4 True
long_covid_weakness_tiredness int 10 0 4 True
long_covid_worry_anxiety int 10 0 4 True
main_job_changed int 10 0 4 True
n_participants_corrected int 10 0 4 True
nhs_data_share int 10 0 4 True
opt_out_date date 10 0 3 True
others_home_hours int 10 0 4 True
others_own_home_hours int 10 0 4 True
outside_shopping_only_times int 10 0 4 True
outside_shopping_social_times int 10 0 4 True
outside_socialising_only_times int 10 0 4 True
patient_facing_clean int 10 0 4 True
patient_facing_clean_ever int 10 0 4 True
Patient_ID bigint 19 0 8 False
pseudo_visit_id varbinary 0 0 8000 True
reason_for_withdrawal int 10 0 4 True
received_ox_date date 10 0 3 True
reduce_activities_long_covid int 10 0 4 True
result_combined int 10 0 4 True
result_mk int 10 0 4 True
result_mk_date date 10 0 3 True
result_tdi int 10 0 4 True
result_tdi_date date 10 0 3 True
result_tdi_date_n date 10 0 3 True
result_tdi_n int 10 0 4 True
rural_urban int 10 0 4 True
samples_taken_date date 10 0 3 True
school_year int 10 0 4 True
self_isolating int 10 0 4 True
self_isolating_v1 int 10 0 4 True
sex int 10 0 4 True
sex_is_imputed int 10 0 4 True
smoke_ever_regularly int 10 0 4 True
smoke_now_cigar int 10 0 4 True
smoke_now_cigarettes int 10 0 4 True
smoke_now_hookah_shisha int 10 0 4 True
smoke_now_nothing int 10 0 4 True
smoke_now_pipe int 10 0 4 True
smoke_now_vape int 10 0 4 True
SOC_occupation varchar 0 0 100 True
sympt_covid_abdominal_pain int 10 0 4 True
sympt_covid_any int 10 0 4 True
sympt_covid_cough int 10 0 4 True
sympt_covid_diarrhoea int 10 0 4 True
sympt_covid_fatigue_weakness int 10 0 4 True
sympt_covid_fever int 10 0 4 True
sympt_covid_headache int 10 0 4 True
sympt_covid_loss_of_smell int 10 0 4 True
sympt_covid_loss_of_taste int 10 0 4 True
sympt_covid_muscle_ache_myalgia int 10 0 4 True
sympt_covid_nausea_vomiting int 10 0 4 True
sympt_covid_shortness_of_breath int 10 0 4 True
sympt_covid_sore_throat int 10 0 4 True
sympt_now_abdominal_pain int 10 0 4 True
sympt_now_any int 10 0 4 True
sympt_now_any_orig int 10 0 4 True
sympt_now_cough int 10 0 4 True
sympt_now_count12 int 10 0 4 True
sympt_now_date date 10 0 3 True
sympt_now_diarrhoea int 10 0 4 True
sympt_now_fatigue_weakness int 10 0 4 True
sympt_now_fever int 10 0 4 True
sympt_now_headache int 10 0 4 True
sympt_now_loss_of_smell int 10 0 4 True
sympt_now_loss_of_taste int 10 0 4 True
sympt_now_muscle_ache_myalgia int 10 0 4 True
sympt_now_nausea_vomiting int 10 0 4 True
sympt_now_shortness_of_breath int 10 0 4 True
sympt_now_sore_throat int 10 0 4 True
tenure_group int 10 0 4 True
think_have_covid_sympt_now int 10 0 4 True
travel_abroad int 10 0 4 True
travel_abroad_date date 10 0 3 True
visit_date date 10 0 3 True
visit_num int 10 0 4 True
visit_status int 10 0 4 True
visit_type int 10 0 4 True
withdrawn_participant int 10 0 4 True
work_direct_contact_patients_etc int 10 0 4 True
work_location int 10 0 4 True
work_outside_home_days real 24 0 4 True
work_sector int 10 0 4 True
work_social_distancing int 10 0 4 True
work_status int 10 0 4 True
work_status_clean int 10 0 4 True
work_status_v1 int 10 0 4 True
work_status_v2 int 10 0 4 True
work_travel int 10 0 4 True

ONS_CIS_New_Swab_Clearance

ColumnName ColumnType Precision Scale MaxLength IsNullable
age_at_visit int 10 0 4 True
ageg_small int 10 0 4 True
ageg_sy int 10 0 4 True
any_evidence_sympt_ARO int 10 0 4 True
any_lfdpos int 10 0 4 True
atrisk_date date 10 0 3 True
check int 10 0 4 True
cis20_name int 10 0 4 True
cis20_samp int 10 0 4 True
clear_pattern int 10 0 4 True
count_pos_in_epi_updt int 10 0 4 True
country int 10 0 4 True
ct_mean_max real 24 0 4 True
ct_mean_min real 24 0 4 True
ctpattern_max int 10 0 4 True
ctpattern_min int 10 0 4 True
duration_intermittent int 10 0 4 True
epi_inf_type int 10 0 4 True
episode_updt int 10 0 4 True
ethnicity_wo int 10 0 4 True
ethnicityg int 10 0 4 True
ever_care_home_worker int 10 0 4 True
ever_lthc int 10 0 4 True
ever_lthc_disabled int 10 0 4 True
ever_personfacing_socialcare int 10 0 4 True
first_neg_date date 10 0 3 True
first_pos_date date 10 0 3 True
firstpos_test_no int 10 0 4 True
gor9d int 10 0 4 True
hh_enrol_date date 10 0 3 True
hh_id_fake int 10 0 4 True
hhsize int 10 0 4 True
index_date_updt date 10 0 3 True
intermittent int 10 0 4 True
last_pos_date date 10 0 3 True
laua_name int 10 0 4 True
laua_samp int 10 0 4 True
lineage varchar 0 0 1000 True
n_participants_corrected int 10 0 4 True
n_tests_in_epi int 10 0 4 True
next_lab_id int 10 0 4 True
other_in_hh int 10 0 4 True
pangolin varchar 0 0 1000 True
patient_facing_clean_ever int 10 0 4 True
Patient_ID bigint 19 0 8 False
plot real 24 0 4 True
pospattern varchar 0 0 1000 True
prev_neg_date date 10 0 3 True
PREVNEG int 10 0 4 True
rgn_samp int 10 0 4 True
second_neg_date date 10 0 3 True
sex int 10 0 4 True
smoke int 10 0 4 True
sympt_ARO_amn_source int 10 0 4 True
sympt_ARO_split int 10 0 4 True
testkit varchar 0 0 1000 True
wofy53 int 10 0 4 True
WOFY57 int 10 0 4 True

ONS_CIS_New_Swab_Clearance_Pos_All

ColumnName ColumnType Precision Scale MaxLength IsNullable
age_at_visit int 10 0 4 True
ageg_small int 10 0 4 True
ageg_sy int 10 0 4 True
any_evidence_sympt_ARO int 10 0 4 True
any_lfdpos int 10 0 4 True
atrisk_date date 10 0 3 True
check int 10 0 4 True
cis20_name int 10 0 4 True
cis20_samp int 10 0 4 True
clear_pattern int 10 0 4 True
count_pos_in_epi_updt int 10 0 4 True
country int 10 0 4 True
covid_test_swab_result int 10 0 4 True
ct_mean_max real 24 0 4 True
ct_mean_max_exc_tnt real 24 0 4 True
ct_mean_min real 24 0 4 True
ct_mean_min_exc_tnt real 24 0 4 True
ctpattern_max int 10 0 4 True
ctpattern_max_exc_tnt int 10 0 4 True
ctpattern_min int 10 0 4 True
ctpattern_min_exc_tnt int 10 0 4 True
duration_intermittent int 10 0 4 True
epi_inf_type int 10 0 4 True
episode_updt int 10 0 4 True
ethnicity_wo int 10 0 4 True
ethnicityg int 10 0 4 True
ever_care_home_worker int 10 0 4 True
ever_lthc int 10 0 4 True
ever_lthc_disabled int 10 0 4 True
ever_personfacing_socialcare int 10 0 4 True
first_neg_date date 10 0 3 True
first_pos_date date 10 0 3 True
first_pos_date_cis date 10 0 3 True
firstpos_test_no int 10 0 4 True
gor9d int 10 0 4 True
hh_enrol_date date 10 0 3 True
hh_id_fake int 10 0 4 True
hhsize int 10 0 4 True
index_date_updt date 10 0 3 True
intermittent int 10 0 4 True
last_pos_date date 10 0 3 True
laua_name int 10 0 4 True
laua_samp int 10 0 4 True
lineage varchar 0 0 1000 True
n int 10 0 4 True
n_participants_corrected int 10 0 4 True
n_tests_in_epi int 10 0 4 True
next_lab_id int 10 0 4 True
other_in_hh int 10 0 4 True
pangolin varchar 0 0 1000 True
patient_facing_clean_ever int 10 0 4 True
Patient_ID bigint 19 0 8 False
plot real 24 0 4 True
pospattern varchar 0 0 1000 True
prev_neg_date date 10 0 3 True
PREVNEG int 10 0 4 True
rgn_samp int 10 0 4 True
second_neg_date date 10 0 3 True
sex int 10 0 4 True
smoke int 10 0 4 True
sympt_ARO_amn_source int 10 0 4 True
sympt_ARO_split int 10 0 4 True
testedfor varchar 0 0 1000 True
testkit varchar 0 0 1000 True
type_updt int 10 0 4 True
type_updt_tnt_minus_cis_days int 10 0 4 True
wofy60 int 10 0 4 True
WOFY68 int 10 0 4 True

ONS_CIS_New_Swab_Clearance_Pos_TnT

ColumnName ColumnType Precision Scale MaxLength IsNullable
age_at_visit int 10 0 4 True
ageg_small int 10 0 4 True
ageg_sy int 10 0 4 True
any_evidence_sympt_ARO int 10 0 4 True
any_lfdpos int 10 0 4 True
atrisk_date date 10 0 3 True
check int 10 0 4 True
cis20_name int 10 0 4 True
cis20_samp int 10 0 4 True
clear_pattern int 10 0 4 True
count_pos_in_epi_updt int 10 0 4 True
country int 10 0 4 True
ct_mean_max real 24 0 4 True
ct_mean_max_exc_tnt real 24 0 4 True
ct_mean_min real 24 0 4 True
ct_mean_min_exc_tnt real 24 0 4 True
ctpattern_max int 10 0 4 True
ctpattern_max_exc_tnt int 10 0 4 True
ctpattern_min int 10 0 4 True
ctpattern_min_exc_tnt int 10 0 4 True
duration_intermittent int 10 0 4 True
epi_inf_type int 10 0 4 True
episode_updt int 10 0 4 True
ethnicity_wo int 10 0 4 True
ethnicityg int 10 0 4 True
ever_care_home_worker int 10 0 4 True
ever_lthc int 10 0 4 True
ever_lthc_disabled int 10 0 4 True
ever_personfacing_socialcare int 10 0 4 True
first_neg_date date 10 0 3 True
first_pos_date date 10 0 3 True
first_pos_date_cis date 10 0 3 True
firstpos_test_no int 10 0 4 True
gor9d int 10 0 4 True
hh_enrol_date date 10 0 3 True
hh_id_fake int 10 0 4 True
hhsize int 10 0 4 True
index_date_updt date 10 0 3 True
intermittent int 10 0 4 True
last_pos_date date 10 0 3 True
laua_name int 10 0 4 True
laua_samp int 10 0 4 True
lineage varchar 0 0 1000 True
n int 10 0 4 True
n_participants_corrected int 10 0 4 True
n_tests_in_epi int 10 0 4 True
next_lab_id int 10 0 4 True
other_in_hh int 10 0 4 True
pangolin varchar 0 0 1000 True
patient_facing_clean_ever int 10 0 4 True
Patient_ID bigint 19 0 8 False
plot real 24 0 4 True
pospattern varchar 0 0 1000 True
prev_neg_date date 10 0 3 True
PREVNEG int 10 0 4 True
rgn_samp int 10 0 4 True
second_neg_date date 10 0 3 True
sex int 10 0 4 True
smoke int 10 0 4 True
sympt_ARO_amn_source int 10 0 4 True
sympt_ARO_split int 10 0 4 True
testedfor varchar 0 0 1000 True
testkit varchar 0 0 1000 True
type_updt int 10 0 4 True
type_updt_tnt_minus_cis_days int 10 0 4 True
wofy60 int 10 0 4 True
WOFY68 int 10 0 4 True

ONS_DEATHS

ONS_Deaths

ColumnName ColumnType Precision Scale MaxLength IsNullable
ageinyrs int 10 0 4 True
dod date 10 0 3 True
FIC10MEN1 varchar 0 0 100 True
FIC10MEN10 varchar 0 0 100 True
FIC10MEN11 varchar 0 0 100 True
FIC10MEN12 varchar 0 0 100 True
FIC10MEN13 varchar 0 0 100 True
FIC10MEN14 varchar 0 0 100 True
FIC10MEN15 varchar 0 0 100 True
FIC10MEN2 varchar 0 0 100 True
FIC10MEN3 varchar 0 0 100 True
FIC10MEN4 varchar 0 0 100 True
FIC10MEN5 varchar 0 0 100 True
FIC10MEN6 varchar 0 0 100 True
FIC10MEN7 varchar 0 0 100 True
FIC10MEN8 varchar 0 0 100 True
FIC10MEN9 varchar 0 0 100 True
FIC10UND varchar 0 0 100 True
ICD10001 varchar 0 0 100 True
ICD10002 varchar 0 0 100 True
ICD10003 varchar 0 0 100 True
ICD10004 varchar 0 0 100 True
ICD10005 varchar 0 0 100 True
ICD10006 varchar 0 0 100 True
ICD10007 varchar 0 0 100 True
ICD10008 varchar 0 0 100 True
ICD10009 varchar 0 0 100 True
ICD10010 varchar 0 0 100 True
ICD10011 varchar 0 0 100 True
ICD10012 varchar 0 0 100 True
ICD10013 varchar 0 0 100 True
ICD10014 varchar 0 0 100 True
ICD10015 varchar 0 0 100 True
icd10u varchar 0 0 100 True
Patient_ID bigint 19 0 8 False
Place_of_occurrence varchar 0 0 1000 True
sex varchar 0 0 10 True

OS_BUILD

BuildInfo

ColumnName ColumnType Precision Scale MaxLength IsNullable
BuildDate datetime 23 3 8 False
BuildDesc varchar 0 0 100 False
BuildNumber int 10 0 4 False

CodeCountIndicator

ColumnName ColumnType Precision Scale MaxLength IsNullable
CodeCountIndicator float 53 0 8 True
CTV3Code varchar 0 0 50 False

LatestBuildTime

ColumnName ColumnType Precision Scale MaxLength IsNullable
DtLatestBuild datetime 23 3 8 False

OpenSAFELYSchemaInformation

ColumnName ColumnType Precision Scale MaxLength IsNullable
CollationName nvarchar 0 0 256 True
CollationName sysname 0 0 256 True
ColumnId int 10 0 4 False
ColumnName nvarchar 0 0 256 True
ColumnName sysname 0 0 256 True
ColumnType nvarchar 0 0 256 False
ColumnType sysname 0 0 256 False
DataSource varchar 0 0 1000 True
IsNullable bit 1 0 1 True
MaxLength smallint 5 0 2 False
Precision tinyint 3 0 1 False
Scale tinyint 3 0 1 False
TableName nvarchar 0 0 256 False
TableName sysname 0 0 256 False

OS_DERIVED

Household

ColumnName ColumnType Precision Scale MaxLength IsNullable
CareHome bit 1 0 1 True
Household_ID bigint 19 0 8 True
HouseholdSize int 10 0 4 True
MatchesUprnCount bit 1 0 1 True
MixedSoftwareHousehold bit 1 0 1 True
MSOA varchar 0 0 50 True
NFA_Unknown bit 1 0 1 True
Prison bit 1 0 1 True
TppPercentage int 10 0 4 True

HouseholdMember

ColumnName ColumnType Precision Scale MaxLength IsNullable
Household_ID bigint 19 0 8 False
HouseholdMember_ID bigint 19 0 8 False
Patient_ID bigint 19 0 8 False

MSOA_PopulationEstimates_2019

ColumnName ColumnType Precision Scale MaxLength IsNullable
Age_0 int 10 0 4 False
Age_1 int 10 0 4 False
Age_10 int 10 0 4 False
Age_11 int 10 0 4 False
Age_12 int 10 0 4 False
Age_13 int 10 0 4 False
Age_14 int 10 0 4 False
Age_15 int 10 0 4 False
Age_16 int 10 0 4 False
Age_17 int 10 0 4 False
Age_18 int 10 0 4 False
Age_19 int 10 0 4 False
Age_2 int 10 0 4 False
Age_20 int 10 0 4 False
Age_21 int 10 0 4 False
Age_22 int 10 0 4 False
Age_23 int 10 0 4 False
Age_24 int 10 0 4 False
Age_25 int 10 0 4 False
Age_26 int 10 0 4 False
Age_27 int 10 0 4 False
Age_28 int 10 0 4 False
Age_29 int 10 0 4 False
Age_3 int 10 0 4 False
Age_30 int 10 0 4 False
Age_31 int 10 0 4 False
Age_32 int 10 0 4 False
Age_33 int 10 0 4 False
Age_34 int 10 0 4 False
Age_35 int 10 0 4 False
Age_36 int 10 0 4 False
Age_37 int 10 0 4 False
Age_38 int 10 0 4 False
Age_39 int 10 0 4 False
Age_4 int 10 0 4 False
Age_40 int 10 0 4 False
Age_41 int 10 0 4 False
Age_42 int 10 0 4 False
Age_43 int 10 0 4 False
Age_44 int 10 0 4 False
Age_45 int 10 0 4 False
Age_46 int 10 0 4 False
Age_47 int 10 0 4 False
Age_48 int 10 0 4 False
Age_49 int 10 0 4 False
Age_5 int 10 0 4 False
Age_50 int 10 0 4 False
Age_51 int 10 0 4 False
Age_52 int 10 0 4 False
Age_53 int 10 0 4 False
Age_54 int 10 0 4 False
Age_55 int 10 0 4 False
Age_56 int 10 0 4 False
Age_57 int 10 0 4 False
Age_58 int 10 0 4 False
Age_59 int 10 0 4 False
Age_6 int 10 0 4 False
Age_60 int 10 0 4 False
Age_61 int 10 0 4 False
Age_62 int 10 0 4 False
Age_63 int 10 0 4 False
Age_64 int 10 0 4 False
Age_65 int 10 0 4 False
Age_66 int 10 0 4 False
Age_67 int 10 0 4 False
Age_68 int 10 0 4 False
Age_69 int 10 0 4 False
Age_7 int 10 0 4 False
Age_70 int 10 0 4 False
Age_71 int 10 0 4 False
Age_72 int 10 0 4 False
Age_73 int 10 0 4 False
Age_74 int 10 0 4 False
Age_75 int 10 0 4 False
Age_76 int 10 0 4 False
Age_77 int 10 0 4 False
Age_78 int 10 0 4 False
Age_79 int 10 0 4 False
Age_8 int 10 0 4 False
Age_80 int 10 0 4 False
Age_81 int 10 0 4 False
Age_82 int 10 0 4 False
Age_83 int 10 0 4 False
Age_84 int 10 0 4 False
Age_85 int 10 0 4 False
Age_86 int 10 0 4 False
Age_87 int 10 0 4 False
Age_88 int 10 0 4 False
Age_89 int 10 0 4 False
Age_9 int 10 0 4 False
Age_90_Plus int 10 0 4 False
Age_All int 10 0 4 False
LA_Code_2019 varchar 0 0 50 False
LA_Code_2020 varchar 0 0 50 False
MSOA_Code varchar 0 0 50 False

PotentialCareHomeAddress

ColumnName ColumnType Precision Scale MaxLength IsNullable
LocationDoesNotRequireNursing varchar 0 0 5 False
LocationRequiresNursing varchar 0 0 5 False
Patient_ID bigint 19 0 8 False
PatientAddress_ID bigint 19 0 8 False

S1

Appointment

ColumnName ColumnType Precision Scale MaxLength IsNullable
Appointment_ID bigint 19 0 8 False
ArrivedDate datetime 23 3 8 False
BookedDate datetime 23 3 8 False
EndDate datetime 23 3 8 False
FinishedDate datetime 23 3 8 False
Organisation_ID bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
SeenDate datetime 23 3 8 False
StartDate datetime 23 3 8 False
Status int 10 0 4 False

CTV3Dictionary

ColumnName ColumnType Precision Scale MaxLength IsNullable
CTV3Code varchar 0 0 50 False
Description varchar 0 0 255 False

CTV3Hierarchy

ColumnName ColumnType Precision Scale MaxLength IsNullable
ChildCTV3Code varchar 0 0 50 False
ChildCTV3Description varchar 0 0 255 False
ChildToParentDistance int 10 0 4 False
ParentCTV3Code varchar 0 0 50 False
ParentCTV3Description varchar 0 0 255 False

CodedEvent

ColumnName ColumnType Precision Scale MaxLength IsNullable
CodedEvent_ID bigint 19 0 8 False
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
CTV3Code varchar 0 0 50 False
NumericValue real 24 0 4 False
Patient_ID bigint 19 0 8 False

CodedEventRange

ColumnName ColumnType Precision Scale MaxLength IsNullable
CodedEvent_ID bigint 19 0 8 False
CodedEventRange_ID bigint 19 0 8 False
Comparator tinyint 3 0 1 False
Consultation_ID bigint 19 0 8 False
LowerBound real 24 0 4 False
Patient_ID int 10 0 4 False
UpperBound real 24 0 4 False

Consultation

ColumnName ColumnType Precision Scale MaxLength IsNullable
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
Patient_ID bigint 19 0 8 False
Registration_ID bigint 19 0 8 False

DataDictionary

ColumnName ColumnType Precision Scale MaxLength IsNullable
Code varchar 0 0 255 True
Description varchar 0 0 1000 True
Table varchar 0 0 1000 True
Type varchar 0 0 255 True

ICD10Dictionary

ColumnName ColumnType Precision Scale MaxLength IsNullable
Code varchar 0 0 4 False
CodeDescription varchar 0 0 500 False
ParentCode char 0 0 3 False
ParentCodeDescription varchar 0 0 500 False

MedicationDictionary

ColumnName ColumnType Precision Scale MaxLength IsNullable
CompanyName varchar 0 0 200 True
DMD_ID varchar 0 0 50 True
Form varchar 0 0 50 True
FullName varchar 0 0 1000 True
MultilexDrug_ID varchar 0 0 767 True
PackDescription varchar 0 0 50 True
ProductId bigint 19 0 8 False
RootName varchar 0 0 100 True
Strength varchar 0 0 500 True

MedicationIssue

ColumnName ColumnType Precision Scale MaxLength IsNullable
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
Dose varchar 0 0 255 False
EndDate datetime 23 3 8 False
MedicationIssue_ID bigint 19 0 8 False
MedicationStatus int 10 0 4 False
MultilexDrug_ID varchar 0 0 255 False
Patient_ID bigint 19 0 8 False
Quantity varchar 0 0 255 False
RepeatMedication_ID bigint 19 0 8 False
StartDate datetime 23 3 8 False

MedicationRepeat

ColumnName ColumnType Precision Scale MaxLength IsNullable
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
Dose varchar 0 0 255 False
EndDate datetime 23 3 8 False
MedicationRepeat_ID bigint 19 0 8 False
MedicationStatus int 10 0 4 False
MultilexDrug_ID varchar 0 0 255 False
Patient_ID bigint 19 0 8 False
Quantity varchar 0 0 255 False
StartDate datetime 23 3 8 False

MedicationSensitivity

ColumnName ColumnType Precision Scale MaxLength IsNullable
Consultation_ID bigint 19 0 8 False
ConsultationDate datetime 23 3 8 False
Ended bit 1 0 1 True
FormulationSpecific bit 1 0 1 False
MedicationSensitivity_ID int 10 0 4 False
MultilexDrug_ID varchar 0 0 100 False
Patient_ID int 10 0 4 False
StartDate datetime 23 3 8 False

Organisation

ColumnName ColumnType Precision Scale MaxLength IsNullable
GoLiveDate datetime 23 3 8 False
MSOACode varchar 0 0 150 False
Organisation_ID bigint 19 0 8 False
Region varchar 0 0 255 False
STPCode varchar 0 0 50 False

Patient

ColumnName ColumnType Precision Scale MaxLength IsNullable
DateOfBirth date 10 0 3 True
DateOfDeath date 10 0 3 True
Patient_ID bigint 19 0 8 False
Sex char 0 0 1 False

PatientAddress

ColumnName ColumnType Precision Scale MaxLength IsNullable
AddressType int 10 0 4 False
EndDate datetime 23 3 8 False
ImdRankRounded int 10 0 4 False
MSOACode varchar 0 0 150 False
Patient_ID bigint 19 0 8 False
PatientAddress_ID bigint 19 0 8 False
RuralUrbanClassificationCode int 10 0 4 False
StartDate datetime 23 3 8 False

QOFClusterReference

ColumnName ColumnType Precision Scale MaxLength IsNullable
ClusterName varchar 0 0 100 False
ClusterType varchar 0 0 50 False
CTV3Code varchar 0 0 50 False
Description varchar 0 0 255 False

RegistrationHistory

ColumnName ColumnType Precision Scale MaxLength IsNullable
EndDate datetime 23 3 8 False
Organisation_ID bigint 19 0 8 False
Patient_ID bigint 19 0 8 False
Registration_ID bigint 19 0 8 False
StartDate datetime 23 3 8 False

UnitDictionary

ColumnName ColumnType Precision Scale MaxLength IsNullable
CTV3Code varchar 0 0 50 False
DecimalPlaces int 10 0 4 False
LowerNormalBound real 24 0 4 False
Maximum real 24 0 4 False
Minimum real 24 0 4 False
UnitDictionary_ID int 10 0 4 False
Units varchar 0 0 50 False
UpperNormalBound real 24 0 4 False

Vaccination

ColumnName ColumnType Precision Scale MaxLength IsNullable
Patient_ID bigint 19 0 8 False
Vaccination_ID bigint 19 0 8 False
VaccinationDate datetime 23 3 8 False
VaccinationName varchar 0 0 100 False
VaccinationName_ID bigint 19 0 8 False
VaccinationSchedulePart int 10 0 4 False

VaccinationReference

ColumnName ColumnType Precision Scale MaxLength IsNullable
VaccinationContent varchar 0 0 50 False
VaccinationName varchar 0 0 100 False
VaccinationName_ID int 10 0 4 False

YCodeToSnomedMapping

ColumnName ColumnType Precision Scale MaxLength IsNullable
SctConceptId bigint 19 0 8 True
YCode varchar 0 0 5 False

UK_Renal_Register

UKRR

ColumnName ColumnType Precision Scale MaxLength IsNullable
creat real 24 0 4 True
dataset varchar 0 0 1000 True
eGFR_ckdepi real 24 0 4 True
mod_prev varchar 0 0 1000 True
mod_start varchar 0 0 1000 True
Patient_ID bigint 19 0 8 False
renal_centre varchar 0 0 1000 True
rrt_start date 10 0 3 True