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

SG156R-B
Record Update From Gen Ext

This job group updates Student Biographic records selected using the Generalized Extract. Three fields may be updated: STU-TYP, ADV-ID and BRANCH. Records may also be added to Student Unusual Action dataset for a selected UNUSUAL-ACTN-CD.
Special Instructions None
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 SM5204J
Student Generalized Extract
  Student Generalized Extract (SM5204)
R 02 01 SM5202J
Student Biographic Sort
R 03 02 SM5219J
Student Record Update
  Student Record Update Report (SM5219)
R 04 03 SM5299J
Student Biographic Extract/Sort File Purge


Parameters

SM5202-SORT-OPT CODE = SEQUENCE 01 = STU-NAME 02 = SID 03 = STU-ZIP, STU-NAME 04 = ADV-ID, STU-NAME 05 = ETH-ORIG, STU-NAME 06 = STU-PRG-APPL, STU-NAME 07 = STU-PRG-ENR, STU-NAME 08 = HI-SCHL, STU-NAME 09 = SEX, STU-NAME 10 = STU-TYPE, STU-NAME 11 = BIRTH-DATE, STU-NAME 12 = HNDCP-STAT, STU-NAME 13 = RES-STAT, STU-NAME 14 = ADM-NUM, STU-NAME
SM5204-LINE01
SM5204-LINE02
SM5204-LINE03
SM5204-LINE04
SM5204-LINE05
SM5204-LINE06
SM5204-LINE07
SM5204-LINE08
SM5204-LINE09
SM5204-LINE10
SM5204-LINE11
SM5204-LINE12
See Parameters Section on Generalized Extract
SM5219-ACTN Enter a valid UNUSUAL-ACTN-CD to be added to the student unusual action records. If left blank, no unusual action records will be added.
SM5219-ADV-ID Enter a valid ADV-ID to be posted to the student biographic records. Enter "$" to blank this field.
SM5219-BRANCH Enter a 2-character user defined code to be posted to college branch site in the student biographic records. Enter "$" to blank this field.
SM5219-ENTR-DATE Enter unusual action entry date, a 4 character field used to indicate the year/month or quarter the unusual action code was assigned to the students. Enter this parameter only if SM5219-ACTN is not equal to spaces.
SM5219-ORIG Enter unusual action orgin id, a 4-character field used to indicate the office or employee assigning the unusual action code to the students. Enter this parameter only if SM5219-ACTN is not equal to spaces.
SM5219-REPL-OPT Enter "Y" to replace existing values in the student biographic records, enter "N" to only update if there is no existing value (field is blank).
SM5219-TYP Enter a valid STU-TYP to be posted to the student biographic records. Enter "$" to blank this field.

Distribution: SMS
Created: WED, JAN 04, 2012, 07:28 AM