Penn Computing

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

PENNERA_INCREMENT Table - Data Element Index

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

 

Data element Definition
ACCOUNT_END

Indexed - no
Format - date
May be null? yes

The last date when the fund code specified as the AWARD_FUND may be used to track financial activity for the sponsored research project. Some sponsors have financial reporting requirements that allow the same fund code to be used throughout the awarded project period (also known as the funding cycle—see PENNERA_PROPOSAL’s AWARDED_PROJECT_START and AWARDED_PROJECT_END). Other sponsors have financial reporting requirements that allow the fund code to be used for only for one budget period. See also ACCOUNT_START, AWARDED_PERIOD_START_DATE, and AWARDED_PERIOD_END_DATE. (Unlike AWARDED_PERIOD_START_DATE, ACCOUNT_END does not necessarily change as additional funding segments are received.)

Example: 1/31/2007

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Account End

ACCOUNT_RESP_INVESTIGATOR

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

The Penn ID of the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT. The account responsible investigator is one of the investigators associated with the proposal. However, it may or may not be the same person as the Principal Investigator for the proposal.

See also PI_PENN_ID, PARENT_PI_PENN_ID, and FUND_RESP_INVESTIGATOR

Example: 10108345 (LAUFER,TERRI M)

Values:
Refer to the PENNERA_PEOPLE table for values.

PennERA source: Proposal Tracking module; Awarded detail screen; the PennID of the person named under the Personnel tab whose role is 'Primary Investigator' (or, if there is no 'Primary Investigator', the person who is listed first)

ACCOUNT_START

Indexed - no
Format - date
May be null? yes

The first date when the fund code specified as the AWARD_FUND may be used to track financial activity for the sponsored research project. Some sponsors have financial reporting requirements that allow the same fund code to be used throughout the awarded project period (also known as the funding cycle—see PENNERA_PROPOSAL’s AWARDED_PROJECT_START and AWARDED_PROJECT_END). Other sponsors have financial reporting requirements that allow the fund code to be used for only for one budget period. See also ACCOUNT_START, AWARDED_PERIOD_START_DATE, and AWARDED_PERIOD_END_DATE.

Example: 2/15/2002

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Account End

ACCTRESPINV_ERA_PRI_ORG_CODE

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

The 4-character code for the ERA primary organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR. That is the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The ERA primary org. is the org. flagged as the primary department in the person’s PennERA Profile. Although it is used to secure certain data elements in the Data Warehouse, the ERA primary org. is not used by the University’s business processes.

For Penn staff, the ERA primary org. is the primary (job) appointment org. For Penn faculty, it is the primary academic (job) appointment org., which will not be the same as primary appointment org. for those faculty holding administrative positions. For Penn employees whose job appointments are all on the executive payroll, ERA primary org. is ‘8000’ ('General University Special '). For Penn students, the ERA primary org. is the organizational equivalent of their home Division (for example, ‘0200’, School of Arts and Sciences.) For investigators from the University of Pennsylvania Health System (UPHS), the ERA primary org. is ‘2100’ ('Health System '). For members of the research community who are otherwise not affiliated with Penn, the ERA primary org. is ‘8760' ('Research Services').

ACCTRESPINV_ERA_PRI_ORG_CODE reflects the ERA primary org. of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_ERA_PRI_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.)

To facilitate Organization-based security, ACCTRESPINV_ERA_PRI_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR.ERA_PRIMARY_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_ERA_PRI_SCH_CODE

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

The 2-character code for the school or center for the ACCTRESPINV_ERA_PRI_ORG_CODE. That identifies the ERA primary organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR--the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The ERA primary org. is the org. flagged as the primary department in the person’s PennERA Profile. Although it is used to secure certain data elements in the Data Warehouse, the ERA primary org. is not used by the University’s business processes.

ACCTRESPINV_ERA_PRI_SCH_CODE reflects the ERA primary school of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_ERA_PRI_SCH_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.)

If the ACCTRESPINV_ERA_PRI_ORG_CODE is '.', the ACCTRESPINV_ERA_PRI_SCH_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same 
as the first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR.ERA_PRIMARY_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_HOME_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code for the home organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR. That is the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The home org. is the org. that owns the person's University employee record and is responsible for its maintenance.

ACCTRESPINV_HOME_ORG_CODE reflects the home org. of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_HOME_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If the ACCOUNT_RESP_INVESTIGATOR has no employee information dating back to the time of the funding cycle, ACCTRESPINV_HOME_ORG_CODE is '.'. (Because the ACCTRESPINV_HOME_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR.HOME_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_HOME_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code for the school or center for the ACCTRESPINV_HOME_ORG_CODE. That is the home organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR--the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The home org. is the org. that owns the person's University employee record and is responsible for its maintenance.

ACCTRESPINV_HOME_SCH_CODE reflects the home school of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_HOME_SCH_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If the ACCOUNT_RESP_INVESTIGATOR has no employee information dating back to the time of the funding cycle, ACCTRESPINV_HOME_SCH_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. The 
code for a school or center is the same as the 
first 2 characters of the CNAC.
Source: PENNERA_PROPOSAL_INVESTIGATOR.HOME_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR
ACCTRESPINV_INV_ORG_CODE

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

The 4-character code for the investigator organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR. That is the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

Although it is used to secure certain data elements in the Data Warehouse, the investigator org. is not used by the University’s business processes.

For a given investigator associated with an increment, the investigator org. is the org. specified as the Associated Department for the increment (the INCREMENT_RESP_ORG_CODE). An exception to this rule is that, if the INCREMENT_RESP_ORG_CODE is neither the investigator's ERA primary org. nor an org. where the investigator has a job appointment, when the investigator's data is entered for the increment in PennERA, the investigator org. is chosen from among those orgs., based on its being the one that is most closely related to the INCREMENT_RESP_ORG_CODE. In other words:

  • if the investigator has only one org, then that org. is chosen; otherwise,
  • if the investigator has an org. that is the same as the INCREMENT_RESP_ORG_CODE, then that org. is chosen; otherwise
  • the investigator's orgs. are sorted in ascending order, and the first org. whose org. code is greater than or equal to the INCREMENT_RESP_ORG_CODE is chosen; otherwise,
  • if the investigator has no org. whose org. code is greater than or equal to the INCREMENT_RESP_ORG_CODE, the investigator's ERA primary org. is chosen

To facilitate Organization-based security, ACCTRESPINV_INV_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

PennERA source: Proposal Tracking module; specify the Institution Number for the proposal to which the increment applies; Summary screen; Investigator tab; the code in the Department column for the person who is the investigator responsible for the increment. (PennERA source for the investigator responsible for the increment: Proposal Tracking module; specify the Institution Number for the proposal to which the increment applies; Awarded screen; view or edit the increment under the Awards tab; Awarded detail screen; the PennID of the person named under the Personnel tab whose role is 'Primary Investigator' [or, if there is no 'Primary Investigator', the person who is listed first])

ACCTRESPINV_INV_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code for the school or center for the ACCTRESPINV_INV_ORG_CODE. That is the investigator organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR--the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

Although it is used to secure certain data elements in the Data Warehouse, the investigator org. is not used by the University’s business processes.

If the ACCTRESPINV_INV_ORG_CODE is '.', the ACCTRESPINV_INV_SCH_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. The 
code for a school or center is the same as the 
first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR.INVESTIGATOR_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_PRI_APPT_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code for the organization (‘org.’) of the primary job appointment for the person identified by the ACCOUNT_RESP_INVESTIGATOR. That is the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The primary appointment org. is the org. where the person has his or her primary job appointment, per the University’s employee census logic. The logic used to determine a University employee's primary appointment is documented in the cautions for the EMPLOYEE_GENERAL table.

ACCTRESPINV_PRI_APPT_ORG_CODE reflects the primary appointment org. of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_PRI_APPT_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If the ACCOUNT_RESP_INVESTIGATOR has no employee information dating back to the time of the funding cycle, ACCTRESPINV_PRI_APPT_ORG_CODE is '.'. (Because the ACCTRESPINV_PRI_APPT_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR.PRIMARY_APPT_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_PRI_APPT_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code for the school or center for the ACCTRESPINV_PRI_APPT_ORG_CODE. That is the investigator organization (‘org.’) for the person identified by the ACCOUNT_RESP_INVESTIGATOR--the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The primary appointment org. is the org. where the person has his or her primary job appointment, per the University’s employee census logic. The logic used to determine a University employee's primary appointment is documented in the cautions for the EMPLOYEE_GENERAL table.

ACCTRESPINV_PRI_APPT_SCH_CODE reflects the primary appointment school of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_PRI_APPT_SCH_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If ACCOUNT_RESP_INVESTIGATOR has no employee information dating back to the time of the funding cycle, ACCTRESPINV_PRI_APPT_SCH_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same 
as the first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR.PRIMARY_APPT_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_PRIACADAP_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code for the organization (‘org.’) of the primary academic job appointment for the person identified by the ACCOUNT_RESP_INVESTIGATOR. That is the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The primary academic appointment org. is the org. where the person has his or her primary academic job appointment at the University. If the person has more than one academic job appointment, the primary academic appointment is the one with the most important faculty class. For further information on how the primary academic appointment is determined, see the explanation in the Cautions section of the documentation for the EMPLOYEE_GENERAL table.

ACCTRESPINV_PRIACADAP_ORG_CODE reflects the primary academic appointment org. of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_PRIACADAP_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If the ACCOUNT_RESP_INVESTIGATOR has no employee information about a faculty job appointment dating back to the time of the funding cycle, ACCTRESPINV_PRIACADAP_ORG_CODE is '.'. (Because the ACCTRESPINV_PRIACADAP_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR.PRIMARY_ACADEMIC_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

ACCTRESPINV_PRIACADAP_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code for the school or center for the ACCTRESPINV_PRIACADAP_ORG_CODE. That is the organization (‘org.’) of the primary academic job appointment for the person identified by the ACCOUNT_RESP_INVESTIGATOR--the investigator responsible for managing the funding tracked by the AWARD_GL_ACCOUNT, at the time of the increment. (The ACCOUNT_RESP_INVESTIGATOR might or might not be the Principal Investigator for the proposal to which the increment applies.)

The primary academic appointment org. is the org. where the person has his or her primary academic job appointment. If the person has more than one academic job appointment, the primary academic appointment is the one with the most important faculty class. For further information on the primary academic appointment, see the explanation in the Cautions section of the documentation for the EMPLOYEE_GENERAL table.

ACCTRESPINV_PRIACADAP_SCH_CODE reflects the primary academic appointment school of the ACCOUNT_RESP_INVESTIGATOR, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the ACCTRESPINV_PRIACADAP_SCH_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL record for the INSTITUTION_NO. (If the proposal was not awarded, the dates for the funding cycle are the REQUESTED_PROJECT_START and REQUESTED_PROJECT_END.) If the ACCOUNT_RESP_INVESTIGATOR has no employee information about a faculty job appointment dating back to the time of the funding cycle, ACCTRESPINV_PRIACADAP_SCH_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same 
as the first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR.PRIMARY_ACADEMIC_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR.PENN_ID = PENNERA_INCREMENT.ACCOUNT_RESP_INVESTIGATOR

AIS_ISSUE_DATE

Indexed - no
Format - date
May be null? yes

The date when the Award Information Sheet (AIS) for the increment was last printed by the PennERA Proposal Tracking system. The value may be null.

When an increment is received, Research Services prepares an AIS that provides information specific to the General Ledger account (AWARD_GL_ACCOUNT) used to track the increment, as well as general award information that is relevant to all accounts associated with an award.
The AIS is provided to the PI, the award responsible investigator, and to administrators as notification that the award has been recorded within PennERA and a fund and account have been assigned within BEN.

AIS_ISSUE_DATE is populated only for increments whose records were entered or updated since October 14, 2003. The value is null for all other records.

Example: 01/22/2003

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded detail screen; Misc. Award Information tab; Last AIS Printed Date

ARRA_FUNDED_INCREMENT_FLAG

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

A Yes/No flag indicating whether the AWARDED_TOT_SPON_COSTS for the increment were awarded under ARRA (the American Recovery and Reinvestment Act of 2009, also known as the Recovery Act or the federal economic stimulus program). A proposal with awarded ARRA funding might or might not also have other (non-ARRA) awarded funding. Increments of ARRA funding are flagged so that the University can satisfy the reporting requirements specified under federal regulations for ARRA funding recipients.

Note: some increments whose ARRA_FUNDED_INCREMENT_FLAG is 'Y' might have a status other than 'Awarded'. Depending on the requirements of a particular report on ARRA increments, you might or might not want to specify a condition on INCREMENT_STATUS.

See also ARRA_SUBMISSION_FLAG, ARRA_AWARD_FLAG, and PROJECT_MAJOR_GOALS in the PENNERA_PROPOSAL table.

Values:
Y yes, the increment's AWARDED_TOT_SPON_COSTS 
  were awarded under ARRA
N no, the increment's AWARDED_TOT_SPON_COSTS 
  were not awarded under ARRA
PennERA source (assuming the proposal record has been opened in the Proposal Tracking module): Budget; Awarded; view the Award Information for the increment; on the Detail screen, in the Misc. Award Information section: ARRA (Stimulus) Funded Increment
AWARD_BC

Indexed - no
Format - char (1)
May be null? yes
The budgetary control character that represents the level at which funds availability checking occurs in the General Ledger for transactions involving the AWARD_GL_ACCOUNT.

AWARD_BC is the third segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.) For awards that were active on or after July 1, 1996, AWARD_BC is ‘4’ (CNAC/ORG/FUND/CREF Project-to-Date).

For awards that were not active July 1, 1996 and thereafter, AWARD_BC is null.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 3rd segment in the Account # field

AWARD_CNAC

Indexed - yes
Format - char (3)
May be null? yes
The 3-character Center/Net Asset Class code. The first two positions identify the school or center responsible for managing all of the money tracked by the AWARD_GL_ACCOUNT. The last position identifies the net asset class of the money tracked by the AWARD_GL_ACCOUNT. For an AWARD_CNAC, the net asset class is always 0 (Unrestricted).

AWARD_CNAC is the first segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.)

For awards that were not active July 1, 1996 and thereafter, AWARD_CNAC is null. For such records, an approximation of AWARD_CNAC would be the INCREMENT_RESP_SCHOOL_CODE | ‘0’.

Example: 400 (School of Medicine, Unrestricted)

Values:
Refer to the CNAC_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 1st segment in the Account # field

AWARD_CREF

Indexed - yes
Format - char (4)
May be null? yes
The 4-character center reference code that identifies the school- or center-specific individual or group using the money tracked by the AWARD_GL_ACCOUNT. The center reference code is a unique identifier defined by each School or Center, and used to record information important to a school or center, but inappropriate for any other segment of the Accounting Flexfield. Note that while a given center reference code has a unique meaning within a school or center, it has different meanings to different schools or centers.

AWARD_CREF is the sixth segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.) For awards that were not active July 1, 1996 and thereafter, AWARD_CREF is null.

Examples: 2141 (‘LAUFER, TERRI M’--center 40); 2141 ('AMERICAN CIVILIZATION'--center 02)

Values:
Refer to the CENTER_REF_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 7th (last) segment in the Account # field

AWARD_DATE

Indexed - no
Format - date
May be null? yes

The official date on which the increment was awarded by the sponsor to the University.

If the INCREMENT_STATUS is ‘Advance Account’, the AWARD_DATE is the date the advance account was requested (per the completed Advance Account Request form). If the INCREMENT_STATUS is ‘Future’, the AWARD_DATE is the date on the Notice of Award (NOA). If the INCREMENT_STATUS is ‘Awarded’, the AWARD_DATE is the date on the NOA (or, if there is no NOA, the date on the award check).

Example: 01/17/2003

Values:
List of values not available.

PennERA source (assuming the proposal record has been opened in the Proposal Tracking module): General screen; Budget screen; Awarded screen; screen for the selected increment; Award Detail section; the value for Awarded

AWARD_FUND

Indexed - yes
Format - char (6)
May be null? yes
The 6-character code identifying the fund to which the increment has been assigned. A fund uniquely identifies a specific set of financial resources that needs tracking or management. Funds for sponsored projects begin with ‘5’.

AWARD_FUND is the fourth segment of the
AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.) For awards that were not active July 1, 1996 and thereafter, AWARD_FUND is null.

As of October 14, 2003, a fund may be used by one and only one proposal (INSTITUTION_NO). A proposal whose activity ended before that date might have a fund that was used by another proposal whose activity ended before that date, but such a fund is now disabled.

See also FUND_RESPONSIBLE_ORG.

Examples: 537997 ( '5-R01-AI48117-02'); 541102 ('2003-2005 SCHOLAR AWARD')

Values:
Refer to the FUND_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 4th segment in the Account # field

AWARD_GL_ACCOUNT

Indexed - yes
Format - char (26)
May be null? yes
The seven-segment (26-position) Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.)

AWARD_GL_ACCOUNT is an Accounting Flexfield used in the present General Ledger accounting structure (in use at Penn since July 1, 1996). It is populated only for awards that were active July 1, 1996 and thereafter; it is null for awards that were closed by July 1, 1996.

See also AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_OBJECT, AWARD_PROGRAM, AWARD_CREF, and AWARD_LEGACY_ACCOUNT.

Example: 40042614537997300024592141.

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; Account #

AWARD_LEGACY_ACCOUNT

Indexed - yes
Format - char (6)
May be null? yes
A 6-digit number that identifies the account assigned to the increment, in the format used in the financial system that was used before July 1, 1996. The first digit of the AWARD_LEGACY_ACCOUNT is known as the ledger number. All Sponsored Project legacy account numbers begin with the ledger number five.

See also AWARD_GL_ACCOUNT

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; Fund/Acct Setup button; Accounts tab; Legacy #

AWARD_OBJECT

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code that identifies an asset, liability, revenue, or expense.

AWARD_OBJECT is the fifth segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.) For awards that were active on or after July 1, 1996, AWARD_OBJECT is ‘3000’ (FUND BAL). For awards that were not active July 1, 1996 and thereafter, AWARD_OBJECT is null.

Values:
Refer to the OBJECT_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 5th segment in the Account # field

AWARD_ORG

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code for the Organization responsible for managing all of the money tracked by the AWARD_GL_ACCOUNT. An Organization is a subdivision of the University created for management purposes. An Organization belongs to only one responsibility center, and its Organization code is unique. That is, no two Organizations have the same value for AWARD_ORG.

AWARD_ORG is the second segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.)

For awards that were not active July 1, 1996 and thereafter, AWARD_ORG is null. For such records, an approximation of AWARD_ORG would be the INCREMENT_RESP_ORG_CODE.

To facilitate Organization-based security, AWARD_ORG is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 2nd segment in the Account # field

AWARD_PROGRAM

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code that identifies the program using the money tracked by the AWARD_GL_ACCOUNT. A program is an activity or work process commonly defined across the University so that the program's activity can be tracked across Schools and Centers (or across organizations within a school or center).

AWARD_PROGRAM is the sixth segment of the AWARD_GL_ACCOUNT, the seven-segment Accounting Flexfield assigned to the increment. (The AWARD_CNAC, AWARD_ORG, AWARD_BC, AWARD_FUND, AWARD_PROGRAM, and AWARD_CREF should always be used when posting transactions for the increment, but BEN Financials will accept postings to any combination that includes the AWARD_FUND.)
For awards that were not active July 1, 1996 and thereafter, AWARD_PROGRAM is null.

Example: 2459 (Immunology)

Values:
Refer to the PROGRAM_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; 6th segment in the Account # field

AWARD_TYPE

Indexed - no
Format - varchar2 (29)
May be null? yes
The type of increment.

Examples: New Project, Supplement

Values:
Change of Grantee Institution
Competing Renewal
Cost Sharing
Extension
New Project
Non-Competing Continuation
Revised Budget
Revision
Supplement

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; Type

AWARDED_COST_SHR_CASH

Indexed - no
Format - number (13,2)
May be null? yes
Not currently used
AWARDED_COST_SHR_IN_KIND

Indexed - no
Format - number (13,2)
May be null? yes
Not currently used
AWARDED_COST_SHR_OTHER

Indexed - no
Format - number (13,2)
May be null? yes
Not currently used
AWARDED_COST_SHR_TOTAL

Indexed - no
Format - number (13,2)
May be null? yes

The total dollar amount of cost sharing associated with the increment. Cost sharing is the amount of funding provided for the sponsored project that does not come from the sponsor. AWARDED_COST_SHR_TOTAL is the total amount of cost sharing to be provided by all cost sharing sources combined. For example, the University receives a grant for a project estimated to have a total cost of $100,000. The sponsor agrees to pay 75% ($75,000) and the University agrees to pay 25% ($25,000). The $25,000 is the cost-sharing component.

To see whether the amount entered as AWARD_COST_SHR_TOTAL applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

AWARDED_COST_SHR_TOTAL is populated only for increments whose records were entered or updated since October 14, 2003. The value is null for all other records.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; the sum of the Total Costs row for all cost sharing source columns, combined

AWARDED_DIRECT_COSTS

Indexed - no
Format - number (13,2)
May be null? yes
Total dollar amount designated to be paid by the sponsor for direct costs for the increment. Direct costs are clearly identifiable costs related to a specific project. (For example, salaries, wages, and equipment fall under direct costs.)

AWARDED_DIRECT_COSTS + AWARDED_INDIRECT_COSTS =
AWARDED_TOT_SPON_COSTS

To see whether the amount entered as AWARDED_DIRECT_COSTS applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; Project column, Direct Costs row

AWARDED_INDIRECT_COSTS

Indexed - no
Format - number (13,2)
May be null? yes
Total dollar amount designated to be paid by the sponsor for indirect costs for the increment. Indirect costs are costs that are not specific to the sponsored project, but that are incurred by the University in support of the sponsored project. (For example, utilities and laboratory space fall under indirect costs.) Indirect costs are also known as Facilities and Administrative (F&A) costs or overhead.

AWARDED_DIRECT_COSTS + AWARDED_INDIRECT_COSTS =
AWARDED_TOT_SPON_COSTS

To see whether the amount entered as AWARDED_INDIRECT_COSTS applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

See also AWARDED_MTDC

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; Project column, Indirect Costs row

AWARDED_MTDC

Indexed - no
Format - number (13,2)
May be null? yes
Not currently used.

Total dollar amount designated for the modified total direct costs (MTDC) for the increment. For some awards, the indirect costs are calculated based on MTDC, a subset of direct costs, normally excluding--among other costs--equipment, patient care, space rental, alterations and renovations, and subcontract costs in excess of the first $25,000. When modified total direct costs are used, AWARDED_INDIRECT_COSTS is calculated by multiplying the MTDC by the F & A rate (indirect cost rate).

AWARDED_MTDC is populated only for increments whose records were entered or updated since October 14, 2003. The value is null for all other records.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; Project column, MTDC row

AWARDED_NONSPON_COSTS

Indexed - no
Format - number (13,2)
May be null? yes
Total dollar amount designated for non-sponsor costs for the increment. The non-sponsor costs are the total costs (direct and indirect) that are paid for by funding sources other than the sponsor. Non-sponsor costs are also known as cost sharing.

AWARDED_NONSPON_COSTS + AWARDED_TOT_SPON_COSTS =
AWARDED_TOTAL_COSTS

To see whether the amount entered as AWARDED_NONSPON_COSTS applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; Award Period Costs tab; Non-Sponsor Costs column for the Totals row

AWARDED_PERIOD_END_DATE

Indexed - no
Format - date
May be null? yes

The ending date for the budget period to which the increment applies, as defined by the sponsor. The budget period is a discrete period of time for which a sponsor has committed funds that can be expended by the University for the sponsored project.

Example: 01/31/2004

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded screen; Awarded Period Dates tab; End Date where the Period is the one for the increment

AWARDED_PERIOD_END_FY

Indexed - no
Format - char (4)
May be null? yes
The fiscal year at Penn in which the AWARDED_PERIOD_END_DATE falls. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.

Example: 2004 (for an award whose
AWARDED_PERIOD_END_DATE is December 31, 2003)

Values:
List of values not available.
AWARDED_PERIOD_START_DATE

Indexed - no
Format - date
May be null? yes
The beginning date for the budget period to which the increment applies, as defined by the sponsor. The budget period is a discrete period of time for which a sponsor has committed funds that can be expended by the University for the sponsored project.

Example: 02/01/2003

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded screen; Awarded Period Dates tab; Start Date where the Period is the one for the increment

AWARDED_PERIOD_START_FY

Indexed - no
Format - char (4)
May be null? yes
The fiscal year at Penn in which the AWARDED_PERIOD_START_DATE falls. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.

Example: 2004 (for an award whose
AWARDED_PERIOD_START_DATE is July 1, 2003)

Values:
List of values not available.
AWARDED_TOT_SPON_COSTS

Indexed - no
Format - number (13,2)
May be null? yes

Total dollar amount designated for sponsor costs for the increment. The sponsor costs are the total costs (direct and indirect) that are paid for by the sponsor.

AWARDED_DIRECT_COSTS + AWARDED_INDIRECT_COSTS =
AWARDED_TOT_SPON_COSTS

AWARDED_NONSPON_COSTS + AWARDED_TOT_SPON_COSTS =
AWARDED_TOTAL_COSTS

To see whether the amount entered as AWARDED_TOT_SPON_COSTS applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; sponsor column, Total Costs row

AWARDED_TOTAL_COSTS

Indexed - no
Format - number (13,2)
May be null? yes

The total dollar amount of all costs (direct and indirect) associated with the increment that are paid for by all funding sources combined.

AWARDED_NONSPON_COSTS + AWARDED_TOT_SPON_COSTS =
AWARDED_TOTAL_COSTS

To see whether the amount entered as AWARDED_TOTAL_COSTS applies to an advance account, an award, or an award expected in the future, see INCREMENT_STATUS.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Totals tab; upper (Project) section; Project column, Total Costs row

CURRENT_AWARDED_FLAG

Indexed - no
Format - char (1)
May be null? yes
A flag that indicates whether the budget period to which the increment applies is the current awarded budget period (‘C’), or a past (‘P’) or future (‘F’) period.
Values:
C the increment applies to the current budget period (the one whose awarded period start and end dates include the LAST_EXTRACT_DATE, the date when the record was exported to the Warehouse), and that budget period has at least one increment whose INCREMENT_STATUS = 'Awarded'
F the increment applies to a future period (one whose awarded period start date falls after the LAST_EXTRACT_DATE), and that budget period has at least one increment whose INCREMENT_STATUS = 'Awarded'
P the increment applies to a past period (one whose awarded period end date falls before the LAST_EXTRACT_DATE), and that budget period has at least one increment whose INCREMENT_STATUS = 'Awarded'
[null] the increment applies to a period that has no awarded period start date, or no awarded period end date, or no increments whose INCREMENT_STATUS = 'Awarded'
FED_FY_AWD_APPROPRIATION

Indexed - no
Format - char (4)
May be null? yes
The U.S. federal fiscal year whose budget includes the appropriation of funding for the increment. The federal fiscal year begins October 1 of one calendar year and ends September 30 of the next calendar year.

FED_FY_AWD_APPROPRIATION is populated only for awards from federal sponsors, and only for those whose records were entered or updated since October 14, 2003. The value is null for all other records.

Example: 2002

Values:
List of values not available 

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Misc. Award Information tab; Federal Fiscal Year of Award Appropriation

FOREIGN_CURRENCY_AMT

Indexed - no
Format - number (13,2)
May be null? yes
For increments paid in foreign currency, the amount of the increment in that currency. The value is null for increments paid in U.S. dollars. See also FOREIGN_CURRENCY_UNIT and FOREIGN_CURRENCY_FLAG.

FOREIGN_CURRENCY_AMT is populated only for increments paid in foreign currency, and only for those whose records were entered or updated since October 14, 2003. The value is null for all other records.

For increments paid in foreign currency, the dollar amounts for the increment reflect the exchange rate as of the date the increment check was deposited.

Values:
0 to 99,999,999,999.99

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Misc. Award Information tab; Foreign Currency Amount

FOREIGN_CURRENCY_FLAG

Indexed - no
Format - char (1)
May be null? yes
A Yes/No flag that indicates whether the increment was paid in foreign currency. See also FOREIGN_CURRENCY_UNIT and FOREIGN_CURRENCY_AMT.

For increments paid in foreign currency, the dollar amounts for the increment reflect the exchange rate as of the date the increment check was deposited.

Values:
Y yes, the increment was paid in a 
  currency other than U.S. dollars
N no, the increment was not paid in a foreign currency; it was paid in U.S. dollars
PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Misc. Award Information tab; Foreign Currency Award

FOREIGN_CURRENCY_UNIT

Indexed - no
Format - varchar2 (10)
May be null? yes
For increments paid in foreign currency, the currency in which the increment was. The value is null for increments paid in U.S. dollars. See also FOREIGN_CURRENCY_AMT and FOREIGN_CURRENCY_FLAG.

FOREIGN_CURRENCY_UNIT is populated only for increments paid in foreign currency, and only for those whose records were entered or updated since October 14, 2003. The value is null for all other records.

For increments paid in foreign currency, the dollar amounts for the increment reflect the exchange rate as of the date the increment check was deposited.

Example: 2002

Values:
List of values not available 

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Misc. Award Information tab; Currency

FUND_COST_SHR_PARENT

Indexed - no
Format - char (6)
May be null? yes
If the AWARD_FUND tracks cost sharing, FUND_COST_SHR_PARENT is the 6-character code for the fund that serves as the parent (or rollup group) for similar cost sharing funds, allowing amounts to be summarized at the parent level. If the AWARD_FUND does not track cost sharing, FUND_COST_SHR_PARENT is null. (For example, if FUND_REVENUE_PARENT has a non-null value, FUND_COST_SHR_PARENT ought to be null.)

Cost sharing is the amount of funding provided for the sponsored project that does not come from the sponsor. For example, the University receives a grant for a project estimated to have a total cost of $100,000. The sponsor agrees to pay 75% ($75,000) and the University agrees to pay 25% ($25,000). The $25,000 is the cost-sharing component.

Example: GCCSXX

Values:
Refer to the PARENT_FUND_CODES table for values. 
PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Fund Parents section; Cost Sharing

FUND_INT_BEAR_PARENT

Indexed - no
Format - char (6)
May be null? yes
If the AWARD_FUND is for an interest-bearing account, the FUND_INT_BEAR_PARENT is the 6-character code for the fund that serves as the parent (or rollup group) for similar interest-bearing funds, allowing amounts to be summarized at the parent level. There is one parent for interest-bearing funds whose interest is returned to the sponsor, and another for interest-bearing funds whose interest kept by the project. If the AWARD_FUND is not for an interest-bearing account, FUND_INT_BEAR_PARENT is null.
Values:
 Refer to the PARENT_FUND_CODES table for values.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Fund Parents section; Interest Bearing

FUND_OVERHEAD_PARENT

Indexed - no
Format - char (6)
May be null? yes
If the increment includes indirect costs, FUND_OVERHEAD_PARENT is the 6-character code for the fund that serves as the parent (or rollup group) for funds whose indirect cost recovery base and rate are the same as those of the AWARD_FUND. The FUND_OVERHEAD_PARENT allows amounts to be summarized at the parent level. If the increment does not include indirect costs, FUND_OVERHEAD_PARENT is null.

Example: B01R76 (BASE101/RATE076 58.50%)

Values:
Refer to the PARENT_FUND_CODES table for values.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Fund Parents section; Overhead

FUND_PURPOSE_CODE

Indexed - no
Format - char (2)
May be null? yes
The 2-character code identifying the primary purpose of expenditures tracked by the AWARD_FUND. This is determined by the program type for the proposal (see PENNERA_PROPOSAL.PROGRAM_TYPE).

Examples: 01 (Instruction), NA (Not applicable). NA is used for "parent" funds and other funds where purpose does not really apply (for example, capital gifts, annuities). UN (Unknown) is the default

Values:
01 Instruction
10 Sponsored Research
11 Other, Separately Budgeted Research (for example,
  URF {University Research Foundation}, RFDF 
  {Research Facilities Development Fund}, 
  Technology Transfer, Research Matching Program, 
  Insurance Fund)
12 Other Sponsored Programs
20 Libraries
30 Student Aid (for example, University Fellowship)
40 Student Services
50 Extension & Public Service
60 Auxiliary Enterprise: Dormitories
61 Auxiliary Enterprise: Bookstore
62 Auxiliary Enterprise: Dining Services
63 Auxiliary Enterprise: Intercollegiate Athletics
64 Auxiliary Enterprise: Other
70 Hospitals & Clinics: Medical
71 Hospitals & Clinics: Dental
72 Hospitals & Clinics: Veterinary
73 Hospitals & Clinics: Nursing
80 Independent Operations
90 Management and General (for example, Debt 
   Service, Employee Benefits Pool)
92 Fundraising
93 Maintenance & Operation of Facilities (for 
  example, Deferred Maintenance)
NA Not applicable (for example, General 
  Unrestricted, Anticipated revenue & expense, 
  Capital Construction Fund, other 02XXXX funds, 
  Loan funds, annuities, capital gifts funds, 
  agency)
NA is used for "parent" funds and other funds where purpose does not really apply (for example, capital gifts, annuities) UN is the default. UN unknown, to be assigned later
PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Fund Purpose

FUND_RESP_INVESTIGATOR

Indexed - no
Format - char (8)
May be null? yes
The Penn ID of the investigator responsible for managing the funding tracked by the AWARD_FUND. The fund responsible investigator is one of the investigators associated with the proposal. However, it may or may not be the same person as the Principal Investigator for the proposal.

See also PI_PENN_ID, PARENT_PI_PENN_ID, and ACCOUNT_RESP_INVESTIGATOR

Example: 10108345 (LAUFER,TERRI M)

Values:
Refer to the PENNERA_PEOPLE table for values. 

PennERA source: PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; the PennID of the person named in the PI Name field

FUND_RESPONSIBLE_ORG

Indexed - no
Format - char (8)
May be null? yes
The 4-character code identifying the Organization responsible for managing all of the money tracked by the AWARD_FUND. An Organization is a subdivision of the University created for management purposes. An Organization belongs to only one responsibility center, and its Organization code is unique. That is, no two Organizations have the same value for FUND_RESPONSIBLE_ORG.

To facilitate Organization-based security, FUND_RESPONSIBLE_ORG is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

PennERA source: PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Responsible Org

FUND_REVENUE_PARENT

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

If the AWARD_FUND tracks funding provided by the sponsor, FUND_REVENUE_PARENT is the 6-character code for the fund that serves as the parent (or rollup group) for funds whose revenue is provided by the sponsor in the same way as for the AWARD_FUND. The FUND_REVENUE_PARENT allows amounts to be summarized at the parent level. If the AWARD_FUND does not track funding provided by the sponsor, FUND_REVENUE_PARENT is null. (For example, if FUND_COST_SHR_PARENT has a non-null value, FUND_REVENUE_PARENT ought to be null.)

For increments awarded under ARRA (the American Recovery and Reinvestment Act of 2009, also known as the Recovery Act or the federal economic stimulus program), the FUND_REVENUE_PARENT is 'GCB009', 'LOCNIS', or 'LOCNSS'. (In the PARENT_FUND_CODES table, their PARENT_FUND is 'ARRALC'.) Because advance accounts are funded by the University (not by the sponsor), an increment in 'Advance Account' status should not have 'GCB009', 'LOCNIS', or 'LOCNSS' as its FUND_REVENUE_PARENT, but it might. Rather than using the FUND_REVENUE_PARENT to identify ARRA increments, use the ARRA_FUNDED_INCREMENT_FLAG.

Examples: LOCNIH (NIH LETTER OF CREDIT FUNDS);
GCB002 (GRANTS BILLED UNDER B002 OBJECTS)

Values:
Refer to the PARENT_FUND_CODES table for values.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Fund Parents section; Revenue

INCREMENT_F_AND_A_RATE

Indexed - no
Format - number(5,2)
May be null? yes

The Facilities and Administration (F&A) rate associated with the increment. The value was entered by hand, and was not used by the system to calculate the AWARDED_INDIRECT_COSTS for the increment. INCREMENT_F_AND_A_RATE is null if the increment does not include indirect cost recovery.

The F&A rate (indirect cost rate) is the percentage rate used in the calculation that determines the amount of the indirect costs. Indirect costs are calculated by multiplying the indirect cost base by the F & A rate.

Indirect costs are costs that are not specific to the sponsored project, but that are incurred by the University in support of the sponsored project. (For example, utilities and laboratory space fall under indirect costs.) Indirect costs are also known as Facilities and Administrative (F&A) costs or overhead.

Example: 59 (59%)

Values:
List of values not available 

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Misc. Award Information tab; F&A Rate

INCREMENT_NUMBER

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

A sequence number uniquely identifying the increment within the proposal to which it applies. Each proposal (INSTITUTION_NO) that has at least one increment, has an INCREMENT_NUMBER ‘1’. The maximum INCREMENT_NUMBER for a proposal is the number of increments for that proposal.

When an amount is received, or an amount is expected to be paid in the future (per a Notice of Award), or an amount is paid by a department in expectation of an amount to be received, an increment is the portion of that amount that is assigned to a General Ledger account.

There is one PENNERA_INCREMENT record per proposal (INSTITUTION_NO or PROP_NO) per INCREMENT_NUMBER. (Though PERIOD_NUMBER is part of the physical primary key for the PENNERA_INCREMENT table, it is not part of the logical primary key for the table.)

Examples: 2, 13

Values:
List of values not available 

PennERA source: though PennERA does not display the Increment Number, it can be found in the Proposal Tracking module; Awarded screen; the row number for the increment listed under the Awards tab

INCREMENT_RESP_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
The 4-character code that identifies the Organization responsible for administering the science and the money for the increment.

For records dating from before November 24, 1997, the values for PROPOSAL_RESP_ORG_CODE and INCREMENT_RESP_ORG_CODE are the same. For later records, these data elements may have values that are different from each other.

To facilitate Organization-based security, INCREMENT_RESP_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; value to the left of the Award No. field

INCREMENT_RESP_SCHOOL_CODE

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code that identifies the school or center for the Organization responsible for administering the science and the money for the increment.

For records dating from before November 24, 1997, the values for PROPOSAL_RESP_SCHOOL_CODE and INCREMENT_RESP_SCHOOL_CODE are the same. For later records, these data elements may have values that are different from each other.

If the INCREMENT_RESP_ORG_CODE is '.', the INCREMENT_RESP_SCHOOL_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the 
same as the first 2 characters of the CNAC.
Source: ORG_CODES.CENTER_CODE where PENNERA_INCREMENT.INCREMENT_RESP_ORG_CODE =ORG_CODES.ORGANIZATION_CODE

INCREMENT_STATUS

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

The current status of the increment, per the sponsor’s response.

For the effective date of that status, or for more details on how the increment's status has changed over time, use the PENNERA_INCR_STAT_HIST table.

Values: 
Advance Account--the funding for the increment is
   an advance provided by the department administering
   the project, in expectation of an award from the sponsor
Awarded--the funding for the increment is an award provided
   by the sponsor 
Future--the sponsor has notified the University
   of its intent to award funding for the increment,
   which applies to a future period (“out year”)
PennERA source: Proposal Tracking module; Requested screen; Status link; Status
INSTITUTION_NO

