This table requires activation of Position Management functional area. Position budget day Dimension
Module: Global Human Resources
POSITION_BUDGET_ID, CALENDAR_DATE, POSITION_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, 2024, Oracle and/or its affiliates.