DW_POSITION_CURRENT_D

It stores records for all the current positions.

Details

Module: Global Human Resources

Key Columns

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_CURRENT_TL joining this ID. DW_POSITION_D_CURRENT_TL POSITION_ID
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.    

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