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.