FAS Job Scheduling
SM9xxxJ AGxxxx Other

SM9119J
Dir Loan Reconciliation Report

The job will compare subsidized and unsubsidized direct disbursements in the FAEXP database with the Direct Loan School Account Statement (SAS) file for a specified fiscal year. A report is produced that lists all students with direct loan disbursements in the FAEXP database and in the SAS file, and notes the students that have mismatched disbursements.

The SAS file must be requested from COD (Common Origination Disbursement System) in the comma delimited format. The file is available via the school's SAIG mailbox, COD's Report Requests page, and/or via the school's Newsbox on the COD Web site.

An HPUX screen is used to upload the SAS file prior to running this job. The upload screen is SM9120.

Prior to running this job, the direct loan FAPC's need to be entered on the CIS/WCC Processing Table in FAM. The values are SM9119-FAPC-CD1, SM9119-FAPC-CD2 and SM9119-FAPC-CD3.

The report shows disbursement amounts from FAEXP and the latest SAS file uploaded to the HPUX, as well as other warnings and errors (including students found in FAEXP but not in the SAS file, and students found in the SAS file and not in FAEXP).

To list only student's whose totals are mismatched, enter 'Y' in the RPT-ONLY-DIFS parameter. To list all students with direct loan disbursements, enter 'N' in the RPT-ONLY-DIFS parameter.

The job will also compare the student's name in the FAEXP database with the student's name in the SAS file. A warning will display on the report if the name does not match.

The report can be sorted by the student's name from the FAEXP database or by SSN. Enter 'N' in the FA-PRT-SORT to sort the report by the student's name; enter 'S' to sort by SSN. Note: if the report is sorting by student's name and the name is missing from the FAEXP database, the record will be listed at the beginning of the report.


Report:
SM9119A    Dir Loan Reconciliation Report
Special Instructions Must have first uploaded 'SAS' file using SM9120.
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 2 minutes
Recovery/Restart This job is restartable.


Parameters

FA-PRT-SORT Report Sort Option.
N = Student Name Order.
S = Student ID Order.
RPT-ONLY-DIFS N = Report all selected students
Y = Report only the selected students whose total disbursement for the year differs between FAEXP and the COD 'SAS' file
YR-SES-BEG The first session in the session range to review. For example, B341 or B451.
YR-SES-END The last session in the session range to review. For example, B345 or B455.

Distribution: FAS
Created: TUE, APR 14, 2015, 01:15 PM