SMS Job Scheduling
CMxxxxJ FCxxxxJ ISxxxxJ SDxxxxJ SMxxxxJ SRxxxxJ MGxxxx SGxxxx Other

CM3201J
Course Catalog Extract

This job creates an extract file from the course catalog file.
Special Instructions None
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status None
Job Groups
SG074R     Desktop Course Catalog
SG076R     Printed Desktop Course Catalog
SG140R     Update Catalog Allocation Group
SG155R     Course Catalog to Regdb Copy
SG181R     Course Prg/Org Indx Update
Job Dependency None
Operator Instructions None
Estimated Run Time 30 minutes
Recovery/Restart This job is restartable.


Parameters

ADMIN-UNIT-LINE This is an optional parameter and is used to select only certain administrative units from the course catalog. Administrative unit may be selected on the first position, the second position, or both positions. A maximum of 12 ADMIN-UNITs may be entered, each separated by a space. Valid Entries:
Blank = Extracts all ADMIN-UNITs ## = Extracts X# = Extracts records with the first position of ADMIN-UNIT equal to the variable "X" #X = Extracts records with the second position of ADMIN-UNIT equal to the variable "X"
XX = Extracts records with both positions of ADMIN-UNIT equal to "XX" The following example selects records with the first position of ADMIN-UNIT equal to "A", the second position of ADMIN-UNIT equal to "Z" and the ADMIN-UNITs of C1 through C5: A# #Z C1 C2 C3 C4 C5
CM3201-EFF-YRQ This parameter is used to select courses that are active during the effective YRQ selected.
CM3201-SRT-OPT Sort Option
01 = MISC-SRT, TITLE, COURSE-ID (default)
02 = Title, Course ID
DEPT-DIV-LINE This optional parameter is used to select only certain departments or divisions from the course catalog. A maximum of 10 Department/Divisions may be entered, each separated by a comma.
e.g., ART H, ART
EXCLUD-STAT-4 This is an optional parameter and will allow the job to exclude any records with the 4th position of SECT-STAT equal to the value entered in parameter (EXCLUD-STAT-4) (Will usually be set to default on a specific value)
EXCLUD-ZRO-SEC This is an optional parameter and is used to exclude any Course-D records where summer, fall, winter and spring sections are ALL = 0 Valid entries:
Blank = Extract all Course-D records
Y = Exclude any Course-D records where summer, fall, winter and spring sections are All = 0

Distribution: SMS
Created: WED, JAN 04, 2012, 06:54 AM