DW_POSITION_BUDGET_DAY_D (Preview)

This table requires activation of Position Management functional area. Position budget day Dimension

Details

Module: Global Human Resources

Key Columns

POSITION_BUDGET_ID, CALENDAR_DATE, POSITION_ID

Columns

Columns
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