9.2 Batch Process Admissions Applications
Purpose: Use this document as a reference for processing admissions applications in batch.
Audience: Admissions staff.
You must have at least one of these local college managed security roles:
- ZD_DS_QUERY_VIEWER
You must also set these SACR Security permissions:
- CS 9.2 SACR Security: Basic Requirements for Staff
- CS 9.2 SACR Security - Service Indicator Security
If you need assistance with the above security roles or SACR settings, please contact your local college supervisor or IT Admin to request role access.
The batch process performs the following actions:
- Applicants without an active program/plan stack in student records will have their application matriculated (program action MATR).
- Applicants who have an existing active program/plan stack in student records will have their application administratively withdrawn (program action WADM).
- Applicants with more than one unprocessed application without an active program plan stack will have their lowest Admissions Application Number matriculated, and the rest of the applications will be administratively withdrawn.
- The process does not check the "Complete" box on the Application Data tab (Maintain Applications).
Queries
Clark College created the queries in the below table to support their business decisions and are used in the first two steps of the process. Your college query developers can create other queries with different criteria to fit your business needs.
| Query | Description |
|---|---|
| QCS_AD_NO_AC_PPS_IN_SR | This query identifies applicants who do not have an active program/plan stack in student records or the minimum admissions number if they have multiple applications.
|
| QCS_AD_NO_AC_PPS_IN_SR_OPTION | This query includes prompts for admit types and identifies applicants who do not have an active program/plan stack in student records or the minimum admissions number if they have multiple applications. For instance, if you wish to process admit type "FYR," enter it into the Admit Type 1 field and put an "X" into the additional admit type fields. The same applies to program prompts.
|
| QCS_AD_AC_PPS_IN_SR | This query identifies applicants who have active admissions applications where the student already has a dynamic program plan stack in student records or has submitted multiple applications.
|
| QCS_AD_AC_PPS_IN_SR_OPTION | This query includes prompts allowing institutions to select some admit types and/or programs. It identifies active admissions applicants where the student already has a dynamic program plan stack in student records or has submitted multiple applications.
|
In addition, the queries in the table below were created to support the batch process.
| Query | Description |
|---|---|
| QCS_AD_SAD_APPS | This query identifies admissions application rows created by the Update Program Action/Reason process. |
| QCS_AD_MATR_BY_SAD_NO_SR_PPS | This query returns a list of students who had admissions applications processed using the run control at Student Admissions > Processing Application > Update Application > Update Program Action/Reason that are in the MATR program action who have not yet been activated using the run control at Student Admissions > Processing Applications > Update Applications > Activate Applicants and thus do not have a program/plan stack in Student Records |
The subsequent processes may be scheduled on recurrence to process applications automatically.
You must have at least one of these local college managed security roles:
- ZC AD App Entry
- ZD AD App Entry
- ZZ AD App Entry
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
Navigation: NavBar > Navigator > Student Admissions > Processing Applications > Update Applications > Update Program Action/Reason
- The Update Program Action/Reason search page displays.
- Select the Add a New Value tab and create a Run Control ID.
- Select Add.
- Select Selection Tool: PS Query.
- Select Query Name: QCS_AD_NO_AC_PPS_IN_SR or QCS_AD_NO_AC_PPS_IN_SR_OPTION (review query descriptions).
- Select the Edit Prompts link.
- Enter or look up the Institution.
- Enter the number of minutes in the Submitted more than X mins ago field. Enter "0" to run the query if no minutes are defined.
- Enter an institutional service indicator code in the Exclude Srv Ind Cd @ Inst field. If you do not have an institution-specific service indicator, enter "X" to run the query.
- SDI - Applied to signal a duplicate record marked for deletion
-
SXF - Applied to signal a fraudulent account
- S99 - By replacing SDI and/or SXF service indicators, you can process an application marked with one of the services indicators. By doing so, the application will be processed to an EMPLID with one of the service indicators.
- Select OK.
- Select Preview Selection Results to verify students (optional).
- Select Return to access the Update Program Action/Reason page.
- Effective Date: Select the Use System Date checkbox.
- Program Action: Select MATR.
- Action Reason: Optional (action reasons can be created for your institution).
- Select the Run button.
Note: The below image highlights the prompts available when using the query QCS_AD_NO_AC_PPS_IN_SR_OPTION (review query descriptions).
- Select SAD_APL_PRG.
- Select OK.
Navigation: NavBar > Navigator > Student Admissions > Processing Applications > Update Applications > Update Program Action/Reason
- The Update Program Action/Reason search page displays.
- Select the Add a New Value tab and create a Run Control ID.
- Select Add.
- Select Selection Tool: PS Query.
- Select Query Name: QCS_AD_AC_PPS_IN_SR or QCS_AD_AC_PPS_IN_SR_OPTION (review query descriptions)
- Select the Edit Prompts link.
- Enter or look up the Institution.
- Enter the number of minutes in the Submitted more than X mins ago field. Enter "0" to run the query if no minutes are defined.
- Enter an institutional service indicator code in the Exclude Srv Ind Cd @ Inst field. If you do not have an institution-specific service indicator, enter "X" to run the query.
- SDI - Applied to signal a duplicate record marked for deletion
- SXF - Applied to signal a fraudulent account
- S99 - By replacing SDI and/or SXF service indicators, you can process an application marked with one of the services indicators. By doing so, the application will be processed to an EMPLID with one of the service indicators.
- Select OK.
- Select Preview Selection Results to verify students (optional).
- Select Return to access the Update Program Action/Reason page.
- Effective Date: Select the Use System Date checkbox.
- Program Action: Select WADM.
- Action Reason: Optional (action reasons can be created for your institution).
- Select the Run button.
Note: The below image highlights the prompts available when using the query QCS_AD_AC_PPS_IN_SR_OPTION (review query descriptions).
- Select SAD_APL_PRG.
- Select OK.
- Wait for the Run Control you set up to MATR students to finish running.
- The next step of the process will “throw the students over the wall” into Student Records, and WADM students don’t need this step (they’ve already been thrown over the wall!).
Navigation: NavBar > Navigator > Student Admissions > Processing Applications > Update Applications > Activate Applicants
This step is equivalent to pushing the "Create Program" button on the "Application Program Data" on the Maintain Applications page.
- The Activate Applicants search page displays.
- Select the Add a New Value tab and create a Run Control ID.
- Select Add.
- Enter or look up the Institution.
- Change the date to a date in the future. When the process runs, it will be saying, “Is this student ready to be tossed over the wall on this date?” If the date is in the past, the answer will always be “No,” so your students won’t get tossed into Student Records.
- Optional prompts:
- Admit Term, Academic Program, Admit Type
- Entering something will limit who is moved to student records
- Entering nothing will throw everyone with a MATR row over the wall to student records
- Select the Run button.
- Select the Process Name ADPCPPRJ.
- Select OK.
- Select the Process Monitor link and the Process Monitor page displays.
- At the Process List page, ensure the Run Status runs to Success, and the Distribution Status runs to Posted. You may select the Refresh button until the status is Success, Posted.
- Process complete.
Zhane
I noticed there is a step that I usually do in the admissions process that includes selecting that the application is completed on the Application Data tab in "Maintain Applications". Does this batch process take that step into account? Is it automatically initiated after the "Activate Application" step in this QRG? Or is this step not necessarily needed? Thank you for your help.
Tanjagay Martin
Hi Zhane, Nice catch! The process does not check the Complete box on the Application Data tab. I would submit a CS Support ticket to inquire whether it can be added. Thank you so much!~Tanjagay Martin | CS Core Trainer
Tracy
I missed the meeting. Does this actually take the place of processing and matriculating each application separately? Or do we still have to term activate each one?
Tanjagay Martin
Hi Tracy, Yes! The batch process replaces manually individually processing applications. Thank you for your question. ~Tanjagay Martin | CS Core Trainer