This table requires activation of Position Management functional area. DW_POSITION_SNAPSHOT_F stores position along with incumbent headcount and fte for every day
Module: Global Human Resources
CALENDAR_DATE, POSITION_ID
| 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, 2025, Oracle and/or its affiliates.