This table requires activation of Project Labor Distribution functional area. This table stores current and future active assignment data with effective date.
Module:
EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, ASSIGNMENT_ID, EFFECTIVE_LATEST_CHANGE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment identifier | ||
EFFECTIVE_START_DATE | DATE | True | Start date of event | ||||
EFFECTIVE_END_DATE | DATE | True | End date of event | ||||
EFFECTIVE_SEQUENCE | NUMBER | 38 | 0 | True | Sequence to track multiple changes on same effective start date | ||
EFFECTIVE_LATEST_CHANGE | VARCHAR2 | 32 | True | Flag to indicate last transaction of a day | |||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Functional key of records.Combination of Assignment Id , Effective Start Date and effective Sequence | ||||
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 | Assignment status type identifier | DW_ASSIGNMENT_STATUS_D_TL | ASSIGNMENT_STATUS_TYPE_ID | |
ASSIGNMENT_NUMBER | VARCHAR2 | 32 | Assignment Number | ||||
ASSIGNMENT_NAME | VARCHAR2 | 128 | Assignment Name | ||||
ASSIGNMENT_TYPE | VARCHAR2 | 32 | Identifies the type of record. | DW_WORKER_TYPE_D_TL | WORKER_TYPE | ||
ASSIGNMENT_CATEGORY | VARCHAR2 | 32 | User defined category. For example Full-Time Permanent or Part-Time Permanent | DW_ASSIGNMENT_CATEGORY_D_TL | ASSIGNMENT_CATEGORY | ||
DEPARTMENT_ID | NUMBER | 38 | 0 | Department Identifie | DW_DEPARTMENT_D | DEPARTMENT_ID | |
JOB_ID | NUMBER | 38 | 0 | Job Identifier | DW_JOB_D | JOB_ID | |
PERSON_TYPE_ID | NUMBER | 38 | 0 | Person Type Identifier | DW_PERSON_TYPE_D | PERSON_TYPE_ID | |
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.