OSP NEGOTIATION DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LEAD_UNIT |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
NEGOTIATION_NUMBER |
XXX |
VARCHAR2 |
25 |
PI_NAME |
The full name of the project's Principal Investigator, in the format Last, First MI. |
VARCHAR2 |
100 |
PI_PERSON_ID |
XXX |
VARCHAR2 |
40 |
PI_ROLODEX_ID |
XXX |
NUMBER |
28 |
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 |
6 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
200 |
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 |
200 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |