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
POSITION_ID, CALENDAR_DATE
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.