Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BUDGET DRAFT STATUS Table


View exposing budget draft status reference data including draft rule and status codes and descriptions used for budget workflow reporting.


Field Name

Description

Data Type

Length

BUDGET_DRAFT_STATUS_KEY

Surrogate key identifying the budget draft status.

VARCHAR2

2

DRAFT_RULE

Draft rule as provided by the source.

VARCHAR2

40

DRAFT_RULE_CODE

Code identifying draft rule.

VARCHAR2

1

DRAFT_STATUS

Draft status as provided by the source.

VARCHAR2

40

DRAFT_STATUS_CODE

Code identifying draft status.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE