DW_LM_BOOKING_D (Preview)
This table requires activation of Learning Management functional area. Table to store details of activity bookings
Details
Module: Work Life
Key Columns
BOOKING_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BOOKING_ID | NUMBER | 38 | 0 | True | Booking Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| LEARNING_ITEM_ID | NUMBER | 38 | 0 | Activity learning item id | |||
| BOOKED_ITEM_TYPE | VARCHAR2 | 128 | Indicates what type of booked item this is (resource, person) | ||||
| BOOKED_ITEM_ID | NUMBER | 38 | 0 | Can be a resource_id or person_id | |||
| PRIMARY_FLAG | VARCHAR2 | 16 | Primary Flag | ||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Identifier of Enterprise | |||
| BOOKING_NUMBER | VARCHAR2 | 128 | UserKey for uniquely identifying Learning Booking |