OSP PROPOSAL Table
OSP Proposals
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_TYPE |
Type of activity billed against this award (Example: fellowship, organized research, other) |
VARCHAR2 |
100 |
ACTIVITY_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
COST_SHARING_INDICATOR |
XXX |
VARCHAR2 |
2 |
CURRENT_AWARD_NUMBER |
XXX |
VARCHAR2 |
10 |
DEADLINE_TYPE_DESCRIPTION |
XXX |
VARCHAR2 |
15 |
GRAD_STUDENT_HEADCOUNT |
XXX |
VARCHAR2 |
3 |
GRAD_STUDENT_PERSON_MONTHS |
XXX |
NUMBER |
22 |
IDC_RATE_INDICATOR |
XXX |
VARCHAR2 |
2 |
INITIAL_CONTRACT_ADMIN |
XXX |
VARCHAR2 |
9 |
IP_REVIEWER |
XXX |
VARCHAR2 |
9 |
IP_REVIEW_ACTIVITY_INDICATOR |
XXX |
VARCHAR2 |
2 |
IP_REVIEW_DESCRIPTION |
XXX |
VARCHAR2 |
15 |
IP_REVIEW_REQ_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
IS_ARRA_FUNDING |
Funded by ARRA |
VARCHAR2 |
1 |
IS_SUBCONTRACT |
XXX |
VARCHAR2 |
1 |
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
MAIL_ACCOUNT_NUMBER |
XXX |
VARCHAR2 |
7 |
MAIL_BY |
XXX |
VARCHAR2 |
1 |
MAIL_BY_DESCRIPTION |
XXX |
VARCHAR2 |
15 |
MAIL_TYPE |
XXX |
VARCHAR2 |
1 |
MAIL_TYPE_DESCRIPTION |
XXX |
VARCHAR2 |
12 |
NOTICE_OF_OPPORTUNITY |
XXX |
VARCHAR2 |
100 |
NOTICE_OF_OPPORTUNITY_CODE |
XXX |
VARCHAR2 |
3 |
NSF_CODE |
A four digit alphanumeric code defining a field of research, from a categorization table created by the National Science Foundation. Example: "B.02" stands for "Chemistry - Physical Sciences." See also NSF_CODE_DESCRIPTION. |
VARCHAR2 |
15 |
NSF_CODE_DESCRIPTION |
The broad scientific category into which a particular research project falls, based on a coding system used by the National Science Foundation. Examples: "Chemical - Engineering," "Chemistry - Physical Sciences." Each description is associated with a four digit alphanumeric code. |
VARCHAR2 |
100 |
NUMBER_OF_COPIES |
XXX |
NUMBER |
22 |
OSP_PROPOSAL_KEY |
XXX |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
OSP_PROPOSAL_TYPE |
XXX |
VARCHAR2 |
100 |
OSP_PROPOSAL_TYPE_CODE |
XXX |
NUMBER |
22 |
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 |
5 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
60 |
PRINCIPAL_INVESTIGATOR_ID |
XXX |
VARCHAR2 |
9 |
PRINCIPAL_INVESTIGATOR_NAME |
XXX |
VARCHAR2 |
90 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
11 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
PROPOSAL_CREATED_DATE |
XXX |
DATE |
8 |
PROPOSAL_DEADLINE_DATE |
XXX |
DATE |
8 |
PROPOSAL_DEADLINE_TYPE_CODE |
XXX |
VARCHAR2 |
1 |
PROPOSAL_STATUS |
XXX |
VARCHAR2 |
100 |
PROPOSAL_STATUS_CODE |
XXX |
VARCHAR2 |
3 |
REQUESTED_END_DATE_INITIAL |
XXX |
DATE |
8 |
REQUESTED_END_DATE_TOTAL |
XXX |
DATE |
8 |
REQUESTED_START_DATE_INITIAL |
XXX |
DATE |
8 |
REQUESTED_START_DATE_TOTAL |
XXX |
DATE |
8 |
REVIEW_RECEIVE_DATE |
XXX |
DATE |
8 |
REVIEW_RESULT_CODE |
XXX |
VARCHAR2 |
3 |
REVIEW_SUBMISSION_DATE |
XXX |
DATE |
8 |
ROLODEX_ID |
XXX |
VARCHAR2 |
6 |
SCIENCE_CODE_INDICATOR |
XXX |
VARCHAR2 |
2 |
SPECIAL_REVIEW_INDICATOR |
XXX |
VARCHAR2 |
2 |
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 |
60 |
SPONSOR_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
70 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
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 |
50 |
TYPE_OF_ACCOUNT_CODE |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |