...
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. Letter codes are assigned such that if you qualify for one letter, you will not be assigned a second letter. For example, if you qualify for a 7A, you will not qualify for a 7B. 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 and the student is not a new or transfer student this term | ||||||
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 and the student is not a new or transfer student this term | ||||||
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 | BUhaving more than 2 courses this term with the most recent final grade in (f, fx, u) for a course that is not repeating | P1 | ||||||
6A | GR | ED | 00,AW,P1,P2 | having more than 2 1 courses this term with the most recent final grade =D for a in ( 'F','U') for a GR course that is not repeating | |||||
6B | GR | ED | 00,AW,P1,P2 | having more than 2 1 courses this term with the most recent final grade =D for a in ( 'F','U') for a GR course that is not repeating | |||||
6C | GR | ED | AW | ||||||
6D | GR | ED | 00,P1,P2 | having more than 2 courses this term with the most recent final grade =D for a ( 'F','U') for a GR course that is not repeating | |||||
6D6E | GR | ED00,P1,P2 | 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 | ||||||
11A | UG | PS | AW | ||||||
11A | UG | PS | having more than 2 courses this term with the most recent final grade =D for a ( 'F','U','FX') for a UG course that is not repeating | 6E | GR | ED | |||
11B | UG | PS | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | |||||
11B | UG | PS | P1 | ||||||
10A12A | GR | ASPS | ANZO | AW | |||||
10A12A | GR | PSAS | ANZO | P1, P2 | and has a P1 or P2 in the previous term (excluding summer) | ||||
10B12B | GR | PSAS | ANZO | P1 |
- The following print screen is a listing of the adhocs that are scheduled to run as part of regr080.shl:
...