DW_LABOR_SCHEDULE_D (Preview)

This table requires activation of Project Labor Distribution functional area. This table stores the top level of information in relation to a labor schedule, its type, and type-related key attributes.

Details

Module:

Key Columns

LABOR_SCHEDULE_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LABOR_SCHEDULE_HEADER_ID NUMBER 38 0 True Primary Key.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
LABOR_SCHEDULE_NAME VARCHAR2 256 Labor schedule name.
LABOR_SCHEDULE_TYPE VARCHAR2 32 Type of labor schedule like Person-Assignment.
PERSON_ID NUMBER 38 0 Person ID related to the person record for this labor schedule.
ASSIGNMENT_ID NUMBER 38 0 Assignment ID relating to the assignment record for this labor schedule.
BUSINESS_UNIT_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row.
ELEMENT_TYPE_ID NUMBER 38 0 Identifier of the pay element type.
CREATED_BY VARCHAR2 128 indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.