OSP DEV PROPOSAL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEV_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
12 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
INST_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
PERSON_ID |
XXX |
VARCHAR2 |
40 |
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 |
PROPOSAL_CREATED_DATE |
XXX |
DATE |
|
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
9 |
PROPOSAL_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
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_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
20 |
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 |
UNIT_NUMBER |
XXX |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |