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

SG079R
Fee Code Table/Catalog Compare

This job group creates an Extract File from the Course Catalog File. The Fee Code Table/Catalog Compare Report is printed from the Extract File.
Special Instructions None
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 CM3203J
Course Catalog Extract
R 02 01 CM3108J
Fee Code Table/Catalog Compare
  Fee Code Table/Catalog Compare (CM3108)
R 03 02 CM3299J
Purge Catalog Extract Files


Parameters

ADMIN-UNIT-LINE A maximum of 15 administrative units may be selected separated by a comma or a space.
Blank = Extract all administrative units ## = Extracts blank administrative units @X = Extracts records with the second position of administrative unit = variable X, regardless of the contents of the first position X@ = Extracts records with the first position of administrative unit = variable x, regardless of the contents of the second position
XX = Specific administrative units of value = XX
CM3108-ERR-ONLY Option to print fee data errors and warnings only (Y or N).
CM3108-SRT-OPT Report sort option:
01 = DEPT/DIV, COURSE-NUM
02 = CIP, DEPT/DIV
03 = PRG-INDX, ORG-INDX, CIP, COURSE-NUM
04 = ADMIN-UNIT, CIP, DEPT/DIV, COURSE-NUM
05 = ADMIN-UNIT, DEPT/DIV, COURSE-NUM
06 = COURSE-TITLE, DEPT/DIV
07 = PRG-INDX, ORG-INDX, DEPT/DIV, COURSE-NUM
CM3201-EFF-YRQ Enter the EFF-YRQ-BEG date.
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, 07:28 AM