Expect More. Achieve More.
CIS Job Documentation: Banner Documentation
WFRECNT
SYSTEM:
Student
SUBSYSTEM:
Registration
JOB NAME:
WFRECNT
REVISION DATE:
17-Sep-2007
PURPOSE:
Enrollment counts in Banner sometimes get out of whack. Why this happens, nobody
knows. Some blame Web pirates, others blame the ghost that haunts Boyden Hall at
night. Whatever the reason, this PL/SQL is designed to set things straight by checking
counts against actual enrollments and correcting when necessary.
FREQUENCY AND TIMING:
Weekly
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WFRECNT.SQL - SQL used to update records in the affected tables
WFRECNT.SHL - shell file used to control run of the job
REQUIRED INPUT:
None
INPUT FORMATS:
OUTPUT:
wfrecnt.lis - emailed to user
SPECIAL INSTRUCTIONS:
WSPCORE
SYSTEM:
Student
SUBSYSTEM:
Course Catalog
JOB NAME:
WSPCORE
REVISION DATE:
13-Aug-2007
PURPOSE:
This PL/SQL is used to set CORE attributes using an input file in the Registrar's
G:\NSLC folder. The file contains subject area, crse number and attribute. The
input will be loaded into a temp table then a materialized view for use with this
program. Four tables are updated. SSRATTR - add attributes to course section records,
SHRATTC - add attributes to student academic history, SHRTATT - add attributes to
student transfer credit, SHRTRAT - add attributes to transfer articulation.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
The file core_attr.csv must exist in the \NSLC folder on the Registrar's G:\ drive
before the process is run.
OTHER RESOURCES:
WSPCORE.SQL - SQL used to update records in the affected tables
WSPCORE.SHL - shell file used to control run of the job
WSPCORE_MV.SQL - SQL used to recreate materialized view used by the job
BSC_CORE_ATTR.CTL - SQL*Loader control file to upload core_attr.dat
REQUIRED INPUT:
None
INPUT FORMATS:
OUTPUT:
wspcore_ONEUPNUM.lis
wspcore_ONEUPNUM.log
SPECIAL INSTRUCTIONS:
WCR3YCR
SYSTEM:
Student
SUBSYSTEM:
Course Catalog
JOB NAME:
WCR3YCR
REVISION DATE:
14-Aug-2007
PURPOSE:
This PL/SQL is used to set generate a listing of courses that have not been
offered between the start term parameter and the end term parameter. The college
periodically reviews courses that have not been offered within 3 years. By making
this a parameterized report and putting it in job submission the Registrar's office
has the flexibility to run the job when it wants, for the terms it needs.
The output of the job is FTPd to the Reigstrar's G:\NSLC folder as a .csv file.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WCR3YCR.SQL - SQL used to extract the data
WCR3YCR.SHL - shell file used to control run of the job
REQUIRED INPUT:
Start Term Code - the low range of the period being requested
End Term Code - the high range of the period being requested
INPUT FORMATS:
YYYYTT - Example: 200490
OUTPUT:
wcr3ycr_ONEUPNUM.csv on the Registrar's G:\ drive under the NSLC folder
SPECIAL INSTRUCTIONS:
WCPCRBK
SYSTEM:
Student
SUBSYSTEM:
Course Catalog
JOB NAME:
WCPCRBK
REVISION DATE:
17-Sep-2007
PURPOSE:
This job submission job will create a listing of course sections for a given semester.
The file is used by the Registrar's Office to create the published course catalog.
The file can be sorted two ways, one for summer terms and one for fall/spring.
The difference is in summer an additional sort happens - after college and subject
we sort by part of term to separate out summer I and summer II.
The output of the job is FTPd to the Reigstrar's G:\NSLC folder as crsbook.txt file.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WCPCRBK.SQL - SQL used to extract the data
WCPCRBK.SHL - shell file used to control run of the job
REQUIRED INPUT:
Term Code - the term to create catalog output file
INPUT FORMATS:
YYYYTT - Example: 200490
OUTPUT:
crsbook.txt on the Registrar's G:\ drive under the NSLC folder
SPECIAL INSTRUCTIONS:
WFRADIS
SYSTEM:
Student
SUBSYSTEM:
Registration
JOB NAME:
WFRADIS
REVISION DATE:
23-Jul-2007
PURPOSE:
This job submission job will retrieve students that are coded as 'AD' for academic
dismissal in the given term. It will compare that list to the registered students
in the same term and drop schedules for the drop term.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WFRADIS.SQL - SQL used to extract the data
WFRADIS.SHL - shell file used to control run of the job
REQUIRED INPUT:
Academic Dismissal Term Code - term where Academic Dismissal is coded
Registration Term Code - term where registrations should be dropped
INPUT FORMATS:
YYYYTT - Example: 200490
OUTPUT:
SPECIAL INSTRUCTIONS:
WFRSCHD
SYSTEM:
Student
SUBSYSTEM:
Registration
JOB NAME:
WFRSCHD
REVISION DATE:
05-Dec-2007
PURPOSE:
This job submission job will create a list of students for producing schedules.
The job will populate the normal pop-sel tables so the schedule job (SFRSCHD) runs
normally. The Registrar's Office can select name ranges like A-E, F-M, N-Z to make
the populations as large or small as they'd like. The job will select all students
whose last name begins in A through E and does an uppercase function on the starting
character.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WFRSCHD.SQL - SQL used to extract the data
WFRSCHD.SHL - shell file used to control run of the job
REQUIRED INPUT:
Term - registration term for schedules
Start Letter (last name) - First letter of last name (low range)
End Letter (last name) - First letter of last name (high range)
INPUT FORMATS:
YYYYTT - Example: 200490
L - Example: A
L - Example: E
OUTPUT:
SPECIAL INSTRUCTIONS:
WPRNDGR
SYSTEM:
Student
SUBSYSTEM:
Registration
JOB NAME:
WPRNDGR
REVISION DATE:
02-Apr-2007
PURPOSE:
This job submission job is used to set program restrictions on sections to
prevent NDGR-U students from registering during the blackout periods. The
procedure can do three things
- Report sections that already have a program restriction
- Add NDGR restrictions to sections with no previous restrictions
- Remove NDGR restrictions when the blackout is over
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WPRNDGR.SQL - SQL used to extract the data
WPRNDGR.SHL - shell file used to control run of the job
REQUIRED INPUT:
Term - term to report, add or drop program restrictions
FUNCTION - Function - REPORT, ADD, or DELETE
INPUT FORMATS:
YYYYTT - Example: 200490
CCCCCC - Example: REPORT or report
OUTPUT:
SPECIAL INSTRUCTIONS:
WGPGRDT
SYSTEM:
Student
SUBSYSTEM:
Registration
JOB NAME:
WGPGRDT
REVISION DATE:
07-Apr-2007
PURPOSE:
This PL/SQL is used to set the graduation date on SGBSTDN for
students that are registered in the given semester and have a
NULL value in SGBSTDN_EXP_GRAD_DATE. The date is set to the
date accepted as a parameter.
FREQUENCY AND TIMING:
As determined by Registrar's Office office.
PREREQUISITES/DEPENDENCIES:
None
OTHER RESOURCES:
WGPGRDT.SQL - SQL used to extract the data
WGPGRDT.SHL - shell file used to control run of the job
REQUIRED INPUT:
Term - Registration term to identify students
Grad Date - Expected Graduation Date to be set
INPUT FORMATS:
YYYYTT - Example: 200490
DD-MON-YYYY - Example: 17-Jul-2008
OUTPUT:
SPECIAL INSTRUCTIONS:
© Bridgewater State College, 131 Summer Street, Bridgewater, Massachusetts 02325, 508.531.1000
Contact Us
: Policies
: Privacy
: Site Map