Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP ORGANIZATION AUDIT Table


View exposing organizational audit and compliance records associated with sponsored awards including oversight findings, corrective actions, and administrative follow-up used for compliance reporting and institutional accountability.


Field Name

Description

Data Type

Length

AUDIT_ACCEPTED

Audit accepted associated with the record.

VARCHAR2

3

AUDIT_COMMENT

Audit comment associated with the record.

VARCHAR2

300

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

ORGANIZATION_ID

Business identifier for the organization.

VARCHAR2

8

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE