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.

Database Fields Available for Use in Automated Awarding Fund Source Rules
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.
Examples:

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  ClosedRead Note.

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