OSP PENDING PROPOSALS Table
View exposing pending or in-development proposal records including proposal stage, estimated funding amounts, development timeline, and status indicators used for research pipeline tracking and proposal forecasting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR_EFFORT |
Academic year effort associated with the record. |
NUMBER |
5,2 |
CALENDAR_YEAR_EFFORT |
Calendar year effort associated with the record. |
NUMBER |
5,2 |
FACULTY_FLAG |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
HOME_UNIT |
Home unit associated with the record. |
VARCHAR2 |
8 |
HOME_UNIT_NAME |
Home unit name associated with the record. |
VARCHAR2 |
60 |
INITIAL_ALL_COST_AMOUNT |
Initial all cost amount associated with the record. |
NUMBER |
28,7 |
INITIAL_DIRECT_COST_AMOUNT |
Initial direct cost amount associated with the record. |
NUMBER |
12,2 |
INITIAL_INDIRECT_COST_AMOUNT |
Initial indirect cost amount associated with the record. |
NUMBER |
12,2 |
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
20 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
OSP_PROPOSAL_NUMBER |
Osp 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 |
40 |
PERSON_NAME |
Person name associated with the record. |
VARCHAR2 |
200 |
PERSON_PROJECT_ROLE |
Person project role associated with the record. |
VARCHAR2 |
60 |
PERSON_ROL |
Person rol associated with the record. |
VARCHAR2 |
12 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
20 |
PRIME_SPONSOR_COUNTRY_CODE |
Code identifying prime sponsor country. |
VARCHAR2 |
3 |
PRIME_SPONSOR_COUNTRY_NAME |
Prime sponsor country name associated with the record. |
VARCHAR2 |
255 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
200 |
PRIME_SPONSOR_TYPE |
Prime sponsor type associated with the record. |
VARCHAR2 |
100 |
PROPOSAL_CREATED_DATE |
Date associated with proposal created. |
DATE |
|
PROPOSAL_STATUS |
Proposal status associated with the record. |
VARCHAR2 |
200 |
PROPOSAL_STATUS_CODE |
Code identifying proposal status. |
NUMBER |
|
PROPOSAL_TYPE |
Proposal type associated with the record. |
VARCHAR2 |
200 |
PROPOSAL_TYPE_CODE |
Code identifying proposal type. |
VARCHAR2 |
3 |
REQUESTED_END_DATE_INITIAL |
Requested end date initial associated with the record. |
DATE |
|
REQUESTED_END_DATE_TOTAL |
Requested end date total associated with the record. |
DATE |
|
REQUESTED_START_DATE_INITIAL |
Requested start date initial associated with the record. |
DATE |
|
REQUESTED_START_DATE_TOTAL |
Requested start date total associated with the record. |
DATE |
|
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
20 |
SPONSOR_COUNTRY_CODE |
Code identifying sponsor country. |
VARCHAR2 |
3 |
SPONSOR_COUNTRY_NAME |
Sponsor country name associated with the record. |
VARCHAR2 |
255 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
100 |
SUMMER_EFFORT |
Summer effort associated with the record. |
NUMBER |
5,2 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
TOTAL_ALL_COST_AMOUNT |
Total all cost amount associated with the record. |
NUMBER |
28,7 |
TOTAL_DIRECT_COST_AMOUNT |
Total direct cost amount associated with the record. |
NUMBER |
12,2 |
TOTAL_EFFORT |
Total effort associated with the record. |
NUMBER |
5,2 |
TOTAL_INDIRECT_COST_AMOUNT |
Total indirect cost amount associated with the record. |
NUMBER |
12,2 |
USER_NAME |
User name associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_INSERT_TIMESTAMP |
Timestamp associated with warehouse insert. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |