SPONSOR HIERARCHY HISTORY Table
Historic data for sponsor hierarchy maintained in COEUS.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
DODAC_NUMBER |
Sponsor DODAC number from COEUS |
VARCHAR2 |
20 |
DUNS_PLUS_FOUR_NUMBER |
Duns plus four number from COEUS |
VARCHAR2 |
20 |
DUN_AND_BRADSTREET_NUMBER |
Dun and Bradstreet Number. |
VARCHAR2 |
9 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
HIERARCHY_NAME |
The name of the Sponsor Hierarchy |
VARCHAR2 |
100 |
OWNED_BY_UNIT |
XXX |
VARCHAR2 |
8 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
ROLODEX_ID |
XXX |
VARCHAR2 |
6 |
SPONSOR_ACRONYM |
Sponsor acronym |
VARCHAR2 |
10 |
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_FY_KEY |
XXX |
VARCHAR2 |
14 |
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 |
SP_LEVEL1_CATEGORY |
The name assigned to level 1 node of the sponsor hierarchy |
VARCHAR2 |
50 |
SP_LEVEL1_SORT |
Sort ID used to specify the order of SP_CATEGORY1 in reports. |
NUMBER |
22 |
SP_LEVEL2_CATEGORY |
The name assigned to level 2 node of the sponsor hierarchy |
VARCHAR2 |
50 |
SP_LEVEL2_SORT |
Sort ID used to specify the order of SP_CATEGORY2 in reports. |
NUMBER |
22 |
SP_LEVEL3_CATEGORY |
The name assigned to level 3 node of the sponsor hierarchy |
VARCHAR2 |
50 |
SP_LEVEL3_SORT |
Sort ID used to specify the order of SP_CATEGORY3 in reports. |
NUMBER |
22 |
SP_LEVEL4_CATEGORY |
The name assigned to level 4 node of the sponsor hierarchy |
VARCHAR2 |
50 |
SP_LEVEL4_SORT |
Sort ID used to specify the order of SP_CATEGORY4 in reports. |
NUMBER |
22 |
SP_LEVEL5_CATEGORY |
The name assigned to level 5 node of the sponsor hierarchy |
VARCHAR2 |
50 |
SP_LEVEL5_SORT |
Sort ID used to specify the order of SP_CATEGORY5 in reports. |
NUMBER |
22 |
STATE |
State. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |