Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse NIMBUD DSBUD Table


View exposing Nimbus budget measures by fiscal year, cost collector, and general ledger account including original, approved, current, projected, base, and non-base amounts.


Field Name

Description

Data Type

Length

APPRBASE

Apprbase associated with the record.

NUMBER

12,2

APPRNONBASE

Apprnonbase associated with the record.

NUMBER

12,2

COST_COLLECTOR

Cost collector associated with the record.

VARCHAR2

10

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

CURRBASE

Currbase associated with the record.

NUMBER

12,2

CURRNONBASE

Currnonbase associated with the record.

NUMBER

12,2

CURRTOTAL

Currtotal associated with the record.

NUMBER

12,2

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

GL_ACCOUNT_KEY

Surrogate key identifying the gl account.

VARCHAR2

14

ORIGBASE

Origbase associated with the record.

NUMBER

12,2

ORIGNONBASE

Orignonbase associated with the record.

NUMBER

12,2

PROJBASE

Projbase associated with the record.

NUMBER

12,2

PROJNONBASE

Projnonbase associated with the record.

NUMBER

12,2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE