Penn Computing

University of Pennsylvania
Penn Computing << go backback
PENNERA_PROPOSAL_INTL_LOCATION Table   Tables and Data Elements   PennERA Proposals Home   Data Warehouse Home

PENNERA_PROPOSAL_INTL_LOCATION Table - Data Element Index

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

 

Data element Definition
COUNTRY_OF_ACTIVITY

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

The name of the country (other than the United States of America) where some or all of the proposal's international activities take place. The value is stored in mixed case, and may be up to 100 characters long.

There is one PENNERA_PROPOSAL_INTL_LOCATION
record per proposal (INSTITUTION_NO) per COUNTRY_OF_ACTIVITY. A proposal with international activities may have one or more countries of activity.

The data for the COUNTRY_OF_ACTIVITY is available only for proposals that: (1) entail activities occurring outside the United States of America, (2) were created using PennERA's Proposal Development (PD) module, and (3) include a Certification by Principal Investigator that was completed after April 19, 2010. (Before then, PennERA did not capture data for this field.) PENNERA_PROPOSAL.PD_FLAG indicates whether or not the proposal was created using PD. The Data Warehouse does not store information on when the Certification by Principal Investigator was completed.

Examples: 'Australia'; 'Trinidad & Tobago', 'China (including Hong Kong)', 'Democratic Republic of the Congo'

Values:
List of values not available

PennERA source (assuming the proposal record has been opened in the Proposal Development module): Finalize; Submit for Internal Review section; Certification by Principal Investigator; International Activities section; Countries with Activity

INSTITUTION_NO

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

The eight-digit sequence number used by the University to uniquely identify the proposal whose work entails activities occurring in the COUNTRY_OF_ACTIVITY. Note that the value for INSTITUTION_NO includes leading zeroes.

There is one PENNERA_PROPOSAL_INTL_LOCATION
record per proposal (INSTITUTION_NO) per COUNTRY_OF_ACTIVITY. A proposal with international activities may have one or more countries of activity.

The PENNERA_PROPOSAL_INTL_LOCATION table stores data only for proposals that: (1) entail activities occurring outside the United States of America, (2) were created using PennERA's Proposal Development (PD) module, and (3) include a Certification by Principal Investigator that was completed after April 19, 2010. (Before then, PennERA did not capture data for this field.) PENNERA_PROPOSAL.PD_FLAG indicates whether or not the proposal was created using PD. The Data Warehouse does not store information on when the Certification by Principal Investigator was completed.

Example: '10027459'

Values:
List of values not available

PennERA source (assuming the proposal record has been opened in the Proposal Development module): any screen for the proposal; the Proposal Header (unlabelled, stationary section at the top of the screen); the number in the Proposal box in the upper right corner of the screen

REGION_OF_ACTIVITY

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

The name of the region of the world that includes the COUNTRY_OF_ACTIVITY, where some or all of the proposal's international activities take place. The value for REGION_OF_ACTIVITY is stored in mixed case, and may be up to 200 characters long.

There is one PENNERA_PROPOSAL_INTL_LOCATION
record per proposal (INSTITUTION_NO) per COUNTRY_OF_ACTIVITY. A proposal with international activities may have one or more countries of activity. A region includes multiple countries; a country is located within a single region.

The data for the REGION_OF_ACTIVITY is available only for proposals that: (1) entail activities occurring outside the United States of America, (2) were created using PennERA's Proposal Development (PD) module, and (3) include a Certification by Principal Investigator that was completed after April 19, 2010. (Before then, PennERA did not capture data for this field.) PENNERA_PROPOSAL.PD_FLAG indicates whether or not the proposal was created using PD. The Data Warehouse does not store information on when the Certification by Principal Investigator was completed.

Values:
Central America and the Caribbean
East Asia and the Pacific
Europe (Including Iceland and Greenland)
Middle East and North Africa
North America
Russia and the Newly Independent States
South America
South Asia
Sub-Saharan Africa

 

PENNERA_PROPOSAL_INTL_LOCATION Table   Tables and Data Elements  PennERA Proposals 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