SERVICE_SCHED_BREAKDOWN

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

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier (.1 item) for the order 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.