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

CM3203J
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
SG079R     Fee Code Table/Catalog Compare
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 blank ADMIN-UNITs 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 record 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 Effective YRQ (year/session) used to select courses that are active during the YRQ selected.
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