# Presentation: 519502

##  Financial Partners - 2005 

***Partner Information, Reports, and Tables***

***Training Guide/Manual***
**	*****            ***
***Volume VI                                                January 2006***
***    ******Part 2***
*** ******U.S. Department of Education – Federal Student Aid***
**(VISIT OUR WEBPAGE @ www.ed.gov/offices/OSFAP/PEPS)****        **
***    ***

***(*****The information in this guide is either fictitious or has been blocked for privacy purposes.)**

**Notes:**
Please point out the the information in this guide was fabricated for training only.

## Table of Contents Volume VI, Part 2Financial Partners Module

**	****	****	****	****	****	****Page**
**ENTITY MAINTENANCE**	**Servicer Query****	****	****  90**
**	****	****	****	****Servicer Detail****	****	****  95**
**	****	****	****	****Lender Query****	****	****  97**
**	****	****	****	****Lender Detail****	****	****107**
**	****	****	****	****Lender Portfolio Query****	****	****108****	****	****	****	****Lender Portfolio Detail****	****	****112**
**	****	****	****	****Guarantor Query****	****	****113**
**	****	****	****	****Guarantor Detail****	****	****117**
**	****	****        ****REPORTS****	****List of Reports Available****	****118**
**	****	****          ****TABLES****	****Lender Association Code****	****146**
**	****	****	****	****Scope Code****	****	****	****148**
**	****	****	****	****ARL Type****	****	****	****150**
**	****	****	****	****Review Type****	****	****152**
**	****	****	****	****Payment Method****	****	****154**
**	****	****	****	****Default Letter Type****	****	****156**
**	****	****     ****Appendix A ****	****Lender Deficiency Codes    ****	****158**
**	****	****     ****Appendix B****	****School Deficiency Codes****	****160**
**	****	****     ****Appendix C****	****Description of Reports****	****	****162**
**	****	****     ****Appendix D****	****Field Definitions and Points****	****165**

## Servicer Query:  To query data on servicer’s names, addresses and ID choose More/Financial Partners/Entity Maint/Servicer Query.

**ENTITY MAINTENANCE**

## This screen automatically loads with all servicers in PEPS.  Scroll to the right to view additional information.  From this screen you can click on shortcut buttons to view basic demographical information on a servicer, and the lenders or guarantors they service for.

**Notes:**
Again, the guarantor information has not been populated from the LaRS data.

## Servicer Query - Second Screen.

## Servicer Query - Third Screen.  Scroll back to the left and select the “Detail” button of the first record.

## This is the servicer detail record. There is a “Servicer Dtl Rpt” button that can be selected to preview or print numerous information that is contained in PEPS on the servicer. This report is also available in the Reports screen (PEPSR342). This is a lender servicer, therefore, you can view the lenders’ it services.  Select the “Lenders” button.

- This is the servicer detail record. There is a **“Servicer Dtl Rpt”** button that can be selected to preview or print numerous information that is contained in PEPS on the servicer. This report is also available in the Reports screen (PEPSR342). This is a lender servicer, therefore, you can view the lenders’ it services.  Select the **“Lenders”** button.

**Note:  **This table is maintained in the headquarters office.  If you notice a change that should be made to these records, please provide a note at the following address: Elbert.Murphy@ed.gov.  There is an alternative way to access this screen by choosing _**M**_**ore/**_**F**_**inancial Partners/**_**E**_**ntity Maint/**_**S**_**ervicer Detail**.

## This information was populated based on the lenders reported in the servicer’s audit for the 2002 audit year.   Select the “Red Door” twice to exit to the main menu.

- This information was populated based on the lenders reported in the servicer’s audit for the 2002 audit year.   Select the **“Red Door”** twice to exit to the main menu.

## Servicer Detail:  See page 94.

## Lender Query:  To get a list of lender names, addresses, IDs, and associated lenders choose More/Financial Partners/Entity Maint/Lender Query.

## Enter a criteria to view a list of lenders.  In this example we will be requesting all lenders whose name starts with “Chase”.  Enter “Chase %” in the “Name” field and select the “Magnifying Glass” button.

- Enter a criteria to view a list of lenders.  In this example we will be requesting all lenders whose name starts with “Chase”.  Enter “**Chase %”** in the “**Name**” field and select the “**Magnifying Glass**” button.

## The query produced numerous records.  Scroll to the right for additional information. From this screen, you can click on shortcut buttons to view basic demographical information on a lender, the portfolio rollup on all associated lenders and the servicers and guarantors they do business with.

## Lender Query Results - Second Screen.  

## Lender Query Results - Third Screen.  

- Lender Query Results - Third Screen.

## Lender Query Results - Fourth Screen.  Scroll back to the left and select the “Detail” button of the first record.

- Lender Query Results - Fourth Screen.  Scroll back to the left and select the “**Detail**” button of the first record.

## This is the lender detail record.  There is a Lender Detail Report button that can be selected to preview or print numerous information that is contained in PEPS on the lender.  This report is also available in the Reports screen (PEPSR340).  Select the “Servicers” icon to view the servicers they do business with.

- This is the lender detail record.  There is a **Lender Detail Report** button that can be selected to preview or print numerous information that is contained in PEPS on the lender.  This report is also available in the Reports screen (PEPSR340).  Select the **“Servicers**” icon to view the servicers they do business with.

**Note:  **This table is loaded using the data from the LaRS system.  There is an alternative way to access this screen by choosing _**M**_**ore/**_**F**_**inancial Partners/**_**E**_**ntity Maint/**_**L**_**ender Detail.**

## This is a list of related servicers. This information was populated based on the lenders reported in the servicer’s audit for the 2002 audit year. Select the “Red Door” twice to go back to the query screen.  

- This is a list of related servicers. This information was populated based on the lenders reported in the servicer’s audit for the 2002 audit year. Select the **“Red Door”** twice to go back to the query screen.

**Notes:**
The related guarantor information has not been populated.  This information will be loaded from the LAP in the near future and can be viewed by selecting the “Guarantors” button either on the Query or the Detail screens.

Have them select the Assoc Rollup button.

## Select the “Assoc rollup” button.

- Select the **“Assoc rollup”** button.

## A record is displayed for the most current calendar year and provides summed portfolio data for a group of lenders that are associated.  Other years can be displayed by using the scroll bar. Select the “Red Door” icon twice to exit to the main menu.

- A record is displayed for the most current calendar year and provides summed portfolio data for a group of lenders that are associated.  Other years can be displayed by using the scroll bar. Select the “**Red Door**” icon twice to exit to the main menu.

**Notes:**
Have them scroll down to the other years on this screen before they exit.

## Lender Detail:  See page 103.

## Lender Portfolio Query:  To query information such as origination or outstanding amounts on lenders choose More/Financial Partners/Entity Queries/Lender Portfolio Query.

## The lender portfolio query will provide portfolio data from FY 1995 through current.    In this example, click in the “OPE ID” field and enter 81079800.  Select the “Magnifying Glass”

- The lender portfolio query will provide portfolio data from FY 1995 through current.    In this example, click in the “**OPE ID**” field and enter **81079800**.  Select the “**Magnifying Glass**”

## The following information resulted from the query criteria specified.  These screens provide origination & outstanding dollars that the lender has reported on their ED form 799, Part V on the old form and Part IV on the new form. Scroll to the right to see the additional data.  Scroll back and select the “Dtl” to view the portfolio data for the selected year.

- The following information resulted from the query criteria specified.  These screens provide origination & outstanding dollars that the lender has reported on their ED form 799, Part V on the old form and Part IV on the new form. Scroll to the right to see the additional data.  Scroll back and select the **“Dtl”** to view the portfolio data for the selected year.

**Note:**  If no records were found and the OPE ID is a valid number, it means the lender has not filed a ED Form 799 since the first quarter of 1995.

**Notes:**
Mention that the lender now have the capability to submit multiple ED Form 799s, however, PEPS adds up all multiple 799s into one number for each quarter.

## This is the lender portfolio detail record.  It is the same information displayed on the query spreadsheet.  The Association rollup can be viewed on this screen and the spreadsheet for the year selected.  Regular & complex queries can be performed on this screen as well. Select the “Red Door” icon twice to return to the main PEPS screen.

- This is the lender portfolio detail record.  It is the same information displayed on the query spreadsheet.  The Association rollup can be viewed on this screen and the spreadsheet for the year selected.  Regular & complex queries can be performed on this screen as well. Select the “**Red Door**” icon twice to return to the main PEPS screen.

**Notes:**
Many screens have shortcut buttons to other areas of interest.  In this case, there is a shortcut button to the Assoc rollup that was discussed on page 101.  This shortcut button is also provided in the portfolio query screen that was previously displayed.

## Lender Portfolio Detail:  See page 111.

## Guarantor Query:  To query data on guarantor’s names and ID  choose More/Financial Partners/Entity Maint/Guarantor Query.

## This screen automatically loads the guarantor data.  Scroll to the right to view additional information. From this screen, you can click on shortcut buttons to view basic demographical information on a guarantor, contacts with the guarantor, and the servicers and lenders they do business with.  Select the “Detail” button.

- This screen automatically loads the guarantor data.  Scroll to the right to view additional information. From this screen, you can click on shortcut buttons to view basic demographical information on a guarantor, contacts with the guarantor, and the servicers and lenders they do business with.  Select the **“Detail”** button.

**Notes:**
The guarantor relationship data with servicers and lenders have not been populated, therefore, we will not review those items.

## This is the guarantor detail record.  Select the “Additional Contact” icon.

**Note**:  This table is maintained by the regional office.  If you notice a change that should be made to these records, please notify your cognizant regional office.  There is an alternative way to access this screen by choosing _**M**_**ore/**_**F**_**inancial Partners/**_**E**_**ntity Maint/**_**G**_**uarantor Detail**.

**Notes:**
Again, the Servicer and Lender relationship data has no information, therefore, we will not review those items.

## This screen can hold many contacts within the guarantor.  Select the “Red Door” three times to exit to the main menu.

- This screen can hold many contacts within the guarantor.  Select the **“Red Door” **three times to exit to the main menu.

**Notes:**
You can go directly to the contact screen from the guarantor query screen also.

## Guarantor Detail:  See page 115.

## Numerous reports are available to preview on the screen or print directly to the local printer by choosing More/Financial  Partners/Reports.

**REPORTS**

## Currently there are 29 canned reports available that provide information on program reviews, audits, default rates and the participants.  

## The next few screens are the additional reports that are available in this section.  For a brief description of all reports, see Appendix C.

## There are three remaining reports after scrolling to the bottom of this screen.  For a brief description of all reports, see Appendix C.

## The first report is “Review Activity.”  It lists review activity and dates associated to reviews for a specified period.  The report can be viewed or printed directly to a local printer from this screen.  This is the monthly report that was once sent to every guarantor.  For this exercise select the “Preview” button on the first report to go to a parameters screen.

- The first report is “**Review Activity.**”  It lists review activity and dates associated to reviews for a specified period.  The report can be viewed or printed directly to a local printer from this screen.  This is the monthly report that was once sent to every guarantor.  For this exercise select the “**Preview**” button on the first report to go to a parameters screen.

**Notes:**
If time is running out, you may want to only go over the first report and how to complete the parameter screen and view the report.  Then you can skip over some or all of the rest of the reports and go to the “Tables” section which will only take a few minutes to explain.

## The parameter screen is used to make the selection criteria for a report.  In this example we will view lender reviews conducted by the ED Region 2 for the period of 10/01/2001 thru 09/30/2002.  Complete the parameter screen as shown below and select the “ Green Light”.  There are three types of reports that can be selected in this parameter screen.

- The parameter screen is used to make the selection criteria for a report.  In this example we will view lender reviews conducted by the ED Region 2 for the period of 10/01/2001 thru 09/30/2002.  Complete the parameter screen as shown below and select the “ **Green Light**”.  There are three types of reports that can be selected in this parameter screen.

**NOTE**: After selecting the “**Green Light**” it takes a few moments for the report to appear on the screen.  Please be patient.  Pushing numerous buttons could cause the system to lock up and your User ID will need to be reset.

**Notes:**
Step them through completing this screen.  Click on each drop down arrow so that they know their options of selection.

## The reviews that were conducted during the period specified in the parameters are listed in this report.  It also provides other dates related to the review, the review type, and deficiency data.  Scroll to the right to view additional information. 

- The reviews that were conducted during the period specified in the parameters are listed in this report.  It also provides other dates related to the review, the review type, and deficiency data.  Scroll to the right to view additional information.

**Notes:**
In order for them to see the scroll bar at the bottom they may need to maximize the report window.

The IDs and Names have been blocked for privacy.

## Additional pages of the report can be viewed using the “arrow”  buttons.  It can be printed to the local printer or generated to a file so that it can be sent electronically.  To return to the reports screen, select the “Red X” button.   All open report windows need to be closed, as well.

- Additional pages of the report can be viewed using the **“arrow” ** buttons.  It can be printed to the local printer or generated to a file so that it can be sent electronically.  To return to the reports screen, select the **“Red X” **button.   All open report windows need to be closed, as well.

**Notes:**
Since the printer will not be hooked up, the print feature will not be reviewed.  

## The second report is “Collected Liabilities-Detail Report.”  This report provides information on the amount of money collected on reviews during a specified period of time.  Select the “Preview” button.

## This parameter screen will retrieve results to view dollars collected on lender reviews by Region 2 during 10/01/2001 thru 0930/2002.  Complete the parameter screen as shown below and select the “ Green Light”.  

- This parameter screen will retrieve results to view dollars collected on lender reviews by Region 2 during 10/01/2001 thru 0930/2002.  Complete the parameter screen as shown below and select the “ **Green Light**”.

## The dollars collected by Region 2 during the period specified in the parameters are listed in this report.  It also provides information on the review and type of deficiency.  Scroll to the right to view additional information.

- The dollars collected by Region 2 during the period specified in the parameters are listed in this report.  It also provides information on the review and type of deficiency.  Scroll to the right to view additional information.

**Notes:**
In order for them to see the scroll bar at the bottom they may need to maximize the report window.

## Additional pages of the report can be viewed using the “arrow”  buttons.  To return to the reports screen, select the “Red X” button.   

## The third report is “Open Reviews w/o Rpt/Issues.”  This report provides information on reviews that have been conducted and the reports have not been sent out.  Select the “Preview” button.

- The third report is **“Open Reviews w/o Rpt/Issues.”  **This report provides information on reviews that have been conducted and the reports have not been sent out.  Select the “**Preview**” button.

**Notes:**
The next two reports are used in the Department to track the activity of the review to assure the reports are sent out and the review is closed.

## Enter the following criteria to get a report where a review was conducted and it has been more than 3 months and the report has not been issued.  Enter a date in the “To DT” field that is 3 months less than today.  After entering the criteria listed on this screen, select the “Green Light” button.

- Enter the following criteria to get a report where a review was conducted and it has been more than 3 months and the report has not been issued.  Enter a date in the “**To DT**” field that is 3 months less than today.  After entering the criteria listed on this screen, select the **“Green Light”** button.

## The following report provides information where a review was conducted and as of the 3-month date the report has not been issued, as well, as other important information related to the review.  Scroll to the right to see additional information.

- The following report provides information where a review was conducted and as of the 3-month date the report has not been issued, as well, as other important information related to the review.  Scroll to the right to see additional information.

## Open Reviews w/o Rpt/Issues Report - right side.  Select the “Red X” button to return to the reports screen.

- Open Reviews w/o Rpt/Issues Report - right side.  Select the “**Red X**” button to return to the reports screen.

## The fourth report is “Reports Issued and not closed.”  This report provides information on reviews where the report has been sent, however, the review has not been closed.  Select the “Preview”  button.

## Enter the following criteria to get a list of reviews where the reports were issued and it has been more than 6 months and the review remains open.  Enter a date in the “To DT” field that is 6 months less than today.  After entering the criteria on this screen, select the “Green Light” button.

- Enter the following criteria to get a list of reviews where the reports were issued and it has been more than 6 months and the review remains open.  Enter a date in the “**To DT**” field that is 6 months less than today.  After entering the criteria on this screen, select the “**Green Light**” button.

## The following report provides information on the entity, dates and deficiencies associated with the review.  Scroll to the right to see additional information.

- The following report provides information on the entity, dates and deficiencies associated with the review.  Scroll to the right to see additional information.

## Reports Issued & not closed Report - right side.  Select the “Red X” button to return to the reports screen.

- Reports Issued & not closed Report - right side.  Select the “**Red X**” button to return to the reports screen.

## The fifth report is “Summary Activities - Liabilities.”  This report provides a monthly summary of liability, penalty, or repayment activity during that month selected.  Select the “Preview” button.

## Enter the following criteria to view a report of monetary activity for the month of March 2003 on lender reviews that were conducted by the Department.  Select the “Green Light”  button.

- Enter the following criteria to view a report of monetary activity for the month of March 2003 on lender reviews that were conducted by the Department.  Select the “**Green Light**”  button.

**Notes:**
This report may take some time to execute.  If so, now would be a good time for a break.

## This report shows that the Department collected liabilities in the month of March 2003.  Scroll to the right for additional information.

- This report shows that the Department collected liabilities in the month of March 2003.  Scroll to the right for additional information.

## Summary Activity - Liabilities Report - right side.  Select the “Red X” button to return to the standard report screen.

- Summary Activity - Liabilities Report - right side.  Select the “**Red X**” button to return to the standard report screen.

## The fifth report is “Comparison of Reviews.”  This report provides summary review information for each fiscal year.  Select “Preview” to go to the parameter screen.

- The fifth report is **“Comparison of Reviews.”  **This report provides summary review information for each fiscal year.  Select “**Preview**” to go to the parameter screen.

## Enter the following criteria to view a list of lender reviews that were conducted by the Dept. of Education from 10/2000 thru 09/2002.  Select the “Green Light” button to view this report. 

- Enter the following criteria to view a list of lender reviews that were conducted by the Dept. of Education from 10/2000 thru 09/2002.  Select the “**Green Light**” button to view this report.

## The counts in each fiscal year are based on dates that are entered in the review detail.  For example, a review that was conducted in FY 2000 and the report was issued and closed in FY 2001 will get counted once in 2000 “Reviews Conducted,” once in 2001 “Reports Issued” and once in 2001 “Reports Closed.”  The paid amounts are based on the date they are received.  Scroll to the right to view  additional information.

## Comparison of Reviews Report - right side.  Select the “Red X” button to return to the standard report screen and then the “Red Door” button to return to the main menu. 

- Comparison of Reviews Report - right side.  Select the “**Red X**” button to return to the standard report screen and then the “**Red Door”** button to return to the main menu.

## Lender Association Code:  There are numerous tables that populate the LOVs for certain fields.  The first one is the Lender Assoc Code.  To view this table choose More/Financial Partners/Tables/Lender Assoc Code.

**TABLES**

**Note**: These tables are maintained by Financial Partners.  If you notice a change that should be made to these records, please provide a note and send to Nettie.Harding@ed.gov

**Notes:**
You may recognize several of these lists.  They are used to provide a list of values on many of the fields within the records.  We will quickly review them.  

## Many lenders have merged or consolidated with other lenders.  This table was created to update and track the changes.  Select the “Magnifying glass” to populate this screen.  The lenders in this table are the “parent” assigned to a group of lenders and their LID’s.  A list of lenders associated with each parent LID can be obtained in the Lender Query screen.  Select the “Red Door” icon to exit.

- Many lenders have merged or consolidated with other lenders.  This table was created to update and track the changes.  Select the **“Magnifying glass”** to populate this screen.  The lenders in this table are the “parent” assigned to a group of lenders and their LID’s.  A list of lenders associated with each parent LID can be obtained in the **Lender Query** screen.  Select the “**Red Door**” icon to exit.

## Scope Code:  To view this list choose Menu/Financial Partners/Tables/Scope Code.

## This list is used as an LOV in the Scope area of the Review Detail screen.  The scroll bar signifies there are more at the bottom of the list. Select the “Red Door” icon to exit. 

## ARL Type:  To view this list choose More/Financial Partners/Tables/ARL Type.

## This list is used as an LOV in the Audit Detail screen.  Select the “Red Door” icon to exit.

## Review Type:  To view this list choose More/Financial Partners/Tables/Review Type.

## This list is used as an LOV in the Review Detail screen.  Select the “Red Door” icon to exit.

## Payment Method:  To view this list select “More/Financial Partners/Tables/ Payment Method”.

## This list is used as an LOV in the Review Deficiency Detail screen for a paid obligation.  Select the “Red Door” icon to exit.

## Default Letter Type: To view these letters choose More/Financial Partners/Tables/Default Letter Type.

## There are three different letters that are used when notifying the guarantors and lenders of their default rates.  Select each type to view the different letters.  Select the “Red Door” icon to exit.