Database Fields
Any new values that you add or modify within the database fields require you to remove the rule then add it back to reflect the changes. For example, if you configure the ISIR Results database field to a Verification Status of 'Verified', the new status will not appear in the drop-down field until you remove the rule and then reapply it.
Note: For award year 2024-25 and later, the system marks all ISIR database fields that are no longer valid with a red asterisk (*). The system also displays a red asterisk (*) at the end of all field rules for line items configured with a database field that will no longer be valid after 2023-24.
Automated Awarding will process any fund source rule written against an ISIR database field with an asterisk as skipped from validation for the 2024-25 award year and future award years. This will allow the 2023-24 and prior award years to validate the ISIR database fields, but the 2024-25 and future award years will not be impacted since the fields are no longer present on the ISIRs.
The Dependency Status Model field in the ISIR Data folder provides the Dependent or Independent field values. The field value of Rejected Dependent or Rejected Independent changes to NULL.
Automated Awarding Fund Source Rules places a red asterisk (*) at the end of ISIR database fields that no longer are valid on the ISIR for the 24/25 award year and after. Legacy updates the full database field name in red with the asterisk.
Folder | Field | |
---|---|---|
Database Fields | Athletics | Based on configured values |
Documents - Academic Records |
Based on all documents configured for the campus within the Academic Records module. Examples: AR - Likeness Name Usage Form - Date Received AR - Likeness Name Usage Form - Status |
|
Documents - Admissions |
Based on all documents configured for the campus within the Admissions module. Examples: AM - Application For Admissions - Date Received AM - Application For Admissions - Status |
|
Documents - Career Services |
Based on all documents configured for the campus within the Career Services module. Examples: EX - Externship Employer Evaluation 1 - Date Received EX - Externship Employer Evaluation 1 - Status |
|
Documents - Contact Manager |
Based on all documents configured for the campus within the Contact Manager module. FERPA Document - Date Received FERPA Document - Status |
|
Documents - Financial Aid |
Below are examples, as this is based on all documents configured for the campus within the Financial Aid module. FA - Alien Registration - Date Received FA - Alien Registration - Status |
|
Documents - Loan Management |
Based on all documents configured for the campus within the Loan Management module. Examples: DP - Exit Interview - Date Received DP - Exit Interview - Status |
|
Documents - Other | Based on configured values | |
Documents - Student Accounts |
Based on all documents configured for the campus within the Student Accounts module. Examples: SA - Ledger Card Prior to Conversion - Date Received SA - Ledger Card Prior to Conversion - Status |
|
Documents - Student Services | Based on configured values | |
Documents - System |
Based on all documents configured for the campus within the System module. Examples: National Do Not Call Override Document - Date Received National Do Not Call Override Document - Status |
|
Enrollment |
Academic Advisor Academic Calendar CIP Code Campus Code Credits Earned Credits Scheduled Credits per Term Degree Code Degree Level Degree Program? Enrollment Cum GPA Enrollment Date Enrollment Status (Full, 3/4, Half, etc.) Enrollment Term Expected Graduation Date Grade Level Hours per Term Last Date Attended Overall Cum GPA Program Code Program Length (Weeks) Program Version Code SAP Status Status Category Student Status Term Code Title IV Eligible Program? Total Credits/Hours for Program |
|
GPA's |
Area of Study GPA - Cum Cred Att Area of Study GPA - Cum Cred Earn Area of Study GPA - Cum GPA Course Level GPA - Cum Cred Att Course Level GPA - Cum Cred Earn Course Level GPA - Cum GPA CourseCategoryGPA - Cum Cred Att CourseCategoryGPA - Cum Cred Earn CourseCategoryGPA - Cum GPA Enrollment GPA - Cum Cred Att Enrollment GPA - Cum Cred Earn Enrollment GPA - Cum GPA Overall Cum GPA - Cum Cred Att Overall Cum GPA - Cum Cred Earn Overall Cum GPA - Cum GPA |
|
ISIR Data |
Active Duty in Armed Forces? * Active Duty in Armed Forces? 24/25 (not validated for 2023/24 and prior award years) Degree/Certificate * Dependency Status Model Drug Conviction Affecting Eligibility? * Father Income * First Batch Degree Grade Level In College * Grade Level In College 24/25 (not validated for 2023/24 and prior award years) HS Diploma or GED? Interested in Work-Study? * Is Student Male? * Is Student Married? * Mother Income * Net Worth of Parents' Business/Farm Parent Legal Residence Date Parent State of Legal Residence Parent a Dislocated Worker? * Parent's IRA Payments * Parents Exemptions * Parents Number in College Parents Number of Family Members Parents Tax Form Used * Parents' Adjusted Gross Income * Parents' Calculated Tax Status * Parents Cash, Savings, and Checking Parents' Child Support Paid * Parents' Child Support Receive Parents' Combat Pay * Parents' Educational Credits * Parents' Eligible to file 1040A/1040EZ * Parents' Interest Income * Parents' Investment Net Worth Parents' Medicaid or SSI Benefits * Parents' Military/Clergy Allowances * Parents' Need-Based Employment * Parents' Other Untaxed Income * Parents' Pension Payments * Parents' U.S. Income Tax Paid * Parents' Untaxed Income Total * Parents' Untaxed Portions of IRA Distributions and Pensions * Parents' Veterans Non-education Benefits * Spouse Income * Student AGI * Student Citizenship Student Date of Birth Student Has Children to Support * Student Has Legal Dependents other than Child/Spouse * Student Income * Student Marital Status * Student Marital Status 24/25 (not validated for 2023/24 and prior award years) Student Marital Status Date * Student Monthly Veterans Education Benefits * Student Permanent City Student Permanent State Student Permanent Zip Student Residence 5+ Years * Student Residence Date (YYYYMM) Student State of Legal Residence Student Tax Return Completed * Tax Form Used * Veteran of Armed Forces? Working on Master or Doctorate Program * |
|
ISIR Results |
Application Receipt Date Automatic Zero EFC? * DOD Match Flag * Date Application Completed * Date ISIR Received Full Time Pell Grant Amount ISIR Comment Codes ISIR SAI (Student Aid Index) Institutional EFC * Packaged EFC * Parent Contribution * Pell Grant Eligibility Flag Pell Paid EFC * Primary EFC * SAR C Code Simplified Needs Test * Student Selected for Verification Transaction Process Date (If no ISIR is on file for Award Year 1, the transaction process date will default to 01/01/1900.) Transaction Receipt Date Verification Status Verification Tracking Flag |
|
NSLDS Data |
ACG Overpayment Flag * Active Bankruptcy Flag Database Results Flag Defaulted Loan Flag Fraud Loan Flag PERKINS Overpayment Flag Pell Lifetime Eligibility Used Pell Overpayment Flag SEOG Overpayment Flag SMART Overpayment Flag * Satisfactory Repayment Flag Subsidized Usage Limit Applies Flag Subsidized Usage Period TEACH Grant Undergrad Disb Amount TEACH Overpayment Flag TEACH Pmt 1 Award Yr TEACH Pmt 1 Disb Amt TEACH Pmt 1 Grade Level TEACH Pmt 2 Award Yr TEACH Pmt 2 Disb Amt TEACH Pmt 2 Grade Level TEACH Pmt 3 Award Yr TEACH Pmt 3 Disb Amt TEACH Pmt 3 Grade Level Unusual Enrollment History Flag |
|
Package |
Prior Year Award |
|
Populations |
Based on all populations configured for the campus. Example: Population Name |
|
State Grant |
This folder only supports Georgia HOPE scholarship for private institutions' state grants supported by Anthology Student and SFAAA. Example: HOPE Eligible |
|
State Report Benchmarks |
These fields are configured by the institution. Examples: HOPE - Eligibility Status Zell Miller - Eligibility Status |
|
Student |
Agency/Sponsor Alien Registration Number Area Of Study Birth Date Campus Code Citizenship City E-Mail Address Extra-Curricular First Name Gender In District Last Name Phone Previous Education High School GPA Soc Sec Nbr State of Residence Veteran Zip Code |
|
Student - School Defined |
School-defined fields within the folder are created and assigned a value of "online" so they are available for SFAAA. Examples: FAA Test Maximum Packaging |
|
Student Ac Yr Budget |
Board Books/Supplies Fees Other Institutional Costs Other Non-Institutional Costs Pell COA Personal Room Total COA Total Direct Costs Travel Tuition |
|
Student Academic Year |
Credits Expected to Complete Eligible Health Profession End Date First Award Year First Time Borrower Grade Level (Dept of Ed) Grade Level Code Housing Status Months in Year PLUS Credit Decision Status Second Award Year Sequence Start Date Unsupported Dependent Weeks Enrolled in Ac/Yr |
|
Student Group |
Based on all student groups configured for the campus. Example: !!!DB - Student Group 001 The Verification Group configured in this database field is award-specific for Pell, TEACH, and SEOG funds regardless of whether the fund is awarded through Award Year 1 or Award Year 2. All other fund sources are award year-specific when the fund is awarded through Award Year 1. |
|
Student Schedule |
Academic Year Sequence Course Code Course Status Credits Hours Enrollment Status Credits Enrollment Status Hours Expected End Date Student Start Date Term Description |
|
Tests |
All tests are configured in Admissions > Tests. When you drop a Test onto the Rules form, a field is presented to enter information applicable to the test. This enables tests to be incorporated into the SFAAA processes. Examples: Tests of type - Date Tests of type - Numeric Tests of type - Score Tests of type - Text |
|
Calculated Fields |
Based on a configured field from the campus. RBS Calculated Field |
|
Conditional Builders |
Preset parameters you can use to create a fund source rule. All of the following Any of the following End |
|
Conditional Templates |
Based on a configured set of database fields saved for the campus. Examples: DB SUB - Award Limit |