IAPT_assessments_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
ASSESSMENT_ID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
REFERRAL_ID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IAPT_RECORD_NUMBER INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IAPT_PERSON_ID TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ORGCODEPROVIDER TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ASSESSPEQDATE TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ASSESSPEQTIME TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ASSESSMENT1 TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ASSESSMENT2 TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
ASSESSMENT3 TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
SATISFACTION REAL [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IC_PATHWAY_ID INTEGER [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
IC_AFTER_LAST_ASSESS_FLAG TEXT [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace] [Replace]
PSERVICEID 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]