MHS_MHCareCoord_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] |
STARTDATEASSCARECOORD | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
PCAREPROFLOCALID | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
ENDDATEASSCARECOORD | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
CAREPROFSERVORTEAMTYPEASSOC | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
RECORDNUMBER | BIGINT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
MHS006UNIQID | BIGINT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
UNIQMHSDSPERSID | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
INACTIVE_TIMESTAMP | 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] |
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] |