Indexed - yes
Format - char (8)
May be null? yes
The eight-digit sequence number used by the University to uniquely identify the proposal to which the increment applies. Note that the value for INSTITUTION_NO includes leading zeroes.

Records with an INSTITUTION_NO less than or equal to 05017400 were converted from the Research Services System (RSS, the system used to track proposals and awards before October 14, 2003). Other records are for proposals created in PennERA.

There are two different unique identifiers for a proposal: INSTITUTION_NO and PROP_NO. INSTITUTION_NO is used by the University. PROP_NO is used internally by the PennERA system. For a given record, INSTITUTION_NO will not have the same value as PROP_NO. While either one may be used when joining PennERA Proposals tables, INSTITUTION_NO is the one recommended for display in reports.

There is one PENNERA_INCREMENT record per proposal (INSTITUTION_NO or PROP_NO) per INCREMENT_NUMBER. (Though PERIOD_NUMBER is part of the physical primary key for the PENNERA_INCREMENT table, it is not part of the logical primary key for the table.)

Example: 00216424

Values:
List of values not available

PennERA source: Proposal Tracking module; Awarded screen; summary box in the upper right corner of the screen; Proposal

LAST_EXTRACT_DATE

Indexed - no
Format - date
May be null? yes
The date this increment record was extracted from the PennERA Proposal Tracking system and loaded into the Warehouse.

Example: 10/28/2003

Values:
List of values not available.
LAST_FIN_RPT_DATE

Indexed - no
Format - date
May be null? yes
The date on which the last financial report for the AWARD_FUND was filed.

Example: 10/15/2003

Values:
List of values not available.

PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Last Fin Report Filed

NEXT_FIN_RPT_DUE_DATE

Indexed - no
Format - date
May be null? yes

The next date a financial report for the AWARD_FUND is due to the sponsor.

Example: 01/15/2003

Values:
List of values not available. 
PennERA source: Proposal Tracking module; Awarded detail screen; Fund/Acct Setup button; Edit fund; Next Fin Report Due

NIH_GRANT_ACTIVITY_CODE

Indexed - no
Format - char (3)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_ACTIVITY_CODE is a 3-character code used by NIH to identify a specific category of extramural activity. The value is characters 3 through 5 of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_ACTIVITY_CODE is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_ACTIVITY_CODE is null.

Example: R01 (Research Project) is the activity code for the increment for an NIH grant whose SPONSOR_AWARD_ID is 5-R01-AI-048117-02.

Values:
For the list of NIH activity codes, 
refer to the NIH manual titled “Activity
Codes, Organization Codes, and Definitions 
used in Extramural Programs” (also
known as the IMPAC handbook)
NIH_GRANT_ADMIN_ORG

Indexed - no
Format - char (2)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_ADMIN_ORG is a 2-letter code that identifies the first major level subdivision within an NIH organization. The value is characters 7 and 8 of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_ADMIN_ORG is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_ADMIN_ORG is null.

Example: for an NIH grant whose SPONSOR_AWARD_ID is 5-R01-AI-048117-02, AI (National Institute of Allergy and Infectious Diseases Extramural Activities (NIAID)) is an administrative organization within NIH.
Values:
For the list of NIH administering organizations, 
refer to the NIH manual titled “Activity
Codes, Organization Codes, and Definitions
used in Extramural Programs” (also
known as the IMPAC handbook)
NIH_GRANT_APPLICATION_TYPE

Indexed - no
Format - char (1)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_APPLICATION_TYPE is a single-digit code that identifies the type of grant application received and processed by NIH. The value is the first character of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_APPLICATION_TYPE is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_APPLICATION_TYPE is null.

Example: for an NIH grant whose SPONSOR_AWARD_ID is 5-R01-AI-048117-02, 5 (Noncompeting Continuation) is the application type.

Values:
For the list of NIH application types, refer
to the NIH manual titled “Activity
Codes, Organization Codes, and Definitions
used in Extramural Programs” (also
known as the IMPAC handbook)
NIH_GRANT_SERIAL_NUMBER

Indexed - no
Format - char (6)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_SERIAL_NUMBER is a 6-digit number generally assigned sequentially by NIH to number awards within an NIH Institute, Center, or Division. The value is characters 10 through 15 of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_SERIAL_NUMBER is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_SERIAL_NUMBER is null.

When dealing with historical data, bear in mind that, prior to June, 2002, this was a 5-digit number. Existing NIH grants had a leading zero added to their NIH Grant Serial Numbers in June, 2002.

Example: for an NIH grant whose SPONSOR_AWARD_ID is 5-R01-AI-048117-02, 048117 is the serial number.

Values:
List of values not available.
NIH_GRANT_SUPPLEMENT

Indexed - no
Format - char (4)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_SUPPLEMENT is a 2- to 4-character code identifying a supplement, amendment, or allowance awarded by NIH. The value is characters 19 through 22 of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_SUPPLEMENT is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_SUPPLEMENT is null.

Examples:

  • For an NIH grant whose SPONSOR_AWARD_ID is 3-K23-DC-000165-01A1S1, NIH_GRANT_SUPPLEMENT is A1S1--the letter A and the following number identifies the amended application (here, A1, Amendment 1), and the letter S and the following number identifies the supplemental record (here, S1, Supplement 1).
  • For an NIH grant whose SPONSOR_AWARD_ID is 5-F05-AG-12345-01X1, NIH_GRANT_SUPPLEMENT is X1--the letter X and the following number identifies the fellowship’s institution allowance record (here, X1, Allowance 1).
Values:
For more information on the NIH suffixes for 
Supplements, Amendments, and Allowances, refer
to the NIH manual titled “Activity Codes,
Organization Codes, and Definitions 
used in Extramural Programs” (also
known as the IMPAC handbook)
NIH_GRANT_YEAR

Indexed - no
Format - char (2)
May be null? yes
For National Institutes of Health grants and cooperative agreements, NIH_GRANT_YEAR is a 2-digit number that indicates the actual segment or budget period of an NIH award. (The grant year number is increased by one for each succeeding renewal year.) The value is characters 17 and 18 of the SPONSOR_AWARD_ID.

Note: NIH_GRANT_YEAR is populated only if two criteria are met:

  1. the proposal's sponsor or sponsor parent is NIH (SPONSOR_CODE = '09470' or the PENNERA_SPONSOR record for the proposal's sponsor has SPONSOR_PARENT= '09470'), and
  2. the increment is funded under a 'Grant' or 'Cooperative Agreement' (per the PENNERA_PROPOSAL.INSTRUMENT_TYPE).
For other records, NIH_GRANT_YEAR is null.

Example: for an NIH grant whose SPONSOR_AWARD_ID is 3-R01-CA-012921-04, 04 is the grant year--meaning that the grant is in its fourth year.

Values:
For more information on the NIH suffix for
Grant Year, refer to the NIH manual titled 
“Activity Codes, Organization Codes, and 
Definitions used in Extramural Programs”
(also known as the IMPAC handbook)
NOTICE_OF_AWARD_NO

Indexed - no
Format - number (17,2)
May be null? yes

Used by the Office of Research Services (ORS) to store the call number for the image of the Notice of Award document that applies to the increment. The format of NOTICE_OF_AWARD_NO allows its value to have 2 digits to the right of the decimal point, but ORS does not plan to use those digits.

Values:
0 to 999,999,999,999,999

PennERA source: Proposal Tracking module; Budget; view or edit an increment under the Awarded menu item; Misc. Award Information section; Notice of Award #

PAR_PI_PRIACADAPPT_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
This data element is reserved for future use.
PAR_PI_PRIACADAPPT_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
This data element is reserved for future use.
PARENT_INSTITUTION_NO

Indexed - yes
Format - char (8)
May be null? yes
This data element is reserved for future use.
PARENT_PI_ERA_PRI_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
This data element is reserved for future use.
PARENT_PI_ERA_PRI_SCHOOL_CODE

Indexed - yes
Format - char (2)
May be null? yes
This data element is reserved for future use.
PARENT_PI_HOME_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
This data element is reserved for future use.
PARENT_PI_HOME_SCH_CODE

