OTP_SVC_SCHED_BREAKDOWN
Description:
Stores the referral service schedule breakdown details for an order.

Primary Key
Column Name Ordinal Position
OTP_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 OTP_ID NUMERIC No
The unique identifier (.1 item) for the patient order template 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 SVC_SCHED_TYPE_C_NAME NUMERIC No
Stores the type of the service schedule breakdown on the associated row. Determines if the schedule row is related to the recommended units or if it is for additional requested units.
May contain organization-specific values: No
Category Entries:
Recommended
Additional
4 SVC_SCHED_SLOTKEY_C_NAME NUMERIC No
Stores the key identifier for a slot in the referral service schedule for the associated units.
May contain organization-specific values: No
Category Entries:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
5 SVC_SCHED_SLOT_UNIT INTEGER No
Stores the units for a referral service schedule breakdown slot.