SM5115J
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.

Report:

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.

Parameters

SM5115S-BASE

Enter the name of the database that was used to
select student information for the Data Express
Extract file.
SM = SM database
TRAN = TRANSCRIPT 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