Database Fields

Note: 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', you will not see the new status in the drop-down field until you remove the rule and then reapply it.

Database Fields Available for Use in FAA 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

Campus Code

Last Date Attended

Start Date

Program Code

Program Version Code

Degree Code

Expected Graduation Date

Program Length (Weeks)

Credits Earned

Credits Scheduled

Total Credits/Hours for Program

Enrollment Status (Full, 3/4, Half, etc)

SAP Status

Student Status

Grade Level

Enrollment Cum GPA

Overall Cum GPA

Degree Program?

Title IV Eligible Program

Academic Calendar

Academic Advisor

CIP Code

Enrollment Term

Status Category

Degree Level

  GPA's

Area of Study GPA - Cum GPA

Area of Study GPA - Cum Cred Att

Area of Study GPA - Cum Cred Earn

Course Level GPA - Cum GPA

Course Level GPA - Cum Cred Att

Course Level GPA - Cum Cred Earn

CourseCategoryGPA - Cum GPA

CourseCategoryGPA - Cum Cred Att

CourseCategoryGPA - Cum Cred Earn

Enrollment GPA - Cum GPA

Enrollment GPA - Cum Cred Att

Enrollment GPA - Cum Cred Earn

Overall Cum GPA - Cum GPA

Overall Cum GPA - Cum Cred Att

Overall Cum GPA - Cum Cred Earn

  ISIR Data

Student Income

Spouse Income

Father Income

Mother Income

Student AGI

Dependency Status Model

Student Permanent City

Student Permanent State

Student Permanent Zip

Student Date of Birth

Student Citizenship

Student Marital Status

Student Marital Status Date

Student State of Legal Residence

Student Residence 5+ Years

Student Residence Date (YYYYMM)

Is Student Male?

Degree/Certificate

Grade Level In College

Enrollment Status

Interested in Work Study?

HS Diploma or GED?

First Batch Degree

Drug Conviction Affecting Eligibility?

Student Tax Status

Tax Form Used

Student Monthly Veterans Education Benefits

Number of Months Veteran Benefits Received

Working on Master or Doctorate Program

Is Student Married?

Student Has Children to Support

Student Has Legal Dependents other than Child/Spouse

Active Duty in Armed Forces?

Veteran of Armed Forces?

Parents' Marital Status

Parents' Number of Family Members

Parents' Number in College

Parents' State of Legal Residence

Parents' Legal Residence Date

Parents' Exemptions

Parents' Tax Form Used

Parents' Calculated Tax Status

Net Worth of Parents' Business/Farm

Parents' Cash, Savings, and Checking

Parents' Combat Pay

Parents' Child Support Paid

Parents' Child Support Receive

Parent a Dislocated Worker?

Parents' Adjusted Gross Income

Parents' U.S. Income Tax Paid

Parents' Interest Income

Parents' Investment Net Worth

Parents' IRA Distributions

Parents' IRA Payments

Parents' Military/Clergy Allowances

Parents' Need-Based Employment

Parents' Educational Credits

Parents' Eligible to file 1040A/1040EZ

Parent Federal Benefits - Supplemental Security Income Benefits

Parents' Federal Benefits - SNAP Benefits

Parents' Federal Benefits - Free/Reduced Price School Lunch

Benefits Parents' Federal Benefits - TANF Benefits

Parents' Federal Benefits - WIC Benefits

Parents' Other Untaxed Income

Parents' Pension Payments

Parents' Untaxed Income Total

Parents' Untaxed Pensions

Parents' Veterans Non-education Benefits

  ISIR Results

Primary EFC

Pell Paid EFC

Packaged EFC

Institutional EFC

Parent Contribution

Pell Grant Eligibility Flag

Pell Grant Amount

Simplified Needs Test

Automatic Zero EFC?

Student Selected for Verification

SAR C Code

Verification Status

ISIR Comment Codes

Transaction Process Date (If no ISIR is on file for Award Year 1, the transaction process date will not be blank and will default to 01/01/1900.)

Date ISIR Received

Transaction Receipt Date

Date Application Completed

Application Receipt Date

DOD Match Flag

Verification Tracking Flag

  NSLDS Data

Database Results Flag

Defaulted Loan Flag

Discharge Loan Flag

Fraud Loan Flag

Satisfactory Repayment Flag

Active Bankruptcy Flag

ACG Overpayment Flag

Pell Overpayment Flag

SEOG Overpayment Flag

PERKINS Overpayment Flag

SMART Overpayment Flag

TEACH Overpayment Flag

Aggregate Loans Balance and Expected

Aggregate Subsidized Loan Balance and Expected

Aggregate Unsubsidized Loan Balance and Expected

Aggregate Loan Balance

Aggregate Subsidized Loan Balance

Aggregate Unsubsidized Loan Balance

TEACH Grant Undergrad Disb Amount

TEACH Grant Grad Disb Amount

Pell Lifetime Limit Flag

Pell Lifetime Eligibility Used

Unusual Enrollment History Flag

Subsidized Usage Limit Applies Flag

Subsidized Usage Period

TEACH Pmt 1 Disb Amt

TEACH Pmt 1 Award Yr

TEACH Pmt 1 Grade Level

TEACH Pmt 2 Disb Amt

TEACH Pmt 2 Award Yr

TEACH Pmt 2 Grade Level

TEACH Pmt 3 Disb Amt

TEACH Pmt 3 Award Yr

TEACH Pmt 3 Grade Level

  Package

Prior Year Award

SEOG Award Year

  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

First Name

Last Name

City

State of Residence

Zip Code

E-Mail Address

Alien Registration Number

Phone

Soc Sec Nbr

Birth Date

Citizenship

In District

Gender

High School Academic GPA

Campus Code

Veteran

Agency/Sponsor

Extra-Curricular

Area Of Study

  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

Tuition

Fees

Books/Supplies

Room

Board

Personal

Travel

Other Institutional Costs

Other Non-Institutional Costs

Total COA

Pell COA

Total Direct Costs

  Student Academic Year

Sequence

Start Date

End Date

Weeks Enrolled in Ac/Yr

Credits Expected to Complete

First Award Year

Second Award Year

First Time Borrower

Grade Level (Dept of Ed)

Grade Level Code

Housing Status

Months in Year

Unsupported Dependent

Eligible Health Profession

  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

Course Code

Term Description

Academic Year Sequence

Course Status

Credits Hours

Enrollment Status Credits

Enrollment Status Hours

Student Start Date

Expected End Date

  Tests

All tests configured in Admissions > Tests. When you drop a Test on to 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