Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WL PROP RV DETAILS EXT Table


XXX


Field Name

Description

Data Type

Length

COMMENTS

Comments about the graduate appointment

VARCHAR2

2000

DEV_PROPOSAL_NUMBER

XXX

VARCHAR2

8

INST_PROPOSAL_NUMBER

XXX

VARCHAR2

8

PERSON_ID

XXX

VARCHAR2

9

PROPOSAL_NUMBER

A unique number assigned by OSP to each proposal submitted to a sponsor.

VARCHAR2

8

REVIEWED_DEAN_OFFICE_FLAG

XXX

VARCHAR2

1

REVIEW_ACTION_CODE

XXX

NUMBER

REVIEW_NUMBER

XXX

NUMBER

REVIEW_ROLE_CODE

XXX

NUMBER

REVIEW_TIME_SPENT_CODE

XXX

NUMBER

ROUTING_NUMBER

XXX

VARCHAR2

10

SUBMISSION_VEHICLE_CODE

XXX

NUMBER

TIME_SPENT_ASSIS_DLC_CODE

XXX

NUMBER

UPDATE_TIMESTAMP

Date that a record was last updated by OSP.

DATE

UPDATE_USER

Userid of the person who last updated this record.

VARCHAR2

8