OSP PROPOSAL DETAIL Table
View exposing detailed proposal records including narrative objectives, specific aims, methodology, timeline, and budget details used for proposal content tracking and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
100 |
GRAD_STUDENT_HEADCOUNT |
Grad student headcount associated with the record. |
NUMBER |
|
GRAD_STUDENT_PERSON_MONTHS |
Grad student person months associated with the record. |
NUMBER |
5,2 |
INITIAL_ALL_COST_AMOUNT |
Initial all cost amount associated with the record. |
NUMBER |
28,7 |
INITIAL_CONTRACT_ADMIN_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
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 |
IS_ARRA_FUNDING |
Indicator identifying whether arra funding (Y/N). |
VARCHAR2 |
1 |
IS_SUBCONTRACT |
Indicator identifying whether subcontract (Y/N). |
VARCHAR2 |
1 |
LEAD_UNIT_KEY |
Surrogate key identifying the lead unit. |
VARCHAR2 |
8 |
MAIL_ACCOUNT_NUMBER |
Mail account number associated with the record. |
VARCHAR2 |
7 |
MAIL_BY |
Mail by associated with the record. |
VARCHAR2 |
1 |
MAIL_TYPE |
Mail type associated with the record. |
VARCHAR2 |
1 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
12 |
NUMBER_OF_COPIES |
Number of copies associated with the record. |
NUMBER |
7 |
OSP_ACTIVITY_TYPE_KEY |
Surrogate key identifying the osp activity type. |
VARCHAR2 |
3 |
OSP_NOTICE_OF_OPPORTUNITY_KEY |
Surrogate key identifying the osp notice of opportunity. |
VARCHAR2 |
3 |
OSP_NSF_DISCIPLINE_KEY |
Surrogate key identifying the osp nsf discipline. |
VARCHAR2 |
15 |
OSP_PROPOSAL_NUMBER |
Osp proposal number associated with the record. |
VARCHAR2 |
8 |
OSP_PROPOSAL_STATUS_KEY |
Surrogate key identifying the osp proposal status. |
NUMBER |
|
OSP_PROPOSAL_TYPE_KEY |
Surrogate key identifying the osp proposal type. |
VARCHAR2 |
3 |
PRIME_SPONSOR_KEY |
Surrogate key identifying the prime sponsor. |
VARCHAR2 |
6 |
PRINCIPAL_INVESTIGATOR_KEY |
Surrogate key identifying the principal investigator. |
VARCHAR2 |
40 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
13 |
PROPOSAL_DEADLINE_DATE |
Date associated with proposal deadline. |
DATE |
|
PROPOSAL_DEADLINE_TYPE_CODE |
Code identifying proposal deadline type. |
VARCHAR2 |
1 |
PROPOSAL_TITLE |
Proposal title associated with the record. |
VARCHAR2 |
200 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
REQESTED_INITIAL_START_DATE |
Date associated with reqested initial start. |
DATE |
|
REQUESTED_INITIAL_END_DATE |
Date associated with requested initial end. |
DATE |
|
REQUESTED_TOTAL_END_DATE |
Date associated with requested total end. |
DATE |
|
REQUESTED_TOTAL_START_DATE |
Date associated with requested total start. |
DATE |
|
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
6 |
SPONSOR_PROPOSAL_NUMBER |
Sponsor proposal number associated with the record. |
VARCHAR2 |
70 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
18 |
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_INDIRECT_COST_AMOUNT |
Total indirect cost amount associated with the record. |
NUMBER |
12,2 |
TYPE_OF_ACCOUNT_CODE |
Code identifying type of account. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |