Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINANCIAL PROCESSING STATUS Table


Table containing data which displays the current status of several financial processing areas. Examples: costing sheets, payroll, facilities processing, fiscal period complete, etc.


Field Name

Description

Data Type

Length

COMPLETE_DATE

Date indicating when a particular financial process was completed.

DATE

8

IS_PROCESS_COMPLETE

Flag indicating whether a financial process has been completed. Values: Y or N.

VARCHAR2

1

PROCESS_NAME

Name of the process in the financial processing status table. Examples: costing sheets, payroll, facilities processing, fiscal period complete.

VARCHAR2

30

TIME_MONTH_KEY

Key used only for joining the TIME_MONTH table to other tables, NOT for reporting.

VARCHAR2

6

USERNAME

Kerberos ID

VARCHAR2

12

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8