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

EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, ASSIGNMENT_ID, 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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.