# 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

CALENDAR_DATE, POSITION_BUDGET_ID, 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, 2025, Oracle and/or its affiliates.