nhsd_iapt_assessments_pseudo_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
STUDY_ID	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
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	INTEGER	[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	INTEGER	[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]