OSP PROPOSAL SUBMISSION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATE_TIMESTAMP |
XXX |
DATE |
|
CREATE_USER |
XXX |
VARCHAR2 |
60 |
DATE_REACHED_OSP |
XXX |
DATE |
|
DEADLINE_DATE |
XXX |
DATE |
|
INST_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
12 |
LEAD_UNIT |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
NUM_OF_DAYS |
XXX |
NUMBER |
28,7 |
NUM_OF_DAYS_OSP |
XXX |
NUMBER |
28,7 |
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 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
12 |
PROPOSAL_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
ROUTING_START_DATE |
XXX |
DATE |
|
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 |
SPONSOR_NAME |
In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources. |
VARCHAR2 |
200 |
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 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |