FAS Job Scheduling
SM9xxxJ AGxxxx Other

SM9114J
Students Without Sid In Cross Ref

Identifies and reports students in the FAM data base without a record in the SM cross-walk data set (SID-SSN-XREF-D). The report is based on the Session Applied field (SAF_SES_ APPLIED) on the Student Tab. The Session Applied field is updated automatically with the year session start (for example, A901) each time an Institutional Student Information Report (ISIR) is loaded. In addition, by entering a specific track code (for example, AW), the program can identify students who had an ISIR loaded for an academic year (for example, A901) and a track code (for example, AW in A901) on the Tracking Tab.

If the parameter UPDATE-SID is set to Y, then the selected students who DO have a record in the cross-walk will have their SID added to the Alternate ID field on the Student Tab.

If the student's name and birthdate in FAM match exactly the student's name and birthdate in SM, the student's SMS SID and enrolled credits/hours will be printed. If the student's name matches but the student's birthdate does not, neither SID nor enrolled credits/hours will be printed, and 'YES' will appear in the column labelled 'BIRTH MISMATCH'.


Report:
SM9114   
Special Instructions None
Frequency As directed
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status None
Job Groups None
Job Dependency None
Operator Instructions None
Estimated Run Time 30
Recovery/Restart This job is restartable.


Parameters

ACCPT-TRCK-CODE TRACK CODE - up to 2 chars. Optional - can be
blank.
ACCPT-TRNS-DATE Session Applied in year session format (for example, A901)
UPDATE-SID If set to Y, then the selected students who DO have a record in the cross-walk will have their SID added to the Alternate ID field on the Student Tab

Distribution: FAID
Created: WED, JAN 04, 2012, 07:38 AM