FAS Job Scheduling
SM9xxxJ AGxxxx Other

SM9118J
Col Bound Scholarship File Rpt/Upd

This program will process the file returned from the Student Achievement Council (formerly HECB) 'Cruncher' for students who have applied for College Bound Scholarships. It works in conjunction with SM9116R (DataX procedure to create a file of SSNs as input to the 'Cruncher'), and SM9117 (an upload function for the 'Cruncher' return file).

In Final mode, qualifying students will have a track code created (based on the WCC COLBOUNDTRK process table entry). The tracking records will contain Notation and Comment values that reflect students' College Bound statuses, and will be assigned the Yr-Ses you specify for this run. If a student's status changes, their Col Bound track code can be updated or deleted.

Note that the WCC COLBOUNDTRK and WCC COLBOUNDMFI process table entries must be set up ahead of time.

Report SM9118 is always produced. It includes 'Cruncher' info about each student, as well as any warnings or errors that may be detected.

You can report all students returned by the 'Cruncher', or just those whose statuses are changing (Note: most warning conditions are reported regardless of this parm). You may also choose to have the report skip the validation of student names (aka: 'Cruncher' vs. Std-Mstr names).

The report can be sorted by SSN (1) or student name (2).


Report:
SM9118    Col Bound Scholarship File Report
Special Instructions Must have first uploaded 'Cruncher' return file using SM9117.
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status JOBFAIL
Job Groups None
Job Dependency None
Operator Instructions None
Estimated Run Time 10 minutes
Recovery/Restart This job is restartable.


Parameters

PRELIM-FINAL P = Preliminary--Do not post tracking codes report only
F = Final--Post tracking codes
RPT-ONLY-CHGS N = Report all students in 'Cruncher' file
Y = Report only students whose status has changed (stds with errors are reported either way)
SKIP-NAME-MATCH N = Validate student name ('Cruncher' vs Std-Mstr)
Y = Skip validation of student name
SORT-OPTION SORT OPTION
1 = Sort by Student Identification
2 = Sort by Student Name, Student Identification
YRQ Enter the year-quarter to be processed.

Distribution: FAS
Created: THU, MAY 24, 2012, 02:49 PM