• ACCOUNT_NUMBER
• AGENCY_CODE
• AGENCY_REF_NUMBER
• AIS_PRINT_DATE
• ANIMALS_FLAG
• ANIMALS_PROTOCOL_ID
• AWARD_ACCOUNT_NUMBER
• AWARD_ACCOUNT_TYPE
• AWARD_BC
• AWARD_CNAC
• AWARD_CREATE_DATE
• AWARD_CREF
• AWARD_FUND
• AWARD_ID
• AWARD_ORG
• AWARD_PROGRAM
• AWD_RESP_ORG
• AWD_RESP_SCHOOL
• CARCINOGENIC_MATERIALS_FLAG
• CLINICAL_TRIAL_FLAG
• CLINICAL_TRIAL_PROTOCOL_ID
• CO_PI_HOME_ORG
• CO_PI_HOME_SCHOOL
• COMMITTED_YEARS
• CREATE_DATE
• CURRENT_BUDGET_END
• CURRENT_BUDGET_START
• DATE_AWARDED
• DIRECT_COST_AMOUNT
• DNA_SUBJECT_FLAG
• DOMESTIC_TRAVEL_AMOUNT
• EQUIPMENT_AMOUNT
• EXTENSION_CODE
• FISCAL_YR_END
• FISCAL_YR_START
• FISCAL_YR_STATUS
• FOREIGN_TRAVEL_AMOUNT
• FUND_RESPONSIBLE_ORG
• GRANT_CONTRACT_CODE

• HUMAN_PROTOCOL_ID
• HUMAN_SUBJECTS_FLAG
• INDIRECT_COST_AMOUNT
• INDIRECT_COST_RATE
• INFECTIOUS_AGENTS_FLAG
• LAST_EXTRACT_DATE
• MODIFY_DATE
• NIH_GRANT_ACTIVITY_CODE
• NIH_GRANT_ADMIN_ORG
• NIH_GRANT_APPLICATION_TYPE
• NIH_GRANT_SERIAL_NUMBER
• NIH_GRANT_SUPPLEMENT
• NIH_GRANT_YEAR
• ORA_CONTRACT_INITIALS
• ORA_CONTRACT
• ORA_PURPOSE_CODE
• ORG_LOG_NUMBER
• ORIGINAL_PROPOSAL_DATE
• OTHER_EXPENSES_AMOUNT
• PI_HOME_ORG
• PI_HOME_SCHOOL
• PI_PRI_APPT_ORG
• PI_PRI_APPT_SCHOOL
• PROJECT_COST_SHARING_AMOUNT
• PROJECT_COST_SHARING_SOURCE
• PROJECT_ID
• PROJECT_SEGMENT_ID
• PROP_RESP_ORG
• PROP_RESP_SCHOOL
• PROPOSAL_ID
• RADIOACTIVE_MATERIAL_FLAG
• RADIOACTIVE_PROTOCOL_ID
• SUB_CONTRACTOR_AMOUNT
• TITLE
• TOTAL_AGENCY_AMOUNT
• TOTAL_COMPENSATION_AMOUNT
• TUITION_AMOUNT
• UNIVERSITY_EXPENSES_AMOUNT

A 6-digit number that identifies the account for the award, in the format used in the financial system that was used before July 1, 1996. The first digit of the Account_Number is known as the ledger number. All Sponsored Project account numbers begin with the ledger number five. In the present General Ledger accounting structure (in use at Penn since July 1, 1996), the counterpart for the ACCOUNT_NUMBER is the 22-character COA_ACCOUNT_NUMBER (the combination of COA_CNAC, COA_ORG, COA_BC, COA_FUND, COA_PROGRAM, and COA_CREF)

Values:

List of values not available.

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

Values:

Refer to the AGENCY Table for values.

The identification number that is assigned to the award by the sponsoring agency. For example: 1-N01-HV-020002-000 is an identification number assigned by NIH.

Values:

List of values not available.

AIS_Print_Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 9/10/1997.

Values:

List of values not available.

Values:

[Null]  No animals are used for the project

Y   Animals are used for the project

Values:

List of values not available.

Values:

List of values not available.

Values:

P     Prime account

S     Sub-account

The budgetary control character that represents the level at which funds availability checking occurs. AWARD_BC is the third segment of the AWARD_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials, though people may post to any budgetary control character. (For awards that were not active July 1, 1996 and thereafter--AWARD_BC is null.) Examples: 1 (CNAC/ORG/FUND Year-to-Date); 4 (CNAC/ORG/FUND/CREF Project-to-Date)

Values:

0     Project-to-date for capital projects

1     CNAC/ORG/FUND Year-to-date

2     CNAC/ORG/FUND/CREF Year-to-date

4     CNAC/ORG/FUND/CREF Project-to-date

A     Funds check parent of 1

B     Funds check parent of 2

D     Funds check parent of 4

T     All Funds checks

The 3-character Center Net Asset Class code. The first two positions identify the school or center. The last position identifies the net asset class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). AWARD_CNAC is the first segment of the AWARD_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials, though people may post to any CNAC. (For awards that were not active July 1, 1996 and thereafter--AWARD_CNAC is the -0 CNAC for the school or center associated with the AWARD_ORG. For award records awards that were not active July 1, 1996 and thereafter for prime or only accounts, PROP_RESP_SCHOOL will be the same as the first two characters of AWARD_CNAC. For accounts other than prime or only accounts, they may differ.) Examples: 880 (Medical Center, Unrestricted); 921 (Human Resources, Temporarily Restricted)

Values:

Refer to the CNAC_CODES table for values.

AWARD_CREATE_DATE

Indexed - no
Format - date
May be null? yes

The date on which the status of the proposal for the funding increment (Project_Segment_ID) was changed from P (Proposed) to A or V (Awarded or Advance Account). (Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment.) Once the value for the Award_Create_Date has been entered in the Research Services system, it cannot be changed. The value for Award_Create_Date is the default value for Date_Awarded. The values may differ if the Date_Awarded was corrected by authorized Research Services personnel (for example, because the status of the proposal was changed from P to A or V on the wrong date, or because it was changed from V to A). (See also Date_Awarded.)

Award_Create_Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 8/27/1997.

Values:

List of values not available.

AWARD_CREF

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

The 4-character center reference code. This is the sixth segment of the AWARD_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials, though people may post to any center reference code. (For awards that were not active July 1, 1996 and thereafter--AWARD_CREF is null.) AWARD_CREF 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. Examples: 2000 ('21st Century Project'--center 13); 2000 ('DEPARTMENT CHAIR'--center 02)

Values:

Refer to the CTR_REF_CODES table for values.

The 6-character code identifying the fund. This is the fourth segment of the AWARD_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials. While people may post to almost any six segment combination, they must post to AWARD_FUND. Only the AWARD_FUND segment is reliable for finding postings in BEN Financials. (For awards that were not active July 1, 1996 and thereafter--AWARD_FUND is null.) A fund uniquely identifies a specific set of financial resources that needs tracking or management. Example: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1) (See also FUND_RESPONSIBLE_ORG.)

Values:

Refer to the FUND_CODES table for values.

A unique 9-digit number, based on the PROPOSAL_ID, that is assigned to each award and account. The first five digits are the project id. The next two digits identify the funding increment. (Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment.) The last two digits of the Award_Id identify the account sequence number--01 indicates the prime account (if the award has been split into more than one account) or the only account (if the award has not been split). (See also PROJECT_ID and PROJECT_SEGMENT_ID in the AWARD Table.) Note that for some awards dating from before November 24, 1997, the last four characters are unreliable. (To make an example, 123450003 is actually the record for the prime account for the first funding increment--the AWARD_ID should have been 123450101.) Also note that in the Research Services transaction processing system, the last two digits will always be 00 for records dating from November 24, 1997 and thereafter.)

Values:

000000000 to 999999999

The 4-character code for the Organization. This 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_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials, though people may post to any Organization. (For awards that were not active July 1, 1996 and thereafter--AWARD_ORG is the Organization administratively responsible for the award. For pre-7/1/1996 award records for prime or only accounts, PROP_RESP_ORG will be the same as AWARD_ORG. For accounts other than prime or only accounts, they may differ.) To facilitate Organization-based security, records with a null value for COA_ORG will have the value changed to '.' in the Warehouse. Examples: 0102 (Wharton Finance); 0705 (Wharton Legal Studies)

Values:

Refer to the ORG_CODES table for values.

The 4-character code for the program, an activity or work process commonly defined across the University for tracking a program's activity across Schools and Centers (or across organizations within a school or center). AWARD_PROGRAM is the fifth segment of the AWARD_ACCOUNT_NUMBER, the six segment Accounting Flexfield that ought to be used for posting transactions to BEN Financials, though people may post to any program. (For awards that were not active July 1, 1996 and thereafter--AWARD_PROGRAM is null.) Examples: 7311 (Alumni Relations); 0001 (Discretionary)

Values:

Refer to the PROGRAM_CODES table for values.

The 4-character code that identifies the Organization responsible for administering the project, according to the data (from the transmittal form) entered into the Research Services transaction processing system. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). To facilitate Organization-based security, records with a null value for AWD_RESP_ORG will have the value changed to '.' in the Warehouse. For records dating from before November 24, 1997, the values for PROP_RESP_ORG and AWD_RESP_ORG will be the same.

Values:

Refer to the ORG_CODES Table for values.

The 2-character code that identifies the school or center for the Organization responsible for administering the science and the money for the award at the time of the award. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). For records dating from before November 24, 1997, the values for PROP_RESP_SCHOOL and AWD_RESP_SCHOOL will be the same.

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.

Indicates whether the project involves the use of carcinogenic agents. Examples: Y (the project involves the use of carcinogenic agents), [Null] (the project does not involve the use of carcinogenic agents)

Values:

[Null]  No carcinogenic agents are used in the project

Y   Carcinogenic agents are used in the project

Indicates whether the project is a clinical trial. See also the Clinical_Trial_Protocol_Id in the AWARD table. Examples: Y (the project is a clinical trial), [Null} (the project is not a clinical trial)

Values:

[Null]    Not a clinical trial

Y         Clinical trial

The 20-character code assigned by the sponsoring agency to identify the protocol for conducting clinical trials for the project. See also CLINICAL_TRIAL_FLAG.

Values:

List of values not available.

The 4-character code that identifies the Co-Principal Investigator's home Organization as of the time of the award. (Once the end date for the award has passed, CO_PI_HOME_ORG is no longer updated.) The home Organization is the one that owns the Co-Principal Investigator's employee record and is responsible for its maintenance. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the Co-Principal Investigator's home Organization as of the time of the award, the value of CO_PI_HOME_ORG will be set to '.' (rather than null) to facilitate Organization-based security in the Warehouse.

Values:

Refer to the ORG_CODES Table for values.

The 2-character code that identifies the Co-Principal Investigator's home school or center as of the time of the award. (Once the end date for the award has passed, CO_PI_HOME_SCHOOL is no longer updated.) The home school or center is the one that owns the Co-Principal Investigator's employee record and is responsible for its maintenance . The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the Co-Principal Investigator's home school or center as of the time of the award, the value of CO_PI_HOME_SCHOOL will be null.

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.

The number of years beyond the current funding period for which the sponsor has committed funding for the entire project. If this data element is zero (0), no additional years of funding have been committed. Do not sum COMMITTED_YEARS.

Values:

0   No additional years have been committed for further 

    funding

1 - 99  Number of years the project has been committed 

    for further funding

The date when the source record was created. The source record is the record in the Research Services system that is the source of the data in this Award record.

Create_Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 06/29/1994.

Values:

List of values not available.

The ending date for the budget period for this funding increment (Project_Segment_ID), as defined by the project's sponsoring agency. Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment. Each funding increment has a budget period, a discrete period of time for which a fund sponsor has committed funds that can be expended by the University for an agreed upon purpose.

Current_Budget_End is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 8/31/1998.

Before Oct. 1, 2000, this data element was known as End_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:

List of values not available.

The beginning date for the budget period for this funding increment (Project_Segment_ID), as defined by the project's sponsoring agency. Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment. Each funding increment has a budget period, a discrete period of time for which a fund sponsor has committed funds that can be expended by the University for an agreed upon purpose.

Current_Budget_Start is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 09/01/1997.

Before Oct. 1, 2000, this data element was known as Start_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:

List of values not available.

The official date on which the funding increment (identified by the Project_Segment_ID) was received by the University from the sponsoring agency. Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment. See also Award_Create_Date.

Date_Awarded is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 8/29/1997.

Before Oct. 1, 2000, this data element was known as Status_Date. While the contents have not changed, the data element was re-named as part of a project to standardize the date terminology used in sponsored research administration.

Values:

List of values not available.

Total dollar amount designated for direct costs for the award that is assigned to this account for the grant/contract period. This is equal to the TOTAL_AGENCY_AMOUNT minus the INDIRECT_COST_AMOUNT. See also Account_Number and New_Account_Number in the AWARD table.

Values:

0 to 999999999

Indicates whether the project involves recombinant DNA activity. Examples: Y (the project involves recombinant DNA activity), [Null] (the project does not involve recombinant DNA activity)

Values:

[Null]  No recombinant DNA activity is involved in

        the project

Y       Recombinant DNA activity is involved in the 

        project

Total amount awarded for domestic travel for the grant/contract period. For records dating from before September 1, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, DOMESTIC_TRAVEL_AMOUNT will not populated--the budget for domestic travel may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999

Values:

0 to 999999999

The 1-character code indicating whether the award is a new award, an extension, or a renewal. :

Values:

G       Grant change (change of grantee institution)

N       New

P       Pre-proposal

R       Renewal/Competing Continuation  (Used primarily 

        with PHS grant to show competing continuation for 

        a new project period.)

S       Supplement

V       Revision

X       Extension, amendment or non-competing continuation

The fiscal year at Penn in which the award ends. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year. Example: 1998 (for an award whose END_DATE is 12/31/1997)

Values:

List of values not available.

The fiscal year in which the award begins. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year. Example: 1997 (for an award whose START_DATE is 01/01/1997)

Values:

List of values not available.

The fiscal year at Penn in which the award was received by the University from the sponsoring agency. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year. Example: 1997 (for an award whose Status_Date is 11/15/1996)

Values:

List of values not available.

Total amount awarded for foreign travel for the grant/contract period. For records dating from before September 1, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, FOREIGN_TRAVEL_AMOUNT will not populated--the budget for foreign travel may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999

The 4-character code identifying the Organization responsible for managing the fund. (See also AWARD_FUND.) To facilitate Organization-based security, records with a null value for FUND_RESPONSIBLE_ORG will have the value changed to '.' in the Warehouse.

Values:

Refer to the ORG_CODES Table for values.

The 1-character code indicating the type of award. Examples: G (government grant); I (industry/corporation) ???

Values:

G       Government Grant (Federal/State/Local)

C       Government Contract (Federal/State/Local)

N       Non-Government (Foundations, Associations)

I       Industry/Corporation

The 4- to 7-character code assigned by Regulatory Affairs to identify the protocol for the use of human subjects in the project. See also HUMAN_SUBJECTS_FLAG.

Values:

List of values not available.

Indicates whether the project involves human subjects, as noted in the Human Subjects certification. See also the Human_Protocol_Id in the AWARD table. Examples: Y (the project involves human subjects), [Null] (the project does not involve human subjects)

Values:

[Null]  No human subjects are involved in the project

Y   Human subjects are involved in the project

