...
Components of this process :
Banner shell script: $REGLIB/regr080.shl
SQL run by shell script: $REGLIB/regr080.sql
Database Table: wreg080 holds output from sql for reporting/adhoc generation
Infoview Reports: regr080 and regr081
- Banner’s student academic standing process determines a student’s standing based on the rules defined on SHAACST.
Once the registrar’s office has completed grade processing at the completion of a term, the Registrar will run regr080 from banner. REGR080 will collect the data needed for the various %DISPRO% adhocs and stores it in the wreg080 table. Regr080.shl will also update wsys0008 and set these same adhocs to run, as long as the process was run with the param to schedule the adhoc to run set to ‘Y’. REGR080.sql inserts into table regr080 all those students with shrttrm_astd_code_end_of_term values that indicate they should be dismissed or on probation. Based on the school
...
,
...
it sets up a letter code so that the appropriate letter will be generated. Letters are generated based on the following criteria:
Ltr Code | level | school | Major | Acadmic Standing code | additional detail requirements |
7A | UG | AS | AW | ||
7A | UG | AS | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |
7A | UG | AS | having more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | ||
7B | UG | AS | P1 | ||
9A | UG | BU | AW | ||
9A | UG | BU | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |
9A | UG | BU | having more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | ||
9B | UG | BU | P1 | ||
5A | UG | ED | AW | ||
5A | UG | ED | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |
5A | UG | ED | having more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | ||
5B | UG | ED | P1 | ||
2A | GR | AS | COMG | AW | |
2A | GR | AS | COMG | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) |
2B | GR | AS | COMG | having more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | |
4A | GR | BU | AW | ||
4A | GR | BU | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |
4B | GR | BU | having more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | ||
6A | GR | ED | 00,AW,P1,P2 | having more than 2 courses this term with the most recent final grade =D for a course that is not repeating | |
6B | GR | ED | 00,AW,P1,P2 | having more than 2 courses this term with the most recent final grade =D for a course that is not repeating | |
6C | GR | ED | AW | having more than 2 courses this term with the most recent final grade =D for a course that is not repeating | |
6D | GR | ED | 00,P1,P2 | having more than 2 courses this term with the most recent final grade =D for a course that is not repeating | |
6E | GR | ED | P1 | ||
10A | GR | PS | AW | ||
10A | GR | PS | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |
10B | GR | PS | P1 |
- The following print screen is a listing of the adhocs that are scheduled to run as part of regr080.shl:
...
BU_9ADISMISS_LTR.DOCX - Ltr Indicator = 9A
BU_9BPROBATION_LTR.DOCX - Ltr Indicator = 9B
Adhoc: UGSTU_DISPRO_EM utilize templates as follows:
...
ED_5ADISMISS_EML.DOC - Ltr Indicator = 5A
ED_5BPROBATION_EML.DOC - Ltr Indicator = 5B
BU_9ADISMISS_EML.DOCX - Ltr Indicator = 9A
BU_9BPROBATION_EML.DOCX - Ltr Indicator = 9B
2) The Parent letter is generated from the adhoc UGPAR_DISPRO_LT. In April of 15, Blair had the code changed to send the parent letter regardless of the FERPA form if the student is a dependent.
...
AS_P7ADISMISS_EML.DOC - Ltr Indicator = 7A
AS_P7BPROBATION_EML.DOC - Ltr Indicator = 7B
ED_TO_PARENTSOF_ENV.DOC - Ltr Indicator like ‘5%’
...
GRED_DISPRO_LTR- Education
Templates:
GRED_6ADISMISS_OTHER_LTR.DOC - Ltr Indicator 6A
...
GRPS_DISPRO_LTR – Professional Studies
Templates:
GRPS_10ADISMISS_LTR.DOCX - Ltr Indicator 10A
...