OSP WL PROPOSALS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INST_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
PI_ID |
The nine-digit MIT ID number of the project's Principal Investigator. |
VARCHAR2 |
40 |
PI_NAME |
The full name of the project's Principal Investigator, in the format Last, First MI. |
VARCHAR2 |
90 |
PRIME_SPONSOR_CODE |
Primary Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
9 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
9 |
PROPOSAL_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
SPONSOR_CODE |
Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
200 |
UNIT_NUMBER |
XXX |
VARCHAR2 |
8 |