.
 

Enterprise Systems

 

Globe and planet

     

Recruitment

Cancel Recruit Records


This process cancels recruit records for students who have an admissions application for another term within the same year or for another term within the year before or after the application year. Only recruit records with terms greater than the current term will be canceled. The level and student type on the application must match the recruit record. In the case of transfer student types, a J (Transfer from FL College Sys) is considered to be equal to a U (Other Undergraduate Transfer).

 

This process produces output that is sent to users listed in the rec_cancelled distribution list.

 

Technical Notes:

Technical Notes
  Automic Chain     NSTU_ENROLL_MGMT
  Job   WSA5610
  Package   WKSABRM
  Procedure   p_cancel_recruit

 



Electronic Prospects Post Match Processing


This process resolves data conflicts between the Electronic Prospect match process (SRRSRIN) and the Migrate Electronic Prospects process (SRRPREL). This allows for any prospects that are matched to have only the appropriate data loaded and/or overwritten. Currently the following actions occur:

 

  1. Finds incoming prospects that have parent data and deletes any existing parent data on the matched record. This allows for the process to load the new parent data without issue. The current configuration only allows for two records to be maintained with a P1 and P2 address, telephone and email.
  2. Deletes emails from incoming prospect records when a match occurs to a student or an active employee. This prevents overwriting email addresses.
  3. Finds matched students that could not load because their email address already exists and then deletes the email from the temp table and takes the student back out of suspense.
  4. Deletes emails that already loaded from incoming prospect records when a match occurs to a student or an active employee and the email address was marked as not preferred with WSA5634.
      

This job should be run after Electronic Prospect match process (SRRSRIN).  Once this job has been run, the Migrate Electronic Prospects process (SRRPREL) process may be run.  Currently these processes are automated for electronic test score loads and run in the following order:

 

1. SRTLOAD

2. WSA5634

3. SRRSRIN

4. WSA5635

5. SRRPREL

6. SRTPURG

 

 

Technical Notes:

  

Automic Chain

  

NSTU_ACT_TESTSCORE_LOAD

NSTU_SAT_TESTSCORE_LOAD

NSTU_ACT_SAT_SUSPENSE

NSTU_GMAT_TESTSCORE_LOAD

NSTU_GRE_TESTSCORE_LOAD

 

Job

 

WSA5634

WSA5635

 

Package

 

WKSABRM

 

Procedure

 

WSA5634 - p_set_srtemal_preferred

WSA5635 - p_parent_data_cleanup, p_remove_email_emp_stu



Electronic Prospects Pre Match Processing


This process sets all the email preferred indicators on the temporary load table SRTEMAL to N in preparation for the Electronic Prospect match and load processes (SRRSRIN and SRRPREL).  This allows emails to only be created on the permanent table GOREMAL when they don't already exist and prevents the update of existing email addresses.

 

This job should be run after Electronic Prospect load process (SRTLOAD).  Once this job has been run, the Electronic Prospect Match process (SRRSRIN) process may be run.  Currently these processes are automated for electronic test score loads and run in the following order:

 

1. SRTLOAD

2. WSA5634

3. SRRSRIN

4. WSA5635

5. SRRPREL

6. SRTPURG

 

Technical Notes:

    Automic Chain    

NSTU_ACT_TESTSCORE_LOAD

NSTU_SAT_TESTSCORE_LOAD

NSTU_GMAT_TESTSCORE_LOAD

NSTU_GRE_TESTSCORE_LOAD
  Job   WSA5634
  Package   WKSABRM
  Procedure   p_set_srtemal_preferred

 



Population Selection for Assigning GEO-regions


The process selects all students with a recruit record greater than the current term or an admissions application greater than the current term and where there has been a change made to the permanent address since the last time this job ran.  The records are then inserted into the population selection table (GLBEXTR). This population selection is then used to run a Banner job that assigns the student a geo-region based on their permanent address.

 

Technical Notes: 

Technical Notes
  Automic Chain     NSTU_ENROLL_MGMT
  Job   WSA5600
  Package   WKSABRM
  Procedure   p_georegion_popsel