Total dollar amount designated for indirect costs for the award that is assigned to this account for the grant/contract period. See also Account_Number and New_Account_Number in the AWARD table.

Values:

0 to 999999999

A 5-digit number (with 2 decimal places) indicating the rate of indirect cost recovery for the award. The INDIRECT_COST_RATE multiplied by the portion of the direct costs subject to indirect cost recovery equals the INDIRECT_COST_AMOUNT.

Values:

0  to 100.00

Indicates whether the project involves the use of infectious agents. Examples: Y (the project involves the use of infectious agents), [Null] (the project does not involve the use of infectious agents)

Values:

[Null]  No infectious agents are used in the project

Y   Infectious agents are used in the project

The date this award record was extracted from the Research Services system and loaded into the Warehouse. This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 9/22/1997.

Values:

List of values not available.

The date when the source record was last updated. The source record is the record in the Research Services system that is the source of the data in this Award record.

Modify_Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 9/10/1997.

Values:

List of values not available.

A 3-character code used by NIH to identify a specific category of extramural activity. For example: N01 (Research and Development Contracts) is the activity code in the NIH reference number 1-N01-HV-020002-000. Only populated if agency is NIH and this is a federal grant.

Values:

Refer to IMPAC handbook for the list of NIH activity codes.

A 2-letter code that identifies the first major level subdivision within an NIH organization. For example: in the NIH reference number 1-N01-HV-020002-000, HV (Division of Heart and Vascular Diseases) is an administrative organization within NIH. Only populated if agency is NIH and this is a federal grant.

Values:

Refer to IMPAC handbook for the list of NIH administering

organization codes.

A single-digit code that identifies the type of grant application received and processed by NIH. For example: 1 (New) is the application type in the NIH reference number 1-N01-HV-020002-000. Only populated if agency is NIH and this is a federal grant.

Values:

Refer to IMPAC handbook for the list of NIH codes and

application types.

A 6-digit number generally assigned sequentially by NIH to number awards. For example: 020002 is the serial number in the NIH reference number 1-N01-HV-020002-000. Only populated if agency is NIH and this is a federal grant. (Note: 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.)

Values:

Refer to IMPAC handbook for additional information on NIH

serial numbers.

A 4-character code identifying a supplement, amendment, or allowance awarded by NIH. For example: in the NIH reference number 3-P01-NS-011037-20A2S1 SUB 4, the letter S and the related number identifies each supplement, for example, S1, S2 (Supplement 1, Supplement 2) and the letter A and the related number identifies each amendment, for example A1, A2 (Amendment 1, Amendment 2). NIH_Grant_Supplements containing an X are allowances. In the example 1-N01-HV-020002-0000, there is no supplement, amendment or allowance. Only populated if agency is NIH and this is a federal grant.

Values:

Refer to IMPAC handbook for additional information on NIH

supplements, amendments, and allowances.

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. For example: in the NIH reference number 3-R01-CA-012921-04, 04 is the grant year--meaning that the grant is in its fourth year. Only populated if agency is NIH and this is a federal grant.

Values:

Refer to IMPAC handbook for additional information on NIH

grant years.

The 3 initials of the Research Services staff member who is the contact person for this award. See also ORA_CONTACT.

Values:

List of values not available.

The name of the Research Services staff member who is the contact person for this award. The value may be up to 25 characters long. See also ORA_CONTACT_INITIALS.

Values:

List of values not available.

The 2-character code assigned by the ORA (Office of Research Administration) to designate the purpose of the project. Examples: 01 (Research), 05 (Student Aid)

Values:

Refer to the ORA_PURPOSE Table for values.

The identification number that is assigned to the award by the Organization at Penn responsible for administering the project. Example: 93-0418 is an identification number assigned by the Medical School.

Values:

List of values not available.

