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.