This table requires activation of Position Management functional area. Position budget day Dimension
Module: Global Human Resources
CALENDAR_DATE, POSITION_ID, POSITION_BUDGET_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| POSITION_BUDGET_ID | NUMBER | 38 | 0 | True | Position budget Identifier | ||
| POSITION_ID | NUMBER | 38 | 0 | True | Position Identifier | ||
| CALENDAR_DATE | DATE | True | calendar date | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. unique key | ||||
| BUDGET_CODE | VARCHAR2 | 32 | Budget Code | ||||
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business unit Identifier | |||
| DEPARTMENT_ID | NUMBER | 38 | 0 | Department Identifier | |||
| LOCATION_ID | NUMBER | 38 | 0 | Location Identifier | |||
| BUDGET_PERIOD_START_DATE | DATE | Budget period start date | |||||
| BUDGET_PERIOD_END_DATE | DATE | Budget period end date | |||||
| ALLOCATED_HEADCOUNT | NUMBER | Allocated budget headcount | |||||
| ALLOCATED_FTE | NUMBER | Allocated budget fte | |||||
| ALLOCATED_AMOUNT | NUMBER | Allocated budget amount | |||||
| ENTERPRISE_CURRENCY | VARCHAR2 | 256 | Curreny of enterprise budget amount allocated | ||||
| POSITION_MAX_PERSONS | NUMBER | 38 | 0 | Position headcount | |||
| POSITION_FTE | NUMBER | FTE of Position | |||||
| POSITION_BUDGET_AMOUNT | NUMBER | Position budget amount | |||||
| POSITION_BUDGET_AMOUNT_CURRENCY | VARCHAR2 | 32 | Used to identify currency for Budget Amount | ||||
| POSITION_START_DATE | DATE | Start date of position | |||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code | ||||
| ENTERPRISE_GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency conversion rate. | |||||
| POSITION_GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency conversion rate. | |||||
| POSITION_MAX_PERSONS_CHANGE_IND | NUMBER | 38 | 0 | Indicated if position max person changed | |||
| POSITION_FTE_CHANGE_IND | NUMBER | 38 | 0 | Indicated if position fte changed | |||
| POSITION_BUDGET_AMOUNT_CHANGE_IND | NUMBER | 38 | 0 | Indicated if position budget amount changed |
Copyright © 2019, 2025, Oracle and/or its affiliates.