• FUND_SPONSOR_CODE
• FUND_SPONSOR_DESC

Indexed - yes
Format - varchar2 (5)
May be null? no

The 5-character code that identifies the external organization that sponsors a fund. (The code comes from PennERA, the system used at Penn since August 26, 2003 to track information on sponsored project awards.) A fund is the unique identifier for a specific set of financial resources that needs tracking or management.

Codes less than or equal to 599999 were assigned to the sponsor by InfoEd (the vendor of the PennERA software). Codes greater than or equal to 60000 were assigned to the sponsor by the Office of Research Services.

See also LEGACY_FUND_SPONSOR_CODE.

Examples: 09470 (NATIONAL INSTITUTES OF HEALTH); 62776 (SOCIETY FOR AMBULATORY ANESTHESIA).

Values:
Refer to the FUND_SPONSORS table for values.

Indexed - no
Format - varchar2 (150)
May be null? yes

Identifies the sponsoring entity that corresponds to the FUND_SPONSOR_CODE. (This comes from PennERA, the system used at Penn since August 26, 2003 to track information on sponsored project awards.)

Examples: NATIONAL INSTITUTES OF HEALTH (09470); SOCIETY FOR AMBULATORY ANESTHESIA (62776).

Values:
Refer to the FUND_SPONSORS table for values.

Indexed - yes
Format - varchar2 (50)
May be null? yes

Values:
UPENN Commercial/Industrial
UPENN Federal
UPENN Foreign Governments
UPENN Foundations
UPENN Hospital/Medical Centers
UPENN Internal
UPENN Other
UPENN Other Non-Federal Governments
UPENN Other Non-Profit Organizations
UPENN Private Associations
UPENN Universities

Indexed - yes
Format - char (4)
May be null? yes

This code was formerly used in the General Ledger, and is currently used only in BRIM (the Billing and Receivables Information Management system used by the Office of Research Services).

See also FUND_SPONSOR_CODE.

Examples: 1110 (NATIONAL INSTITUTES OF HEALTH); 4306 (SOCIETY FOR AMBULATORY ANESTHESIA).

Values:
Refer to the LEGACY_FUND_SPONSORS table for values.