# DW_CMP_PERSON_BUDGET_F

This table holds budget amounts

## Details

Module: Compensation

## Key Columns

BUDGET_POOL_ID, PERIOD_ID, PLAN_ID, PERSON_EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BUDGET_POOL_ID | NUMBER | 38 | 0 | True | Budget Pool Identifier | DW_CMP_BUDGET_POOL_D | BUDGET_POOL_ID
PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Persion Event Id | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
PERIOD_ID | NUMBER | 38 | 0 | True | Period Id | DW_CMP_PLAN_PERIOD_D | PERIOD_ID
PLAN_ID | NUMBER | 38 | 0 | True | Plan Id | DW_CMP_PLAN_D | PLAN_ID
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Primary Key consisting of Budget Pool,PersonEvent,PeriodId, and PlanId identifier |  |
OVERALL_BUDGET_AMOUNT | NUMBER |  |  |  | Overall Budget Amount |  |
OVERALL_BUDGET_AMOUNT_USED | NUMBER |  |  |  | Overall Budget Amount Used |  |
OVERALL_BUDGET_AMOUNT_AVAILABLE | NUMBER |  |  |  | Overall Budget Amount Available |  |
TOTAL_ELIGIBLE_SALARY | NUMBER |  |  |  | Total Eligible Salaries |  |
CREATION_DATE | TIMESTAMP |  |  |  | creation date |  |

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