Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINANCIAL PROCESSING STATUS Table


View exposing reference values describing processing status for financial transactions and reporting workflows.


Field Name

Description

Data Type

Length

COMPLETE_DATE

Date associated with complete.

DATE

IS_PROCESS_COMPLETE

Indicator identifying whether process complete (Y/N).

VARCHAR2

1

PROCESS_NAME

Process name associated with the record.

VARCHAR2

30

TIME_MONTH_KEY

Surrogate key identifying the time month.

VARCHAR2

6

USERNAME

Username associated with the record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE