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

SG074R
Desktop Course Catalog

This job creates an Extract File from the Course Catalog. The file is sorted and various data items, control codes and breaks are written to an ASCII "flat" file in Ventura or Pagmaker Desltop Publishing formats.
Special Instructions A PUnnnnnn file is created each time this job group is run; nnnnnn is the job group TRANS-NUM assigned when this job group is scheduled. This file should be downloaded via a Reflection command file residing on the PC.
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 CM3201J
Course Catalog Extract
R 02 01 CM3105J
Desktop Course Catalog
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
CM3105-CALC-PRNT This parameter is used to select how the contact hour fields are to be calculated and printed.
1 = Calculate contact hours as a whole number. Print contact hours of 21 and above as numbers. Contact hours below 21 will be spelled out.
2 = Calculate contact hours as a whole number. Print all contact hours as numbers.
3 = Calculate contact hours rounded to 1 decimal
place. Print all contact hours as numbers (i.e. 9.1).
CM3105-PUB-OPT Option that controls the desktop publishing package to be used.
V = Ventura
P = Pagemaker
CM3201-EFF-YRQ Enter the EFF-YRQ-BEG date.
CM3201-SRT-OPT Sort Option
01 = MISC-SRT, TITLE, COURSE-ID (default)
02 = Title, Course ID
DATA-ITEM-LN1 Enter codes/numbers representing Ventura Publisher control codes and SM data items.
DATA-ITEM-LN2 Enter codes/numbers representing Ventura Publisher control codes, SM data items, and SM data items that records in the output file will break on.
DATA-ITEM-LN3 See DATA-ITEM-LN2
DATA-ITEM-LN4 See DATA-ITEM-LN2
DATA-ITEM-LN5 See DATA-ITEM-LN2
DATA-ITEM-LN6 See DATA-ITEM-LN2
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