Test_main_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 |
STUDY_ID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
EPCC_DATE_RECEIVED |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQMONTHID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
FILE_TYPE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
IC_USE_SUBMISSION_FLAG |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTACTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
SERVICEREQUESTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CAREPROFTEAMLOCALID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTTIME |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
ORGIDCOMM |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
ADMINCATCODE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
SPECIALISEDMHSERVICECODE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CLINCONTDUROFCARECONT |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CONSTYPE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTSUBJ |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CONSMEDIUMUSED |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
ACTLOCTYPECODE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
SITEIDOFTREAT |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
GROUPTHERAPYIND |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
ATTENDORDNACODE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
EARLIESTREASONOFFERDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
EARLIESTCLINAPPDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTCANCELDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CARECONTCANCELREAS |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
REPAPPTOFFERDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
REPAPPTBOOKDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
RECORDNUMBER |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
MHS201UNIQID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
ORGIDPROV |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQMHSDSPERSID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQSUBMISSIONID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQSERVREQID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQCARECONTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
LOCAREATEAMORGCODECOMM |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
NHSENGREGORGCODECOMM |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
AGECARECONTDATE |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
CONTLOCDISTANCEHOME |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
TIMEREFERANDCARECONTACT |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
UNIQCAREPROFTEAMID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
MONTH_IDENTIFIER |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
MONTH_NAME |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
FINANCIALYEAR_IDENTIFIER |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PLACEOFSAFETYIND |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PCARECONTACTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PCAREPROFTEAMLOCALID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PSERVICEREQUESTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PUNIQCARECONTID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PUNIQSERVREQID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
PUNIQCAREPROFTEAMID |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |
Replace |