...
The screen is used to upload information from Campus Cafe into Financial Aid Software. When you click the Export F/A button, data will be inserted into a table called external_data in the PowerFAIDS database. The data is then imported into the financial aid system using its import facility.
Export F/A Data
Enter up to 5 semesters, up to 5 sites, a housing semester (also used for inquiry students), and an academic year start date to process and click on transfer submit to create the transfer file.
...
It will exclude records where the STBIOS.ID_NUMBER = STBIOS.SOCIAL_SEC_NUMBER.
SQL Filter Example SQL query of what this process does behind the scenes (Sample WHERE CLAUSE):
WHERE (STBIOS.ID_NUMBER IN (SELECT HOHIST.ID_NUMBER FROM HOHIST WHERE HOHIST.CURRENT_SEMESTER = 201620 202520 AND HOHIST.BILLING_SITE IN (01)) OR
(STBIOS.ID_NUMBER IN (SELECT ID_NUMBER FROM STBIOS WHERE ADM_PROGRESS_CODE IN ('A','C','P','Y','AW','YW','PW','YR','PC') AND STBIOS.ADMISSIONS_ENT_SEM = 201620 202520 AND STBIOS.ADMISSIONS_SITE IN (01)))) AND ADM_PROGRESS_CODE NOT IN ('X')
...
Progress Code (admissions_status) Logic
If the admissions entering semester = the primary semester entered for the export the status is set to the COMMON_APP_CODE associated with the student’s progress code (STPARM – SBPRCC)
If the degree status is ‘L’ the status is set to ‘L’
If the degree status is ‘D’ the status is set to ‘U’
If the entering semester is less than the primary semester entered for the export AND the degree status is either ‘A’ or ‘E’, the admissions status is set to ‘U
If the entering semester is less than the primary semester entered for the export AND the degree status is ‘W’, the admissions status is set to ‘V’
If the entering semester is less than the primary semester entered for the export admissions status value is not yet set (BLANK), export the status is set to the COMMON_APP_CODE associated with the student’s progress code (STPARM – SBPRCC)
F/A Transfer Usage/Logic Notes
STMAIL.ADDRESS. Email address will be extracted for usage preferred flag only in STMAIL.
STBIOS.ADMISSIONS_RES_CODE will be translated to a 1 for value R, otherwise set to 3.
STBIOS.ADM_PROGRESS_CODE Progress code is mapped using the common application mapping from the STPARM file.
STBIOS.US_CITIZENSHIP. Translated to value 1 if Y in Campus Café, otherwise set to 2.
MAJOR CODE ( If the progress code is Y (Applied) the major is extracted from the ADMAST applied for major. If the progress code is A (Accept) the major is extracted from the ADMAST accept major. If the progress is P (Deposited), the major is extracted from the RGDEGR row.
STBIOS.TRANSFER_CODE. This will contain a Y if the value in Campus Café is T.
ADMAST.ADMAST.ADMISSION_CODE. This field is equivalent to financial aid rating in the financial aid system.
TRK_ACTIVITY_TRACKING.TEMPLATE_NAME (This field in the table will contain a value from a template in TRK_ACTIVITY_TRACKING with a category from the MSPARM FACATEGORY. This will allow specification of an Admissions scholarship and corresponding amount in TRK_ACTIVITY_TRACKING.PLEDGED_AMOUNT.
The grad_date will be populated with the STATUS_DATE if the DEGREE_STATUS value is either 'Y' or 'C'. Alternately, the grad_date be populated with the LAST_DAY_EXAMS associated with the current degree's EXPECTED_GRAD_SEM value.
The date_enrolled value is being populated with the SEM_START_DATE value from the semester dates table (FASCDT) associated with the current degree row's ENTERING_SEM and STUDENT_SITE.
The academic_year_begin_date is being populated with the SEM_START_DATE value from the semester dates table (FASCDT) associated with the semester entered in the first semester box on the panel.
...