The date on which the original proposal for the funding cycle was submitted to the sponsoring agency. Note: in cases where the funding cycle is composed of more than one funding increment (Project Segment ID), Original Proposal Date is the submission date for the proposal for the first funding increment within the funding cycle, even when the award record that is being queried is for a later funding increment within the funding cycle. Note also: in cases where the project period is composed of more than one funding cycle, the Original Proposal Date refers to the first proposal for the funding cycle, not the first proposal for the project period. See also PROPOSAL / STATUS_DATE and AWARD / DATE_AWARDED.

The funding cycle is the total period of time for which the sponsor has made an award for a project (usually 1 to 5 years). The funding cycle can be composed of one or more funding increments. (Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment.) The project period is the time from the date the sponsor first authorized an award for a project through the end of the last funding cycle. The project period can be composed of one or more funding cycles.

Original Proposal Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. (To specify the date format in Windows 95, choose the Regional Settings of the Control Panel, select the Date tab and specify the Short date style. In Windows, use the International option of the Control Panel. On the Macintosh, use the Date & Time Control Panel.) Example: 06/30/1994.

Values:

List of values not available.

Total amount awarded for miscellaneous expenses for the grant/contract period. For records dating from before September 1, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, OTHER_EXPENSES_AMOUNT will not populated--the budget for expenses may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999

The 4-character code that identifies the Principal Investigator's home Organization as of the time of the award. (Once the end date for the award has passed, PI_HOME_ORG is no longer updated.) The home Organization is the one that owns the Principal Investigator's employee record and is responsible for its maintenance. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the Principal Investigator's home Organization as of the time of the award, the value of PI_HOME_ORG will be set to '.' (rather than null) to facilitate Organization-based security in the Warehouse.

Values:

Refer to the ORG_CODES Table for values.

The 2-character code that identifies the Principal Investigator's home school or center as of the time of the award. (Once the end date for the award has passed, PI_HOME_SCHOOL is no longer updated.) The home school or center is the one that owns the Principal Investigator's employee record and is responsible for its maintenance . The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the Principal Investigator's home school or center as of the time of the award, the value of PI_HOME_SCHOOL will be null.

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.

The 4-character code that identifies the Organization for the Principal Investigator's primary job appointment as of the time of the award. (Once the end date for the award has passed, PI_PRI_APPT_ORG is no longer updated.). The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the Organization for the Principal Investigator's primary job appointment as of the time of the award, the value of PI_PRI_APPT_ORG will be set to '.' (rather than null) to facilitate Organization-based security in the Warehouse.

Values:

Refer to the ORG_CODES Table for values.

The 2-character code that identifies the school or center for the Principal Investigator's primary job appointment as of the time of the award. (Once the end date for the award has passed, PI_PRI_APPT_SCHOOL is no longer updated.) The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If there is no record of the school or center for the Principal Investigator's primary job appointment as of the time of the award, the value of PI_PRI_APPT_SCHOOL will be null.

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.

The total dollar amount of this award that will be supplied by the University of Pennsylvania as part of a cost sharing agreement with the sponsor. (For some research projects, the sponsor agrees to fund the project only if the receiving institution supplies an agreed upon amount of money to supplement the sponsor-supplied amount.) For records dating from September 1, 1997 and thereafter, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from before November 24, 1997, PROJECT_COST_SHARING_AMOUNT will not be populated. See also PROJECT_COST_SHARING_SOURCE.

Values:

0 to 999999999

The source of the cost sharing funds for this award. (For some research projects, the sponsor agrees to fund the project only if the receiving institution supplies an agreed upon amount of money to supplement the sponsor-supplied amount.) For records dating from November 24, 1997 and thereafter, the value will be populated only for the -01 account (prime or only account) so it is associated with the PROJECT_COST_SHARING_AMOUNT. Note that for records dating from before November 24, 1997, PROJECT_COST_SHARING_SOURCE will not be populated. See also PROJECT_COST_SHARING_AMOUNT.

Values:

List of values not available.

The 5-digit code that uniquely identifies a project. (This is the same as the first five digits of both the AWARD_ID and PROPOSAL_ID.) Example: 27036.

Values:

00000 to 99999

