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

SG156R-A
Record Update From Bio Ext

This job group updates Student Biographic records selected using the Biographic 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 SM5201J
Student Biographic Extract
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

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.
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
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.
YRQ Enter the year-quarter to be processed.

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