SSP FAQ- External Data
- Jason Elwood
SSP FAQ for External Data Questions
Questions and Answers |
|---|
| Loading external data for students who take the same test more than once in a day. |
The external database table that holds records for test students have taken. The results of the tests are stored in external_student_test. The natural/primary key for external_student_test consists of the following columns.
The discriminator column is used to distinguish the exact same test taken on the same day. The default value of 'discriminator' is '1'. The application does not care what values are set. I.e. it is intended to be a completely opaque value used exclusively to distinguish between multiple sittings for the same exam on the same date. For implementers upgrading to v2.0.1 with duplicate rows, the update needs to be applied in multiple steps.
For implementers installing v2.0.1 or later, the data should be loaded with appropriate discriminator values. Documentation for the external tables |
The number of earned hours at an A and B level required to achieve an overall 2.0 gpa (external_student_financial_aid.gpa_20_a_hrs_needed). A student can have 6 credit hours with an "B" and a "D" grade and have a 2.0 gpa.
|
| The original intent is to give students an indication of what they would have to accomplish to achieve an A or B GPA . A & B level will vary for each school. Traditionally, they would indicate a GPA representing an A (4.0) or B (3.0) using a standard calculation of earned/attempted. The example of B and D grades is correct. |
| What is the indicator for the student's eligibility to receive federal financial aid (external_student_financial_aid.eligible_federal_aid). How is this defined? |
| This indicates whether or not the student can currently receive federal aid. Student may be disqualified for not meeting SAP status, exhausting all federal aid, etc. |
| The number of remaining eligible terms to receive financial aid (external_student_financial_aid). Is this for the aid year? Is this the number of terms before they have maxed their federal aid? |
| The original intent was to display the number of remaining terms before reaching the maximum limit for federal aid. The value could be used for either definition. |
| What is the acceptance status of financial aid for the term (external_student_financial_aid_award_term). What does this mean? |
| Each term the student is eligible for financial aid, they must accept the award. The table holds a list of terms for which the student was eligible and whether or not the student accepted aid that term. |
| What is the SAP status (external_student_financial_aid)? |
| SAP Status is a calculation required by the Department of Education (DOE) to indicate Satisfactory Academic Progress. Every institution is required to calculate and report the data to the DOE. Each institution may have multiple status code definitions. Those definitions are configured in SSP. |
| The file name of the Financial Aid information related to the files required in the student application (external_student_financial_aid_file). Which student application? |
In order for a student to receive financial aid, there are many requirements and documents that must be met. The list of documents varies by schools but always includes the FAFSA. The list should be configured in SSP to indicate which files are required by the implementers Financial Aid office. Based on the required document list, this table will hold the status of the required files for each student. For example:
|