Indexed - yes
Format - char (2)
May be null? yes
This data element is reserved for future use.
PARENT_PI_INV_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
This data element is reserved for future use.
PARENT_PI_INV_SCH_CODE

Indexed - no
Format - char (2)
May be null? yes
This data element is reserved for future use.
PARENT_PI_PENN_ID

Indexed - no
Format - char (8)
May be null? yes
This data element is reserved for future use.
PARENT_PI_PRI_APPT_ORG_CODE

Indexed - yes
Format - char (4)
May be null? yes
This data element is reserved for future use.
PARENT_PI_PRI_APPT_SCH_CODE

Indexed - yes
Format - char (8)
May be null? yes
This data element is reserved for future use.

PARENT_PROP_NO

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

This data element is reserved for future use.

PARENT_PROP_RESP_ORG_CODE

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

This data element is reserved for future use.

PARENT_PROP_RESP_SCH_CODE

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

This data element is reserved for future use.

PERIOD_NUMBER

Indexed - yes
Format - number (10)
May be null? no

A sequence number uniquely identifying the budget period within the proposal to which the increment applies. Each proposal (INSTITUTION_NO) has a PERIOD_NUMBER ‘1’. The maximum PERIOD_NUMBER for a proposal is the number of budget periods for that proposal.

There is one PENNERA_INCREMENT record per proposal (INSTITUTION_NO or PROP_NO) per INCREMENT_NUMBER. (Though PERIOD_NUMBER is part of the physical primary key for the PENNERA_INCREMENT table, it is not part of the logical primary key for the table.)

Examples: 3, 11

Values:
List of values not available 

PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; Award for Period

PI_ERA_PRIMARY_ORG_CODE

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

The 4-character code for the ERA primary organization (‘org.’) for the person identified by the PI_PENN_ID. That is the Principal Investigator for the proposal to which the increment applies.

The ERA primary org. is the org. flagged as the primary department in the person’s PennERA Profile. Although it is used to secure certain data elements in the Data Warehouse, the ERA primary org. is not used by the University’s business processes.

For Penn staff, the ERA primary org. is the primary (job) appointment org. For Penn faculty, it is the primary academic (job) appointment org., which will not be the same as primary appointment org. for those faculty holding administrative positions. For Penn employees whose job appointments are all on the executive payroll, ERA primary org. is ‘8000’ ('General University Special '). For Penn students, the ERA primary org. is the organizational equivalent of their home Division (for example, ‘0200’, School of Arts and Sciences.) For investigators from the University of Pennsylvania Health System (UPHS), the ERA primary org. is ‘2100’ ('Health System '). For members of the research community who are otherwise not affiliated with Penn, the ERA primary org. is ‘8760' ('Research Services').

PI_ERA_PRIMARY_ORG_CODE reflects the ERA primary org. of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_ERA_PRIMARY_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table.

To facilitate Organization-based security, PI_ERA_PRIMARY_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR. ERA_PRIMARY_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_ERA_PRIMARY_SCHOOL_CODE

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

The 2-character code for the school or center for the PI_ERA_PRIMARY_ORG_CODE. That identifies the ERA primary organization (‘org.’) for the person identified by the PI_PENN_ID--the Principal Investigator for the proposal to which the increment applies.

The ERA primary org. is the org. flagged as the primary department in the person’s PennERA Profile. Although it is used to secure certain data elements in the Data Warehouse, the ERA primary org. is not used by the University’s business processes.

PI_ERA_PRIMARY_SCHOOL_CODE reflects the ERA primary school of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_ERA_PRIMARY_SCHOOL_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table.

If the PI_ERA_PRIMARY_ORG_CODE is '.', the PI_ERA_PRIMARY_SCHOOL_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same
as the first 2 characters of the CNAC.
Source: PENNERA_PROPOSAL_INVESTIGATOR. ERA_PRIMARY_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_HOME_ORG_CODE

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

The 4-character code for the home organization (‘org.’) for the person identified by the PI_PENN_ID. That is the Principal Investigator for the proposal to which the increment applies.

The home org. is the org. that owns the person's employee record and is responsible for its maintenance.

