SOCIAL_CARE_EPISODE

Description: |
This table stores episode information for Compass Rose episodes.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
The unique identifier for the episode record.
2 | EPISODE_DEF_ID_EPISODE_DEF_NAME | VARCHAR | No |
This column displays the name of the episode / block definition record.
3 | EPI_STATUS_C_NAME | VARCHAR | No |
The status category ID for the episode.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
4 | EPISODE_START_DATE | DATETIME | No |
The date the episode was started.
5 | EPISODE_END_DATE | DATETIME | No |
The date the episode was ended.
6 | EPISODE_PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for a special contact which stores Social Care information at episode-level. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
7 | DECISION_FIN_ASST_CASE_ID | NUMERIC | No |
The unique ID of the case which contains all the decisions created in the episode.
8 | RESPONSIBLE_USER_ID | VARCHAR | No |
The unique ID of the responsible user for the episode.
9 | RESPONSIBLE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | INIT_REFERRAL_ID | NUMERIC | No |
The unique ID of the referral that initiated the episode.
11 | PROGRAM_EPISODE_ID | NUMERIC | No |
The unique ID of the program episode for a service episode. If the episode is voided, it will contain a link to the parent record at the time the episode was voided.
12 | TRACKING_STATUS_C_NAME | VARCHAR | No |
The tracking status category ID for the episode.
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
13 | EPISODE_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
14 | EPISODE_SUMMARY | VARCHAR | No |
An overview of a Social Care episode.
15 | CMGMT_ENROLL_DATE | DATETIME | No |
The date when the episode became active. Refer to CMGMT_ENROLL_CALC_DATE for more robust reporting.
16 | CMGMT_ENROLL_CALC_DATE | DATETIME | No |
The date that the user documented as the enrollment date or the date the status was originally changed to Active if no enrollment date is documented. If the overall episode status is Enrolling, the value will be blank.
17 | SOURCE_EVENT_TRIGGER_C_NAME | VARCHAR | No |
The source event category ID for an automatically created Compass Rose episode.
May contain organization-specific values: No
Category Entries:
Inpatient Hospital Admission
Undo Inpatient Hospital Admission
Basic Hospital Admission
Undo Basic Hospital Admission
External Hospital Admission
Hospital Discharge
Undo Hospital Discharge
External Hospital Discharge
Emergency Department Arrival
Undo Emergency Department Arrival
Emergency Department Dismissal
Undo Emergency Department Dismissal
External Emergency Department Visit
External Emergency Department Visit End