Versions Compared

Version Old Version 2 New Version 3
Changes made by

Robert Lenk

Robert Lenk

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...