/
Identifying Dean's List candidates and applying Dean's List designation - REG_DEANS_LIST_REPORT_UG_C and REG_DEANS_LIST_UPDATE_C

Identifying Dean's List candidates and applying Dean's List designation - REG_DEANS_LIST_REPORT_UG_C and REG_DEANS_LIST_UPDATE_C

Overview

Dean’s List processing is a two-step process. First the Registrar’s Office runs a report of students who meet the Dean’s List qualifications. This report is sent to the NTC Dean’s office for modifications and approval. Once vetted, the Dean’s Office then returns the list to the Registrar who then runs the process to apply the Dean’s List coding to the students' Banner records.

 

From Lee Skinner:
The Registrar will run the job that creates Dean’s List multiple times: 3 days after grades are due, 10 days after grades are due, and the day after incomplete grades are due. Dean’s List will be announced and updated, and messaging will include a statement that students with incompletes or missing grades will not be listed on Dean’s List until all their grades are in.

Step 1 - Generate Dean’s List report

APPWORX Request

  • REG_DEANS_LIST_REPORT_UG_C

Parameters

  • Term Code - required

    • The grading term just completed

  • Run Date - required

    • Use default value (defaults to current date/time)

Notes:

  • This job creates an xml file that has the student GPA, PR address, and email.  

  • Open the report and save in xls format before forwarding.

  • Send this file to Kimberly Charlesworth (kcharle3@tulane.edu) and Jennifer Tracy (jtracy2@tulane.edu) for approval. 

  • Send this file to Hilary Roberts (hroberts4@tulane.edu)

Step 2 - Apply DL coding in Banner

Prepare Student List

  • Once NTC approves the list, create a csv file with the following format:

    • TERM_CODE_KEY

    • BANNER_ID

  • NO HEADER RECORD

Upload the csv file into Banner

  • Banner form:  GUAUPLP

  • Process name:  Registration – Dean’s List

  • **If job is run in audit mode first, the file needs to be reloaded into GUAUPLP before update**

APPWORX Request:

  • REG_DEANS_LIST_UPDATE_C

Parameters

  • Data File - required

    • Defaults to “deanslist.txt” - this is the GUAUPLP input file

  • Run Mode - required

    • Run in Audit (A) to check output

      • There is no output file for this job, but check the 0.REG_DL_SQLLDR_A log file to compare the number of processed records to the number of records in the input file.

    • Run in Update (U) mode to update student records

      • **If job is run in audit mode first, the file needs to be reloaded into GUAUPLP before update**

  • Input Archive Folder - required

    • Use default value

  • Error Report Output Folder - required

    • Use default value

Verify

This job does not create an output file.  It updates the students’ records in banner to reflect the DL tag in SHAINST.  Once the job has completed, spot check a few students to make sure their records have been updated.

 

NO LONGER NEEDED – BUT CAN BE RUN TO VERIFY DL UPLOAD

Run CR-NWTU-010

  • Since this report is built on the Student Detail package in Cognos, wait for the next ODS refresh before running this report, or it will not return the correct data.

 

On this page