Penn Computing

University of Pennsylvania
Penn Computing << go backback
AGENCY Table   Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

AGENCY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

 

Data element Definition
AGENCY_CODE

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

The 4-character code that identifies an agency to which a proposal has been sent, or from which an award has been received. Example: 1043 (Peace Corps). Agency codes that are made up of numerals are BEN Financials fund sponsor codes. Agency codes that begin with letters are translations of the 5-character agency codes used before November 24, 1997 for Sponsored Projects data in the Warehouse. Agency codes that begin with a letter ('X', 'Y', or 'Z') refer only to agencies that sponsored projects before July 1, 1996 and that are not included in the BEN Financials Fund Sponsor Codes table because the agencies no longer exist.


Values:

Refer to the AGENCY Table for values.

AGENCY_NAME

Indexed - no
Format - char (70)
May be null? yes

The 70-character name of the sponsoring agency that provides the financial support for the project. Example: PEACE CORPS (1043


Values:

Refer to the AGENCY Table for values.
PARENT_AGENCY_CODE

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

The 4-character code indicating the group of agencies to which this agency belongs. (For agencies that do not belong to a group, the value for PARENT_AGENCY_CODE will be the same as for AGENCY_CODE.) Example: 1110 (NATIONAL INSTITUTES OF HEALTH)


Values:

Refer to the AGENCY Table for values.

 

AGENCY Table   Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania