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