Access the DL Reconciliation Report page (Financial Aid, Loans, DL School Account Statement, Generate Reconciliation Report, DL Reconciliation Report).
DL Batch ID Enter the DL Batch ID of a previously loaded SAS file. You cannot run this report without first loading one or more SAS files.
Reviewing the DL Reconciliation Report The three main sections in the report are:
• Cash summary information
• Cash detail
• Loan detail
Cash Summary Information This section of the report contains:
• Year-to-date cash summary.
• Year-to-date disbursement summary by loan type.
• Monthly disbursement by loan type.
Cash Detail
The content of this section of the report depends on the information in the SAS file.
If the file contains monthly cash detail (default), the system compares the data from the SAS file to data in PS_LN_DL_CASH_DTL for the month specified only.
This section reports any mismatches where:
• Cash transactions in the SAS file are not in the database.
• Cash transactions in the database are not in the SAS file.
• Year-to-date cash detail: The system compares the data from the SAS file to all data in PS_LN_DL_CASH_DTL for the specified aid year.
The section reports any mismatches where:
• Cash transactions in the SAS file are not in the database
• Cash transactions in the database are not in the SAS file.
• No cash detail: The section contains a No Cash Detail message.
Loan Detail
The content of this section of the report depends on the information in the SAS file.
If the file contains monthly disbursement detail without loan summary (default), the system compares the data from the SAS file to data in PS_LOAN_DISB_ACTION for the month specified only.
The section also reports any mismatches where:
• Disbursement transactions in the SAS file are not in the database.
• Disbursement transactions in the database are not in the SAS file.
• Disbursement transactions that match based on disbursement number and disbursement sequence number have differing amounts or dates.
Note: You can use the disbursement sequence number to compare information from the SAS file against the database.
• Year-to-date disbursement detail: The system compares the data from the SAS file with the sum of data in PS_LOAN_DISBMNT where LOAN_PAID_IND = "Y" and with data in PS_LOAN_DISB_ACTN.
The section reports any mismatches at the loan level where:
• Loan level records in the SAS file are not in the database.
• Loan level records in the database that have a disbursed amount greater than zero are not in the SAS file.
• Loan level records that match based on loan ID have differing gross, fee, rebate, or net amounts.
The section also reports any mismatches at the disbursement activity level where:
• Disbursement transactions in the SAS file are not in the database.
• Disbursement transactions in the database (that have a disbursed amount greater than zero) are not in the SAS file.
• Disbursement transactions that match based on disbursement number and disbursement sequence number have differing amounts or dates.
• Year-to-date loan level detail: The system compares the data from the SAS file with the sum of data in PS_LOAN_DISBMNT where LOAN_PAID_IND = "Y."
The section reports any mismatches where:
• Loan level records in the SAS file are not in the database.
• Loan level records in the database that have a disbursed amount greater than zero are not in the SAS file
• Loan level records that match based on loan ID have differing gross, fee, rebate, or net amounts.
• No loan detail: The section contains a "No Loan Detail" message.
The format of the loan detail section of the report also depends on the data included in the SAS file.
Reviewing SAS Files with Monthly Disbursement Level Detail Only
For SAS files with monthly disbursement level detail only (no loan level detail), the section contains the following information for each loan ID:
Field Row 1 Row 2 Row 3 Row 4
EmplID From PeopleSoft data.
Student Name From PeopleSoft loan data.
From COD loan data ( pulled from the Total fields provided on the disbursement detail record)
Loan ID From PeopleSoft loan
data.
From COD loan data ( pulled from the Total fields provided on the disbursement detail record
Field Row 1 Row 2 Row 3 Row 4
Disbursement Number From PeopleSoft
disbursement
Transaction Type From PeopleSoft
disbursement transaction data.
From COD disbursement transaction data.
Disbursement Date From PeopleSoft
disbursement
From COD loan data ( pulled from the Total fields provided on the disbursement detail
From COD loan data ( pulled from the Total fields provided on the disbursement detail
From COD loan data ( pulled from the Total fields provided on the disbursement detail
From COD loan data ( pulled from the Total fields provided on the disbursement detail
Transaction Date From PeopleSoft
disbursement transaction data.
From COD disbursement transaction data.
Note: Rows 3 and 4 repeat for each disbursement transaction associated with the loan ID.
For SAS files with year-to-date disbursement level detail and loan level summary, the section contains the following information for each loan ID:
Field Row 1 Row 2 Row 3 Row 4
EmplID From PeopleSoft loan
data.
Student Name From PeopleSoft loan data.
From COD loan data ( pulled from loan level summary record
Loan ID From PeopleSoft loan
data.
From COD loan data ( pulled from loan level summary record
Disbursement Number From PeopleSoft
disbursement
Transaction Type From PeopleSoft
disbursement transaction data.
From COD disbursement transaction data.
Disbursement Date From PeopleSoft
disbursement
From COD loan data ( pulled from loan level summary record)
From COD loan data ( pulled from loan level summary record)
From COD loan data ( pulled from loan level summary record)
From COD loan data ( pulled from loan level summary record)
Field Row 1 Row 2 Row 3 Row 4 Disbursement Actual
Net Adjustment Amount
From PeopleSoft disbursement transaction data.
From COD disbursement transaction data.
Transaction Date From PeopleSoft
disbursement transaction data.
From COD disbursement transaction data.
Note: Rows 3 and 4 repeat for each disbursement transaction associated with the loan ID.
For SAS files with year-to-date loan level detail (loan level detail only), the section contains the following information for each loan ID:
Field Row 1 Row 2
EmplID From PeopleSoft loan data.
Student Name From PeopleSoft loan data. From COD loan data.
Disbursement Number
Disbursement Sequence Number
Transaction Type
Disbursement Date
Loan/Disbursement Actual Gross Amount
From PeopleSoft loan data. From COD loan data.
Loan/Disbursement Actual Loan Fee Amount
From PeopleSoft loan data. From COD loan data.
Loan/Disbursement Actual Interest Rebate Amount
From PeopleSoft loan data. From COD loan data.
Loan/Disbursement Actual Net Amount From PeopleSoft loan data. From COD loan data.
Disbursement Actual Net Adjustment Amount
Transaction Date