DW_PROJECT_ASSIGNMENT_D (Preview)

This table requires activation of Project Labor Distribution functional area. This table stores current and future active assignment data with effective date.

Details

Module:

Key Columns

ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE

Columns

Columns
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.