nhsd_mhs002gp_table - isaric4c/wiki GitHub Wiki

[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]
IC_USE_SUBMISSION_FLAG TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
GMPCODEREG TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
STARTDATEGMPREGISTRATION TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ENDDATEGMPREGISTRATION TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ORGIDGPPRAC TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDNUMBER INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MHS002UNIQID 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]
ORGIDCCGGPPRACTICE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
GPDISTANCEHOME INTEGER [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]