OSP PROPOSAL Table
View exposing submitted research proposals including proposal identifiers, principal investigators, requested funding amounts, target sponsors, submission dates, and proposal status used for proposal tracking and analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_TYPE |
Activity type associated with the record. |
VARCHAR2 |
200 |
ACTIVITY_TYPE_CODE |
Code identifying activity type. |
VARCHAR2 |
3 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
100 |
COST_SHARING_INDICATOR |
Indicator identifying whether cost sharing (Y/N). |
VARCHAR2 |
1 |
CURRENT_AWARD_NUMBER |
Current award number associated with the record. |
VARCHAR2 |
12 |
DEADLINE_TYPE_DESCRIPTION |
Description of deadline type. |
VARCHAR2 |
8 |
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 |
IDC_RATE_INDICATOR |
Indicator identifying whether idc rate (Y/N). |
VARCHAR2 |
1 |
INITIAL_CONTRACT_ADMIN |
Initial contract admin associated with the record. |
VARCHAR2 |
40 |
IP_REVIEWER |
Ip reviewer associated with the record. |
VARCHAR2 |
40 |
IP_REVIEW_ACTIVITY_INDICATOR |
Indicator identifying whether ip review activity (Y/N). |
VARCHAR2 |
1 |
IP_REVIEW_DESCRIPTION |
Description of ip review. |
VARCHAR2 |
200 |
IP_REVIEW_REQ_TYPE_CODE |
Code identifying ip review req type. |
NUMBER |
|
IS_ARRA_FUNDING |
Indicator identifying whether arra funding (Y/N). |
VARCHAR2 |
1 |
IS_SUBCONTRACT |
Indicator identifying whether subcontract (Y/N). |
VARCHAR2 |
1 |
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
MAIL_ACCOUNT_NUMBER |
Mail account number associated with the record. |
VARCHAR2 |
7 |
MAIL_BY |
Mail by associated with the record. |
VARCHAR2 |
1 |
MAIL_BY_DESCRIPTION |
Description of mail by. |
VARCHAR2 |
10 |
MAIL_TYPE |
Mail type associated with the record. |
VARCHAR2 |
1 |
MAIL_TYPE_DESCRIPTION |
Description of mail type. |
VARCHAR2 |
10 |
NOTICE_OF_OPPORTUNITY |
Notice of opportunity associated with the record. |
VARCHAR2 |
200 |
NOTICE_OF_OPPORTUNITY_CODE |
Code identifying notice of opportunity. |
VARCHAR2 |
3 |
NSF_CODE |
Code identifying nsf. |
VARCHAR2 |
15 |
NSF_CODE_DESCRIPTION |
Description of nsf code. |
VARCHAR2 |
200 |
NUMBER_OF_COPIES |
Number of copies associated with the record. |
NUMBER |
7 |
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
Osp proposal number associated with the record. |
VARCHAR2 |
8 |
OSP_PROPOSAL_TYPE |
Osp proposal type associated with the record. |
VARCHAR2 |
200 |
OSP_PROPOSAL_TYPE_CODE |
Code identifying osp proposal type. |
VARCHAR2 |
3 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
200 |
PRINCIPAL_INVESTIGATOR_ID |
Business identifier for the principal investigator. |
VARCHAR2 |
40 |
PRINCIPAL_INVESTIGATOR_NAME |
Principal investigator name associated with the record. |
VARCHAR2 |
90 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
13 |
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
PROPOSAL_CREATED_DATE |
Date associated with proposal created. |
DATE |
|
PROPOSAL_DEADLINE_DATE |
Date associated with proposal deadline. |
DATE |
|
PROPOSAL_DEADLINE_TYPE_CODE |
Code identifying proposal deadline type. |
VARCHAR2 |
1 |
PROPOSAL_STATUS |
Proposal status associated with the record. |
VARCHAR2 |
200 |
PROPOSAL_STATUS_CODE |
Code identifying proposal status. |
NUMBER |
|
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 |
|
REVIEW_RECEIVE_DATE |
Date associated with review receive. |
DATE |
|
REVIEW_RESULT_CODE |
Code identifying review result. |
NUMBER |
|
REVIEW_SUBMISSION_DATE |
Date associated with review submission. |
DATE |
|
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
|
SCIENCE_CODE_INDICATOR |
Indicator identifying whether science code (Y/N). |
VARCHAR2 |
1 |
SPECIAL_REVIEW_INDICATOR |
Indicator identifying whether special review (Y/N). |
VARCHAR2 |
1 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
SPONSOR_PROPOSAL_NUMBER |
Sponsor proposal number associated with the record. |
VARCHAR2 |
70 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
18 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
TYPE_OF_ACCOUNT_CODE |
Code identifying type of account. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |