This table requires activation of Project Labor Distribution functional area. This table stores stores the information related to an allocation rule.
Module:
RULE_ID
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.