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

CALENDAR_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
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