FM_APPROVED_BUDGETS

This table stores approved budgets of financial summaries.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

FM_FINANCIAL_SUMMARY

FINANCIAL_SUMMARY_ID

FINANCIAL_SUMMARY_ID

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

FISCAL_PERIOD_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

APPROVED_BUDGET_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

VERSION

NOT NULL

NUMBER

System-generated version, used for hibernate version control.

NAME

NOT NULL

VARCHAR2(200)

Name of the approved budget

LABOR_TYPE_CODE

NULLABLE

VARCHAR2(40)

Not used. The labor type for which the budget is approved. Possible values are: LABOR/NON_LABOR

CATEGORY_CODE

NULLABLE

VARCHAR2(40)

Not used. The category for which the budget is approved.

EXPENSE_TYPE_CODE

NOT NULL

VARCHAR2(40)

Expense type for which the budget is approved. Possible values are: CAPITAL, OPERATING

AMOUNT_LCL

NOT NULL

NUMBER

Amount of approved budget in local currency

AMOUNT_BSE

NOT NULL

NUMBER

Amount of approved budget in base currency

FISCAL_PERIOD_ID

NULLABLE

NUMBER

Identifier of the fiscal period for which the budget is approved

APPROVAL_DATE

NOT NULL

DATE

Date at which the budget is approved

APPROVED_BY

NOT NULL

NUMBER

Identifier of the person who approves the budget

NOTES

NULLABLE

VARCHAR2(1000)

Notes

FINANCIAL_SUMMARY_ID

NULLABLE

NUMBER

Identifier of financial summary to which the approved budget belongs

SYNCH_SOURCE_FLAG

NULLABLE

VARCHAR2(10)

If the approved budget is synchronized, describes the source. If the approved budget is not synchronized, the value is "N". For example, synch_source_flag could be "FSR" for Financial Summary Rollup, and it could be "ALLOC" for budget allocated from programs.

SOURCE_FS_ID

NULLABLE

NUMBER

For synchronized approved budgets in program's financial summary, this column stores the source financial summary IDs from which the approved budgets are rolled up.

Indexes

Index Name

Index Type

Sequence

Column Name

FM_APPROVED_BUDGETS_PK

UNIQUE

1

APPROVED_BUDGET_ID

Sequences

Sequence Name

Sequence Type

FM_APPROVED_BUDGETS_S

APPROVED_BUDGET_ID