EPISODE_PAUSE_HISTORY
Description:
This table stores the audit data for the items in the Social Care - Pause Status (I HSB 64100) related group, such as audit data for episode pauses.

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_HISTORY_STATUS_C_NAME VARCHAR No
The status category ID of the pause when it was added, edited, or deleted.
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_HISTORY_START_DATE DATETIME No
The date the pause was set to start before being updated.
5 PAUSE_HISTORY_END_DATE DATETIME No
The date the pause was set to end before being updated.
6 PAUSE_HISTORY_REASON_C_NAME VARCHAR No
The pause reason category ID when the pause period was added, edited, or deleted.
May contain organization-specific values: Yes
7 PAUSE_HISTORY_UPDATE_USER_ID VARCHAR No
The unique ID of the user who most recently updated the pause period.
8 PAUSE_HISTORY_UPDATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 PAUSE_HISTORY_UPD_UTC_DTTM DATETIME (UTC) No
The UTC date and time that a pause period was last updated.
10 PAUSE_HISTORY_KEY VARCHAR No
This item stores the key used to identify a particular scheduled pause period.
11 PAUSE_HISTORY_EVENT_C_NAME VARCHAR No
The audit even category ID for the event that occurred for the pause period.
May contain organization-specific values: No
Category Entries:
Add
Edit
Delete
Delete from Resolve