# DW_POSITION_SNAPSHOT_F

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 |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |

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