Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BUDGET PRIVATE COMMENT Table


View exposing private comments associated with budget transactions including author, request source, comment text, and warehouse load date.


Field Name

Description

Data Type

Length

AUTHOR_NAME

Author name as provided by the source.

VARCHAR2

30

AUTHOR_POSITION

Author position as provided by the source.

VARCHAR2

20

BUDGET_PRIVATE_COMMENT

Budget private comment as provided by the source.

VARCHAR2

2000

REQUEST_SOURCE

Request source as provided by the source.

VARCHAR2

15

TRANSACTION_NUMBER

Transaction number as provided by the source.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE