Pell Schedule Guide

Use this workbook to determine Federal Pell Grant award amounts. This configuration is delivered and updated as part of Baseline Configuration using the U.S. Department of Education Pell Grant Payment Schedules, but you can also update it.

Defining the Configuration.csv File

Note: This workbook is only applicable to the 2023-2024 and prior Aid Years.

Workbook Description

The file name for this workbook is PELL_SCHEDULE.csv.

Configuration Workbooks are delivered in the form of Excel spreadsheets. In these spreadsheets, every configurable field is represented as a spreadsheet column and there are as many spreadsheet rows as needed for that particular configuration. Here are the column descriptions:

• Field Name.
• Column: Spreadsheet column associated with the field.
• Required?: Denote if you're required to populate the field or not.
• Field Type and Accepted Values:
  • String: These are usually alphanumeric.
  • Integer: Numeric, a whole number.
  • Double: Numeric with places to the right of the decimal.
  • Enumeration: List of values.
  • Boolean: True or False, Yes or No.
  • Groovy script: A logical query using groovy script.
  • Date: yyyy-mm-dd format.
• Description.

Field Name	Column	Required?	Field Type and Accepted Values	Description
Aid_Year	A	Y	String	Aid Year of Pell Grant Payment Schedule. Example: 2021-2022
Enrollment_Status	B	Y	String HALF_TIME THREE_QUARTER_TIME FULL_TIME	Student's enrollment status for Pell Grant award.
COA_Min	C	Y	Integer	Minimum Cost of Attendance for Pell Grant award amount.
COA_Max	D	Y	Integer	Maximum Cost of Attendance for Pell Grant Award Amount.
EFC_Min	E	Y	Integer	Minimum Estimated Family Contribution for Pell Grant award amount.
EFC_Max	F	Y	Integer	Maximum Estimated Family Contribution for Pell Grant award amount.
Pell_Amount	G	Y	Integer	Pell Grant award amount.

Enable the Configuration in the UI

There is no UI setup to enable this configuration.