Open sidebar
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
20 Dec 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 19 December 2023. It reflects the state of the database on this date.

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 CollationName
Patient_ID int 10 0 4 False NaN
Consultation_ID bigint 19 0 8 False NaN
CodedEvent_ID bigint 19 0 8 False NaN
ConsultationDate datetime 23 3 8 False NaN
CreationDate datetime 23 3 8 False NaN
CTV3Code varchar 0 0 50 False Latin1_General_BIN
ConceptId varchar 0 0 50 True Latin1_General_BIN
CodeSystemId int 10 0 4 False NaN
NumericValue real 24 0 4 False NaN
NumericCode int 10 0 4 False NaN

ICNARC

ICNARC

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

ISARIC

ISARIC_New

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

NHSD_HIGH_COST_DRUGS

HighCostDrugs

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

NHSE_APCS

APCS

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

APCS_Cost

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

APCS_Der

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

NHSE_CPNS

CPNS

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

NHSE_EC

EC

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

EC_AlcoholDrugInvolvement

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

EC_Comorbidities

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

EC_Cost

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

EC_Diagnosis

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

EC_Investigation

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

EC_PatientMentalHealth

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

EC_Treatment

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

NHSE_ECDS

ECDS

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

ECDS_EC_Diagnoses

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

NHSE_HEALTH_CARE_WORKER

HealthCareWorker

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

NHSE_MPI

MPI

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

UPRN

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

NHSE_OPA

OPA

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

OPA_Cost

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

OPA_Diag

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

OPA_Proc

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

NHSE_SGSS

SGSS_AllTests_Negative

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

SGSS_AllTests_Positive

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

SGSS_Negative

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

SGSS_Positive

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

NHSE_Therapeutics

Therapeutics

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

NHSE_WL

WL_ClockStops

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

WL_Diagnostics

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

WL_OpenPathways

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

ONS_DEATHS

ONS_Deaths

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

OS_BUILD

BuildInfo

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

CodeCountIndicator

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

LatestBuildTime

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

OpenSAFELYSchemaInformation

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

OS_DERIVED

Household

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

HouseholdMember

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

MSOA_PopulationEstimates_2019

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

PotentialCareHomeAddress

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

Other

APCS_Cost_JRC20231009_LastFilesToContainAllHistoricalCostData

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

APCS_Der_JRC20231009_LastFilesToContainAllHistoricalCostData

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

APCS_JRC20231009_LastFilesToContainAllHistoricalCostData

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

BuildProgress

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Event varchar 0 0 1350 False Latin1_General_CI_AS
BuildStart datetime 23 3 8 False NaN
EventStart datetime 23 3 8 False NaN
EventEnd datetime 23 3 8 False NaN
Duration int 10 0 4 False NaN

ClusterRandomisedTrial

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Organisation_ID int 10 0 4 True NaN
TrialNumber int 10 0 4 True NaN
TrialArm varchar 0 0 100 True Latin1_General_CI_AS

ClusterRandomisedTrialDetail

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Organisation_ID int 10 0 4 True NaN
TrialNumber int 10 0 4 True NaN
Property varchar 0 0 1000 True Latin1_General_CI_AS
PropertyValue varchar 0 0 1000 True Latin1_General_CI_AS

ClusterRandomisedTrialReference

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
TrialNumber int 10 0 4 True NaN
TrialName varchar 0 0 1000 True Latin1_General_CI_AS
TrialDescription varchar 0 0 1000 True Latin1_General_CI_AS
CPMSNumber int 10 0 4 True NaN

CodedEvent_SNOMED

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

DecisionSupportValue

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Patient_ID int 10 0 4 True NaN
AlgorithmType int 10 0 4 True NaN
CalculationDateTime datetime 23 3 8 True NaN
NumericValue real 24 0 4 True NaN

DecisionSupportValueReference

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
AlgorithmType int 10 0 4 True NaN
AlgorithmDescription varchar 0 0 4000 True Latin1_General_CI_AS
AlgorithmVersion varchar 0 0 100 True Latin1_General_CI_AS
AlgorithmSourceLink varchar 0 0 4000 True Latin1_General_CI_AS

EC_AlcoholDrugInvolvement_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_Comorbidities_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_Cost_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_Diagnosis_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_Investigation_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_PatientMentalHealth_JRC20231023_LastFilesToContainAllHistoricalCostData

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

EC_Treatment_JRC20231023_LastFilesToContainAllHistoricalCostData

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