The 7-digit code that identifies a sponsored research project and its funding increment. (This is the same as the first 7 digits of the AWARD_ID.) The first 5 digits identify the sponsored project. (See also PROJECT_ID.) The last 2 digits identify the funding increment. (Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment.) Example: 2703601

Values:

0000000 to 9999999

The 4-character code that identifies the Organization responsible for the proposal at the time of the proposal. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). If it cannot be determined which Organization was responsible for the proposal at the time of the proposal, the value of PROP_RESP_ORG will be set to '.' (rather than null) to facilitate Organization-based security in the Warehouse. For records dating from before November 24, 1997, the values for PROP_RESP_ORG and AWD_RESP_ORG will be the same.

Values:

Refer to the ORG_CODES Table for values.

The 2-character code that identifies the school or center for the Organization responsible for the proposal at the time of the proposal. The code set comes from the present General Ledger accounting structure (in use at Penn since July 1, 1996). For records dating from before November 24, 1997, the values for PROP_RESP_SCHOOL and AWD_RESP_SCHOOL will be the same.

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.

The 9-digit number identifying the proposal that resulted in this award. The first 5 digits identify the project. The next two digits identify the funding increment (which may be 00 for proposals). (Each time the sponsor is asked to pay an installment of the award (or to guarantee payment), that installment is a funding increment.) The last two digits are meaningless for proposals. See also AWARD_ID, PROJECT_ID, and PROJECT_SEGMENT_ID in the AWARD Table. (Note that in the Research Services transaction processing system, the last two digits of PROPOSAL_ID will always be 00 for records dating from November 24, 1997 and thereafter.)

Values:

000000000 to 999999999

Indicates whether the project involves the use of radioactive materials or radiation-producing machines. See also the Radioactive_Protocol_Id in the AWARD table. Examples: Y (radioactive materials or radiation-producing machines are used for the project), [Null] (radioactive materials or radiation-producing machines are not used for the project)

Values:

[Null]  No radioactive materials or radiation-

        producing machines are used for the project

Y       Radioactive materials or radiation-producing 

        machines are used for the project

The 8-character code assigned by the Radiation Safety Office to identify the protocol for the use of radioactive materials in the project. See also RADIOACTIVE_MATERIAL_FLAG.

Values:

List of values not available.

Total amount awarded for subcontracts by the University to other institutions, companies, etc. for the budget period for the funding increment (Project_Segment_Id). Each time the sponsor pays an installment of the award (or guarantees payment), that installment is a funding increment. Each funding increment has a budget period, a discrete period of time for which a fund sponsor has committed funds that can be expended by the University for an agreed upon purpose.

SUB_CONTRACTOR_AMOUNT is populated only for the -01 account for a given award and funding increment, so that it will not be double counted when summarized by award. For records dating from November 24, 1997 and thereafter, a breakdown of this amount by subcontractor is available in the SPON_PROJ_SUBCONTRACTOR table. The breakdown is not available for records dating from before November 24, 1997.

Values:

0 to 999999999

The first 100 characters of the title of the project.

Values:

List of values not available.

Total dollar amount of the award that is assigned to this account for the grant/contract period. See also Account_Number and New_Account_Number in the AWARD table.

Values:

1 to 999999999

Total amount awarded for salary and benefits for the grant/contract period. For records dating from before September 1, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, TOTAL_COMPENSATION_AMOUNT will not populated--the budget for salary and benefits may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999

Total amount awarded for tuition and fees for trainees for the grant/contract period. For records dating from before September 1, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, TUITION_AMOUNT will not populated--the budget for tuition and fees for trainees may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999

Total amount awarded for University charges (i.e. mail, service centers) for the grant/contract period. For records dating from before November 24, 1997, the value will be populated only for the -01 account (prime or only account) so it will not be double-counted when it is summarized by award. Note that for records dating from November 24, 1997 and thereafter, UNIVERSITY_EXPENSES_AMOUNT will not populated--the budget for expenses may be retrieved from the BEN Financials General Ledger Balances table.

Values:

0 to 999999999