MHS_GP_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] |
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] |
RECORDNUMBER |
BIGINT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
MHS002UNIQID |
BIGINT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
UNIQMHSDSPERSID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
GPDISTANCEHOME |
REAL |
[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] |
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] |