Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OPA DISCL REVIEW Table


View exposing OPA disclosure review assignments and actions including review number, reviewer user, reviewer name, and update audit fields.


Field Name

Description

Data Type

Length

FULL_NAME

Full name associated with the record.

VARCHAR2

100

OPA_CYCLE_NUMBER

Opa cycle number associated with the record.

NUMBER

PERSON_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

REVIEW_NUMBER

Review number associated with the record.

NUMBER

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

8

USER_ID

Business identifier for the user.

VARCHAR2

8