ISARIC_Patient_Data

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Patient_ID bigint 19 0 8 False NaN
no_medication varchar 0 0 200 True Latin1_General_CI_AS
cmtrt varchar 0 0 200 True Latin1_General_CI_AS
cmdose varchar 0 0 200 True Latin1_General_CI_AS
cmdose_unit varchar 0 0 200 True Latin1_General_CI_AS
cmdose_unitoth varchar 0 0 200 True Latin1_General_CI_AS
cmdosfrq varchar 0 0 200 True Latin1_General_CI_AS
cmdosfrqoth varchar 0 0 200 True Latin1_General_CI_AS
cmroute varchar 0 0 200 True Latin1_General_CI_AS
cmrouteoth varchar 0 0 200 True Latin1_General_CI_AS
daily_dsstdat varchar 0 0 200 True Latin1_General_CI_AS
daily_hoterm varchar 0 0 200 True Latin1_General_CI_AS
daily_noninvasive_prtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_invasive_prtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_nasaloxy_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_ecmo_prtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_rrt_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_inotrope_cmyn varchar 0 0 200 True Latin1_General_CI_AS
daily_dopless5_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_dop5to15_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_dopgr15_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_neuro_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_nitritc_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_prone_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
daily_trach_prperf varchar 0 0 200 True Latin1_General_CI_AS
daily_prperf varchar 0 0 200 True Latin1_General_CI_AS
daily_other_prtrt varchar 0 0 200 True Latin1_General_CI_AS
remdesivir varchar 0 0 200 True Latin1_General_CI_AS
remdesivir_day varchar 0 0 200 True Latin1_General_CI_AS
remdesivir_last_dose varchar 0 0 200 True Latin1_General_CI_AS
daily_lbperf varchar 0 0 200 True Latin1_General_CI_AS
daily_lbdat varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_hbop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_wbcop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lympop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_neutroop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_pltop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_aptt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_apttop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_aptt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_pt_inr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ptop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_pt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_inrop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_inr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_esr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_esrop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_esr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ferrop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_alt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_altop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_alt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_bilop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_ast_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_astop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ast_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_glucoseop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_bunop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lactateop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_ldh_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ldhop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ldh_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_cpk_lby varchar 0 0 200 True Latin1_General_CI_AS
daily_cpkop_lbyn_2 varchar 0 0 200 True Latin1_General_CI_AS
daily_cpk_lbyn_2 varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_creatop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_sodiumop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_potassiumop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_procal_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_procalop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_procal_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_crpop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lborresu varchar 0 0 200 True Latin1_General_CI_AS
mbperf varchar 0 0 200 True Latin1_General_CI_AS
cov19sars_mbyn_v2 varchar 0 0 200 True Latin1_General_CI_AS
influ_mbyn varchar 0 0 200 True Latin1_General_CI_AS
influ_mbyn_v2 varchar 0 0 200 True Latin1_General_CI_AS
influ_mbcat varchar 0 0 200 True Latin1_General_CI_AS
influothera_mborres varchar 0 0 200 True Latin1_General_CI_AS
influother_mborres varchar 0 0 200 True Latin1_General_CI_AS
corna_mbcat varchar 0 0 200 True Latin1_General_CI_AS
corna_mbcaty varchar 0 0 200 True Latin1_General_CI_AS
coronaother_mborres varchar 0 0 200 True Latin1_General_CI_AS
rsv_mbcat varchar 0 0 200 True Latin1_General_CI_AS
rsv_mbcat_v2 varchar 0 0 200 True Latin1_General_CI_AS
adeno_mbcat varchar 0 0 200 True Latin1_General_CI_AS
adeno_mbcat_v2 varchar 0 0 200 True Latin1_General_CI_AS
bact_mborres varchar 0 0 200 True Latin1_General_CI_AS
bacteria_mborres varchar 0 0 200 True Latin1_General_CI_AS
clinicalpneu_mborres varchar 0 0 200 True Latin1_General_CI_AS
infectuk_mborres varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___0 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___1 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___2 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___3 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___4 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___5 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___6 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diag___10 varchar 0 0 200 True Latin1_General_CI_AS
pcr_path_diago varchar 0 0 2000 True Latin1_General_CI_AS
other_mbyn varchar 0 0 200 True Latin1_General_CI_AS
other_mborres varchar 0 0 200 True Latin1_General_CI_AS
infectious_respiratory_disease_pathogen_diagnosis_complete varchar 0 0 200 True Latin1_General_CI_AS
daily_mbperf varchar 0 0 200 True Latin1_General_CI_AS
mbdat varchar 0 0 200 True Latin1_General_CI_AS
mbspec varchar 0 0 200 True Latin1_General_CI_AS
other_mbspec varchar 0 0 200 True Latin1_General_CI_AS
mbmethod varchar 0 0 200 True Latin1_General_CI_AS
other_mbmethod varchar 0 0 200 True Latin1_General_CI_AS
mborres varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd varchar 0 0 2000 True Latin1_General_CI_AS
mbspec_v2 varchar 0 0 200 True Latin1_General_CI_AS
mborres_v2 varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_nsth varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_nstho varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_bc varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_bco varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_sp varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_spo varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_drs varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_drso varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_ur varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_uro varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_csf varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_csfo varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_fst varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_fsto varchar 0 0 200 True Latin1_General_CI_AS
mbdat_v2 varchar 0 0 200 True Latin1_General_CI_AS
mbspec_v3 varchar 0 0 200 True Latin1_General_CI_AS
mbtestcd_v3 varchar 0 0 200 True Latin1_General_CI_AS
mbdat_v3 varchar 0 0 200 True Latin1_General_CI_AS
interleukin_cmyn varchar 0 0 200 True Latin1_General_CI_AS
interleukin_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
conv_plasma_cmyn varchar 0 0 200 True Latin1_General_CI_AS
icu_hoterm varchar 0 0 200 True Latin1_General_CI_AS
icu_no varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdat varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdatnk varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendat varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendatnk varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdat2 varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdat2_nk varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendat2 varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendat2_nk varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdat3 varchar 0 0 200 True Latin1_General_CI_AS
icu_hostdat3_nk varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendat3 varchar 0 0 200 True Latin1_General_CI_AS
icu_hoendat3_nk varchar 0 0 200 True Latin1_General_CI_AS
icu_hostillin varchar 0 0 200 True Latin1_General_CI_AS
hodur varchar 0 0 200 True Latin1_General_CI_AS
oxygen_cmoccur varchar 0 0 200 True Latin1_General_CI_AS
oxygenhf_cmoccur varchar 0 0 200 True Latin1_General_CI_AS
noninvasive_proccur varchar 0 0 200 True Latin1_General_CI_AS
invasive_proccur varchar 0 0 200 True Latin1_General_CI_AS
pronevent_prtrt varchar 0 0 200 True Latin1_General_CI_AS
inhalednit_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
tracheo_prtrt varchar 0 0 200 True Latin1_General_CI_AS
extracorp_prtrt varchar 0 0 200 True Latin1_General_CI_AS
rrt_prtrt varchar 0 0 200 True Latin1_General_CI_AS
inotrop_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
invasive_prdur varchar 0 0 200 True Latin1_General_CI_AS
invasive_still_on varchar 0 0 200 True Latin1_General_CI_AS
excorp_prdur varchar 0 0 200 True Latin1_General_CI_AS
excorp_still_on varchar 0 0 200 True Latin1_General_CI_AS
rrt_totdur varchar 0 0 200 True Latin1_General_CI_AS
rrt_still_on varchar 0 0 200 True Latin1_General_CI_AS
inotrope_cmdur varchar 0 0 200 True Latin1_General_CI_AS
inotrope_still_on varchar 0 0 200 True Latin1_General_CI_AS
other_cmyn varchar 0 0 200 True Latin1_General_CI_AS
other_cm varchar 0 0 200 True Latin1_General_CI_AS
vrialpneu_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
bactpneu_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
ards_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
cryptogenic_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pneumothorax_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pleuraleff_ceterm varchar 0 0 200 True Latin1_General_CI_AS
bronchio_ceterm varchar 0 0 200 True Latin1_General_CI_AS
meningitis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
seizure_ceterm varchar 0 0 200 True Latin1_General_CI_AS
stroke_ceterm varchar 0 0 200 True Latin1_General_CI_AS
neuro_comp varchar 0 0 200 True Latin1_General_CI_AS
heartfailure_ceterm varchar 0 0 200 True Latin1_General_CI_AS
endocarditis_aeterm varchar 0 0 200 True Latin1_General_CI_AS
myocarditis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
cardiomyopathy_ceterm varchar 0 0 200 True Latin1_General_CI_AS
arrhythmia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
ischaemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
cardiacarrest_ceterm varchar 0 0 200 True Latin1_General_CI_AS
bacteraemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
coagulo_ceterm varchar 0 0 200 True Latin1_General_CI_AS
dvt_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pulmthromb_ceterm varchar 0 0 200 True Latin1_General_CI_AS
aneamia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
rhabdomyolsis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
renalinjury_ceterm varchar 0 0 200 True Latin1_General_CI_AS
gastro_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pancreat_ceterm varchar 0 0 200 True Latin1_General_CI_AS
liverdysfunction_ceterm varchar 0 0 200 True Latin1_General_CI_AS
hyperglycemia_aeterm varchar 0 0 200 True Latin1_General_CI_AS
hypoglycemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
other_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
dsterm varchar 0 0 200 True Latin1_General_CI_AS
dshosp varchar 0 0 4000 True Latin1_General_CI_AS
dsstdtcyn varchar 0 0 200 True Latin1_General_CI_AS
dsstdtc varchar 0 0 200 True Latin1_General_CI_AS
suppds_qval varchar 0 0 200 True Latin1_General_CI_AS
oxygen_proccur varchar 0 0 200 True Latin1_General_CI_AS
renal_proccur varchar 0 0 200 True Latin1_General_CI_AS
other_cmoccur varchar 0 0 200 True Latin1_General_CI_AS
other_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
outcome_complete varchar 0 0 200 True Latin1_General_CI_AS
dsterm_v2 varchar 0 0 200 True Latin1_General_CI_AS
dsstdtc_v2 varchar 0 0 200 True Latin1_General_CI_AS
dsstdtc_v2_nk varchar 0 0 200 True Latin1_General_CI_AS
suppds_qval_v2 varchar 0 0 200 True Latin1_General_CI_AS
oxygen_proccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
final_outcome_complete varchar 0 0 200 True Latin1_General_CI_AS

