nhsd_iapt_appointment_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] |
| REFERRAL_ID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| APPOINTMENT_ID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_PATHWAY_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] |
| APPOINTMENT | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| APPOINTMENTTIME | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PRIMARYROLE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| ATTENDANCE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| CONTACTDURATION | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| APPTYPE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| CONSMEDIUM | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE1 | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE2 | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE3 | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE4 | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| EMPSTATUS | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| EMPSUPPORTIND | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| EMPSUPPORTREFERRAL | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PSYCHMED | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SSPIND | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PHQ9_SCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| GAD7SCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASWSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASHMSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASSLASCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASPLASCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASRSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASSCORETOTAL | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCOREACC | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCOREALONE | FLOAT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| GENANXSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| HEALTHANXSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| OCDSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PANICSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PTSDSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPHOBIAINVSCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPHOBIASCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SPECPHOBIASCORE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_TREATMENT_APPOINTMENT_RANK | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_LOW_INTENSITY_FLAG | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_HIGH_INTENSITY_FLAG | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| CANCELLATION | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| FFCOMM | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| STEPINTENSITY | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PSERVICEID | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |