Processing Direct Loans

This chapter provides the required information for direct lending mandated by the Department of Education. This chapter provides an overview of direct lending and discusses how to:

• View packaging results before origination.

• Re-award direct loans with new disbursement plans.

• Originate direct loans and display loan status summary information.

• Process and review direct lending origination information.

• Override bio/demo data for direct lending.

• Override and view direct loan origination data and action messages.

• Create and use promissory notes.

• View promissory note action history and loan disbursement messages.

• Process direct loan manifests.

• Transmit direct lending outbound files.

• Receive direct lending inbound files.

• Use EC queue status with direct loan processing.

• View direct loan EC history.

• Review direct lending origination export files.

• Review direct lending origination acknowledgement import files.

• Review direct lending promissory note acknowledgement files.

• Review direct lending credit decision files.

• Process direct lending origination changes.

• Understand direct lending change processing.

• Review direct lending change export files.

• Review direct lending change acknowledgement import files.

• Review direct lending disbursements.

• Understand direct lending cash management.

• Process cash reconciliation for direct lending.

• Enter cash summary data.

• Use loan/import programs.

• View data import information.

• Work with the DL school account statement and the reconciliation loan destination reports.

• Generate the reconciliation loan destination report.

• Use the direct lending 732 Loan Detail Report.

• View system administration information.

• Run direct lending reports.

• Use demographic data selection for loan origination.

Understanding Direct Lending

The William D. Ford Federal Direct Loan program was established to provide long-term academic loans to qualified students who are enrolled in facilities of higher education, vocational, technical, business and trade schools. The Federal Government provides the funds for direct loans directly to the student, bypassing an outside lender. Students who receive federal direct loan funds cannot receive FFEL (federal family education loan) funds during the same enrollment period.

Direct Loan processing in Campus Solutions does not support COD web initiated response file (document type WB) loads when you do not originate the outbound process through the system. There must be a one to one match between the outbound promissory note record and the inbound acknowledgement record. For direct loans, you must create both a promissory note record and an origination, change, and disbursement record so that the system can properly load and process corresponding inbound acknowledgement records (promissory note, origination, change and disbursement). If web initiated acknowledgement response files are generated from self-service transactions and processed through the COD website, the system inbounds and loads the acknowledgement record but does not process it.

Note. Direct Lending now uses common origination and disbursement (COD) processing.

There are three types of direct loans, as described below:

The direct lending portion of the Financial Aid package is designed to help you process the Subsidized Stafford, Unsubsidized Stafford, and PLUS loans awarded to students attending your institution.

Viewing Packaging Results Before Origination

Beginning with the 2001/2002 processing year, Direct Loan Rebate information is required to be submitted on the origination file. You should include a preliminary and periodic review of your packaging results, your loan amount, loan fees, and rebate information for each loan record. This minimizes the potential for incorrect information being originated and submitted to the common origination and disbursement processing center.

Note. Refer to financial aid packaging chapters for special setup of financial aid item types, disbursement plans and split codes for Direct Loan types.

Re-awarding Direct Loans with New Disbursement Plans

The packaging engine does not allow you to change the disbursement plan for direct lending loans, even if the loan has not been originated. You would need to change disbursement plans if you awarded a direct lending loan for two terms, then found out the student should only be awarded for one term. There are two ways to accomplish this change. The steps are shown below.

Option 1 – Changing disbursement plans for non-originated direct lending loans.

1. Cancel the original loan (with the original disbursement plan and split code) on the Student Aid Package page.

2. Insert a row on the Student Aid Package page below the row for the canceled loan in step 1.

3. Using the same financial aid item type as the original loan, award the loan with the new disbursement plan and split code.

Note. If you are using professional judgement to override an award amount, you must make sure that your loan disbursements (amounts, fees, and rebates) are split correctly between your item types. Refer to the common origination and disbursement technical data for details.

Option 2 – Changing disbursement plans for non-originated direct lending loans.

1. Using the original loan you awarded (with the original disbursement plan), create a custom split so the money is allocated only to the new terms you want to use.

2. Originate the loan.

3. Go to the Application Financial page (Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application) and select the Override Loan Dates check box. Change the Loan Period Start, Loan Period End, and Antc Date (anticipated disbursement date) to match the new period for which the loan is awarded.

Originating Direct Loans and Displaying Loan Status Summary Information

This section discusses how to:

• Originate any Stafford or PLUS loans that have been awarded and have an award status of Accepted.

• Check the status of a loan.

Pages Used to Originate Direct Loans and Display Loan Status Summary Information

Originating Direct Loans

Access the Loan Origination page.

Control Information

You can add additional rows to include different institution, aid year, and career combinations for originating loans.

Selection Criteria

The fields in the Selection Criteria group box allow you to originate loans for a group of students selected by last name. Only students with the selected Institution, Aid Year, and Career are selected. You can only enter names in the Selection Criteria if the Student Override check box is NOT selected.

Student Override

The Student Override group box is used to originate loans for a single student or a group of specific students within the selected Institution, Aid Year, and Career.

Click Run to run the Loan Origination process (FAPLBOG1).

Displaying Loan Status Summary Information

Access the Loan Status Summary Information page.

Student Eligibility

Origination Detail

Actions Tab

Amounts Tab

Access the Loan Status Summary Information page.

Ln Dsb Amt (loan disbursement amount)	The gross scheduled disbursement amount. This value is derived from the accepted balance on the loan award.
Net Disb (net disbursement)	Displays the amount derived from the loan amount minus the loan fee amount plus the rebate amount.
Ln Fee Amt (loan fee amount)	Displays the calculated loan fee for this disbursement.
Rebate Amt (rebate amount)	Displays the calculated rebate amount for this disbursement.

Processing and Reviewing Direct Lending Origination Information

The Direct Loan Application component is designed for users who are actively involved with the Direct Lending process. Access to these pages should be restricted to key personnel. The information contained in these pages is eventually transmitted to the common origination and disbursement processing center (COD) in the origination outbound file.

This section discusses how to:

• Process and review borrower bio/demo data.

• Process and review miscellaneous borrower data.

• Process and review financial data.

• Process and review loan application acknowledgement data.

Pages Used to View Loan Change Transmission Information

Processing and Reviewing Borrower Bio/Demo Data

Access the Application Bio/Demo page.

The Appl Seq (application sequence) number increases each time a new loan origination record is created for the ID, Career, Loan Type, Institution, and Aid Year combination.

Borrower Information

The fields in the Borrower Information group box contain information regarding the borrower of the loan. The borrower is also the student for Stafford loans. For PLUS loans, the borrower is a parent or guardian of the student and is defined within the Relationships pages in Campus Community.

Student Information

Processing and Reviewing Miscellaneous Borrower Data

Access the Application Misc Data page.

Student Eligibility

PNote Print Information

Loan Credit Information

These fields are used when a credit check is necessary for loan approval. This occurs with PLUS loans.

Processing and Reviewing Financial Data

Access the Application Financial page.

Loan Application Data

Origination Detail

Processing and Reviewing Loan Application Acknowledgement Data

Access the Application Acknowledgement page.

To perform one of the following actions, select the appropriate option and click the Update Origination link.

Origination Detail

Anticipated Tab

For definitions of the fields that display on this tab, see Processing and Reviewing Financial Data.

Acknowledged Tab

Access the Application Acknowledgement page, Acknowledged tab.

Ack Antc Gr (acknowledged anticipated gross)	Indicates the acknowledged anticipated gross disbursement amount, as acknowledged by the COD. This amount is derived from the offer balance on the award. The sum of the anticipated gross amounts for this loan equals the loan certified amount.
Ack Antc Net (acknowledged anticipated net)	The acknowledged anticipated net amount represents the maximum disbursement for the student, as acknowledged by the COD. This amount is equal to the difference between the anticipated gross and the anticipated fee amounts.
Ack Dsb Date (acknowledged disbursement date)	The acknowledged disbursement date is the expected disbursement date, as specified on the acknowledgment record.
Ln Paid Dt (loan paid date)	Indicates the actual date of the disbursement after the loan funds are disbursed to the student's account and the Loan Paid check box is selected.

Viewing Miscellaneous Loan Details

Access the Miscellaneous Loan Detail page.

The field values are derived from the Origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If your institution has not received an acknowledgement or the Origination is rejected, only the ORIGINATED section is complete.

Viewing Loan Eligibility Details

Access the Loan Eligibility Detail page.

The field values are derived from the origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If an acknowledgement has not been received or the origination is rejected, only the ORIGINATED section is complete.

Viewing Borrower Details

Access the Borrower Detail page.

The field values are derived from the origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If your institution has not received an acknowledgement or the origination is rejected, only the ORIGINATED section is complete.

Viewing Student Details

Access the Student Detail page.

The field values are derived from the origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If your institution has not received an acknowledgement or the origination is rejected, only the ORIGINATED section is complete.

Viewing Name Details

Access the Name Detail page.

The field values are derived from the origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If your institution has not received an acknowledgement or the origination is rejected, only the ORIGINATED section is complete.

Viewing Address Details

Access the Address Detail page.

The field values are derived from the origination record and Direct Loan Application component. If the COD has sent an acknowledgment, the ACKNOWLEDGED and ORIGINATED sections are completed. If your institution has not received an acknowledgement or the origination is rejected, only the ORIGINATED section is complete.

Overriding Bio/Demo Data for Direct Lending

This section discusses how to:

• Override direct loan name information.

• Override direct loan phone information.

• Change direct loan address information.

• Override direct loan application information.

Changes you make here do not change the Campus Community data. You must save changes to data made on these pages. To commit the data you override to the Origination file and application pages, go to Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application, Direct Loan Application, App Acknowledgement and click the Activate Change button. Then re-run Origination with adjustments.

Note. The system sends Bio/Demo data to the common origination and disbursement processing center (COD). If you choose to override data on any of these pages, ensure the changes are accurate. If the student has more than one Stafford loan type such as a subsidized and unsubsidized loan and if both loans are originated at the same time, you must ensure that changes made on one loan type is carried through and made for the other loan type.

Pages Used to Override Bio/Demo Data for Direct Lending

Overriding Direct Loan Name Information

Access the Direct Loan Name page.

The system displays the ID, Career, Loan Type, Institution, Aid Year, and Appl Seq (application sequence).

The Loan Name Type and the full name of the borrower are displayed. If there are multiple name types associated with the loan, they can be seen also. These fields are display only.

Overriding Direct Loan Phone Information

Access the Direct Loan Phone page.

Telephone	Displays the current telephone number for the borrower. This phone number originates from Campus Community. This field is display only until you select the Override Phone check box.
Override Phone	Select to override the current phone number on the loan record only. Select this check box to activate the Telephone field. If you override this phone number, future adjustments to Campus Community information will not update this field. If you clear this check box, the system reinserts the telephone number originating from Campus Community.

Changing Direct Loan Address Information

Access the Direct Loan Address page.

Loan Address Type	Specifies the type of address displayed.
Country	The address fields change depending on the country you select. You can only select a country if you select the Override Address check box.

Note. To make address changes, use the Addresses page in Campus Community (Managing Biographical Information, Managing Addresses and Phone, Addresses).

Overriding Direct Loan Email Information

Access the Direct Loan Email page.

Override Email Address

Select to override the student's email address. Enter the updated or changed email address in the field. If you override the student's email address, future adjustments to Campus Community information will not update this field. If you clear this check box, the system reinserts the email information originating from Campus Community.

Overriding Direct Loan Application Information

Access the Direct Loan Demo Ovrd page.

Override Borrower SSN	Use to change the borrower's social security number or date for the SSN.
Override Academic Year Start	Use to change the start date of the academic year for this borrower.
Override Academic Year End	Use to change the end date of the academic year for this borrower.
Override Dependency Status	Use to change the borrower's federal dependency status.
Override Borrower BirthDate	Use to change the borrower's date of birth and to enter the date you changed the date of birth.
Override Borrower Citizenship	Use to change the borrower's citizenship status. The values acceptable to COD for Borrower Citizenship Stat are: 1: Native 2: Naturalized 3: Alien Permanent
Override Borrower Alien Reg (registration)	Use to change the borrower's alien registration or Visa/permit number.

Note. If you override these required fields, your institution must take full responsibility for the data you submit to the COD that may be in conflict with existing institutional records. Access to this page should be limited to key personnel.

Overriding and Viewing Direct Loan Origination Data and Action Messages

This section includes the following information.

• Overriding direct loan origination data.

• Viewing direct loan origination action messages.

Pages Used to Override and View Direct Loan Origination Data and Action Messages

Overriding Direct Loan Origination Data

Access the Direct Loan Override page.

Warning! Use extreme caution when updating loan records with this page. Future processing and dollar amounts are based on these loan amounts and loan statuses.

Note. If you override these required fields, your institution must take full responsibility for the data you submit to the COD that may be in conflict with existing institutional records. Access to this page should be limited to key personnel.

With the exception of the fields listed below, the fields on this page are identical to those on the Application Acknowledgement page.

To perform one of the following actions, select the appropriate option and click the Update Origination button.

Important! Use the promissory note acknowledgement override with caution. If the COD rejects a promissory note after you have overridden the promissory note acknowledgement the loan's status will be unbooked. To get the loan to a booked status and properly disburse the funds, this situation must be resolved directly with the COD.

Note. When you perform any of the above actions, the system generates an exception message that you can review on the Loan Exception Messages page. You are encouraged to note exceptions by adding your own detail.

Viewing Direct Lending Origination Action Messages

The Direct Loan Actions Inquiry component is view only and is designed to provide status and processing information to staff who may or may not be directly involved with the processing of Direct Lending files, but may need access to direct lending information.

You use the DL Actions Inquiry component to view origination and disbursement action history and loan exception messages.

Reviewing the Loan Origination Action History

Access the Direct Loan Orig Actions page.

The system displays the ID, Career, Loan Type, Institution, Aid Year and Appl Seq (application sequence). The application sequence number increases each time the system creates a new loan origination record for each ID, Career, Loan Type, Institution, and Aid Year combination.

The following fields are derived from the Loan Origination record.

Actions Tab

Lender Information Tab

Access the Direct Loan Orig Actions page, Lender Information tab.

Batch ID	A unique identifier comprised of alphanumeric characters that represent batch type, cycle year, school code, date, and time.
Instance	The unique identifier assigned to the particular process that created the action row.
User	The user ID for the individual who processed the action.

Explaining Direct Loan Origination Status and Action Codes

This section provides an explanation of the Direct Lending Status Codes for origination. This includes the processes run and the actions that generate each status code. The fields referenced in the following table display on the Direct Loan Orig Actions page.

Explaining Direct Loan Origination Change Status and Action Codes

This section provides an explanation of the Direct Lending Status Codes for Origination Change. This includes the processes run and the actions that generate each status code. The fields referenced in the following table display on the Direct Loan Orig Actions page.

Reviewing Direct Loan Disbursement Actions

Access the Direct Loan Disb Actions page.

The item type, status, and amount fields are the same as those on the Direct Loan Orig Actions page.

Important! Your inbound disbursement file and booking notification file use the same EC Trans ID name DIODxxOP.DAT. Because of this, you must load and process these files into your system in their sequentially numbered order.

Actions Tab

Details Tab

Access the Direct Loan Disb Actions page, Details tab.

Loan Action Dttm (date/time)	For actions representing received information, the action date time is the date/time the acknowledgement is loaded to the system. For actions representing sent information, this is the date and time the transmission is sent.
Loan Disb Action Amt (loan disbursement action amount)	The gross disbursement amount.
Loan Disb Action Fee (loan disbursement action fee)	The loan fee amount for the disbursement.
Loan Disb Action Net (loan disbursement action net)	The net disbursement amount, minus fees, plus rebate.
Loan Disb Action Adj (loan disbursement action adjustment)	The adjusted disbursement amount reported.

Other Information Tab

Access the Direct Loan Disb Actions page, Lender Information tab.

Direct Lending Booked Status	Displays Booked if the COD has accepted and acknowledged the origination, first disbursement, and promissory notes. Until this occurs, the status is Unbooked.
Loan Disb Sequence Status (loan disbursement sequence status)	The values are Accepted, Invalid (invalid sequence number), and AlrdyRecv (already received).
Loan School Cd Status (loan school code status)	The values are blank if the school code is accepted and I — Invalid if the school code is invalid.
Loan Disbursement Status	The status of the disbursement record. The values are Accepted, Invalid (invalid disbursement), AlrdyRecv (already received), and Reject.
Loan ID Status	Displays one of the following values: I – Invalid Loan Identifier, N – Loan Identifier Not on File, or blank – Accepted.
Instance	Number used by the system to count the occurrences of the processes you run. Use this on the Messages page to select the particular instance of the process.
User ID	The user ID for the individual who processed the action.

Explaining Direct Loan Disbursement Status and Action Codes

This section provides an explanation of the Direct Lending Status Codes for disbursements. This includes the processes run and actions that generate each status code. The fields referenced in the following table are located on the Direct Loan Disb Actions page.

The Loan Disbursement Transaction Status field appears opposite the Disbursement ID. The loan disbursement action status refers to the Action Status field on the page.

Reviewing Loan Exception Messages

Access the Loan Exception Messages page.

DateTime	Displays the date and time that the message was created.
Message	Displays the exception message logged for each transaction listed. You can enter further information regarding the exception message using the Loan Message Comment page.
More	Click this link to view additional message information.

Creating and Using Promissory Notes

Multi-year Master Promissory Notes allow a student to sign and use one promissory note throughout multiple loan years and for multiple schools participating in the multi-year master promissory notes. The multi-year master promissory notes are used for Direct Subsidized and Direct Unsubsidized loans only, for academic year 2000-2001 and forward.

All existing 1999-2000 and 2000-2001 master promissory notes, are treated as multi-year promissory notes. Schools that are eligible for multi-year promissory note functionality can use these existing master promissory notes for 2001-2002 loans for the same student. Borrowers who attend a school that is eligible for multi-year functionality are required to have only one master promissory note on file at the COD for all subsidized and unsubsidized loans disbursed for the academic year 2000-2001 and forward. An open master promissory note on file at the COD is assigned to the borrower and can be used by any school eligible for multi-year functionality.

Note. The Social Security Number, date of birth, and first name on the Loan Origination Record must match the same values on the master promissory note, otherwise the COD cannot link the existing master promissory note to the Loan Origination Record.

An open master promissory note is valid for up to ten years from the date of the first anticipated disbursement, if an actual disbursement is made. Students can close open master promissory notes by calling a customer service representative at the COD. Once a master promissory note is closed, no new loans can be disbursed without generating a new master promissory note. However, all disbursements and booking activity for the loans already attached to the closed master promissory notes are processed.

Single-year schools are not eligible to use multi-year master promissory notes. For these schools, a borrower must sign a new master promissory note for each academic year. Single-year schools must use a master promissory note generated specifically for that institution. For these schools, subsidized and unsubsidized loans for the same student and the same academic year can be linked to a single master promissory note.

This section discusses how to:

• Create a promissory note communication record.

• Print direct lending promissory notes.

• Print direct lending master promissory notes for PLUS.

• Sign and review direct loan promissory notes.

• Create batch signatures for direct loan promissory notes.

• You use the same pages whether you are creating multi-year promissory notes or single year promissory notes.

See Also

Direct Loan Technical Reference

Pages Used to Create and Use Promissory Notes

Creating a Promissory Note Communication Record

Access the Create DL Pnote Communication page.

This page allows you to create direct lending (and non-Direct Lending) promissory note communication records that determine which promissory notes are printed, based on the criteria you enter. The fields in the Select Criteria group box have a cumulative search effect. Each field you enter narrows your search criteria.

The DL PNote Create program (FAPLDPN2.CBL) creates one VAR_DATA_LOAN record if it is assigning a Checklist and Communication at the same time. The logic is updated to ensure consistent VAR_DATA_LOAN data. When you run the Loan Origination (FAPLBOG0.CBL and FAPLORG0.CBL) and the DL Pnote Create (FAPLDPN2.CBL) processes for direct loans, the system populates all of the fields in the record to be in sync. This was done to accommodate users who run the CCLTRGEN routines. For all other loans, the system populates all fields except for LN_APPL_ID. As a result, the system only creates one VAR_DATA_LOAN record when the loan origination process is run along with the CCLTRGEN routine.

Selection Criteria

Note. Although Cover Ltr, TIL, and TIS are listed, they are not valid selections for Document Type for this process.

Click Run to run the Create PNote Communication Rec process (FAPLDPN2).

Note. After you run the Create DL PNote Comm process once with the document type blank, if you want to create additional promissory notes and promissory note communications you should run the process using singular document types or using From Thru Dates. Otherwise, the communication keeps selecting all of the promissory note types and populating the promissory note communication table with multiple rows.

Check the Batch Message Inquiry page in this component after you run the process to be sure it completed properly.

See Also

Using PeopleSoft Enterprise Applications PeopleBook

Printing Direct Lending Promissory Notes

Access the Print DL Promissory Note page.

Selection Criteria

The following fields are the same as those on the Create DL PNote Comm page: Institution, Aid Year, Career, Ln Output Type, Student Override, EmplID.

Note. The system manages positional printing differently. When you run the process to create the communication record, the system processes all loan types associated with the package. It creates all of the communication records. If you're using positional printing, you can only print one document at a time. When you select the package you want to use, you must also specify which document type you want to run.

Click the Run button to run the Print Packages/PNote Docs process (FALDPNT2).

See Also

Using PeopleSoft Enterprise Applications PeopleBook

Printing Direct Loan MPN for PLUS

It is now possible to use Master Promissory Notes (MPN) in making PLUS loans in the Direct Loan (DL) program. The Direct PLUS MPN is a promissory note that can be used to make one or more Direct PLUS Loans to a parent borrower to help pay for the educational costs of one dependent student for one or more academic years.

If your institution collects signed promissory notes for the Direct Lending program, you need to produce a manifest to send with the signed promissory notes to the Direct Lending common origination and disbursement processing center (COD).

A loan origination record must exist before you can create a promissory note. Set up your Manage Communication Tables in Campus Community, set up Loan Report Packages and DL Serial Pnote Tables in Process Loans. To print a promissory note you must first create a promissory note communication record for the types of documents defined in the report package selected. The print process that produces the output for the promissory notes reads the communication record.

PeopleSoft now uses an unlabeled format for printing promissory notes and only supports a positional print process. We still provide an extract process. The extract generated is no longer specifically for JetForms.

Note. For details on how to set up a loan origination record, the Manage Communication Table, Loan Report Packages, and DL Serial Pnote Tables, “Processing Direct Loans,” Creating and Using Promissory Notes in this book.

Signing and Reviewing Direct Loan Promissory Notes

Access the Direct Loan PNote page.

Note. Click the tabs on the page to access multiple view of this page. We document fields that are common to all views first.

Common Page Information

Note. The Checklist associated with the loan type is inserted when the Promissory note Communication is assigned. In previous versions of Financial Aid, the Checklist associated with the loan was inserted at loan origination. Make sure you have assigned a 3Cs inquiry group to your communication category.

Actions Tab

See the previous exhibit for a view of this tab.

Details Tab

Access the Direct Loan Pnote page, Details tab.

Borrower Signature	Indicates the borrower has signed the promissory note.
Signature Date	The date the Borrower Signature check box was selected, or the actual date the borrower signed the promissory note if you edited the signature date.
Student Signature	This field is unavailable with PLUS loans when the borrower is not the student.
Signature Date	The date the Student Signature check box is selected, or the actual date the student signed the promissory note if you edited the signature date.
Promissory Note Amount	The amount printed on the promissory note.

Other Information Tab

Access the Direct Loan PNote page, Lender Information tab.

Loan Action Dttm (loan action date and time)	The date and time the loan promissory note status was posted.
Batch ID	The direct lending batch ID.
Instance	The system assigns this number incrementally to count the occurrences of the processes you run. You can use this number to select the particular instance of the process for which you want to view the process results.
User ID	The ID of the person who ran the process.

Creating Batch Signatures for DL Promissory Notes

Access the DL Batch Signature page.

In the past, this page was designed to select a cumulative list of outstanding unsigned promissory notes. You had to review the aid year designation in the DL Pnote ID. It is now possible to sort based on aid year by selecting it on the Selection Criteria page.

Note. This page is designed to select a cumulative list of outstanding unsigned promissory notes. You should select the promissory notes to be signed by reviewing the aid year designation in the DL Pnote ID. The aid year designation is located after the Borrower's Social Security Number and the M for a Stafford loan and the P for a PLUS. For Aid Year 2004, the aid year designation is 04 and for Aid year 2005, the aid year designation is 05.

The group box contains the promissory note ID numbers and names of the students you selected.

The field that displays to the right of the student signature date field contains the status of the manifest. When you sign the promissory note, the status changes to Authorize. Prior to signing the promissory notes, the status is Pending. After the manifest generation process is complete, the status is Batch.

Signing or Unsigning a Group of Promissory Notes

1. To sign the entire group of promissory notes, select the Sign option in the Batch PNote Action field.

2. Click the PNote Update button to select all the active signature check boxes. For PLUS notes, both the Borrower Signature and Student Signature check boxes are active.

3. To unsign the entire group of promissory notes, select the Unsign option in the Batch PNote Action field.

4. Click the PNote Update button to clear all the active signature check boxes.

5. The group box contains the promissory note ID numbers and names of the students you selected.

Entering Loan Pnote Selection Criteria

Access the Loan PNote Selection Criteria page.

You can select promissory notes by the borrower's name or National ID number. For U.S. citizens this is the social security number. You can also specify whether to select promissory notes of a specific type.

Viewing Promissory Note Action History and Loan Disbursement Messages

This section discusses how to:

• View promissory note action history.

• Review loan disbursement messages.

Page Used to View Promissory Note Action History and Loan Disbursement Messages

Viewing Promissory Note Action History

Access the Direct Loan PNote page.

Actions Tab

Click the Msg (message) link to access the Loan Disbursement Messages page, where you can review message to explain the problem with the promissory note.

See Also

Signing and Reviewing Direct Loan Promissory Notes

Viewing Loan Disbursement Messages

Access the Loan Disbursement Messages page.

PNt MsqSq (promissory note message sequence)	Generated from the promissory note record activity. When multiple sequences exist, they display in reverse order. In other words, the most recent sequence displays at the top.
Msg Code (message code)	The code the COD has assigned to this action message.
Descr (description)	The description of the action message.
Msg (message)	Click this link to view the full text of the message.

Processing Direct Loan Manifests

If your institution collects signed promissory notes for the direct lending program, you need to produce a manifest to send with the signed promissory notes to the direct lending common origination and disbursement processing center (COD). When you receive a signed promissory note you must go to the Direct Loan Pnote page and indicate the promissory note is signed. Once you have indicated the promissory note is signed, the system sets the Manifest Status to Authorize and the promissory note is included the next time you create a loan manifest.

After you have indicated that you have signed promissory notes, you need to create the data for the loan manifest. You use a run control page to run a process that selects all students' promissory notes that have a Manifest Status of Authorize. You can review the selected promissory notes and delete any you do not want included in the manifest. The last step is to print the manifest.

After you have a printed manifest, you must manually sort the signed promissory notes and attach the printed manifest to each group of fifty promissory notes. Financial Aid creates a manifest for every fifty promissory notes. Separate manifests are created for Stafford subsidized and unsubsidized and PLUS promissory notes as required by the COD.

This section discusses how to:

• Create a direct loan manifest.

• Edit a direct loan manifest.

• Print PLUS and Stafford loan manifests.

Pages Used to Process Direct Loan Manifests

Creating a Direct Loan Manifest

Access the Populate Manifest page.

Academic Institution	Indicates the institution whose promissory notes that you want included on this manifest.
Aid Year	Indicates the aid year for the promissory notes that you want included on this manifest.

Click Run to run the DL Manifest Generation process for subsidized and unsubsidized loans (FAMANF01). The DL Manifest Generation process for PLUS loans is FAMAN2.

Editing the Direct Loan Manifest

Access the Direct Loan Manifest page.

School Code	The Central Processing Center (CPS) code for your institution.
Loan Manifest Date	The date you created the manifest.
Manifest Group Number	Indicates each manifest group. A new manifest group is created for each Stafford or PLUS group of fifty promissory notes. You can view the different manifest groups.
DL Batch ID (direct lending batch identifier)	This batch ID is comprised of alphanumeric characters representing batch type, cycle year, school code, date, and time. This batch ID is used to monitor and control the number of promissory notes accepted by the Department of Education COD.
Seq Number (sequence number)	Indicates the order that you should organize the signed promissory notes you include with the manifest.
EmplID	The student's ID.
Loan ID	The identification number of the loan. The promissory note type is displayed next to this field.
Delete Row	If you do not want a student to be included on the manifest when it is printed, you can select this check box. In order for the student to be selected in future manifests, you must reset the Manifest Status back to Authorize on the direct loan PNote page.

Printing PLUS and Stafford Loan Manifests

There are different run control pages for printing PLUS loan manifests and Stafford loan manifests. Use the Plus Manifest page to print PLUS loan manifests and the Stafford Manifest page to print Stafford loan manifests you have created. You can print or reprint the manifests by date or by manifest group.

Printing a PLUS Loan Manifest

Access the DL Print PLUS Manifest page.

Academic Institution	Select the academic institution for which you want to print manifests.
Aid Year	Select the aid year for which you want to print manifests.
Loan Manifest Date	Select the manifests to print by entering a Loan Manifest Date. If you enter a value in this field, the From Manifest Group Number and Thru Manifest Group Number fields are not available.
From Manifest Group Number	Allows you to select a group of manifests to print. Select the beginning manifest group number from the available options. The system prints the most current instance of each manifest for that date selected. All loan manifest groups are available from the options, even if they have been printed.
Thru Manifest Group Number	Enter the ending manifest group number in this field to specify the manifests you want to print.

Click Run to run the Generate Manifest Report process for subsidized and unsubsidized (FAMANFS3). The process that runs the DL Manifest Generation for PLUS loans is FAMANFS2.

Printing a Stafford Loan Manifest

Access the DL Print Stafford Manifest page.

Click Run to run the Print Manifest Report Stafford process (FAMANFS3).

Transmitting Direct Lending Outbound Files

At different times in the direct lending process you need to send files to the direct common origination and disbursement processing center (COD). Origination files, origination change files, and disbursement files use the same process.

Note. These processes are for schools that are not full participant schools.

Warning! You must be a full participant school with COD. Please refer to the COD process for details.

Note. To run multiple careers successfully a technical fix is required. This is documented in the technical installation notes for each regulatory update. You should coordinate with your technical resources to ensure the fix is completed prior to processing your direct loan outbound files. The process that you should reference is called ECOUT001.SQR. This fix will allow the outbound files to be formatted to the direct loan file specifications. If the fix is not made you must run the two step process for each career separately.

This section discusses how to:

• Move data to staging tables.

• Create outbound flat files.

• Rename direct lending EDI outbound files.

Pages Used to Transmit Direct Lending Outbound Files for 2003-04 Phase-In

Moving Data to Staging Tables

Access the Direct Loan Outbound page.

Selection Criteria

Note. You can select more than one of the Outbound check boxes to gather more than one type of outbound record.

Insert a row to add additional Institution, Aid Year, and Career combinations.

Click Run to run the DL Outbound Driver process (FAPLDOD0).

Note. Flat files created for year 2001/02 are generated by school code, rather than career. The system creates a Header file for each school code. With this change, multiple careers can reside in one flat file.

Creating Outbound Flat Files

Access the FA Outbound page.

EC Trans ID	Select this check box for direct lending files. Select an EC Trans ID from the available options. The EC Trans ID is the same as the direct lending message class.
Business Unit	This check box is part of the EDI Manager and is not used for this process. Do not select this check box.
Vendor/Customer	This check box is part of the EDI Manager and is not used for this process. Do not select this check box.

Note. You must run this process separately for each EC Trans ID. For example, if you are sending Stafford origination files and PLUS Origination files, you need to run the ECOUT001 process twice using a different EC Trans ID for each transmission.

Receiving Direct Lending Inbound Files

This section describes processes used in the 2003-04 phase-in. If your institution is a full participant, see the COD sections for processing details.

This section discusses how to:

• Move inbound flat files to staging tables.

• Review inbound processing.

• Move inbound files to the database.

Note. The pages in this section are used for the 2003-2004 phase-in process only. Full participant schools must use common origination and disbursement processes.

Pages Used to Receive Direct Lending Inbound Files

Moving Inbound Flat Files to Staging Tables

Access the Run Control Parameters page.

Note. You should keep track of your acknowledgement file names. The COD sends your acknowledgment files in sequential order. Be sure to load your files sequentially. Do not load your Inbound flat files into the staging tables more than once.

Run Option

Inbound Agent Parameters

Force Profile

Inbound Agent Forced Parameters

File Options

Do not make any changes in the File Options group box.

Direct Lending File Names and EC Map IDs

The following table contains the possible Direct Lending field values for the EC Map ID field with the associated file name message class.

* YY is the last two digits of the aid year. For example, for the 2002 Aid Year YY=02.

Important! You must load all the sections of the 732 Loan Detail Report to run the DL 732 Loan Detail report provided by Financial Aid. Therefore, you need to import the ED1202OP (or ED0902OP) file AND the ED1302OP (or ED1102OP) file before attempting to run the report.

Click the Run button to run the Inbound EC Agent process (ECIN0001).

Moving Inbound Files to the Database

Access the Direct Loan Inbound page.

Selection Criteria

You can select one or more of the check boxes to move multiple types of inbound files.

Click the Run button to run the DL Inbound Driver process (FAPLDID0). When you run the process, the system moves the inbound files you selected from the EDI Manager staging table to the database.

Using EC Queue Status with Direct Loan Processing

This section discusses how to review EC Queue status information.

Page Used to Review EC Queue Status

Reviewing the EC Queue Status

Access the EC Queue Review page.

Click the Update Status button to change the EC Queue Status field. The Override button toggles through the following values: P- processed, E- error, L- loaded.

The EC Queue Status indicates the load status for the entire file. A file can contain one or many records. When the flat file is loaded into the EDI Manager staging tables, the EC Queue Status is set to Loaded. When the data in the file is moved from the staging tables to the database, the EC Queue Status is set to Processed. If you do not want a specific file to be loaded to the database, set the EC Queue Status to Processed and the system will ignore the file on subsequent loads to the database.

If you need to reload a file to the database, set the EC Queue Status to Loaded. A file with an EC Queue Status of Error is automatically recycled attempted to be loaded to the database the next time the inbound process is run.

The other fields on this page provide additional information about the file.

Viewing Direct Loan EC History

You can access Direct Loan EC history for aid years that were removed from the menu.

This section discusses how to enter data to review DL EC history.

Pages Used to View Direct Loan EC History

Entering Data to Review DL EC History

Access the Direct Loan EC History Information page.

ID	Enter the student's ID.
Aid Year	Enter the aid year.
Originations	Click to access the Direct Loan Origination Export component.
Origination Acknowledgements	Click to access the Direct Loan Origination Acknowledgement Import component.
Changes	Click to access the Direct Loan Change Export component.
Change Acknowledgements	Click to access the Direct Loan Change Acknowledgement component.
Credit Decisions	Click to access the Direct Loan Credit Import component.
Pnote Acknowledgements	Click to access the Direct Loan Promissory Note Import component.
Disbursements	Click to access the Direct Loan Disbursement Export component.
Disbursement Acknowledgements	Click to access the Direct Loan Disbursement Acknowledgement Import component.

Reviewing Direct Lending Origination Export Files

This component is populated after the origination, the Direct Loan Out/Validation, and the Direct Loan Out processes successfully complete. The data on these pages reflects the data located on the Application Acknowledgement page (Financial Aid, Process Loans, Use, Direct Loan App, Application Acknowledgement).

The Direct Loan Orig Exp component displays information by loan, rather than by batch. This means that each page contains information for one loan. To view subsequent loans, click the Next in List button or exit the page and select a different loan to view.

This section discusses how to:

• View batch header outbound Direct Lending data in the EDI manager staging tables.

• Review student information in the outbound origination file.

• Review origination financial data contained in the outbound origination file.

• Review origination financial data contained in the outbound origination file.

• Review origination loan data.

• View outbound Direct Lending data in the EDI manager staging tables.

Note. The following pages are view only in financial aid. You can view the following pages using the FA history menu components. FA history also includes pages for PROFILE, Need Access, ISIR, Maintain Institutional Applications, Federal Methodology, and INAS Calculations.

Pages Used to Review Direct Lending Origination Export Files

See Also

Viewing Application History

Viewing the Origination Export Header

Access the Batch Header page.

Note. This page is accessible for converted phase-in data only.

Student Loan Information

The Student Loan Information group box contains fields specific to the student. These fields are derived from the Application Acknowledgement page.

Batch Information

Viewing Origination Export Borrower Information

Access the Borrower Information page.

Note. This page is accessible for converted phase-in data only.

This page displays the borrower information contained in the flat file. The system displays the field values from the Direct Loan App component.

Viewing Origination Export Student Information

Access the Student Information page.

This page displays the borrower information contained in the flat file. The system displays the field values from the Direct Loan App component.

Note. This page is accessible for converted phase-in data only.

Viewing Origination Export Financial Information 1

Access the Financial Information 1 page.

This page displays the borrower information contained in the flat file. The system displays the field values from the Direct Loan App component.

Note. This page is accessible for converted phase-in data only.

Viewing Origination Export Financial Information 2

Access the Financial Information 2 page.

Note. This page is accessible for converted phase-in data only.

This page displays the borrower information contained in the flat file. The system displays the field values from the Direct Loan App component.

Viewing Origination Export Miscellaneous Information

Access the Misc Export Information page.

Note. This page is accessible for converted phase-in data only.

This page displays the borrower information contained in the flat file. The system displays the field values from the Direct Loan App component.

Viewing Origination Export Trailer

Access the Batch Trailer page.

Note. This page is accessible for converted phase-in data only.

Reviewing Direct Lending Origination Acknowledgement Import Files

This component allows you to view the data in the EDI Manager staging tables before you import the data into your system. The Master Promissory Note Indicator valid values are sent to the institution as a Yes or No by the COD. This indicates the existence of a valid MPN and links all current approved loan amounts to the valid MPN. Use the Direct Loan Orig Ack Imp (direct loan origination acknowledgment import) component to:

• View the header information for the origination acknowledgement files received from the COD.

• View the origination acknowledgement data received from the COD.

• View the trailer information for the origination files received from the COD.

Note. Click the Related Links button to access the Direct Loan Application component for the displayed student record on any of the Direct Lending Origination Export or Import pages. Then select the page you want to view.

Note. These pages is accessible for converted phase-in data only.

Pages Used to Review Direct Lending Origination Acknowledgement Import Files

Viewing Origination Acknowledgement Import Data

Access the Origination Acknowledgement page.

Note. This page is accessible for converted phase-in data only.

Reviewing Direct Lending Promissory Note Acknowledgement Files

The Direct Loan PNote Imp (direct loan promissory note import) component displays the promissory note acknowledgement import files received from the common origination and disbursement processing center (COD). The COD generates the Promissory Note Acknowledgement files after you have submitted the promissory note manifests and promissory notes to the COD. This section discusses how to:

• View header information for the promissory note acknowledgement import files received from the COD.

• View the promissory note information received from the COD.

• View the trailer information for the promissory note acknowledgement files received from the COD.

Pages Used to Review Direct Lending Promissory Note Acknowledgement Files

Viewing Promissory Note Acknowledgement Import Data

Access the Pnote Acknowledgement page.

Note. This page is accessible for converted phase-in data only.

Reviewing Direct Lending Credit Decision Files

This section discusses how to:

• View the header information for the credit decision import file received from the COD.

• View the PLUS loan credit decision information received from the COD.

• View the trailer information for the credit decision import file received from the COD.

Pages Used to Review Direct Lending Credit Decision Files

Viewing Credit Decision Import Data

Access the Credit Decision page.

Note. This page is accessible for converted phase-in data only.

Processing Direct Lending Origination Changes

This section discusses processing Direct Lending origination changes.

Page Used to Process Direct Lending Origination Changes

Setting Change Parameters for Direct Loan Origination Changes

Access the DL Student Change Information page.

Specify any change processing requirements for the selected student by entering the fields in the DL Student Change Parameters group box. These field definitions are identical to those listed in on the Ln Dl Inst Parm page.

Note. The above change parameters affect those loans that have been transmitted to the COD. Prior to submitting loans to the COD, you can change the fields on the loan record without generating a change transaction. Change transactions occur when you make changes to loans you have transmitted to the COD.

Understanding Direct Lending Change Processing

This section discusses three examples of the Direct Loan Origination Change process. Each example addresses a different type of change. The processing examples are:

• A bio/demo change.

• An award change.

• A rejected origination change.

See Also

Reviewing Direct Lending Change Export Files

Processing a Bio/Demo Change

The following steps represent the process for changing bio/demo data. For this example, the borrower's date of birth requires a change after you have originated the loan and transmitted it to the COD.

Changing Bio/Demo Data

1. You enter and save a new date in the Birth date field on the Bio/Demo Data page (SA_BIO_DEMO_DATA3).

2. For the Loan Change process to recognize the changed field, you can flag the loan for change processing. Click the Activate Change button on the Application Acknowledgement page (LOAN_ORIG_STAT_DL0). Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application, Application Acknowledgment

   Note. Click the Activate Change button to trigger the Loan Adjustment process to review the student for change transactions. Data changes in the Direct Loan Application component or the Award Entry page do not require you to manually start the Loan Change process here. Click the Activate Change button for any other data changes (for example, the student or borrower name) to start the Loan Change process.

3. You must initiate the Loan Change process by running the Loan Origination process with the Adjustments check box selected. Go to the Loan Origination page (RUNCTL_LNORIG) Financial Aid, Loans, Direct Lending Management, Loan Origination. Select the Adjustments check box and run the Loan Origination process.

4. Review the Application Acknowledgment page after running the Loan Origination with the change. At this point in the process, the Loan Process Status is In Service and the Loan Orig Trans Stat (loan origination transaction status) is Change Pending.

5. Review the Direct Loan Orig Actions page (LN_DL_ORIG_INQ) to ensure the change was processed. The latest Sequence number should reflect an Origination Change, with an Action Status of Pending. Financial Aid, Loans, Direct Lending Management, DL Actions Inquiry, Direct Loan Orig Actions.

6. Now the change is complete and ready to send to the COD.

Processing an Award Change

The following steps represent the process for changing an award. For this example, you are canceling the borrower's unsubsidized loan after the loan was originated, transmitted, and acknowledged by the COD.

Processing an Award Change

1. Make the change to the award on the Student Aid Package page (STDNT_AWARD_ENTRY3). If you canceled the Unsubsidized loan, for example, the Offered and Accepted amounts are now zero.

2. You must initiate the Loan Change process by running the Loan Origination process with the Adjustments check box selected.

3. Review the Application Acknowledgment page to verify the Loan Change process completed successfully. See Step 4 under Processing a Bio/Demo Change. At this point in the process, the Loan Process Status is In Service and the Loan Orig Trans Stat (loan origination transaction status) is Change Pending.

4. Review the Direct Loan Orig Actions page (LN_DL_ORIG_INQ) to ensure the change was processed. The latest Sequence number should reflect an Origination Change, with an Action Status of Pending. Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application, Direct Loan Orig Actions.

5. At this point, the change is complete and you would create the Direct Loan Change Processing outbound file to send to the COD. View this file using the Direct Loan Change Export 00/01 component. The COD must acknowledge the change by sending a Direct Loan Change Acknowledgement file.

Processing a Rejected Origination Change

The following steps represent the process when a change is sent to the COD and the COD rejects the change. In this example, you attempt to change the citizenship status of a student.

To process a rejected origination change:

1. Change the value of the Citizenship Status field on the Citizenship Detail page from the Bio/Demo Data page (SA_BIO_DEMO_DATA3).

2. For the Loan Change process to recognize the changed field, you can flag the loan for change processing. Click the Activate Change button on the Application Acknowledgement page (LOAN_ORIG_STAT_DL0). Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application, Application Acknowledgment.

   Note. Click the Activate Change button to trigger the Loan Adjustment process to review the student for change transactions. Data changes in the Direct Loan Application component or the Award Entry page do not require you to manually start the Loan Change process here. Click the Activate Change button for any other data changes (for example, the student or borrower name) to start the Loan Change process.

3. You must initiate the Loan Change process by running the Loan Origination process with the Adjustments check box selected. Go to the Loan Origination page (RUNCTL_LNORIG) Financial Aid, Loans, Direct Lending Management, Manage Direct Loan Application, Loan Origination. Select the Adjustmentscheck box and run the Loan Origination process.

4. Review the Application Acknowledgment page to verify the Loan Change process completed successfully. See Step 4 under Processing a Bio/Demo Change. At this point in the process, the Loan Process Status is In Service and the Loan Orig Trans Stat (loan origination transaction status) is Change Pending.

5. Review the Direct Loan Orig Actions page (LN_DL_ORIG_INQ) to ensure the change was processed. The latest Sequence number should reflect an Origination Change, with an Action Status of Pending. Financial Aid, Loans, Direct Lending Management, Direct Loan Orig Actions.

6. Run the Origination Change Outbound and Outbound EC Agent (EDI outbound) processes to export the file to the COD.

7. The COD returns the acknowledgement file that includes the error code.

8. Run the Inbound EC Agent (EDI inbound) and Origination Change Inbound processes to import the COD data.

9. Review the Exception Error Report, the DL Inbound Origination Acknowledgement Errors, and the DL Rejected Origination Changes reports to determine which records contain errors.

10. Review the Application Acknowledgment page to view the inbound file you determined has an error. See Step 4 under Processing a Bio/Demo Change.

11. Review the Direct Loan Orig Actions page (LN_DL_ORIG_INQ) to see details about the error. The latest sequence shows an origination change with an Action Status of Rejected. Financial Aid, Loans, Direct Lending Management, Manage Direct Loans, DL Actions Inquiry, Direct Loan Orig Actions.

12. You must now fix the error and resubmit the change record to the COD.

Reviewing Direct Lending Change Export Files

This section discusses how to:

• View changes to export header information.

• View changes to information export data.

• View change to export trailer information.

Warning! You must be a full participant school with COD. Please refer to the COD process for details.

Note. These pages is accessible for converted phase-in data only.

Pages Used to Review Direct Lending Change Export Files

Viewing Change Information Export Data

Access the Change Information page.

Note. This page is accessible for converted phase-in data only.

Reviewing Direct Lending Change Acknowledgement Import Files

This section discusses how to:

• View Direct Loan change acknowledgement data included in the inbound file you receive from the COD.

• View Direct Loan change processing data included in the outbound file you are sending to the COD.

• View Direct Loan change processing trailer data included in the outbound file you are sending to the COD.

Note. These pages are accessible for converted phase-in data only.

Pages Used to Review Direct Lending Change Acknowledgement Import Files

Viewing Change Acknowledgment Import Data

Access the Change Acknowledgement page.

Note. This page is accessible for converted phase-in data only.

Reviewing Direct Lending Disbursements

The disbursement process has several pieces that must work together to successfully disburse Direct Lending awards to students and send the correct disbursement information to the COD. The COD receives disbursement information with the loan origination (anticipated disbursement information) and with the loan disbursement data (actual disbursement information).

Important! Information reported to the COD is based on your setup on the Direct Loan Options page. Be sure you complete this page correctly. Changes to the DL Disbursement Option and DL Transmit Disb Option parameter settings will not affect loans already originated if the parameter settings are changed after the loans have been originated.

This section provides information on how to:

• View data included in the Direct Loan Disbursement export file you are sending to the COD.

• View data contained in the Direct Loan Disbursement Acknowledgement file you receive from the COD.

Pages Used to Review Direct Lending Disbursements

Reviewing Direct Lending Disbursement Export Files

This section discusses how to view the disbursement information contained in the outbound file you are sending to the COD.

Viewing Disbursement Information Export Data

Access the Disbursement Information page.

Disbursement Number	ID number assigned to this disbursement.
Disbursement Action	Refers to the Disbursement Activity field defined in the Direct Lending Technical Reference. Valid values are D – Actual Disbursement, A – Adjusted Disbursement, and Q – Adjusted Disbursement Date.
Disbursement Action Dt (disbursement action date)	Indicates the date the disbursement activity occurred at the school. Refers to the Transaction Date field in the Direct Lending Technical Reference.
Disbursement Seq Nbr (disbursement sequence number)	Counts the maximum allowable disbursements for a Master Promissory Note.
Actual Gross Amt (actual gross amount)	Indicates the gross amount of the loan. Refers to the Disbursement Actual Gross field defined in the Direct Lending Technical Reference.
Actual Fee Amt (actual fee amount)	Indicates the actual loan fee amount. Refers to the Disbursement Actual Loan Fee Amount field defined in the Direct Lending Technical Reference.
Actual Net Amount	The loan total amount minus the loan fee amount. Refers to the Disbursement Actual Net Amount field defined in the Direct Lending Technical Reference.
Actual Rebate	The actual rebate amount for this disbursement. Refers to the Disbursement Actual Rebate field defined in the Direct Lending Technical Reference.
User ID Create	The user ID of the individual who created this batch.
School Code	Identifies the school originating the loan record.
Affirmation Flag	Indicates if the borrower has affirmed the disbursement. Field values are Y-Yes or left blank.

Reviewing Direct Lending Disbursement Acknowledgement Import Files

This section discusses how to view data contained in the Direct Loan Disbursement Acknowledgement file you receive from the COD.

Viewing Disbursement Acknowledgement Import Data

Access the Disbursement Acknowledgement page.

School Code Status	Indicates if the school code is valid. The field is blank if the school code is accepted and I – Invalid if the school code is invalid.
Load Status	The status of the individual record you are loading. The following values are possible: Not Prcsd: (not processed) Indicates the record is in the EDI Manager staging table, but the record has not been added to your application tables. Processed: Indicates the record was moved from the staging tables to the application tables. Error: Indicates a problem loading the file to the application tables. Skip: This status tells the Direct Loan In process to skip this record and not load it into the application tables. You must set this value, the system does not set this value.
DL Action Dt Status (direct loan action date status)	Refers to the Transaction Date Status field as described in the Direct Lending Technical Reference. Valid values are I – Invalid Date or field is blank – Accepted.
Seq Status (sequence status)	Displays the status of this disbursement sequence.
Svcr Actual Gross (servicer actual gross)	The COD calculated actual gross amount of the disbursement.
Svcr Actual Fee (servicer actual fee)	The COD calculated actual loan fee amount.
Svcr Actual Net (servicer actual net)	The COD calculated actual net amount of the disbursement. This is the loan total amount minus the loan fee amount.
Svcr Actual Adjustment (servicer actual adjustment)	The COD calculated actual net adjustment amount of the disbursement.
Srvc Total Booked Net (servicer total booked net)	The total net disbursement accepted and booked by the COD for this loan.
Acknowledgement Date	The date the COD acknowledged the disbursement.
Disbursement Nbr Status (disbursement number status)	Indicates the status of the disbursement represented by this particular sequence number.
Reject 1 - 5	Displays the Booking Reject Code, as defined in the Direct Lending Technical Reference.

See Also

Reviewing Direct Lending Disbursement Export Files

Overview of Direct Lending Cash Management

This section discusses how to manage Direct Lending cash.

Financial Aid assists your institution in managing your cash transactions for the Direct Lending program. Managing your Direct Lending cash transactions entails entering information for cash receipts cash draw-downs and return of excess cash, then reconciling that information with similar information from the common origination and disbursement processing center (COD). You also reconcile individual student disbursements using the data in your Loan Application tables and the disbursement information from the COD. The purpose of reconciliation is to ensure that, on a monthly basis, your institution reviews and compares its Direct Lending portfolio Direct Lending origination and disbursements to student accounts against the cash balance reported by the COD.

For each reconciliation period, a comparison is made among Financial Aid, PeopleSoft Enterprise Student Financials, and COD data. Data from all three sources should match. The Student Financials data shows dollars actually disbursed to students and the amount of each cash receipt and return of excess cash. GAPS is the government entity that your institution actually receives cash receipts from and where excess cash is returned.

Generally, the Bursar's Office interacts directly with GAPS to request funds for Direct Loan disbursements to students. You should work with your Bursar's Office or other appropriate office when using the Cash Reconciliation pages.

Direct Lending Cash Management Process

These are the general steps used in the Direct Lending Cash Management process:

1. Set up your Cash Transaction page for the aid year.

2. Receive cash receipts cash drawdowns and return excess cash.

3. Enter your cash receipt and return of excess cash information on the Cash Transaction page.

4. Enter your cash receipt and return of excess cash information on the Cash Detail page.

5. Use the online and report information to reconcile your institutional data with the COD data.

6. Repeat steps 2 - 5 for each Reconciliation Period.

Understanding the Direct Loan School Account Statement

The Direct Lending common origination and disbursement processing center (COD) sends the Direct Loan School Account Statement (DLSAS) to schools that participate in the Direct Lending program. The Direct Lending Technical Reference states that schools must reconcile the school's Direct Loan records on file at the COD with the school's internal Direct Lending records. This process is School Reconciliation and should be performed by the school on a monthly basis. For more details, see the Direct Loan School Guide. Each school is responsible for reviewing the monthly statement to ensure the accuracy of the data. This data must also be reconciled to the school's internal student account records and bank records.

Entering Cash Summary Data

Before you receive the SAS file, you can manually enter cash transactions, including information about your cash receipts from Grants Administration and Payment System (GAPS) and your excess cash returned to GAPS. The DL-SAS reports use the data you enter manually to compare and match reported fund levels from the DL-SAS file.

This section discusses how to enter institutional data for cash transactions.

Note. This page is used for the DLSAS processing.

Page Used to Enter Cash Summary Data

Entering Institutional Data for Cash Transactions

Access the Direct Loan Cash Transactions page.

To report your cash transactions, you must set up the Direct Loans Cash Transactions page for the new aid year.

Using Loan/Import Programs

Beginning with processing year 2003-2004, you use the FA Inbound page to import the SAS file types (DSDFXXOP and/or DSLFXXOP, where XX equals the processing year). The FA Inbound page runs a one-step process to load the data into staging tables.

This section discusses how to load the SAS file.

Page Used to Load the SAS File

Loading the SAS File

Access the FA Inbound page.

Use the Inbound File field to set the location and name of the file to be loaded. Make sure that your application server has access to the location of the file.

Note. The FA_INBOUND process automatically determines the file type by reading the header row of the file. It is important that the file be in its original, unaltered state. Opening the file with a text editor that automatically reformats the file—such as trimming blank spaces at the end of each row of data in the file—may cause the load to fail.

Click the Run button to run the FA_INBOUND process and load the SAS file(s) into staging tables.

Viewing Data Import Information

This section discusses how the fields in the Direct Loan Cash Sum Imp 05/06 component map to the fields in the SAS file types.

Pages Used to View Data Import Information in Staging Tables

Viewing Header Information

Access the Batch Header page.

Field	DLSAS Field
Batch ID	Batch Identifier: The batch ID associated with the detail records is constructed as follows: Batch Type: #A-Z Cycle Indicator:= 4 (for 03-04) School Code: X00000-X99999, where X = G or E Date Batch Created = CCYYMMDD Time Batch Created = HHMMSS
Trans ID	DL-SAS file type: DSDF04OP = Disbursement Level DSLF04OP = Loan Level
Queue Inst	Queue instance number that identifies the particular instance of the inbound file you are viewing.
Status	Load status. Values for the DL-SAS process are: Loaded – Data imported into the Inquire 2 Pages successfully Error – Problem with data import
In/Out	Inbound is the only valid status for DL-SAS.
Message Class	The Direct Loan Message Class table describes the message classes for sending and receiving Direct Loan data to and from the COD System. For the DL-SAS process the message classes are: DSDF04OP (Fixed Length, Disbursement Level Loan Detail) DSLF04OP (Fixed Length, Loan Level Loan Detail)
DL Create Date	Created Date: The date when the record was created. Format is CCYYMMDD (CCYY = 2003-2004).
DL Create Time	Created Time: The time when the record was created; values range from 000000-235959. Format is HHMMSS, where HH = 00-23 MM = 00-59 SS = 00-59
Record Length	Data Record Length. Indicates length of the data record: 0000-9999.
User ID	Source of information for the data.
Process Instance	Business Process Instance Number. Number used by the Business Document Summary to identify the inbound file.

Viewing Cash Summary Information

Access the Cash Summary page.

Field	DLSAS Field
School Code	School Code - Direct Loan School Code. Identifies the school originating the loan record. X00000-X99999 where X = G or E
Region Code	Region Code - 2-digit region code of the school. 01-99
State Code	State Code - 2-letter state code of the school. A valid two-letter postal code - See the State/Country/Jurisdiction Codes of the COD Technical Reference. Uppercase A-Z
Booked Loan Info
Type	Cash Summary Type Y1 = Year-To-Date Cash Summary Total T1 = Monthly Cash Summary Total
DL End Date	End Date - The date representing the end of the current statement period. This account statement represents activity up to and through this date only. Format is CCYYMMDD. 19000101-20991231
Beg Cash Bal	Beginning Cash Balance - This is COD’s beginning balance for this report. For Cash Summary Type = “Y1,” this field is zero filled. For Cash Summary Type = “T1,” this field represents last month’s ending balance. It is all booked activity up to and through the prior month’s end date. -9999999999 to 09999999999 Zeros for Cash Summary Type = Y1
Cash Receipts	Cash Receipts - Total receipts of cash (draw downs) for the period. For Cash Summary Type = “Y1,” this is the sum of all cash receipt (draw downs) transactions for the program year-to-date and corrections to draw downs processed during the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all cash receipts (draw downs) transactions for the current month and corrections to draw downs processed during current month. -9999999999 to 09999999999 If no activity, zero filled
Excess Cash	Excess Cash - Total excess cash returned for the period. For Cash Summary Type = “Y1,” this is the sum of all excess cash transactions received by COD for the program year-to-date and corrections to excess cash processed during the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all excess cash transactions received by COD for the current month and corrections to excess cash processed during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Tot NetCsh Rcpt	Total Net Cash Receipts - The difference between the total Cash Receipts (draw downs) and total Excess Cash returned. For Cash Summary Type = “Y1,” this is the sum of all cash, -9999999999 to 09999999999. If no activity, zero filled receipts (draw downs) minus all excess cash returned to COD for the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all cash receipts (draw downs) minus all excess cash returned to COD for the current month.
Net Book Disb	Net Booked Disbursements - The total net amount of all actual disbursements booked at COD. For Cash Summary Type = “Y1,” this is the sum of all actual disbursements that were booked at COD during the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all actual disbursements that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Net Book Adj	Net Booked Adjustments - The total net amount of all disbursement adjustments booked at COD. For Cash Summary Type = “Y1,” this is the sum of all actual disbursement adjustments that were booked at COD during the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all actual disbursement adjustments that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled. (-) indicates a downward adjustment. (+) indicates an upward adjustment.
Tot Book Ln Dtl	Total Booked Loan Detail - The total of Net Booked Disbursements and Net Booked Adjustments. For Cash Summary type = “Y1,” this is the sum of all net disbursements and adjustments that were booked at COD during the program year-to-date. For Cash Summary Type = “T1,” this is the sum of all net disbursements and adjustments that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
End Cash Bal	Ending Cash Balance - This is COD’s ending balance for this report. For Cash Summary Type = “Y1” and “T1,” this is the ending cash balance at COD. -9999999999 to 09999999999
Unbooked Loan Info
Note. The values on this tab are reported the same way for both “Y1” and “T1” cash summary types.
Net Unbook Act	Net Unbooked Disbursements Actual - The total net amount of all the actual disbursements not booked at COD. This is the sum of all unbooked actual net disbursements at COD as of the program year-to-date. -9999999999 to 09999999999 If no activity, zero filled.
Net Unbk Adj	Net Unbooked Adjustments - The total net amount of all the actual disbursement adjustments not booked at COD. This is the sum of all unbooked actual net disbursement adjustments at COD as of the program Year- To-Date .-9999999999 to 09999999999 If no activity, zero filled. (-) indicates a downward adjustment. (+) indicates an upward adjustment.
Tot Unbk Ln Dtl	Total Unbooked Loan Detail - The difference between the Net Unbooked Disbursement Actuals and the Net Unbooked Adjustments. This is the sum of all unbooked actual disbursement activities at COD as of the program year-to-date. -9999999999 to 09999999999 If no activity, zero filled.
Adjusted Ending Cash Balance	Adjusted Ending Cash Balance - The difference between the Ending Cash Balance and the Total Unbooked Loan Detail. This is the total year-to-date unbooked amount applied to the ending balance. -9999999999 to 09999999999 If no activity, zero filled.

Viewing Disbursement Summary Information

Access the Disbursement Summary page.

Field	DLSAS Field
Booked Loan Info
Disb Sum Type	Disbursement Summary Type: YS = Year-To-Date Disbursement Total for Subsidized Loans. YU = Year-To-Date Disbursement Total for Unsubsidized Loans. YP = Year-To-Date Disbursement Total for PLUS Loans. YT = Year-To-Date Disbursement Total for Subsidized/Unsubsidized/PLUS Loans. MS = Monthly Disbursement Total for Subsidized Loans. MU = Monthly Disbursement Total for Unsubsidized Loans. MP = Monthly Disbursement Total for PLUS Loans. MT = Monthly Disbursement Total for Subsidized/Unsubsidized/PLUS Loans.
DL End Date	End Date - The date representing the end of the current statement period. This account statement represents activity up to and through this date only. Format is CCYYMMDD. 19000101-20991231
Booked Gross	Booked Gross For Disbursement Summary Types “YS,” “YU,” “YP,” and “YT,” this is the sum of the gross amount of all actual disbursements that were booked at COD during the program year-to-date. For Disbursement Summary Types “MS,” “MU,” “MP,” and “MT,” this is the sum of the gross amount of all actual disbursements that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Booked Fee	Booked Fee For Disbursement Summary Types “YS,” “YU,” “YP,” and “YT,” this is the sum of the loan fee amount of all actual disbursements that were booked at COD during the program year-to-date. For Disbursement Summary Types “MS,” “MU,” “MP,” and “MT,” this is the sum of the loan fee amount of all actual disbursements that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Booked Rebate	Booked Interest Rebate For Disbursement Summary Types “YS,” “YU,” “YP,” and “YT,” this is the sum of the interest rebate amount of all actual disbursements that were booked at COD during the program year-to-date. For Disbursement Summary Types “MS,” “MU,” “MP” and MT,” this is the sum of the interest rebate amount of all actual disbursements that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Booked Net	Booked Net For Disbursement Summary Types “YS,” “YU,” “YP,” and “YT,” this is the sum of the net amount of all actual disbursements that were booked at COD during the program year-to-date. For Disbursement Summary Types “MS,” “MU,” “MP,” and “MT,” this is the sum of the net amount of all actual disbursements that were booked at COD during the current month. -9999999999 to 09999999999 If no activity, zero filled.
Unbooked Loan Info
Note. The values on this tab are reported the same way for all disbursement summary types.
Disb Sum Type	Disbursement Summary Type: YS = Year-To-Date Disbursement Total for Subsidized Loans. YU = Year-To-Date Disbursement Total for Unsubsidized Loans. YP = Year-To-Date Disbursement Total for PLUS Loans. YT = Year-To-Date Disbursement Total for Subsidized/Unsubsidized/PLUS Loans. MS = Monthly Disbursement Total for Subsidized Loans. MU = Monthly Disbursement Total for Unsubsidized Loans. MP = Monthly Disbursement Total for PLUS Loans. MT = Monthly Disbursement Total for Subsidized/Unsubsidized/PLUS Loans.
Unbooked Gross	Unbooked Gross. This is the total gross amount of disbursements at COD that are unbooked for the program year-to-date at the end of current reporting period. -9999999999 to 09999999999 If no activity, zero filled.
Unbooked Fee	Unbooked Fee. This is the total fee amount of disbursements at COD that are unbooked for the program year-to-date at the end of the current reporting period. -9999999999 to 09999999999 If no activity, zero filled.
Unbooked Rebate	Unbooked Rebate Amount. This is the total interest rebate amount of disbursements at COD that are unbooked for the program year-to-date at the end of the current reporting period. -9999999999 to 09999999999 If no activity, zero filled.
Unbooked Net	Unbooked Net. This is the total net amount of disbursements at COD that are unbooked for the program year-to-date at the end of the current reporting period. -9999999999 to 09999999999 If no activity, zero filled.

Viewing Cash Detail Information

Access the Cash Detail page.

Field	DLSAS Field
Transaction Type	Transaction Type—Cash Type of Cash Transaction: R = Cash Receipts. X = Returns of Excess Cash.
DL End Date	End Date - The date representing the end of the current statement period. This account statement represents activity up to and through this date only. Format is CCYYMMDD. 19000101-20991231
Transaction Date	Transaction Date - The date that Excess Cash is applied, or date that Draw down activity occurred. Format is CCYYMMDD. 20020622-20050927
Check Number	Check Number (if available at COD). Check Number on a check for return of excess cash returned by the school. Numeric > = 0 Can be blank.
Transaction Amt	Transaction Amount - COD amount of the cash receipt or return of excess cash transaction. -9999999999 to 09999999999 Cannot be blank; can be zero filled.
GAPS Cntl Nbr	GAPS Control Number - Code received from GAPS for cash receipts only. Numeric > 0 Can be blank.

Viewing Loan Level Detail Information

Access the Loan Level Detail page.

Field	DLSAS Field
Loan Actual Info
DL Loan ID	Loan Identifier - Unique identifier created at the time of origination. Consists of: Student’s Social Security Number: 001010001-999999998 Loan Type: S = Subsidized U = Unsubsidized P = PLUS Program Year: 04 School Code: X00000-X99999, where X = G or E Loan Sequence Number: 001-999
DL End Date	End Date - The date representing the end of the current statement period. This account statement represents activity up to and through this date only. Format is CCYYMMDD.19000101-2099
Booked Date	Loan Booked Date at COD. Date the loan booked at COD. Format is CCYYMMDD. 19000101-20991231
DL Actual Svcr Gross	Actual Gross Amount—COD The sum of COD calculated actual gross amounts (in dollars) for the loan. Numeric > = 0
DL Actual Svcr Fee	Actual Loan Fee Amount—COD The sum of COD calculated actual loan fee amounts (in dollars) for the loan. Numeric > = 0
DL Actual Svcr Rebate	Actual Interest Rebate Amount—COD The sum of COD calculated actual interest rebate amounts (in dollars) for the loan. Numeric > = 0
DL Actual Svcr Net	Actual Net Amount—COD The sum of COD calculated actual net amount (in dollars) for the loan. Numeric > = 0
Demo Information
DL Loan ID	Loan Identifier - Unique Identifier created at the time of origination. Consists of: Student’s Social Security Number: 001010001-999999998 Loan Type: S = Subsidized U = Unsubsidized P = PLUS Program Year: 04 School Code: X00000-X99999, where X = G or E Loan Sequence Number: 001-999
Borrower's First Name	Borrower’s First Name - The borrower’s first name. Left justified with an A-Z in the first position. Allowable characters: 0-9 Uppercase A-Z . (Period) ’ (Apostrophe) (Dash
Borrower's Last Name	Borrower's Last Name — The borrower's last name. Allowable characters: 0-9 Uppercase A-Z . (Period) ’ (Apostrophe) (Dash
Borrower's Middle Initial	Borrower’s Middle Initial - The borrower’s middle initial. Can be blank. Uppercase A-Z are the only allowable characters.
Student's First Name	Students’ First Name - The student’s first name (PLUS Only), left justified with an A-Z in the first position. Can be blank. Allowable characters: 0-9 Uppercase A-Z . (Period) ’ (Apostrophe) (Dash
Student's Last Name	Student's Last Name — The student's last name (PLUS only). Can be blank. Allowable characters: 0-9 Uppercase A-Z . (Period) ’ (Apostrophe) (Dash
Student's Middle Initial	Student’s Middle Initial - The student’s middle initial. Can be blank. Uppercase A-Z are the only allowable characters.

Viewing Disbursement Activity Information

Access the Disbursement Activity page.

Field	DLSAS Field
Disbursement Information
DL Loan ID	Loan Identifier - Unique identifier created at the time of origination. Consists of: Student’s Social Security Number: 001010001-999999998 Loan Type: S = Subsidized U = Unsubsidized P = PLUS Program Year: 04 School Code: X00000-X99999, where X = G or E Loan Sequence Number: 001-999
Disb Number	Disbursement Number - The disbursement number for the current disbursement transaction. 01-04 for PLUS. 01-20 for Subsidized/Unsubsidized.
Disb Seq Nbr	Disbursement Sequence Number - The sequence number that determines the order in which the disbursement activity is processed. 01-99
Trans Type Disb	Transaction Type— Disbursement. Disbursement Activity recorded at COD: A = Adjusted Disbursement Amount. D = Disbursement Disbursement Activity = Q is not indicated on the SAS.
Transaction Dt	Transaction Date - Date disbursement activity occurred at the school. Format is CCYYMMDD. 20020622-20050927
Amount Information
DL Loan ID	Loan Identifier - Unique identifier created at the time of origination. Consists of: Student’s Social Security Number: 001010001-999999998 Loan Type: S = Subsidized U = Unsubsidized P = PLUS Program Year: 04 School Code: X00000-X99999, where X = G or E Loan Sequence Number: 001-999
Loan Book Dt	Loan Booked Date at COD. Date the loan booked at COD. Format is CCYYMMDD. 19000101-20991231
Disb Book Date	Disbursement Booked Date at COD. Date the individual disbursement activity booked at COD. Format is CCYYMMDD. 19000101-20991231
Actual Gross	Disbursement Actual Gross Amount—COD. COD calculated actual gross amount (in dollars) of the disbursement. Numeric > =0
Actual Fee	Disbursement Actual Loan Fee Amount—COD. COD calculated actual loan fee amount (in dollars). Numeric > =0
Actual Rebate	Disbursement Actual Interest Rebate Amount—COD. COD calculated actual interest rebate amount (in dollars). Numeric > =0
Actual Net	Disbursement Actual Net Amount— COD. COD calculated actual net amount (in dollars) of the disbursement. Numeric > =0
Actual Net Adj	Disbursement Actual Net Adjustment—COD. COD calculated actual net adjustment amount (in dollars) of the disbursement. Can be blank. -99999 to 099999
Total Information	Loan Identifier - Unique identifier created at the time of origination. Consists of: Student’s Social Security Number: 001010001-999999998 Loan Type: S = Subsidized U = Unsubsidized P = PLUS Program Year: 04 School Code: X00000-X99999, where X = G or E Loan Sequence Number: 001-999
Total Gross	Total Gross Amount—COD. The sum of COD calculated actual gross amounts (in dollars) for the loan. Numeric > = 0
Total Fee	Total Loan Fee Amount—COD. The sum of COD calculated actual loan fee amounts (in dollars) for the loan. Numeric > = 0
Total Rebate	Total Interest Rebate Amount—COD. The sum of COD calculated actual interest rebate amounts (in dollars) for the loan. Numeric > =
Total Net	Total Net Amount—COD. The sum of COD calculated actual net amount (in dollars) for the loan. Numeric > = 0

Viewing Trailer Information

Access the Batch Trailer page.

Field	DLSAS Field
DL Trailer ID	Trailer Record Identifier - Code to identify record as a trailer record. Must be “DL TRAILER” – uppercase.
Record Length	Data Record Length - Indicates length of the data record. 0000-9999
Number of Records	Number of Records - The number of data records included in the file. Numeric > = 0
Accepted Records	Total number of accepted records. Blank for all files sent to COD. Zero filled for all files sent to schools except: The Full Loan Origination Acknowledgement (DISF or DIPF) Loan Origination Change Acknowledgement (DIOC) MPN Promissory Note Acknowledgement (DIPA) Disbursement Acknowledgement (DIOD—Batch Type #H Only) Numeric > = 0
Rejected Records	Total number of rejected records. Blank for all files sent to COD. Zero filled for all files sent to schools except: The Full Loan Origination Acknowledgement (DISF or DIPF) Loan Origination Change Acknowledgement (DIOC) MPN Promissory Note Acknowledgement (DIPA) Disbursement Acknowledgement (DIOD—Batch Type #H Only) Numeric > = 0
Pending Records	Total number of pending records. Blank for all files sent to COD. Zero filled for all files sent to schools except MPN Note Acknowledgement (DIPA). Numeric > = 0
Loan Trailer Nbr	Defaults to 1.

Working with the DL School Account Statement and the Reconciliation Loan Destination Reports

This section discusses how to:

• Generate the DL School Account Statement report.

• Generate the DL Reconciliation report.

Pages Used to Generate DL School Account Statement and Reconciliation Loan Destination Reports

Generating the DL School Account Statement Report

Access the DL School Account Statement page.

You can now use this report to print both file types, DSDFXXOP DL-SAS Import School Account Statement (Fixed-Length, Disbursement Level Loan Detail) and DSLFXXOP DL-SAS Import School Account Statement (Fixed-Length, Loan Level Loan Detail). XX is a placeholder for the aid year.

Click the Run button to run the DL School Account Statement (FADLSAS).

Important! To maintain a historical archive of the DL School Account Statement Report, Peoplesoft strongly recommends that you rename the files generated by the report. If you do not change the file names, the system will write over the existing files when you run subsequent reports.

Note. The School Account Statement (SAS) report options are year-specific, so schools must update their report options and preferences with the COD separately for each year to change the defaults. Schools should also ensure that they are in the correct program year in the SAS Report Options screen before updating their options.

See Also

Common Origination and Disbursement (COD) Technical Reference COD Reports, School Account Statement section

Generating the DL Reconciliation Report

Access the DL Reconciliation Report page.

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

This report replaces the DL Reconciliation Detail report for processing year 2003-2004 onward and it expands on comparison functionality.

There are three main sections in the report:

• Cash summary information

• Cash detail

• Loan detail

Cash Summary Information

This section of the report contains:

• Year-to-date cash summary.

• Monthly 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 also 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 also 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 also 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 also 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:

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:

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:

Running Direct Lending Reports

Most Direct Lending reports are run from a generic run control page, but some reports have their own run control pages. The run control pages for a few other reports appear within the business process discussion earlier in this chapter.

This section discusses how to:

• Use the generic run control page for Direct Lending reports.

• Generate the Direct Lending Loan Booking Status Report.

• Use the demographic data selection for loan origination.

Pages Used to Run Direct Lending Reports

Using the Generic Run Control Page for Direct Lending Reports

Access the Financial Aid Reports page.

Select the Academic Institution and Aid Year for which you want to run the report.

Generating the Direct Lending Loan Booking Status Report

Access the DL Booking Status Report page.

Select the Academic Institution and Aid Year for which you want to run this report. For the Direct Lending Booked Status you can select Booked or Unbooked loans.

Click the Run button to run the report.

Using Demographic Data Selection for Loan Origination

The loan processes utilize three database views to access demographic data. The demographic data used by loans falls into three categories address, phone number, and name. The views used to access this data are:

• LN_MAIL_ADDR_VW

• LN_PERM_ADDR_VW

• LN_PHONE_VW

• LN_NAME_VW