MHS_PatInd_table - isaric4c/wiki GitHub Wiki

[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
FILE_TYPE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IC_USE_SUBMISSION_FLAG TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CONSTSUPERREQDUETODIS TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
YOUNGCARER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
LACSTATUS TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CPP TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PROPSYCHDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EMERPSYCHDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MANPSYCHDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PSYCHPRESCDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PSYCHTREATDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDNUMBER BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MHS005UNIQID BIGINT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
UNIQMHSDSPERSID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MONTH_IDENTIFIER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MONTH_NAME TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
FINANCIALYEAR_IDENTIFIER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EXBAFINDICATOR TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
OFFENCEHISTORY 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]