SPONSOR Table
Contains data about each sponsor.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMINISTERING_ACTIVITY |
Associated with Federal Sponsors. Identifies what branch. |
VARCHAR2 |
30 |
AUDIT_REPORT_SENT_FOR_FY |
Identifies whether or not an audit report has been sent to the sponsor for the fiscal year. |
VARCHAR2 |
4 |
CAGE_NUMBER |
Sponsor CAGE code from COEUS |
VARCHAR2 |
20 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
COUNTRY_NAME |
The long name of the country (Example United States, France) |
VARCHAR2 |
40 |
DUN_AND_BRADSTREET_NUMBER |
Dun and Bradstreet Number. |
VARCHAR2 |
9 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
ROLODEX_ID |
XXX |
VARCHAR2 |
6 |
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_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
10 |
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_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
SPONSOR_TYPE_CODE |
Numerical code identifing the type of sponsor (Example: 0 - Federal, 3 - Private-Pofit, 4 - Private-Non-Profit, 1 - State, etc?.) |
VARCHAR2 |
2 |
STATE |
State. |
VARCHAR2 |
30 |
UEI |
XXX |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |