Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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