EPISODE_PAUSE

Description: |
This table contains data on past and present Social Care episode pause periods that currently exist in the system.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique identifier for the episode record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | PAUSE_STATUS_C_NAME | VARCHAR | No |
The pause status category ID for the pause period.
May contain organization-specific values: Yes
Category Entries:
10 - First Activity
11 - First Activity (Active Monitoring End)
12 - First Activity (Referral from Consultant or Allied Health Professional)
20 - Subsequent Activity (Further activities anticipated)
21 - Transfer to another Health Care Provider
30 - First Definitive Treatment
31 - Start of Active Monitoring (Patient initiated)
32 - Start of Active Monitoring (Care Professional initiated)
33 - Did Not Attend
34 - Decision Not To Treat
35 - Patient Declined Offered Treatment
36 - Patient Died Before Treatment
90 - After Treatment
91 - During Active Monitoring
92 - Not Yet Referred
98 - Not Applicable
99 - Not Yet Known
11 - Waiting for investigation
12 - Waiting for treatment
13 - Waiting, redirected from other department
14 - Waiting for needed information
15 - Waiting for assistance
21 - Non waiting for investigation/treatment
22 - Non waiting, at control
23 - Non waiting, patient's wish
24 - Non waiting, ongoing treatment/investigation in other department
25 - Non waiting, ongoing investigation
26 - Non waiting, ongoing treatment
0 - No wait status
Active
Care plan / proposed treatment plan completed
Unplanned patient admission to hospital
Planned patient admission to hospital
Alteration in patient medical condition without hospital admission
Patient died
Patient has declined further services
Patient has moved from area
Patient is unable to be contacted
Patient has been referred to another service
No measurable benefit from continuing the service
Patient not complying with program
Risk to patient or staff prevents service provision
Patient/client death or bereavement phase end
Discharged to speciality palliative care provider
Discharged to other health care provider
Other
4 | PAUSE_START_DATE | DATETIME | No |
The date when the pause was started.
5 | PAUSE_END_DATE | DATETIME | No |
The date when the pause was ended.
6 | PAUSE_REASON_C_NAME | VARCHAR | No |
The pause reason category ID for the pause period.
May contain organization-specific values: Yes
7 | UPDATE_USER_ID | VARCHAR | No |
The unique ID of the user who most recently updated the pause period.
8 | UPDATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | UPDATE_UTC_DTTM | DATETIME (UTC) | No |
The UTC date and time that a pause period was last updated.
10 | PAUSE_KEY | VARCHAR | No |
This item contains the key used to identify a pause period (i.e. row in the HSB-64100 related group).