Skip to content

nhsd_mhs007mdisabilitytype_table

Robert Nagy edited this page Oct 27, 2022 · 1 revision
[1] Database Table Field Name [2] Field Data Type [3] Variable Availability Date Range [4] Field Length or Format [5] Range of Values [6] Constraints [7] Representation of Missing Data [8] Field Description [9] Field_Group [10] Notes
FILE_TYPE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IC_USE_SUBMISSION_FLAG TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
DISABCODE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
DISABIMPACPERCEP TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDNUMBER BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MHS007UNIQID BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
UNIQMHSDSPERSID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MONTH_IDENTIFIER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MONTH_NAME TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
FINANCIALYEAR_IDENTIFIER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EPCC_DATE_RECEIVED DATE [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EPCC_DATE_INSERTED TIMESTAMP [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