OR_CASE_RESCHED
Description:
The OR_CASE_RESCHED table contains OR management system case reschedule information.

Primary Key
Column Name Ordinal Position
OR_CASE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 OR_CASE_ID VARCHAR No
The unique ID of the case record.
2 LINE INTEGER No
The number of the line of the rescheduling information for the case.
3 RESCHEDULE_SER_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4 RESCHEDULE_NEED_C_NAME VARCHAR No
The category value indication the reason the reschedule is needed.
May contain organization-specific values: Yes
Category Entries:
Time Unavailable
Outside the Template
Equipment Out of Service
Preference Update
Taken Off Schedule
5 RESCHEDULE_CMT VARCHAR No
The rescheduling comment of the rescheduled case.