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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.