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
Workbook Description
The file name for this workbook is PELL_SCHEDULE.csv.
- 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
|
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.