Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WL RV COMMENT SUMMARY Table


View exposing summarized review comments including consolidated reviewer feedback and summary assessments used for proposal evaluation documentation.


Field Name

Description

Data Type

Length

AGGREGATOR_ID

Business identifier for the aggregator.

VARCHAR2

12

AL_FLAG

Indicator identifying whether al (Y/N).

NUMBER

AL_ID

Business identifier for the al.

VARCHAR2

9

AL_NAME

Al name associated with the record.

VARCHAR2

90

CANNED_REVIEW_COMMENT_CODE

Code identifying canned review comment.

NUMBER

CA_FLAG

Indicator identifying whether ca (Y/N).

NUMBER

CA_ID

Business identifier for the ca.

VARCHAR2

9

CA_NAME

Ca name associated with the record.

VARCHAR2

90

CR_FLAG

Indicator identifying whether cr (Y/N).

NUMBER

CR_ID

Business identifier for the cr.

VARCHAR2

9

CR_NAME

Cr name associated with the record.

VARCHAR2

90

DESCRIPTION

Description associated with the record.

VARCHAR2

2000

DEV_PROPOSAL_NUMBER

Dev proposal number associated with the record.

VARCHAR2

8

DL_ID

Business identifier for the dl.

VARCHAR2

9

DL_NAME

Dl name associated with the record.

VARCHAR2

90

INST_PROPOSAL_NUMBER

Inst proposal number associated with the record.

VARCHAR2

8

PROPOSAL_NUMBER

Proposal number associated with the record.

VARCHAR2

8

SPONSOR_CODE

Code identifying sponsor.

VARCHAR2

12

SPONSOR_GROUP

Sponsor group associated with the record.

VARCHAR2

50

SPONSOR_TYPE_CODE

Code identifying sponsor type.

NUMBER