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

Duplicate Student Comparison

This job will compare student data in a Data Express extract file created by the user and print a list of students who have duplicate information (i.e., students with the same name). Match criteria is selected when the job is scheduled. The students to be compared are limited to those in the Data Express extract file. For each run of this job, run ONE of the three DataExpress procedures located in the INFORM.PLIB catalog to create an extract file containing Student Biographic (SB), Student Enrollment (SE), or Transcript Biographic (TB) data. The Data Express extract file will be purged upon successful completion of this job.
SM5115    Duplicate Student Comparison
Special Instructions None
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status NODATA, JOBFAIL
Job Groups None
Job Dependency A Data Express extract needs to be run prior to this job to extract student information from the SM or TRAN database. The completion status will be set to NODATA if the extract file specified could not be found.
Operator Instructions None
Estimated Run Time 30 minutes
Recovery/Restart This job is restartable.


SM5115S-BASE Enter the name of the database that was used to select student information for the Data Express Extract file.
SM = SM database
SM5115S-FILE Enter the name of the Data Express extract file to be compared (see attached instructions on creating the Data Express file).
SM5115S-MATCH Enter the match criteria to be used to select duplicate student information. The file output from the Data Express extract will be sorted and matched on based upon the following options:
1 = Student Name (Default)
2 = Student Last Name
3 = Student Name and Date of Birth
4 = Student Last Name and Date of Birth
5 = Student Name and Year of Birth
6 = Student Last Name and Year of Birth

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