OSP PENDING PROPOSALS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR_EFFORT |
XXX |
NUMBER |
5,2 |
CALENDAR_YEAR_EFFORT |
XXX |
NUMBER |
5,2 |
FACULTY_FLAG |
Flag identifying whether or not an employee is a member of the faculty (yes or no). |
VARCHAR2 |
1 |
HOME_UNIT |
The persons primary department. |
VARCHAR2 |
8 |
HOME_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
INITIAL_ALL_COST_AMOUNT |
XXX |
NUMBER |
28,7 |
INITIAL_DIRECT_COST_AMOUNT |
XXX |
NUMBER |
12,2 |
INITIAL_INDIRECT_COST_AMOUNT |
XXX |
NUMBER |
12,2 |
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
20 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
OSP_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
PERSON_ID |
XXX |
VARCHAR2 |
40 |
PERSON_NAME |
XXX |
VARCHAR2 |
200 |
PERSON_PROJECT_ROLE |
XXX |
VARCHAR2 |
60 |
PERSON_ROL |
XXX |
VARCHAR2 |
12 |
PI_NAME |
The full name of the project's Principal Investigator, in the format Last, First MI. |
VARCHAR2 |
90 |
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 |
20 |
PRIME_SPONSOR_COUNTRY_CODE |
XXX |
VARCHAR2 |
3 |
PRIME_SPONSOR_COUNTRY_NAME |
XXX |
VARCHAR2 |
255 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
200 |
PRIME_SPONSOR_TYPE |
Type of primary sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
PROPOSAL_CREATED_DATE |
XXX |
DATE |
|
PROPOSAL_STATUS |
XXX |
VARCHAR2 |
200 |
PROPOSAL_STATUS_CODE |
XXX |
NUMBER |
|
PROPOSAL_TYPE |
XXX |
VARCHAR2 |
200 |
PROPOSAL_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
REQUESTED_END_DATE_INITIAL |
XXX |
DATE |
|
REQUESTED_END_DATE_TOTAL |
XXX |
DATE |
|
REQUESTED_START_DATE_INITIAL |
XXX |
DATE |
|
REQUESTED_START_DATE_TOTAL |
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 |
20 |
SPONSOR_COUNTRY_CODE |
XXX |
VARCHAR2 |
3 |
SPONSOR_COUNTRY_NAME |
XXX |
VARCHAR2 |
255 |
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 |
SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
SUMMER_EFFORT |
XXX |
NUMBER |
5,2 |
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 |
TOTAL_ALL_COST_AMOUNT |
XXX |
NUMBER |
28,7 |
TOTAL_DIRECT_COST_AMOUNT |
XXX |
NUMBER |
12,2 |
TOTAL_EFFORT |
XXX |
NUMBER |
5,2 |
TOTAL_INDIRECT_COST_AMOUNT |
XXX |
NUMBER |
12,2 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
60 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |