IAPT_appointment_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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | TEXT | [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 | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE2 | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE3 | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| THERTYPE4 | TEXT | [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 | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| GAD7SCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASWSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASHMSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASSLASCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASPLASCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASRSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| WSASSCORETOTAL | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCOREACC | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCOREALONE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGORASCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| GENANXSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| HEALTHANXSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| OCDSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PANICSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PTSDSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPHOBIAINVSCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPHOBIASCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SPECPHOBIASCORE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_TREATMENT_APPOINTMENT_RANK | REAL | [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 | TEXT | [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] |
| 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] |