Miscellaneous Job Scheduling
DDxxxxJ JMxxxxJ LSxxxxJ MLxxxxJ ZXxxxxJ LGxxxx OGxxxx Other

OG001R
MLS Stu Biographic Load

This Job Group will perform a biographic extract for a specified group of students, then address information will be loaded to the mailing label system. A report will be printed listing all records that have been added or updated. An error report will also be produced.
Special Instructions None
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 SM5201J
Student Biographic Extract
R 02 01 ML1016J
MLS DB Load Process
  Mail DB Load Report (ML1016A)
  Mail DB Load Exception Report (ML1016B)
R 03 02 SM5299J
Student Biographic Extract/Sort File Purge


Parameters

COL-CODE The institution's college code.
ML1016-ADDR-TYP The address type to be updated. This must be a valid ADDR-TYP in the CONFIG-PARM-M table.
ML1016-CHAR-CONV Indicator to denote the type of Upper/Lower case conversion is to be done. Valid entries are:
U = Convert to upper case
M = Convert to mixed upper/lower case
Blank = No conversion is done
ML1016-MAIL-LIST The name of the mail list to be updated. This must be a valid mail list in MS-MAIL-LIST-D.
ML1016-RPT-OPT Indicates the report option. Valid entries are:
F = Full report; list of individuals being added or updated.
T = Totals only; total number of individuals being added or updated.
Blank = Print totals only
ML1016-SRC-FILE A code to indicate which extract file will be used as input to the program. Valid entries are:
C = Generic Data Conversion file
P = PC Data Conversion file
S = Student Extract file
E = Employee Extract file
V = Vendor Extract file
T = Transcript Extract file
ML1016-SRT-OPT Report sort option. Valid entries are:
1 = Sort by ID-NUM
2 = Sort by LAST-NAME, FIRST-NAME
ML1016-UPD-DATE When updating existing address records, only those records with a RVSN-DATE less than this date are to be updated. This will help eliminate overlaying current address information with old
data. Valid entries are: YYMMDD = YEAR/MONTH/DAY BLANK = No date compare is done
ML1016-UPD-METH The method used to update the mail data base. Valid entries are:
1 = Update existing address information, and add any new entries.
2 = Update existing address information, but do not add any new entries.
3 = Add new entries, but do not update any existing address information.
ML1016-UPD-NAME An indicator to denote if the name fields are to be updated as well as the address fields. Valid entries are:
Y = Update name data
N = Do not update name data
Blank = Do not update name data
SM5201-OPT 1 = Extract students with registration activity for the specified YRQ
2 = Extract students with registration activity for specified YRQ and who have at least one class within a specified Item Number range
3 = Extract students who plan to start (YRQ-PLAN-STRT) in the specified YRQ
SM5201-RANGE1
SM5201-RANGE2
SM5201-RANGE3
If Option 2 was selected, then enter item number ranges on this line. The format is beginning item number followed by ending item number, with no spaces between. Multiple item number ranges may be specified by separating item number ranges by a space,
e.g. A000Z999 50015999.
YRQ Enter the year-quarter to be processed.

Distribution: FMS
Created: WED, JAN 04, 2012, 07:19 AM