ISARIC_Patient_Data_TopLine

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Patient_ID bigint 19 0 8 False NaN
arm_participant varchar 0 0 200 True Latin1_General_CI_AS
dsstdat varchar 0 0 200 True Latin1_General_CI_AS
corona_ieorres varchar 0 0 200 True Latin1_General_CI_AS
coriona_ieorres2 varchar 0 0 200 True Latin1_General_CI_AS
coriona_ieorres3 varchar 0 0 200 True Latin1_General_CI_AS
fever varchar 0 0 200 True Latin1_General_CI_AS
cough varchar 0 0 200 True Latin1_General_CI_AS
dyspnoe varchar 0 0 200 True Latin1_General_CI_AS
ari varchar 0 0 200 True Latin1_General_CI_AS
inflammatory_mss varchar 0 0 200 True Latin1_General_CI_AS
sex varchar 0 0 200 True Latin1_General_CI_AS
agedatyn varchar 0 0 200 True Latin1_General_CI_AS
calc_age varchar 0 0 200 True Latin1_General_CI_AS
age_estimateyears varchar 0 0 200 True Latin1_General_CI_AS
age_estimateyearsu varchar 0 0 200 True Latin1_General_CI_AS
ethnic___1 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___2 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___3 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___4 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___5 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___6 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___7 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___8 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___9 varchar 0 0 200 True Latin1_General_CI_AS
ethnic___10 varchar 0 0 200 True Latin1_General_CI_AS
other_ethnic varchar 0 0 200 True Latin1_General_CI_AS
pregyn_rptestcd varchar 0 0 200 True Latin1_General_CI_AS
egestage_rptestcd varchar 0 0 200 True Latin1_General_CI_AS
postpart_rptestcd varchar 0 0 200 True Latin1_General_CI_AS
pregout_rptestcd varchar 0 0 200 True Latin1_General_CI_AS
dlvrdtc_rptestcd varchar 0 0 200 True Latin1_General_CI_AS
aplb_lbperf varchar 0 0 200 True Latin1_General_CI_AS
aplb_lborres varchar 0 0 200 True Latin1_General_CI_AS
apdm_age varchar 0 0 200 True Latin1_General_CI_AS
apvs_weight varchar 0 0 200 True Latin1_General_CI_AS
apvs_weightu varchar 0 0 200 True Latin1_General_CI_AS
apvs_weightnk varchar 0 0 200 True Latin1_General_CI_AS
apsc_gestout varchar 0 0 200 True Latin1_General_CI_AS
estgest varchar 0 0 200 True Latin1_General_CI_AS
apsc_brfedind varchar 0 0 200 True Latin1_General_CI_AS
apsc_brfedindy varchar 0 0 200 True Latin1_General_CI_AS
apsc_brdisdat varchar 0 0 200 True Latin1_General_CI_AS
apsc_dvageind varchar 0 0 200 True Latin1_General_CI_AS
apsc_vcageind varchar 0 0 200 True Latin1_General_CI_AS
covid19_vaccine varchar 0 0 200 True Latin1_General_CI_AS
vaccine_covid_trial varchar 0 0 200 True Latin1_General_CI_AS
influenza_2021_vaccine varchar 0 0 200 True Latin1_General_CI_AS
influenza_2021_vaccined varchar 0 0 200 True Latin1_General_CI_AS
cestdat varchar 0 0 200 True Latin1_General_CI_AS
hostdat varchar 0 0 200 True Latin1_General_CI_AS
hosttim varchar 0 0 200 True Latin1_General_CI_AS
readm_cov19 varchar 0 0 200 True Latin1_General_CI_AS
readminreas varchar 0 0 200 True Latin1_General_CI_AS
susp_reinf varchar 0 0 200 True Latin1_General_CI_AS
surgefacil varchar 0 0 200 True Latin1_General_CI_AS
hooccur varchar 0 0 200 True Latin1_General_CI_AS
hostdat_transfer varchar 0 0 200 True Latin1_General_CI_AS
hostdat_transfernk varchar 0 0 200 True Latin1_General_CI_AS
temp_vsorres varchar 0 0 200 True Latin1_General_CI_AS
hr_vsorres varchar 0 0 200 True Latin1_General_CI_AS
rr_vsorres varchar 0 0 200 True Latin1_General_CI_AS
sysbp_vsorres varchar 0 0 200 True Latin1_General_CI_AS
admission_diabp_vsorres varchar 0 0 200 True Latin1_General_CI_AS
dehydration_vsorres varchar 0 0 200 True Latin1_General_CI_AS
stercap_vsorres varchar 0 0 200 True Latin1_General_CI_AS
oxy_vsorres varchar 0 0 200 True Latin1_General_CI_AS
fever_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
cough_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
coughsput_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
coughhb_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
sorethroat_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
runnynose_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
earpain_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
wheeze_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
chestpain_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
myalgia_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
jointpain_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
fatigue_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
shortbreath_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
ageusia_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
lowerchest_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
headache_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
confusion_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
seizures_cecoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
abdopain_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
vomit_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
diarrhoea_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
conjunct_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
rash_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
skinulcers_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
lymp_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
bleed_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
bleed_ceterm_v2 varchar 0 0 200 True Latin1_General_CI_AS
anosmia_ceoccur_v2 varchar 0 0 200 True Latin1_General_CI_AS
no_symptoms varchar 0 0 200 True Latin1_General_CI_AS
chrincard varchar 0 0 200 True Latin1_General_CI_AS
hypertension_mhyn varchar 0 0 200 True Latin1_General_CI_AS
chronicpul_mhyn varchar 0 0 200 True Latin1_General_CI_AS
asthma_mhyn varchar 0 0 200 True Latin1_General_CI_AS
renal_mhyn varchar 0 0 200 True Latin1_General_CI_AS
modliv varchar 0 0 200 True Latin1_General_CI_AS
mildliver varchar 0 0 200 True Latin1_General_CI_AS
chronicneu_mhyn varchar 0 0 200 True Latin1_General_CI_AS
malignantneo_mhyn varchar 0 0 200 True Latin1_General_CI_AS
chronichaemo_mhyn varchar 0 0 200 True Latin1_General_CI_AS
aidshiv_mhyn varchar 0 0 200 True Latin1_General_CI_AS
obesity_mhyn varchar 0 0 200 True Latin1_General_CI_AS
diabetes_type_mhyn varchar 0 0 200 True Latin1_General_CI_AS
diabetescom_mhyn varchar 0 0 200 True Latin1_General_CI_AS
diabetes_mhyn varchar 0 0 200 True Latin1_General_CI_AS
rheumatologic_mhyn varchar 0 0 200 True Latin1_General_CI_AS
dementia_mhyn varchar 0 0 200 True Latin1_General_CI_AS
malnutrition_mhyn varchar 0 0 200 True Latin1_General_CI_AS
smoking_mhyn varchar 0 0 200 True Latin1_General_CI_AS
other_mhyn varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_transplant varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_cancers varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_copd varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_scid varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_immuno varchar 0 0 200 True Latin1_General_CI_AS
vulnerable_preg varchar 0 0 200 True Latin1_General_CI_AS
immno_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
infect_cmtrt varchar 0 0 200 True Latin1_General_CI_AS
chronic_nsaid_cmoccur varchar 0 0 200 True Latin1_General_CI_AS
daily_dsstdat varchar 0 0 200 True Latin1_General_CI_AS
daily_lbdat varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_hbop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_hb_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_wbcop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_wbc_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lympop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_lymp_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_neutroop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_neutro_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_haematocrit_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_pltop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_plt_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_aptt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_apttop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_aptt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_pt_inr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ptop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_pt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_inr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_esr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_esr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ferrop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_ferr_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_alt_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_altop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_alt_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_bilop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bil_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_ast_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ast_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_glucoseop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_glucose_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_bunop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_bun_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lactateop_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_lactate_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_ldh_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_ldh_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_cpk_lby varchar 0 0 200 True Latin1_General_CI_AS
daily_cpkop_lbyn_2 varchar 0 0 200 True Latin1_General_CI_AS
daily_cpk_lbyn_2 varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_creatop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_creat_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_sodiumop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_sodium_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_potassiumop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_potassium_lborresu varchar 0 0 200 True Latin1_General_CI_AS
daily_procal_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_procalop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_procal_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lbyn varchar 0 0 200 True Latin1_General_CI_AS
daily_crpop_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lborres varchar 0 0 200 True Latin1_General_CI_AS
daily_crp_lborresu varchar 0 0 200 True Latin1_General_CI_AS
xray_prperf varchar 0 0 200 True Latin1_General_CI_AS
infiltrates_faorres varchar 0 0 200 True Latin1_General_CI_AS
country varchar 0 0 200 True Latin1_General_CI_AS
nhs_region varchar 0 0 200 True Latin1_General_CI_AS
onset2admission varchar 0 0 200 True Latin1_General_CI_AS
ethnicity varchar 0 0 200 True Latin1_General_CI_AS
any_trach varchar 0 0 200 True Latin1_General_CI_AS
ecmo varchar 0 0 200 True Latin1_General_CI_AS
dialysis varchar 0 0 200 True Latin1_General_CI_AS
nitric varchar 0 0 200 True Latin1_General_CI_AS
inotrope varchar 0 0 200 True Latin1_General_CI_AS
prone varchar 0 0 200 True Latin1_General_CI_AS
high_flow_o2 varchar 0 0 200 True Latin1_General_CI_AS
supp_o2 varchar 0 0 200 True Latin1_General_CI_AS
antiviral varchar 0 0 200 True Latin1_General_CI_AS
antibiotic varchar 0 0 200 True Latin1_General_CI_AS
cxr_done varchar 0 0 200 True Latin1_General_CI_AS
infiltrates_yn varchar 0 0 200 True Latin1_General_CI_AS
cxr_count varchar 0 0 200 True Latin1_General_CI_AS
max_crp varchar 0 0 200 True Latin1_General_CI_AS
max_ferritin varchar 0 0 200 True Latin1_General_CI_AS
max_pt varchar 0 0 200 True Latin1_General_CI_AS
max_inr varchar 0 0 200 True Latin1_General_CI_AS
min_systolic varchar 0 0 200 True Latin1_General_CI_AS
cardiac_comp varchar 0 0 200 True Latin1_General_CI_AS
pims_freetext varchar 0 0 200 True Latin1_General_CI_AS
ivig_freetext varchar 0 0 200 True Latin1_General_CI_AS
dsterm varchar 0 0 200 True Latin1_General_CI_AS
dsstdtc varchar 0 0 200 True Latin1_General_CI_AS
death varchar 0 0 200 True Latin1_General_CI_AS
symp_or_assess_date varchar 0 0 200 True Latin1_General_CI_AS
assess_or_admit_date varchar 0 0 200 True Latin1_General_CI_AS
assess_age varchar 0 0 200 True Latin1_General_CI_AS
assess_age_minus_age varchar 0 0 200 True Latin1_General_CI_AS
bmj_pt varchar 0 0 200 True Latin1_General_CI_AS
wave varchar 0 0 200 True Latin1_General_CI_AS
first_wave varchar 0 0 200 True Latin1_General_CI_AS
second_wave varchar 0 0 200 True Latin1_General_CI_AS
los varchar 0 0 200 True Latin1_General_CI_AS
los2 varchar 0 0 200 True Latin1_General_CI_AS
los_covid varchar 0 0 200 True Latin1_General_CI_AS
los_covid2 varchar 0 0 200 True Latin1_General_CI_AS
neonate varchar 0 0 200 True Latin1_General_CI_AS
infant varchar 0 0 200 True Latin1_General_CI_AS
age_factor_19_no_neonates varchar 0 0 200 True Latin1_General_CI_AS
age_factor_19_with_neonates varchar 0 0 200 True Latin1_General_CI_AS
admission2onset varchar 0 0 200 True Latin1_General_CI_AS
nosocomial14 varchar 0 0 200 True Latin1_General_CI_AS
nosocomial7 varchar 0 0 200 True Latin1_General_CI_AS
nosocomial5 varchar 0 0 200 True Latin1_General_CI_AS
nosocomial2 varchar 0 0 200 True Latin1_General_CI_AS
symptom_count varchar 0 0 200 True Latin1_General_CI_AS
symptom_missing_count varchar 0 0 200 True Latin1_General_CI_AS
asymp varchar 0 0 200 True Latin1_General_CI_AS
admission_month varchar 0 0 200 True Latin1_General_CI_AS
admission_week varchar 0 0 200 True Latin1_General_CI_AS
pews_rr varchar 0 0 200 True Latin1_General_CI_AS
pews_spo2 varchar 0 0 200 True Latin1_General_CI_AS
pews_o2_rx varchar 0 0 200 True Latin1_General_CI_AS
pews_hr varchar 0 0 200 True Latin1_General_CI_AS
pews_sbp varchar 0 0 200 True Latin1_General_CI_AS
pews_gcs varchar 0 0 200 True Latin1_General_CI_AS
pews_crt varchar 0 0 200 True Latin1_General_CI_AS
pews_temp varchar 0 0 200 True Latin1_General_CI_AS
pews_total varchar 0 0 200 True Latin1_General_CI_AS
fever_all varchar 0 0 200 True Latin1_General_CI_AS
who_fever varchar 0 0 200 True Latin1_General_CI_AS
who_conjunct_rash varchar 0 0 200 True Latin1_General_CI_AS
who_gi varchar 0 0 200 True Latin1_General_CI_AS
who_hypotension varchar 0 0 200 True Latin1_General_CI_AS
who_cardiac varchar 0 0 200 True Latin1_General_CI_AS
who_coag varchar 0 0 200 True Latin1_General_CI_AS
who_crp varchar 0 0 200 True Latin1_General_CI_AS
who_five_criteria varchar 0 0 200 True Latin1_General_CI_AS
who_criteria varchar 0 0 200 True Latin1_General_CI_AS
hyperinflam_WHO varchar 0 0 200 True Latin1_General_CI_AS
misc_ivig varchar 0 0 200 True Latin1_General_CI_AS
misc_considered_pims varchar 0 0 200 True Latin1_General_CI_AS
misc_cardiac varchar 0 0 200 True Latin1_General_CI_AS
misc_immunomod varchar 0 0 200 True Latin1_General_CI_AS
misc_iv_steroids varchar 0 0 200 True Latin1_General_CI_AS
misc_oral_steroids varchar 0 0 200 True Latin1_General_CI_AS
misc_pcr varchar 0 0 200 True Latin1_General_CI_AS
misc_serology varchar 0 0 200 True Latin1_General_CI_AS
resp_comorb varchar 0 0 200 True Latin1_General_CI_AS
asthma_comorb varchar 0 0 200 True Latin1_General_CI_AS
cardiac_comorb varchar 0 0 200 True Latin1_General_CI_AS
liver_gi_comorb varchar 0 0 200 True Latin1_General_CI_AS
haem_onc_comorb varchar 0 0 200 True Latin1_General_CI_AS
obesity_comorb varchar 0 0 200 True Latin1_General_CI_AS
malnutrition_comorb varchar 0 0 200 True Latin1_General_CI_AS
neuro_comorb varchar 0 0 200 True Latin1_General_CI_AS
neurodisab_comorb varchar 0 0 200 True Latin1_General_CI_AS
diabetes_comorb varchar 0 0 200 True Latin1_General_CI_AS
other_endo_comorb varchar 0 0 200 True Latin1_General_CI_AS
rheum_comorb varchar 0 0 200 True Latin1_General_CI_AS
renal_comorb varchar 0 0 200 True Latin1_General_CI_AS
genetic_comorb varchar 0 0 200 True Latin1_General_CI_AS
ld_asd_ad_comorb varchar 0 0 200 True Latin1_General_CI_AS
metabolic_comorb varchar 0 0 200 True Latin1_General_CI_AS
other_comorb varchar 0 0 200 True Latin1_General_CI_AS
preterm_comorb varchar 0 0 200 True Latin1_General_CI_AS
alt_reason_admit varchar 0 0 200 True Latin1_General_CI_AS
incidental_covid varchar 0 0 200 True Latin1_General_CI_AS
any_comorb varchar 0 0 200 True Latin1_General_CI_AS
imm_sup_all varchar 0 0 200 True Latin1_General_CI_AS
has_picu varchar 0 0 200 True Latin1_General_CI_AS
asymp_or_incident varchar 0 0 200 True Latin1_General_CI_AS
pews_over_2 varchar 0 0 200 True Latin1_General_CI_AS
misc_final_status varchar 0 0 200 True Latin1_General_CI_AS
all_antiviral varchar 0 0 200 True Latin1_General_CI_AS
all_cardiac_comp varchar 0 0 200 True Latin1_General_CI_AS
all_ecmo varchar 0 0 200 True Latin1_General_CI_AS
all_imm_mod varchar 0 0 200 True Latin1_General_CI_AS
all_inotropes varchar 0 0 200 True Latin1_General_CI_AS
all_invasive varchar 0 0 200 True Latin1_General_CI_AS
all_noninvasive varchar 0 0 200 True Latin1_General_CI_AS
all_ivig varchar 0 0 200 True Latin1_General_CI_AS
max_resp_support varchar 0 0 200 True Latin1_General_CI_AS
comorb_count varchar 0 0 200 True Latin1_General_CI_AS
country_pcds varchar 0 0 200 True Latin1_General_CI_AS
any_max_steroid varchar 0 0 200 True Latin1_General_CI_AS
vrialpneu_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
bactpneu_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
ards_ceoccur varchar 0 0 200 True Latin1_General_CI_AS
cryptogenic_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pneumothorax_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pleuraleff_ceterm varchar 0 0 200 True Latin1_General_CI_AS
bronchio_ceterm varchar 0 0 200 True Latin1_General_CI_AS
meningitis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
seizure_ceterm varchar 0 0 200 True Latin1_General_CI_AS
stroke_ceterm varchar 0 0 200 True Latin1_General_CI_AS
neuro_comp varchar 0 0 200 True Latin1_General_CI_AS
heartfailure_ceterm varchar 0 0 200 True Latin1_General_CI_AS
endocarditis_aeterm varchar 0 0 200 True Latin1_General_CI_AS
myocarditis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
cardiomyopathy_ceterm varchar 0 0 200 True Latin1_General_CI_AS
arrhythmia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
ischaemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
cardiacarrest_ceterm varchar 0 0 200 True Latin1_General_CI_AS
bacteraemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
coagulo_ceterm varchar 0 0 200 True Latin1_General_CI_AS
dvt_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pulmthromb_ceterm varchar 0 0 200 True Latin1_General_CI_AS
aneamia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
rhabdomyolsis_ceterm varchar 0 0 200 True Latin1_General_CI_AS
renalinjury_ceterm varchar 0 0 200 True Latin1_General_CI_AS
gastro_ceterm varchar 0 0 200 True Latin1_General_CI_AS
pancreat_ceterm varchar 0 0 200 True Latin1_General_CI_AS
liverdysfunction_ceterm varchar 0 0 200 True Latin1_General_CI_AS
hyperglycemia_aeterm varchar 0 0 200 True Latin1_General_CI_AS
hypoglycemia_ceterm varchar 0 0 200 True Latin1_General_CI_AS
other_ceoccur varchar 0 0 200 True Latin1_General_CI_AS

