nhsd_iapt_waitingtimes_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] |
WAITINGTIME_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] |
PAUSEID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
PAUSESTARTDATE |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
PAUSEENDDATE |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
PAUSEREASON |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
IC_PATHWAY_ID |
INTEGER |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
PSERVICEID |
TEXT |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |
[Replace] |