Skip to content
Robert Nagy edited this page Jul 15, 2022 · 1 revision
[1] Database Table Field Name [2] Field Data Type [3] Field Length or Format [4] Range of Values [5] Constraints [6] Representation of Missing Data [7] Field Description [8] Sensitive Field [9] Identifiable Field [10] Field_Group [11] Notes
STUDY_ID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
AGE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CAUSATIVE_AGENT_CODING_CODE BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
LSOA TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MYDOB BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
NHS_NUMBER_STATUS_INDICATOR_CODE BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ONSET TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PERSON_GENDER_CODE BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
POSTCODE_DISTRICT TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
REACTION_CODING_CODE BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
REACTION_SEVERITY TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDED_DATE BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SENDING_ORG_CODE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
TRACE_VERIFIED TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
TYPE_OF_REACTION TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
VERIFICATION_STATUS TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EPCC_DATE_RECEIVED DATE [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EPCC_DATE_INSERTED TIMESTAMP [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]

Contents

ISARIC
PHOSP
GPES
APC
IAPT
AE
NIMS
ECDS
MHS
NDA
SGSS
  • Additional Fields
  • Table Definitions
GDPPR
  • Additional Fields
  • Table Definitions
VACCINATION
COG_UK
COG_UK_VOC
CHESS
SGTF
CIVIL_REG_DEATHS
PILLAR2
Test_IGNORE
Clone this wiki locally