DW_POSITION_SNAPSHOT_F (Preview)

This table requires activation of Position Management functional area. DW_POSITION_SNAPSHOT_F stores position along with incumbent headcount and fte for every day

Details

Module: Global Human Resources

Key Columns

POSITION_ID, CALENDAR_DATE

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
CALENDAR_DATE DATE     True calendar date    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier. This column contains POSITION_ID and CALENDAR_DATE    
DELEGATE_POSITION_ID NUMBER 38 0   Delegate Position identifier    
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier    
ORGANIZATION_ID NUMBER 38 0   Organization Identifier    
JOB_ID NUMBER 38 0   Job Identifier    
LOCATION_ID NUMBER 38 0   Location Identifier    
ENTRY_GRADE_ID NUMBER 38 0   Identifier of the entry grade    
ACTION_REASON_ID NUMBER 38 0   Action reason identifier    
REQUISITION_TEMPLATE_ID NUMBER 38 0   Requisition template Identifier    
SUPERVISOR_ASSIGNMENT_ID NUMBER 38 0   Supervisor Assignmnet Identifier    
SUPERVISOR_ID NUMBER 38 0   Supervisor Identifier    
COST_CENTER VARCHAR2 32     Cost center    
BARGAINING_UNIT VARCHAR2 32     Code of the bargaining uni    
BUDGET_AMOUNT NUMBER       Indicates budget amount    
BUDGET_AMOUNT_CURRENCY VARCHAR2 32     Used to identify currency for Budget Amount    
MAX_PERSONS NUMBER 38 0   Position headcount    
POSITION_FTE NUMBER       FTE of Position    
INCUMBENT_HEADCOUNT BIGDECIMAL   10   Headcount of all assignment in Position    
INCUMBENT_FTE BIGDECIMAL   10   FTE of all assignment in Position    
INCUMBENT_ASSIGNMENT_COUNT NUMBER       Count of assignment in Position    
INCUMBENT_PERSON_COUNT NUMBER       Count of person in Position    

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