Penn Computing

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

ORA_PURPOSE Table - Data Element Index

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

 

Data element Definition
ORA_PURPOSE_CODE

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

A 2-digit code assigned by the ORA (Office of Research Administration) to designate the purpose of a project. Examples: 01 (Research), 05 (Student Aid). Note: this is not the same as the BEN Financials FUND_PURPOSE_CODE, whose decoded values are stored in the PURPOSE_CODES table.

Values:

01   Research

     Includes research projects under the direction of 

     a P.I. with academic rank of Assistant Professor

     or higher (or equivalent). Do not include fellowships,

     scholarships, RCDAs. Include PHS Program Codes R, 

     M, P, S.  Also include most NSF Programs.

02   Training

     Includes projects for new or expanded 

     University curricula, training courses, teaching 

     programs, general education support programs.  

     Include PHS Program Codes A, D, T, E, and G.

03   Community Service

     Includes special community projects.  Do not 

     include research or training programs.

04   Facilities and Equipment

     Includes programs which are entirely for procurement 

     of new buildings and structures.  Include PHS Program

     Codes J, C.

05   Student Aid

     Includes projects where principal funding is for student

     stipends, tuition and fees.  Include all fellowships and

     scholarships.  Include PHS Program Code F.

06   Research Career Development Awards

     Includes only PHS RCDAs, Program Code K.

07   Other

     Includes anything not identified in codes 01 to 06.  

     Code 07 should be used only in unusual circumstances.
ORA_PURPOSE_NAME

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

The 11-character description of the purpose of the project as designated by the ORA (Office of Research Administration). Examples: 01 (Research), 05 (Student Aid). Note: this is not the same as the BEN Financials FUND_PURPOSE_CODE, whose values are stored in the PURPOSE_CODES table.

Values:

01   Research

     Includes research projects under the direction of 

     a P.I. with academic rank of Assistant Professor

     or higher (or equivalent). Do not include fellowships,

     scholarships, RCDAs. Include PHS Program Codes R, 

     M, P, S.  Also include most NSF Programs.

02   Training

     Includes projects for new or expanded 

     University curricula, training courses, teaching 

     programs, general education support programs.  

     Include PHS Program Codes A, D, T, E, and G.

03   Community Service

     Includes special community projects.  Do not 

     include research or training programs.

04   Facilities and Equipment

     Includes programs which are entirely for procurement 

     of new buildings and structures.  Include PHS Program

     Codes J, C.

05   Student Aid

     Includes projects where principal funding is for student

     stipends, tuition and fees.  Include all fellowships and

     scholarships.  Include PHS Program Code F.

06   Research Career Development Awards

     Includes only PHS RCDAs, Program Code K.

07   Other

     Includes anything not identified in codes 01 to 06.  

     Code 07 should be used only in unusual circumstances.

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

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

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