PI_HOME_ORG_CODE reflects the home org. of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_HOME_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information dating back to the time of the funding cycle, PI_HOME_ORG_CODE is '.'. (Because the PI_HOME_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR. HOME_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT. PI_PENN_ID

PI_HOME_SCHOOL_CODE

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

The 2-character code for the school or center for the PI_HOME_ORG_CODE. That is the home organization (‘org.’) for the person identified by the PI_PENN_ID--the Principal Investigator for the proposal to which the increment applies.

The home org. is the org. that owns the person's employee record and is responsible for its maintenance.

PI_HOME_SCHOOL_CODE reflects the home school of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_HOME_SCHOOL_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information dating back to the time of the funding cycle, PI_HOME_SCHOOL_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. The 
code for a school or center is the same as the
first 2 characters of the CNAC.
Source: PENNERA_PROPOSAL_INVESTIGATOR.HOME_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_INVESTIGATOR_ORG_CODE

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

The 4-character code for the investigator organization (‘org.’) for the person identified by the PI_PENN_ID. That is the Principal Investigator for the proposal to which the increment applies.

Although it is used to secure certain data elements in the Data Warehouse, the investigator org. is not used by the University’s business processes.

For a given investigator associated with a proposal, the investigator org. is the org. specified (on the Office of Research Services Proposal Transmittal and Approval Form) as the 'Dept. Administering Project' (the PROPOSAL_RESP_ORG_CODE). An exception to this rule is that, if the PROPOSAL_RESP_ORG_CODE is neither the investigator's ERA primary org. nor an org. where the investigator has a job appointment, when the investigator's data is entered for the proposal in PennERA, the investigator org. is chosen from among those orgs., based on its being the one that is most closely related to the PROPOSAL_RESP_ORG_CODE. In other words:

  • if the investigator has only one org, then that org. is chosen; otherwise,
  • if the investigator has an org. that is the same as the PROPOSAL_RESP_ORG_CODE, then that org. is chosen; otherwise
  • the investigator's orgs. are sorted in ascending order, and the first org. whose org. code is greater than or equal to the PROPOSAL_RESP_ORG_CODE is chosen; otherwise,
  • if the investigator has no org. whose org. code is greater than or equal to the PROPOSAL_RESP_ORG_CODE, the investigator's ERA primary org. is chosen

To facilitate Organization-based security, PI_INVESTIGATOR_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

PennERA source: Proposal Tracking module; Summary screen for the proposal; Investigator tab; the code in the Department column for the person flagged as the PI

PI_INVESTIGATOR_SCHOOL_CODE

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

The 2-character code for the school or center for the PI_INVESTIGATOR_ORG_CODE. That is the investigator organization (‘org.’) for the person identified by the PI_PENN_ID--the Principal Investigator for the proposal to which the increment applies.

Although it is used to secure certain data elements in the Data Warehouse, the investigator org. is not used by the University’s business processes.

If the PI_INVESTIGATOR_ORG_CODE is '.', the PI_INVESTIGATOR_SCHOOL_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. The code 
for a school or center is the same as the first 2 
characters of the CNAC.

Source: ORG_CODES.CENTER_CODE where PENNERA_INCREMENT. PI_INVESTIGATOR_ORG_CODE =ORG_CODES.ORGANIZATION_CODE

PI_PENN_ID

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

The Penn ID of the Principal Investigator for the proposal to which the increment applies.

The PennID is the 8-digit identification number assigned to a person by the Penn Community system. No two persons have the same PennID. However, a person may have more than one PennID. For example, say Dr. John Doe had a sponsored project in 1990, but his Social Security number was not recorded in the Research Services System (RSS, the system then used to track proposals and awards). Dr. Doe left the University after project ended. When the RSS data was converted to PennERA, there was no record in Penn Community for Dr. Doe. Because his Social Security number was not available, a PennERA-specific PennID (beginning with a ‘P’) was created for him. In 2003, Dr. Doe returned to the University, and was assigned a numeric PennID (for example, 10039706). Dr. Doe would then have two PennIDs, but one could not tell from looking at the data that both PennIDs identify the same person.

See also PARENT_PI_PENN_ID, FUND_RESP_INVESTIGATOR, and ACCOUNT_RESP_INVESTIGATOR

Examples: ‘P1000194’ (Lisa Jay); ‘10006336’ (Herman Gluck)

Values:
Refer to the PENNERA_PEOPLE table for values. 

PennERA source: Proposal Tracking module; Summary screen for the proposal; Investigator tab; the PennID for the person flagged as the PI

PI_PRI_ACAD_APPT_ORG_CODE


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

The 4-character code for the organization (‘org.’) of the primary academic job appointment for the person identified by the PI_PENN_ID. That is the Principal Investigator for the proposal to which the increment applies.

The primary academic appointment org. is the org. where the person has his or her primary academic job appointment. If the person has more than one academic job appointment, the primary academic appointment is the one with the most important faculty class. For further information on the primary academic appointment, see the explanation in the Cautions section of the documentation for the EMPLOYEE_GENERAL table.

PI_PRI_ACAD_APPT_ORG_CODE reflects the primary academic appointment org. of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_PRI_ACAD_APPT_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information about a faculty job appointment dating back to the time of the funding cycle, PI_PRI_ACAD_APPT_ORG_CODE is '.'. (Because the PI_PRI_ACAD_APPT_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR. PRIMARY_ACADEMIC_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_PRI_ACAD_APPT_SCHOOL_CODE

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

The 2-character code for the school or center for the PI_PRI_ACAD_APPT_ORG_CODE. That is the organization (‘org.’) of the primary academic job appointment for the person identified by the PI_PENN_ID--the Principal Investigator for the proposal to which the increment applies.

The primary academic appointment org. is the org. where the person has his or her primary academic job appointment. If the person has more than one academic job appointment, the primary academic appointment is the one with the most important faculty class. For further information on the primary academic appointment, see the explanation in the Cautions section of the documentation for the EMPLOYEE_GENERAL table.

PI_PRI_ACAD_APPT_SCHOOL_CODE reflects the primary academic appointment school of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_PRI_ACAD_APPT_SCHOOL_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information about a faculty job appointment dating back to the time of the funding cycle, PI_PRI_ACAD_APPT_SCHOOL_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same
as the first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR. PRIMARY_ACADEMIC_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_PRI_APPT_ORG_CODE

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

The 4-character code for the organization (‘org.’) of the primary job appointment for the person identified by the PI_PENN_ID. That is the Principal Investigator for the proposal to which the increment applies.

The primary appointment org. is the org. where the person has his or her primary job appointment, per the University’s employee census logic. The logic used to determine a University employee's primary appointment is documented in the cautions for the EMPLOYEE_GENERAL table.

PI_PRI_APPT_ORG_CODE reflects the primary appointment org. of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_PRI_APPT_ORG_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information dating back to the time of the funding cycle, PI_PRI_APPT_ORG_CODE is '.'. (Because the PI_PRI_APPT_ORG_CODE is one of the data elements used to secure the data, it is set to '.' if it would otherwise be null.)

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.

Source: PENNERA_PROPOSAL_INVESTIGATOR. PRIMARY_APPT_ORG_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PI_PRI_APPT_SCHOOL_CODE

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

The 2-character code for the school or center for the PI_PRI_APPT_ORG_CODE. That is the organization (‘org.’) of the primary job appointment for the person identified by the PI_PENN_ID--the Principal Investigator for the proposal to which the increment applies.

The primary appointment org. is the org. where the person has his or her primary job appointment, per the University’s employee census logic. The logic used to determine a University employee's primary appointment is documented in the cautions for the EMPLOYEE_GENERAL table.

PI_PRI_APPT_SCHOOL_CODE reflects the primary appointment school of the PI for the proposal, as it was at the time of the proposal (funding cycle). Once the funding cycle has ended, the PI_PRI_APPT_SCHOOL_CODE is no longer updated. The dates for the funding cycle are the AWARDED_PROJECT_START and AWARDED_PROJECT_END in the PENNERA_PROPOSAL table. If the PI for the proposal has no employee information dating back to the time of the funding cycle, PI_PRI_APPT_SCHOOL_CODE is '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same
as the first 2 characters of the CNAC.

Source: PENNERA_PROPOSAL_INVESTIGATOR. PRIMARY_APPT_SCHOOL_CODE where PENNERA_PROPOSAL_INVESTIGATOR. PENN_ID = PENNERA_INCREMENT.PI_PENN_ID

PROP_NO

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

The 10-digit sequence number used internally by the PennERA system to uniquely identify the proposal to which the increment applies. Note that the value for PROP_NO includes leading zeroes.

There are two different unique identifiers for a proposal: INSTITUTION_NO and PROP_NO. INSTITUTION_NO is used by the University. PROP_NO is used internally by the PennERA system. For a given record, INSTITUTION_NO will not have the same value as PROP_NO. While either one may be used when joining PennERA Proposals tables, INSTITUTION_NO is the one recommended for display in reports.

There is one PENNERA_INCREMENT record per proposal (INSTITUTION_NO or PROP_NO) per INCREMENT_NUMBER. (Though PERIOD_NUMBER is part of the physical primary key for the PENNERA_INCREMENT table, it is not part of the logical primary key for the table.)

Example: ‘0000000217’

Values:
List of values not available 

PennERA source: Proposal Tracking module; Awarded screen; summary box in the upper right corner of the screen; the prop_no for the Proposal

PROPOSAL_RESP_ORG_CODE

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

The 4-character code that identifies the organization responsible for the proposal to which the increment applies.

To facilitate Organization-based security, PROPOSAL_RESP_ORG_CODE is set to '.' if it would otherwise be null.

Example: 4261 (DM-Rheumatology)

Values:
Refer to the ORG_CODES table for values.
PennERA source: Proposal Tracking module; Summary screen for the proposal; the code listed under the Assoc. Dept tab

PROPOSAL_RESP_SCHOOL_CODE

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

The 2-character code for the school or center for the PROPOSAL_RESP_ORG_CODE -- the organization responsible for the proposal to which the increment applies.

If the PROPOSAL_RESP_ORG_CODE is '.', the PROPOSAL_RESP_SCHOOL_CODE is also '.'.

Example: 40 (School of Medicine)

Values:
Refer to the CNAC_CODES Table for values. 
The code for a school or center is the same
as the first 2 characters of the CNAC.

Source: ORG_CODES.CENTER_CODE where PENNERA_INCREMENT. PROPOSAL_RESP_ORG_CODE =ORG_CODES.ORGANIZATION_CODE

SPONSOR_AWARD_ID

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

The identification number (if any) that is assigned to the sponsored project award by the sponsoring agency.

When an award has been split among increments (as is the case when it is tracked by multiple General Ledger accounts, for example), more than one PENNERA_INCREMENT record has the same value for SPONSOR_AWARD_ID. Also, if the sponsor uses the same identification number for all awards funding a proposal, all of the proposal's PENNERA_INCREMENT records have the same value for SPONSOR_AWARD_ID.

When SPONSOR_AWARD_ID is null or 'N/A', the sponsor has not assigned an identification number to the sponsored project award.

The sponsor may also assign an identification number to the proposal (funding cycle) for the sponsored project. See PENNERA_PROPOSAL.SPONSOR_PROJECT_AWARD_NO.

Example: 1-N01-HV-020002-000 (an identification number assigned by NIH)

Values:
List of values not available.
PennERA source: Proposal Tracking module; Awarded screen; view or edit an increment under the Awards tab; Detailed Budget… tab; Award No.

SPONSOR_CODE

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

The 5-character numeric code that uniquely identifies the sponsor for the proposal to which the increment applies.

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.

Example: 09470 (NATIONAL INSTITUTES OF HEALTH).

Values:
Refer to the PENNERA_SPONSOR Table for values.
PennERA source: Proposal Tracking module; any screen for the proposal for the increment; summary box in the upper right corner of the screen; the sponsor code for the Sponsor.

 

PENNERA_INCREMENT 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