nhsd_mhs201carecontact_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]
PCARECONTACTID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PSERVICEREQUESTID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PCAREPROFTEAMLOCALID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CARECONTDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CARECONTTIME TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ORGIDCOMM TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ADMINCATCODE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SPECIALISEDMHSERVICECODE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CLINCONTDUROFCARECONT INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CONSTYPE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CARECONTSUBJ TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CONSMEDIUMUSED TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ACTLOCTYPECODE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SITEIDOFTREAT TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
GROUPTHERAPYIND TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ATTENDORDNACODE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EARLIESTREASONOFFERDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
EARLIESTCLINAPPDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CARECONTCANCELDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CARECONTCANCELREAS INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
REPAPPTOFFERDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
REPAPPTBOOKDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
RECORDNUMBER INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
MHS201UNIQID 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]
PUNIQCARECONTID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
LOCAREATEAMORGCODECOMM NULL [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
NHSENGREGORGCODECOMM NULL [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
AGECARECONTDATE INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
CONTLOCDISTANCEHOME INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
TIMEREFERANDCARECONTACT 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]