US English (US)
ES Spanish

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Log in
English (US)
US English (US)
ES Spanish
  • Home
  • Help & Support
  • Support
  • Deep Dive
  • RIO Education Modules
  • RIO Reporting
  • RIO Reporting (US)

RIO Reporting (US) - IPEDS

This guide explains the information required when reporting to the Integrated Postsecondary Education Data System.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • RIO Certification
    RIO Certification Program RIO Academy RIO Challenge RIO Recipe Training
  • Releases
    Release Notes
  • Help & Support
    Install RIO Education RIO Insights RIO Recipe Support
  • About Us
    Who is RIO Education? Start Your RIO Journey Housekeeping
  • Experience RIO in action
+ More

Table of Contents

Introduction Prerequisites Procedures Reporting Configurations Data Preparations Automation


Introduction

This guide outlines the steps required for an end user to setup an IPEDS (Integrated Postsecondary Education Data System) report.

IPEDS is a US Reporting standard. There are multiple report types that need to be generated and submitted at different times during the reporting period. 

Access the Survey Materials (Format) required to submit the report. Input the Institution details here for the specific format or View All a general format via Import Spec.


Example for IPEDS 2023-24 data collection schedule:

Reporting Period
Fall
Winter
Spring
Report Types Required Institutional Characteristics;
Completions;
12-month Enrollment
Student Financial Aid;
Graduation Rates;
200% Graduation Rates
Admissions;
Outcome Measures
Fall Enrollment;
Finance;
Human Resources;
Academic Libraries


Prerequisites

  • The following managed packages must be installed in the Salesforce org:
    • EDA.
    • RIO Education.
    • RIO Reporting (US) - IPEDS.
  • The "REDU - IPEDS Reporting" permission set must be assigned to the user.
  • Refer to RIO Reporting Engine (Generic) documentation here to see how it works


Procedures

Reporting Configurations

The default configuration are generated once you installed the additional plan - "RIO Reporting - IPEDS" and it breaks into 2 main components:

  1. The backend configuration - Custom Metadata Types.
    • Navigate to Setup >> Home >> Search for Custom Metadata Types and manage the following records:
      • Export File Standard.
      • Export File Type.
      • Export File Section.
      • Export Data Field.
      • Export Data Holder Config.
    • User can update the field mapping for the report generation here.
    • Refer to the field mapping spreadsheet here for details.

  2. The front-end configuration - Custom Object.
    • From the Apps menu, select the 'RIO Reporting Engine' and click of the following tab:
      • Reporting Configurations.
        • By the default, there are 3 Reporting Configurations created based on the reporting period of Fall, Winter, and Spring.
        • Each of the Reporting Configuration are configured with the reporting type which referring to the Export File Standard of the Custom Metadata Types; while the Reporting Queries are linked to the Export File Type and Export File Section.
        • User can configure the query/ the criteria of which records should be considered for the report generation.

      • Reporting Exports.
        • This is the reporting export interface where user can generate the IPEDS reporting based on the reporting period.
        • By the default there are 3 Reporting Exports created and linked to the Reporting Configuration above according to the reporting period.

Data Preparations

Before the export can be generated, we will have to ensure that the following data are ready:

  • Reporting Exports

    These are data relevant to the reporting scope which will need to be defined in a yearly basis. To ease the process, it is recommended to clone the current's year "Reporting Export" record and make the updates accordingly for the upcoming year.
    (Note: The updates will mainly focuses on defining the data collection period for the upcoming year.)

  • IPEDS Default Values

    These are information relevant to the institution (for example, does your institution offer housing?, etc.).
    Generally, these data are very likely to be similar every year, thus it is recommended to clone the "IPEDS Default Values" record for the newly cloned Reporting Exports (as mentioned above) every year.
    The following shows the relationship of "IPEDS Default Values" and "Reporting Export":



  • Master Data

    These are data relevant to the program, offered courses, fees, and scholarship. These data are typically populated once unless there are new programs/ offered courses/ fees/ scholarship introduced to the system. In that case, user will need to populate the dedicated fields for the involved records.
    • Account (Educational Institution).
    • Account (Academic Program).
    • Plan Requirement (Course).
    • Course Offering.
    • Funding.
    • Fee.

  • Student Data

    These are transactional data relevant to the student such as contact, program application, program enrollment, and scholarships granted.
    • Contact.
    • Program Application.
    • Program Enrollment.
    • Funding Allocation.
    • Course Connection.


Refer to the spreadsheet here for the full list of objects and fields.


Automation

Following fields will be populated by the automation comes with IPEDS Reporting package.

Object Name

Field Name

IPEDS Reporting File

Description

PE Discipline

Major Identification

  • Completions

Indicates the academic major of the enrolled program:

  • First Major
  • Second Major

Program Enrollment

Progression Status

  • 12-Month Enrollment
  • Student Financial Aid
  • Outcome Measure
  • Graduation Rates
  • Fall Enrollment

Indicator of whether a student who was previously enrolled in the same degree or certificate program at your institution re-enrolled for the next academic year:

  • First-time
  • Transfer-in
  • Continuing
  • Transfer-out

Program Enrollment

Pell Grant Recipient

  • Outcome Measure

If checked TRUE, indicates that the student is a Pell Grant recipient (Scholarship type = Pell Grant).

Program Enrollment

Direct Loan Recipient

  • Graduation Rates

If checked TRUE, indicates that the student is a Direct Loan recipient (Scholarship type = Direct Loan).





ipeds reporting

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Setup Reporting Configuration and Query
  • Setup System and Dynamic Merge Fields
  • Setup Reporting Metadata
  • Exporting Report and Status Monitoring
RIO Education

RIO Education, a WDCi Company. This information is proprietary, confidential and protected by copyright ©2024.

CONTACT

Get in touch

  • Privacy
  • Terms of service

Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand