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