nhsd_mhs102servicetypereferredto_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] |
PCAREPROFTEAMLOCALID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
PSERVICEREQUESTID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
SERVTEAMTYPEREFTOMH |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
CAMHSTIER |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
REFERCLOSUREDATE |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
REFERREJECTIONDATE |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
REFERREJECTIONTIME |
NULL |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
REFERCLOSREASON |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
REFERREJECTREASON |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
RECORDNUMBER |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
MHS102UNIQID |
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] |
PUNIQSERVREQID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
AGESERVREFERCLOSURE |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
AGESERVREFERREJECTION |
INTEGER |
[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] |
REFERCLOSURETIME |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |