Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BUDGET POSTRULE Table


View exposing budget post rule reference data including post rule codes, descriptions, and indicators for inclusion in original, approved, current, and projected budget measures.


Field Name

Description

Data Type

Length

BUDGET_POSTRULE

Budget postrule as provided by the source.

VARCHAR2

40

BUDGET_POSTRULE_CODE

Code identifying budget postrule.

VARCHAR2

1

BUDGET_POSTRULE_KEY

Surrogate key identifying the budget postrule.

VARCHAR2

1

IS_IN_APPR_BUDGET

Indicator identifying whether in appr budget (Y/N).

VARCHAR2

1

IS_IN_CURR_BUDGET

Indicator identifying whether in curr budget (Y/N).

VARCHAR2

1

IS_IN_ORIG_BUDGET

Indicator identifying whether in orig budget (Y/N).

VARCHAR2

1

IS_IN_PROJ_BUDGET

Indicator identifying whether in proj budget (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE