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    

Copyright © 2019, 2024, Oracle and/or its affiliates.