Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WL PROP REVIEW COMMENTS Table


View exposing proposal review comment records including reviewer feedback, recommendations, and assessment documentation used for proposal evaluation tracking.


Field Name

Description

Data Type

Length

CANNED_REVIEW_COMMENT_CODE

Code identifying canned review comment.

NUMBER

COMMENTS

Comments associated with the record.

VARCHAR2

2000

COMMENT_NUMBER

Comment number associated with the record.

NUMBER

MENTOR_PERSON_ID

Business identifier for the mentor person.

VARCHAR2

9

PERSON_ID

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

VARCHAR2

9

PROPOSAL_NUMBER

Proposal number associated with the record.

VARCHAR2

8

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