Skip to main content
Penn Information Systems & Computing Systems Home

Search form

Getting system status
  • Get Started
    • IT Staff
    • Faculty
    • Staff
    • Students
    • Alumni & Guests
    • ISC Staff
  • Services
    • — Services A to Z —
    • Accounts, Access & Security
      • Access Management Services
      • Active Directory
      • Identity Management Services
      • Information Security Services
    • Applications & Data Analytics
      • Application Development & Delivery
      • Data Analytics
        • Data Analytics at Penn
      • Integration Development & Delivery
    • Backup, Storage & Platforms
      • BackItUp
      • Cloud Solutions
      • Data Center & Colocation Solutions
      • Database & Application Platform Support & Consulting
      • Endpoint Management
      • Recovery Solutions
      • Storage
      • Virtual Desktop
      • Virtual Server Hosting
    • Community, Support & Learning
      • Classroom Technology Services
      • Desktop Engineering
      • IT Community Events
      • LinkedIn Learning
      • Tech Center
    • Consulting & Professional Services
      • Brokered Products
      • HireIT
      • Systems Support & Consulting
      • Technology Forecasting
    • Email, Calendaring & Collaboration
      • Classlists
      • Penn Email Routing
      • PennBox
      • PennNet Mailing Lists
      • PennO365
      • PennZoom
      • SMTP-Relay
      • Secure Share
    • Networks & Connectivity
      • Firewall Services
      • Network Design & Installation
      • PennNet
        • Network Names & Numbers
        • MAGPI (Penn's Internet2 Regional Optical Network)
      • PennNet Ethernet Ports
      • Wireless at Penn
    • Phone, TV & Video
      • Contact Center
      • Live Video Streaming
      • Penn Video Network
      • PennFlex Phone
      • Traditional Telephony
      • Video Content Management
      • Video Production
        • Producing Video Content
    • Web Hosting
      • Web Hosting Service
    • — Service Rates —
    • — Service Level Agreements —
  • Security
    • Office of Information Security
    • Security Services
    • Special Projects
    • Policies & Procedures
    • Training & Awareness
    • Penn SecureIT program
  • Collaborations
    • Computing Policies
    • Engaging Penn’s IT Community
    • Identity & Access Management
    • Penn IT Strategic Plan
    • Cloud First
    • Next Generation Unified Communications
    • Penn Bot
    • IT Advisory Groups
      • Common Solutions
      • IT Roundtable
      • Network Policy Committee
      • Penn Technology Investment Committee (PTIC)
        • About PTIC
        • The PTIC IT Development Fund
    • Special Interest Groups (SIGs)
      • Audio-Visual (AV-SIG)
      • Cloud Computing (Cloud-SIG)
      • Data Visualization (DataViz-SIG)
      • Developer SIG (Dev-SIG)
      • High-Performance Computing (HPC-SIG)
      • Instructional Technology SIG
      • Linux SIG
      • Macintosh Networking Group (MacNet)
      • Mobile Technologies (Mobile-SIG)
      • O365 Special Interest Group
      • PC Networking Group (PC-Net)
      • Project Partners SIG
      • Security SIG
      • Social Media SIG
      • Splunk Special Interest Group
      • Super User Group (SUG)
      • Web SIG
    • Technology Services Strategy Review Board
  • News
  • About
  • Hot Topics
  • Get IT Help

You are here

Home » Research Inventory Data Collection

Research Inventory Data Collection

The Research Inventory data collection is the subset of the University Data Warehouse that contains sponsored project subrecipient agreement data, which has been exported to the Data Warehouse from the Research Inventory system (RIS). Subrecipient agreements are often referred to as subawards, but they also include subcontracts and purchased services agreements.

    Tables and Data Elements
    • Tables and Data Elements
    • Schedule
    • Training
    • Security
    • Help

    Currently, the Research Inventory data collection stores information on subaward requests, including data on prime awards and Penn contact information, subaward details and subrecipient contact information, and the review and activity logs for the requests. Information is also available for Fee for Service (FFS) Agreements, Material Transfer Agreements (MTAs), and Other Non-Monetary Agreements (NMAs).

    Some data is available only to authorized staff members of the Office of Research Services:

    • executive compensation data (used for Federal Funding Accountability and Transparency Act of 2006 (FFATA) reporting)
    • data from the Risk Assessment Questionnaire
    • Community data--master data for subcontractors (institutions that receive funding or payments from Penn per subrecipient agreements) and for federal programs that are identified by CFDA numbers

    Tables and Data Elements

    The Research Inventory data collection is refreshed on a nightly basis.

    No data training is required to obtain access to the data. Please contact Enterprise Information & Analytics for assistance with specific training questions.

    Those who wish to access the Research Inventory data collection must submit this eForm.

    When you are granted access to the Research Inventory data in the Warehouse, a subscription is automatically set up for you to participate in an E-mail listserv called RIS-WH@LISTS.UPENN.EDU. (Those with subscriptions to the list are called list members. If any member sends an E-mail note to the list, every member of the list receives a copy.)If you have a question about the Research Inventory data, please send E-mail to the list -- and if you have the answer to a list member's question, please E-mail your reply to the list so all the members can benefit from the discussion.

    Visit ISC on LinkedIn

    Print
    EI&A Home
    Query Tools
    • Introduction
    • BusinessObjects BI Launch Pad
    • BusinessObjects Tips & FAQs
    • QlikView Access Point
    • QlikView Tips & FAQs
    Resources
    • Access Forms
    • Current Load Status
    • Password Changer
    Warehouse Information
    • Guidelines for Writing Queries
    • Security
    • Support Services
    • Training
    Other Information
    • Data Analytics at Penn
    Contact EI&A
    • Computing Policies
    • Tech Jobs @ Penn

    © 2025 THE UNIVERSITY OF PENNSYLVANIA — 3401 Walnut Street, Philadelphia, PA 19104 — Report accessibility issues and get help — For ISC Staff