OPA_Cost_JRC20231009_LastFilesToContainAllHistoricalCostData

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

OPA_Diag_JRC20231009_LastFilesToContainAllHistoricalCostData

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

OPA_JRC20231009_LastFilesToContainAllHistoricalCostData

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

OPA_Proc_JRC20231009_LastFilesToContainAllHistoricalCostData

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

S1

Appointment

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

CTV3Dictionary

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

CTV3Hierarchy

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

CodedEvent

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

CodedEventRange

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

Consultation

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

DataDictionary

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

ICD10Dictionary

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

MedicationDictionary

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

MedicationIssue

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

MedicationRepeat

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

MedicationSensitivity

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

Organisation

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

Patient

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

PatientAddress

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

PatientsWithTypeOneDissent

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Patient_ID bigint 19 0 8 False NaN

QOFClusterReference

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

RegistrationHistory

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

Relationship

ColumnName ColumnType Precision Scale MaxLength IsNullable CollationName
Patient_ID int 10 0 4 False NaN
Patient_ID_Relationship_With int 10 0 4 False NaN
Type_of_Relationship varchar 0 0 255 False Latin1_General_CI_AS
EventDate date 10 0 3 True NaN
RelationshipEndDate date 10 0 3 True NaN

UnitDictionary

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

Vaccination

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

VaccinationReference

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

YCodeToSnomedMapping

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

UK_Renal_Register

UKRR

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