DW_LABOR_ALLOCATION_RULE_D (Preview)

This table requires activation of Project Labor Distribution functional area. This table stores stores the information related to an allocation rule.

Details

Module:

Key Columns

RULE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RULE_ID NUMBER 38 0 True Allocation rule identification number    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System    
LABOR_SCHEDULE_HEADER_ID NUMBER 38 0   Primary key from parent table PJC_RULES_HDR    
LD_VERSION_NAME VARCHAR2 512     Labor Schedule Version Name.    
LD_VERSION_STATUS VARCHAR2 32     Status of the labor schedule version.    
START_DATE_ACTIVE DATE       The date when the rule becomes effective    
END_DATE_ACTIVE DATE       The date when the rule becomes ineffective    
LD_VERSION_COMMENTS VARCHAR2 999     User defined comments for the version.    
BUSINESS_UNIT_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
PERSON_ID NUMBER 38 0   Person ID related to the person record for this labor schedule.    
ASSIGNMENT_ID NUMBER 38 0   Assignment ID related to the assignment record for this labor schedule.    
ELEMENT_TYPE_ID NUMBER 38 0   Pay element type ID.    
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.