DW_POSITION_D

DW_POSITION_D stores all the positions with their attributes.

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, POSITION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
POSITION_ID NUMBER 38 0 True Transaction system generated primary key column.For translation refer table DW_POSITION_D_TL joining this ID.#1 DW_POSITION_D_TL POSITION_ID
EFFECTIVE_START_DATE DATE     True Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.    
EFFECTIVE_END_DATE DATE     True Date Effective Entity: indicates the date at the end of the date range within which the row is effective.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier This column contains JOB_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.    
POSITION_CODE VARCHAR2 32     Code of the position    
ACTIVE_STATUS VARCHAR2 32     Indicates if a position is active or inactive.    
POSITION_TYPE VARCHAR2 32     Indicates the type of the position for example pooled or single.    
MAX_PERSONS NUMBER 38 0   Position headcount    
SECURITY_CLEARANCE VARCHAR2 32     Indicates the security clearance of a position.    
OVERLAP_ALLOWED VARCHAR2 32     Indicates if overlap is allowed.    
SEASONAL_FLAG VARCHAR2 32     Indicates if a position is seasonal.    
SEASONAL_START_DATE DATE       Seasonal start date.    
SEASONAL_END_DATE DATE       Seasonal end date.    
FTE NUMBER       FTE of Position    

Notes

#1 DW_POSITION_D_TL is date effective. Along with POSITION_ID join on dates.

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