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