Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP WL PROPOSALS Table


View exposing workload system proposals including proposed awards, funding requests, and proposal details used for proposal processing and workload tracking.


Field Name

Description

Data Type

Length

INST_PROPOSAL_NUMBER

Inst proposal number associated with the record.

VARCHAR2

8

PI_ID

Business identifier for the pi.

VARCHAR2

40

PI_NAME

Pi name associated with the record.

VARCHAR2

90

PRIME_SPONSOR_CODE

Code identifying prime sponsor.

VARCHAR2

6

PROFIT_CENTER

Profit center associated with the record.

VARCHAR2

9

PROPOSAL_NUMBER

Proposal number associated with the record.

VARCHAR2

9

PROPOSAL_TYPE_CODE

Code identifying proposal type.

VARCHAR2

3

SPONSOR_CODE

Code identifying sponsor.

VARCHAR2

6

TITLE

Title associated with the record.

VARCHAR2

200

UNIT_NUMBER

Unit number associated with the record.

VARCHAR2

8