Skip to content

nhsd_mhs011socpercircumstances_table

Robert Nagy edited this page Nov 8, 2022 · 3 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
MONTH_ID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
FILE_TYPE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SOCPERCIRCUMSTANCE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SOCPERCIRCUMSTANCERECDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDNUMBER INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MHS011UNIQID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ORGIDPROV TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
UNIQMHSDSPERSID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
BSPUNIQID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IC_UNIQUE_RECORD TEXT [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