OSP WL PROP RV DETAILS EXT Table
View exposing extended proposal review detail records including detailed evaluation, scoring, and reviewer assessment information used for comprehensive review tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMENTS |
Comments associated with the record. |
VARCHAR2 |
2000 |
DEV_PROPOSAL_NUMBER |
Dev proposal number associated with the record. |
VARCHAR2 |
8 |
INST_PROPOSAL_NUMBER |
Inst proposal number associated with the record. |
VARCHAR2 |
8 |
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 |
REVIEWED_DEAN_OFFICE_FLAG |
Indicator identifying whether reviewed dean office (Y/N). |
VARCHAR2 |
1 |
REVIEW_ACTION_CODE |
Code identifying review action. |
NUMBER |
|
REVIEW_NUMBER |
Review number associated with the record. |
NUMBER |
|
REVIEW_ROLE_CODE |
Code identifying review role. |
NUMBER |
|
REVIEW_TIME_SPENT_CODE |
Code identifying review time spent. |
NUMBER |
|
ROUTING_NUMBER |
Routing number associated with the record. |
VARCHAR2 |
10 |
SUBMISSION_VEHICLE_CODE |
Code identifying submission vehicle. |
NUMBER |
|
TIME_SPENT_ASSIS_DLC_CODE |
Code identifying time spent assis dlc. |
NUMBER |
|
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |