nhsd_nda_core_table
Robert Nagy edited this page Nov 8, 2022
·
6 revisions
[1] Database Table Field Name | [2] Field Data Type | [3] Variable Availability Date Range | [4] Field Length or Format | [5] Range of Values | [6] Completeness | [7] Constraints | [8] Representation of Missing Data | [9] Field Description | [10] Field Group | [11] Notes |
---|---|---|---|---|---|---|---|---|---|---|
STUDY_ID | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
AUDIT_YEAR | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
ALBUMIN | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
ALBUMIN_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
ALL_3_TREATMENT_TARGETS | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
ALL_8_CARE_PROCESSES | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
BLOOD_PRESSURE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
BMI | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
BMI_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
BP_<=140_80 | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CHOLESTEROL | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CHOLESTEROL_< 4 MMOL/L | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CHOLESTEROL_< 5 MMOL/L | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CHOLESTEROL_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ALBUMIN_STAGE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ALBUMIN_TEST | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ALBUMIN_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_BMI_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_CHOLESTEROL_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_CREATININE_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_DIASTOLIC_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_DIASTOLIC_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_ATTEND_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_ATTEND_VALUE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_OFFER_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_OFFER_VALUE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_REVIEW_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_ED_REVIEW_VALUE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_FOOT_EXAM_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_IHD_VALUE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_MMOL_HBA1C_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PERCENTAGE_HBA1C_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_ACHIEVED_GLUCOSE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_ACHIEVED_HYPO | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_FLAG | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_REASON_GLUCOSE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_REASON_HYPO | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_REASON_OTHER | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_PUMP_REASON_UNKNOWN | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_SMI_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_SMI_FLAG | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_SMOKING_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_SYSTOLIC_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_SYSTOLIC_VALUE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CLEAN_YEAR_PUMP_STARTED | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CREATININE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CREATININE_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
DERIVED_CLEAN_DIABETES_TYPE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
DERIVED_CLEAN_DIAGNOSIS_YEAR | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
DIABETES_DURATION | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
FOOT_EXAM | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
HBA1C | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
HBA1C_<=6.5% OR 48MMOL | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
HBA1C_<=10% OR 86MMOL | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
HBA1C_<=7.5% OR 58MMOL | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
HBA1C_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
IHD_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
IMD_QUINTILE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
SMOKING | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
SMOKING_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
Contents
ISARIC
-
Additional Fields
-
Case Report Form Definitions
- Participant Identification Number (PIN)
- Tier
- Inclusion Criteria
- Demographics
- Onset and Admission
- Admission Signs and Symptoms
- Comorbidities
- Preadmission Treatment
- Preadmission Medication
- Reinfection Form
- Daily Form
- Infectious Respiratory Disease Pathogen Diagnosis
- Infectious Respiratory Disease Pathogen Testing
- Treatment
- Complications
- Study Participation
- Outcome
- Final Outcome
- Core Additional Information
- Withdrawal Form
- Consent Ctu Dms
- Confirmed Negative PCR
- Follow up Consent
- Follow up Self Assessment
PHOSP
-
Additional Fields
-
Case Report Form Definitions
- Forms
- Timepoints
- PHOSP ID
- eConsent Tier 1
- eConsent Tier 2
- Informed Consent Form
- Split Tier Consent
- Eligibility Checklist
- CRF1A Part 1
- CRF1A Part 2
- CRF1A Part 3
- CRF1B
- CRF2A
- CRF2B
- CRF3A
- CRF3B
- CRF3C
- CRF4A
- CRF4B
- CRF Emergency Visit
- Adverse Event Log
- Withdrawals
- CRF Early Termination
- CRF Tier 2 Withdrawal
- Medications Log
- Activity Monitor Log
- Mental Health Assessment
- Nutrition
- Social History
- EQ-5D-5L
- GAD-7
- PHQ-9
- MRC Dyspnoea
- SARC-F
- GPPAQ
- Dyspnoea-12
- FACIT Fatigue
- PCL-5
- BPI
- NEADL
- MoCA
- Rockwood Clinical Frailty
- PSQI
- MEQ
- LCQ
- PFTs
- Walk Tests
- Tier 2 Core Test Checklist
- Tier 2 Research Samples
- Tier 2 Notification - Blood
- Tier 2 Notification - Oral Wash
- Tier 2 Notification - Sputum
- Tier 2 Notification - Urine
- QRISK3
- BIA
- DXA
- Muscle Strength
- SPPB
- Pre-PSQ
- PSQ
- Lab Log - Routine Blood
- Lab Log - Urine
- Lab Log - Immuno
- Lab Log - Additional Tests
- PCR Swab Tests
GPES
-
Additional Fields
-
Table Definitions
APC
-
Additional Fields
-
Table Definitions
IAPT
-
Additional Fields
AE
-
Additional Fields
-
Table Definitions
NIMS
-
Additional Fields
-
Table Definitions
ECDS
-
Additional Fields
-
Table Definitions
MHS
-
Additional Fields
-
Table Definitions
- MHS Master Patient Index table
- MHS GP data table
- NHS Accommodation status table
- MHS Employment status table
- MHS Patient Ind table
- MHS MH Care Coord table
- MHS Disability type table
- MHS Care plan type table
- MHS Care plan arrangement table
- MHS Assistive technology to support disability type table
- MHS Social and Personal Circumstances table
- MHS Overseas Visitor Charging Category table
- MHS Service or Team Referral table
- MHS Service or Team Type Referred To table
- MHS Other Reason for Referral table
- MHS Referral to Treatment table
- MHS Onward Referral table
- MHS Discharge Plan Agreement table
- MHS Care Contact table
- MHS Care Activity table
- MHS Other in Attendance table
- MHS Indirect Activity table
- MHS Medical History (Previous Diagnosis) table
- MHS Provisional Diagnosis table
- MHS Primary Diagnosis table
- MHS Secondary Diagnosis table
- MHS Coded Scored Assessment (Referral) table
- MHS Coded Scored Assessment (Care Activity) table
- MHS Care Programme Approach (CPA) Care Episode table
- MHS Care Programme Approach (CPA) Review table
NDA
-
Additional Fields
SGSS
-
Additional Fields
-
Table Definitions
GDPPR
-
Additional Fields
-
Table Definitions
VACCINATION
-
Additional Fields
-
Table Definitions
COG_UK
-
Additional Fields
-
Table Definitions
COG_UK_VOC
-
Additional Fields
-
Table Definitions
CHESS
-
Additional Fields
-
Table Definitions
SGTF
-
Additional Fields
-
Table Definitions
CIVIL_REG_DEATHS
-
Additional Fields
-
Table Definitions