Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OPA USE OF INST RESOURCES Table


View exposing disclosed use of institutional resources in outside professional activities including resource descriptions, related entity identifiers, and audit fields.


Field Name

Description

Data Type

Length

ENTITY_NAME

Entity name associated with the record.

VARCHAR2

400

ENTITY_NUMBER

Entity number associated with the record.

VARCHAR2

10

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

RESOURCE_DESCRIPTION

Resource description associated with the record.

VARCHAR2

4000

RESOURCE_NUMBER

Resource number associated with the record.

NUMBER

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

8