FAS Job Scheduling
SM9xxxJ AGxxxx Other

SM9550J
Finaid Electronic Award Extract

This batch job provides the Financial Aid Office the ability to generate an extract file of award information. That extract file can then be sent to the Nellie Mae website for electronic delivery of award notification.

This job can run in preliminary, report-only mode, wherein a report of qualifying students is produced, but the extract file is not. Conversely, the job can run in final, extract-only mode, wherein qualifying students are written to the extract file, but no report is produced.

The user provides at least one and no more than five Year-Sessions within a single academic year. For those Year-Sessions, the job qualifies Student Award Detail records against key value criteria (see 'Special Instructions' below). Qualifying student records are either printed on the report, or written to the extract file. For details on the extract file, see the 'Electronic Award Letter Field Guide' published by the CIS.

A Screen 5 tracking record is generated for students included in the extract file. The date the extract file was generated is recorded in Due date. If the student is included in subsequent extract files, the date of the most recent extract is recorded in Notified date.

After the extract file has been generated, use screen SM9551 to download the extract file to your PC. Follow Nellie Mae's instructions for uploading the extract file from your PC to Nellie Mae's website.


Report:
SM9550   
Special Instructions The following TABLE-MAS entries control the inclusion of STD-AWD-DTL records in the report and extract: WCCSM9550-STU-1: STUDENT-INFO section, Field 1. 1=Use SMS student e-mail address 2=Use Financial Aid Screen 1 student e-mail address 3=Do not include student e-mail address WCCSM9550-STU-6: STUDENT-INFO section, Field 6. E-mail Code of the pre-defined email you wish to send the student. Must exist in the system or the student record will be rejected. Maximum length: 30 characters. WCCSM9550-STU-24: STUDENT-INFO section, Field 24. Text section - Introduction to Award (4). Pass a user-defined 3-character value to specify text name code, for example 100 or TOP. WCCSM9550-STU-25: STUDENT-INFO section, Field 25. Text Section (9). Pass a user-defined 3-character value to specify text name code, for example 200 or MID. WCCSM9550-STU-26: STUDENT-INFO section, Field 26. Text Section (9). Pass a user-defined 3-character value to specify text name code, for example 300 or LOW. WCCSM9550-SID-SSN: STUDENT-INFO section, Field 2 and AID-DATA section, Field 1. SID=Use SMS SID value SSN=Use Safer STD-ID-NO value WCCSM9550-EXCL-AW: A list of zero to twenty two-character award codes that will be EXCLUDED from the report and extract. WCCSM9550-INCL-STA: A list of one to twenty two-character award status codes that will be INCLUDED in the report and extract. WCCSM9550-TRACK-CD: The tracking code that will appear on Screen 5 for electronic award records. Use SM9912, item 143, to set up the tracking code and its description. WCCSM9550-MISC-2: A four-character value that corresponds to Screen 2 MISC2, to block the generation of an award letter when the only change to the award amount(s) is due to enrollment level adjustments.
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 30 minutes
Recovery/Restart This job is restartable.


Parameters

FA-REPORT-ONLY Y = Preliminary, report-only with no extract
N = Final, extract only with no report
FA-VERSION-CODE Enter the version of the award letter template to be used for the information contained in the datafile. The version code must correspond to a version code assigned to a non-purged template.
FA-YR-SES-1 The first Year-Session to be processed in the academic year (required). For example: A341
FA-YR-SES-2 The second Year-Session to be processed in the academic year (optional). For example: A342
FA-YR-SES-3 The third Year-Session to be processed in the academic year (optional). For example: A343
FA-YR-SES-4 The fourth Year-Session to be processed in the academic year (optional). For example: A344
FA-YR-SES-5 The fifth Year-Session to be processed in the academic year (optional). For example: A345

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