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