# Presentation: 665385

##  Financial Partners - 2005 

***Entering School and Lender Reviews by Guaranty Agencies******Audit and Default Information***

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

***(*****The information in this guide is fictitious and was created for training purposes.)**

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

## 	      WHAT’S NEW		Recent Changes to the System	 3

- 	      WHAT’S NEW		Recent Changes to the System	 3
- 	              REVIEWS		Review Query			 4
- 				Review Detail			19
- 				Review Deficiency Query		28
- 				Review Deficiency Detail		35
- 		AUDITS		Audit Query			39
- 				Audit Detail			49
- 				Lender Audit Tracking Query		50
- 				Lender Audit Tracking Detail		56
- 				Lender Servicer Audit Tracking	60
- 				GA Servicer Audit Tracking		60
- 				Exceptional Performer Audit Tracking	60
- 				Audit Deficiency Query		61
- 				Audit Deficiency Detail		67
- 	              ACTIONS		Action Query			68
- 				Action Detail			72
- 	              APPEALS		Appeal Query			74
- 				Appeal Detail			78
- DEFAULT INFORMATION		GA Default Rates			80
- 				Lender Default Rates		86

## What’s New

**Servicer review records **has a new feature that allows you to record those lenders that are reviewed at the servicer more easily.  See Part 1, page 26 for further details.
**Exceptional Performer Designation quarterly audits** are being tracked and recorded in the Audit section.  That section starts on Part 1, page 39.
**Exceptional Performer Designation** is now recorded on the entity’s detail screen.  See Part 2, page 94 and 103 for further details.
**New scope codes** have been added to capture reviews done as part of the exceptional performer designation and the CRI initiative.  See Appendix D for a list of scope codes.
-  **Appendix D** has field definitions for program review records and a list of points to remember.

## Review Query:  To view data on program reviews that have been conducted on Lenders, Servicers, and Schools (only Guarantor reviews of Schools), From the main menu bar choose “More/Financial Partners/Reviews/Review Query.”

**REVIEWS**

**Notes:**
The main menu used in this manual may be a little different than what you are seeing on the screen.  That is because the main menu used in this manual reflects what is actually in Production.  Since we are training from a test environment the main menu screens are slightly different. 

Also, stress that most of the information used in this manual has been created for test purposes only.

## The PEPS Tool Bar used within the Financial Partners module is similar to the Tool Bar used throughout PEPS.  

**Notes:**
These buttons may not be usable on all screens.  For example, if you are on a screen where you can only look up records, this tool bar will not allow you to select the green plus, red X, or erase record.

## This screen is used to get a list of reviews that have been conducted.  You will be able to see all records created by all guarantors and the Department’s reviews of lenders.  We will be viewing the dummy records that have been developed for the guarantor 611.  Enter 611 in the GA  column and select the “Magnifying Glass” from your Tool Bar.

- This screen is used to get a list of reviews that have been conducted.  You will be able to see all records created by all guarantors and the Department’s reviews of lenders.  We will be viewing the dummy records that have been developed for the guarantor 611.  Enter **611** in the **GA ** column and select the **“Magnifying Glass”** from your Tool Bar.

**Note:**  It is **NOT **recommended to click on the **“Magnifying Glass” **without entering criteria to search from.  Doing so would retrieve almost 20,000 records and cause the PEPS system to slow down significantly.

**Notes:**
The “query” screens are used to look up multiple records.  It acts as a spreadsheet where key data is viewed.  You can also download the data into an excel spreadsheet from these screens.  That will be covered later in this session.

Stress the Note at the bottom of the slide.  This is very important.
Since there a minimal records that were created for “611”, no other information needs to be filled in.  However, for every guarantor and regional office there may be hundreds of records that will be populated.  Therefore, filling in more criteria is recommended to narrow the search results.

## All records matching the selection criteria will be displayed.  This first screen contains information on the year and quarter in which the review was conducted.  The organization that performed the review, the entity being reviewed and scope related to the review.  Notice that there is one review that is listed multiple times (Kingsley State Bank) because it had multiple scopes.  Using the Horizontal Scroll Bar you can read the additional text that is located to the right of the screen.

- All records matching the selection criteria will be displayed.  This first screen contains information on the year and quarter in which the review was conducted.  The organization that performed the review, the entity being reviewed and scope related to the review.  Notice that there is one review that is listed multiple times (Kingsley State Bank) because it had multiple scopes.  Using the **Horizontal Scroll Bar** you can read the additional text that is located to the right of the screen.

- Shortcut buttons to view or update (if user has access) more detailed information on a record

**Notes:**
We will go over the shortcut buttons located on this screen in a few minutes.

## The second screen of review data contains information on the entity’s ID, name, city, state and related date information.  Continue to scroll to the right.

*Upcoming reviews can be input in the system.  It is important that everyone input their scheduled reviews so that multiple organizations that plan to review the same entity can consider performing joint or CRI reviews to help eliminate redundancy.  This is important to the success of the review process.*

**Notes:**
Scheduled reviews are reviews that are certain to take place or a here-I-come letter has been sent to the lender or school. 

## The third screen provides information on dates relating to the review, the reviewer that performed the review, the level of the violations, and what type of review was performed.  Continue to scroll.

## The forth screen provides information on who updated this record, and the date it was updated.  To view the detail of the last review listed in this query, make sure the last record is highlighted and select the “Detail” shortcut button at the bottom of the screen.

- The forth screen provides information on who updated this record, and the date it was updated.  To view the detail of the last review listed in this query, make sure the last record is highlighted and select the **“Detail”** shortcut button at the bottom of the screen.

**Notes:**
You can search on any of these fields displayed on these screens.  For example, if you would like to see the last records you have or someone has entered, you can enter their user name in the “last update user” column and it will display all records they have entered.  A period of time can also be entered in the “last updt dt” column to reduce the search even more and it will retrieve records updated by a particular user during a specified period of time.  This will be covered in how to do complex queries at the end of this training session. 

## This is the detail information of the selected review from the query screen.  You can Create, Read, Update, and Delete (CRUD) information that relates to reviews conducted by your Guaranty Agency, as well as, read information on reviews conducted by other Guarantors and the Department.  

- This is the detail information of the selected review from the query screen.  You can Create, Read, Update, and Delete (CRUD) information that relates to reviews conducted by your Guaranty Agency, as well as, read information on reviews conducted by other Guarantors and the Department.

- Shortcut buttons to view:  deficiencies, the main info. of a group of lenders that are related; their total portfolio; the deficiency information related to this review; and to print a cover sheet for this record.

- Used when populating the lenders reviewed on a Servicer review.  Please refer to page 26  for more information.

**Notes:**
There is a quicker way to access this screen from the main menu and will cover that later in the session when we are ready to enter a record.

## If you notice this lender has an Assoc Cd (short for Association Code).  That means it is a part of a group of lender numbers that make up an organization.  Many lenders use multiple lender IDs.  Mergers and acquisitions among lenders are tracked in PEPS. Select the “Main” button. 

- If you notice this lender has an Assoc Cd (short for Association Code).  That means it is a part of a group of lender numbers that make up an organization.  Many lenders use multiple lender IDs.  Mergers and acquisitions among lenders are tracked in PEPS. Select the **“Main”** button.

**Notes:**
For instance, this lender is part of the SLMA group and currently has 82 other lender numbers belonging to this group.  Of which, 43 are active as of the end of Federal fiscal year 2004. 

If you go to the “Main” screen ---

## This screen shows the main name and the main location for the associated group of lenders. If the lender does not have an Assoc Cd listed, this screen will be blank.  Select the “Red Door” button to go back to the detail record and select the “Assoc Rollup” button. 

**Notes:**
It will show you the main name and main location for the group.

For example, we know that Sallie Mae is located throughout the country.  This screen will have the Association Name as Sallie Mae and the City and State is Reston, VA although the lender number on the previous screen had the name Chase as trustee for SLMA.

After you are finished, have them select the “Red Door” and select the “Assoc Rollup” button on the detail screen.

## This screen shows the portfolio for the entire group of lender numbers rolled up into quarters in the same year that the review was conducted.  A message will display if the lender has no other associated lenders or does not have portfolio for the review year. More information is in Volume VI, Part 2 under Entity Maintenance/Lender Portfolio.  Select the “Red Door” to go back to the detail record. 

**Notes:**
Notice the name for this screen is derived from the associated group name.  The amounts on this screen make up the total amount that each of the 41 active lender numbers that filed an ED Form 799 through the LaRS system.  

We will cover the portfolio information in more depth in Part 2 later today.

Return to the detail record and select the Cover Sheet button.

## Select the “Cover Sheet” from the detail record and then choose “preview” to review the cover sheet (see below) or “print” and attach to the review report. Select the “Red X” to go back to the detail record. 

**Notes:**
This cover sheet is used as the cover for the review report or whatever other uses you may have.  It is for internal use only.  Go over some of the information contained in the sheet.

Notice that to exit a report you will choose a “Red X”.  The functionality of this Red X is different than what you see on the actual record.  The function of that Red X on a record will  delete the record.  All reports that you have in a preview screen use the Red X to exit the report.  The exit button on a record is the “Red Door”.  

Go back to the  detail record and select deficiencies.

## Select the “Deficiencies” button from the detail record and it will take you to this screen. The deficiency screen provides information on assessed and paid liabilities and their status.  You can CRUD information on reviews conducted by your agency and read information on all others. To view the amount assessed you would first click in the line you want to view and select the “Assessments” button. 

- Select the **“Deficiencies” **button from the detail record and it will take you to this screen. The deficiency screen provides information on assessed and paid liabilities and their status.  You can CRUD information on reviews conducted by your agency and read information on all others. To view the amount assessed you would first click in the line you want to view and select the **“Assessments” **button.

**Note:**  There are alternate ways to access this screen by selecting **“Deficiencies”** in the **“Review Query”** screen or by choosing **“**_**M**_**ore/**_**F**_**inancial Partners/**_**R**_**eviews/**_**R**_**eview Deficiency Detail.”**

**Notes:**
The basic review information is displayed at the top of the screen and can scroll over to view more information.

Have them put their cursor in the second row to view and select the Assessment button.

## The Assessed Obligation screen shows how much liability was identified and assessed against the lender or school in the program review report.  The effective date is usually the same as the date the report was issued.  If the amount has not been determined at the time the report is issued, this screen will remain blank. Select the “OK” button to go back to the deficiency screen and then select the “Payments” button. 

- The **Assessed Obligation** screen shows how much liability was identified and assessed against the lender or school in the program review report.  The effective date is usually the same as the date the report was issued.  If the amount has not been determined at the time the report is issued, this screen will remain blank. Select the **“OK”** button to go back to the deficiency screen and then select the **“Payments”** button.

**Notes:**
Explain that the Org type is where the money is coming from and show them by clicking the drop down arrow beside “lender”.  If the org type = Education than that means the lender underbilled and we owe them money back and consider it as a repayment to the lender.  All amounts are considered positive amounts.  Also, click the drop down arrow next to “liability”.

Return back to the deficiency screen and select the payments button.

## The Paid Obligations screen provides information on the type of organization making the payment, how the payment was made, type of obligation being paid, amount and effective date of payment.  Select the “OK” button to exit and the red door icon on the next three screens to return to the main menu.

**Notes:**
Mention that we will cover the assessments and payments in more detail once we start entering record information.

Make note that the deficiency number and definition appears at the top of the window and review the org type and and other columns listed on the screen.

IMPORTANT:  The screen will not allow you to view the list of payment methods by selecting the “?” beside the method.  To show them the list of what to choose from, make a new row by pressing the “green plus” button at the top then press the “?” in the method row.  It will display the list.  Just cancel and move on.  To eliminate the row you just made press the “pencil” button next to the “red X”.  The system will not allow you to move on if you do not do this. 

Also mention that the effective date is when the payment or adjustment was made.

You can then press the “OK” to return to the deficiency screen.

Also, in the instructions on the slide it states to select the red door icon on the next three screens.  After you have hit it twice and are on the Review Query screen, point out to them that you can also access the deficiency screen directly by pressing the deficiencies button at the bottom of query screen.

## Review Detail: To create or update records it is easiest to go directly to the “Review Detail” by choosing “More/Financial Partners/Reviews/Review Detail.”

**Notes:**
Make note that this is a more direct way to access the detail screen and start entering records.

## To create a new record press the “Open Book” then enter an OPE ID and tab or press enter.  If the lender has reviews it will display a list to choose from or cancel to start a new record.  If starting a new record, click in the Review Dt field and complete as many of the items within the squares as you can.  Once finished, to enter another record simply press the “Open Book” again and follow the steps above.  

- To create a new record press the **“Open Book”** then enter an **OPE ID** and tab or press enter.  If the lender has reviews it will display a list to choose from or cancel to start a new record.  If starting a new record, click in the **Review Dt** field and complete as many of the items within the squares as you can.  Once finished, to enter another record simply press the **“Open Book” **again and follow the steps above.

**Note:**  See Appendix D for a list of field definitions for those fields within the squares.

**Notes:**
When going back into the detail screen, it will populate with the last record being viewed during that session.  To clear the screen and enter a new record press the “Open Book” icon.  When entering the detail screen for the first time after logging on you will simple enter the OPE ID and press the magnifying glass.

Start entering records and wait till everyone understands.

Enter a review record on any lender or school.  If they do not know an OPE ID then start with 800001, then 800002 and so on.  Let them know that the items in the squares are fields that should be entered.

If there are no prior program reviews for that entity a pop up window will appear displaying that message.

Once they are finished go to the next slide.

## Once completed, select the “Diskette” icon to save this record.  The message at the bottom should read that the record has been saved.  The Seq# will be populated once this record has been saved.  To enter the assessed deficiencies associated with this review, select “Deficiencies”.

- Once completed, select the **“Diskette”** icon to save this record.  The message at the bottom should read that the record has been saved.  The Seq# will be populated once this record has been saved.  To enter the assessed deficiencies associated with this review, select **“Deficiencies”**.

**Notes:**
Mention that the system will not allow you to enter deficiencies without saving the record first.

TIP:  This screen recognizes a header (with the lender ID and name) and a detailed record (with the review data).  If your cursor is on the PRCN or anywhere within the detailed record, in order to get your cursor back to the header information you will need to press the magnifying glass with a red X over it.  By doing that it allows you to toggle back and forth between the header and the detailed record.

## Click in the Defic column and enter a valid deficiency code.  The default option of open status should remain open until that deficiency has been resolved and paid.  Click into the Defic column on the second row and enter another valid deficiency code.  To enter an assessed amount associated with one of the codes, make sure the cursor is on the correct line and click the “Assessment” button.

- Click in the **Defic** column and enter a valid deficiency code.  The default option of open status should remain open until that deficiency has been resolved and paid.  Click into the **Defic** column on the second row and enter another valid deficiency code.  To enter an assessed amount associated with one of the codes, make sure the cursor is on the correct line and click the **“Assessment”** button.

**Notes:**
Whatever type of record is entered (see the “For” in the header line) determines the type of deficiencies they will enter.  Direct them to Appendix A for Lender deficiencies and Appendix C for School deficiencies.

If there is no monetary value associated with the finding then the Non Money check box should be checked.  For instance, if the finding is requiring the organization to develop procedures to prevent the finding in the future than this box would be checked and follow-up is still required to verify that procedures were developed.

## For a liability assessment that is due from the school, click on the Org Type LOV and choose School.  Tab or click to Assessed Amt Type LOV and choose Liability.  Tab or click to Assessed Amt and type an amount.  Tab or click to Effective Date and enter a date.  The date is normally the same as the Report Issue Date which is usually when the assessment is made. Click in the Assessed Amt column to add additional rows.  Click on “OK” to exit and save. 

- For a liability assessment that is due from the school, click on the **Org Type **LOV and choose **School**.  Tab or click to **Assessed Amt Type** LOV and choose **Liability**.  Tab or click to **Assessed Amt** and type an amount.  Tab or click to Effective Date and enter a date.  The date is normally the same as the Report Issue Date which is usually when the assessment is made. Click in the **Assessed Amt **column to** **add additional rows.  Click on **“OK”** to exit and save.

**Notes:**
“LOV” is the list of values and is the down arrow next to the field.

## Add a new deficiency code and click the “Payments” button to add an amount that was received or verified that it was paid.

- Add a new deficiency code and click the **“Payments”** button to add an amount that was received or verified that it was paid.

**Notes:**
Show them how to choose a deficiency code by clicking in the defic column to create a new line and pressing the “?”.  Once the deficiency codes are displayed narrow the search by  entering a 6% for lenders or a 2% for schools and select “Find”.  Then choose the appropriate code.

## For a liability received from the school, change the org type to school and the Payment Type to liability.  Complete the method, amount and date.  If the liability is different than the default simply so back and change.  Select the “OK” to exit and save.  Select the “Red Door” icon in the next screen to return to the review record. 

- For a liability received from the school, change the **org type** to school and the **Payment Type **to liability.  Complete the **method, amount and date**.  If the liability is different than the default simply so back and change.  Select the **“OK” **to exit and save.**  **Select the “**Red Door**” icon in the next screen to return to the review record.** **

**Notes:**
State that whatever entity the review was done on should be reflected as the proper org type.  For example, if it is a school liability then school should be reflected in the Org type.

Again, mention that the effective date is the date when the payment or adjustment was made.

## Entering Servicer Review Records:  If entering a servicer review, once the review and deficiency information has been input and saved.  You will then need to add those Lenders reviewed as part of the Servicer review.  Click on the “Underlying Lenders” button.

## Enter those lenders that were reviewed as part of the Servicer review.  Once you have entered the lenders press the “Diskette” to save the record.  Each will be assigned a PRCN which can be accessed individually and all information related to the servicer review will be automatically populated on the individual lender record.

## Review Deficiency Query: To review deficiencies that have been identified in program reviews, choose “More/Financial Partners/Reviews/Review Deficiency Query.”

**Notes:**
Remind them that the query screens are used when you want to review multiple records in a spreadsheet format and that all data on these query screens can be extracted to an excel compatible format which will be covered in this section.

## To get a list of deficiencies that have been identified by the 611 guarantor. Scroll over to the GA  column (between the By and For column) and enter 611.  Select the “Magnifying Glass” icon.

**Notes:**
This screen will show each deficiency for each review.  Therefore, if there are multiple deficiencies on a review there will be multiple lines that repeat the PRCN.

If a review identified no deficiencies than there will be no records on this screen for that PRCN.

## The query will retrieve records similar to these test records.  Using the horizontal scroll bar you can see the additional information that is located to the right of the screen.

**Notes:**
The detail of the deficiencies of any of the reviews listed can be viewed by clicking on the Detail button.  The cursor has to be in the row of the deficiency you want to view.

This information can be queried in many different ways, such as, a list of all alike deficiencies can be queried by entering the just the number, or reviewing all open deficiencies.  We will cover some of these types of queries later in the complex query session.

## Query Review Deficiency Results - Second Screen

## Query Review Deficiency Results -  Third Screen.   To download this data into an excel spreadsheet, select the “Folder Tabs” icon to extract the file.  

## The following window will be displayed.  Enter a path and file name.  In this case enter after the C:\ pepsdata and deficiencies.csv as the file name, to create an excel compatible file, and select “Create File”

- The following window will be displayed.  Enter a path and file name.  In this case enter after the C:\ **pepsdata** and **deficiencies.csv** as the file name, to create an excel compatible file, and select **“Create File”**

## A message should appear to inform you that the extract was downloaded into the path you specified.  You can now open the file into excel or access.   Click the “OK” on that message and then the “Red Door” to return to the main menu.

## Review Deficiency Detail: To view or update deficiency information on specific records, (if the user has access) choose “More/Financial Partners/Reviews/Review Deficiency Detail.”  

**Notes:**
Mention that they have been viewing the deficiency detail in prior sections and this is a more direct way to add additional information, like payments, once they are received.

Also mention, that when they select this it may populate with a prior deficiency record that they were viewing in a prior section.  That feature was created for convenience and saving time.

## To update or view deficiency information on a specific record, press the “Open Book” and enter the lender ID at the top of the screen and tab.  The most current will be displayed.

- To update or view deficiency information on a specific record, press the **“Open Book” **and enter the lender ID at the top of the screen and tab.  The most current will be displayed.

**Note:**  There are various ways to access the deficiency data.  The **Review Query** screen, the **Review Detail** screen, and the **Review Deficiency Query** screen all have shortcut buttons that are accessible, if data is displayed.

## To view a list of all the PRCNs, select the “Up/Down” arrow next to the PRCN information and you will get a list to choose from.  If you select a PRCN that is not your agency’s, the system will not allow you to update that record.  The 6th and 7th position of the PRCN identifies the Region Code.  Every guarantor has a designated Region Code.

- To view a list of all the PRCNs, select the **“Up/Down”** arrow next to the PRCN information and you will get a list to choose from.  If you select a PRCN that is not your agency’s, the system will not allow you to update that record.  The 6th and 7th position of the PRCN identifies the Region Code.  Every guarantor has a designated Region Code.

**Notes:**
For this exercise, we will choose a PRCN with a Region Code of 29 which is what has been assigned to these test IDs.  They can identify their region code by selecting the “?” or Help button in the tool bar.  Everyone will have a number assigned to them.

## The deficiency information for the selected PRCN is displayed.  You can toggle back and forth among PRCN for this entity by pressing the “Up/Down” arrow.    Once your desired record is displayed, you may begin entering deficiency information. Select the “Red Door” icon to exit.

## Audit Query:  To view information in a spreadsheet format on audits that have been received by the Department, choose “More/Financial Partners/Audits/ Audit Query”

**AUDITS**

## This screen will provide information on audits that have been received by Financial Partners.  Enter a year that you are interested in viewing and other specific criteria relevant to the results you desire.  Select the “Magnifying Glass” icon.

- This screen will provide information on audits that have been received by Financial Partners.  Enter a year that you are interested in viewing and other specific criteria relevant to the results you desire.  Select the **“Magnifying Glass”** icon.

**Notes:**
Please state that we are working on updating this information and that the 2000 - 2002 audits are not fully populated.

## You should have similar results from the query.  Using the horizontal scroll bar, there is additional information located to the right of the screen.

## Audit Query Results - Second Screen

- Audit Query Results - Second Screen

## Audit Query Results - Third Screen

## Audit Query Results - Fourth Screen.  Scroll back to the beginning.

**Notes:**
Scroll back to the left of the screen and click the detail button at the beginning of the first record.

## This is the audit detail record.  It provides information on the entity performing the audit, dates that are related to the audit, type and date of response, HQ and Regional referral information, deficiency and servicer information.  As in the review records, you would select the “Defic” button to view the detailed information of the deficiencies associated with this audit.

- This is the audit detail record.  It provides information on the entity performing the audit, dates that are related to the audit, type and date of response, HQ and Regional referral information, deficiency and servicer information.  As in the review records, you would select the **“Defic”** button to view the detailed information of the deficiencies associated with this audit.

**Note:**  There is an alternative way to access this screen by choosing     **“**_**M**_**ore/**_**F**_**inancial Partners/**_**A**_**udits/**_**A**_**udit Detail”**

## This is the audit deficiency detail screen.  No deficiencies were found for this audit.  These screens are slightly different than the review deficiency screens.  We have been working on upgrading the views and the audit screens have not been done.

**Note:** There are alternative ways to access this screen by selecting **“**_**M**_**ore/**_**F**_**inancial Partners/**_**A**_**udits/**_**A**_**udit Deficiency Detail”** or selecting “**Defic” **in the Audit Query results screen or selecting **“Detail”** in the Audit Deficiency Query results screen.

## A cover sheet reflecting the information related to this audit can be printed by pressing the “Cvr Sheet” button.  The servicer information that is associated with an audit can be viewed by selecting the “Servicer” button.  

- A cover sheet reflecting the information related to this audit can be printed by pressing the “**Cvr Sheet”** button.  The servicer information that is associated with an audit can be viewed by selecting the **“Servicer”** button.

## This is the screen when “Servicer” is selected.  Multiple servicer names and numbers that are used by the lender and associated with this audit are recorded in this section. 

## Audit Detail:  See page 45.

**Notes:**
Have them press the “red door” until they return to the main menu.

## Audit Tracking Query: Those lenders required to submit an audit are tracked in the audit tracking section. To query those lenders in a spreadsheet format, choose “More/Financial Partners/Audits/Audit Tracking/Lender Audit Tracking Query”

**Audit Tracking Query: **Those lenders required to submit an audit are tracked in the audit tracking section. To query those lenders in a spreadsheet format, choose **“**_**M**_**ore/**_**F**_**inancial Partners/**_**A**_**udits/**_**A**_**udit Tracking/Lender Audit Tracking Query”**

## Currently all lenders with a portfolio that is = > $10M  for 1995, 1996, and 1997 and =>$5M for 1999 and after; will be displayed.  Scroll to the right to view the additional info.

- Currently all lenders with a portfolio that is = > $10M  for 1995, 1996, and 1997 and =>$5M for 1999 and after; will be displayed.  Scroll to the right to view the additional info.

**Notes:**
Note: The default populates all data on this screen.  To view only one year of data, click on the “Open Book” icon.  Scroll over to the right window and enter a year.  Click on the “Magnifying Glass.”

Also mention that the shortcut buttons labeled “Servicers” and “Guarantors” will view the servicers and guarantors that lender does business with.  Currently there is only servicer information populated and will be covered a little later.

## Lender Audit Tracking Query - Second Screen.  

## Lender Audit Tracking Query - Third Screen.

## Lender Audit Tracking Query - Fourth Screen.

## Lender Audit Tracking Query - Fifth Screen. Select the “Red Door” 

- Lender Audit Tracking Query - Fifth Screen. Select the “**Red Door**”
- icon to exit to the main menu.

## Lender Audit Tracking Detail: The detailed record on the lenders required to submit an audit. To view the detail on those lenders, choose “More/Financial Partners/Audits/Audit Tracking/Lender Audit Tracking Detail”

**Lender Audit Tracking Detail: **The detailed record on the lenders required to submit an audit. To view the detail on those lenders, choose **“**_**M**_**ore/**_**F**_**inancial Partners/**_**A**_**udits/**_**A**_**udit Tracking/Lender Audit Tracking Detail”**

## This is the audit tracking detail record.  This screen provides information on the letters that were sent for tracking purposes, the origination YTD amount, and quarterly outstanding amounts.  Select the “Servicers “ button to view the servicers this lender does business with. 

- This is the audit tracking detail record.  This screen provides information on the letters that were sent for tracking purposes, the origination YTD amount, and quarterly outstanding amounts.  Select the **“Servicers **“ button to view the servicers this lender does business with.

## This screen lists the servicer that the lender utilizes. Select the “Red Door” icon to go back to the previous screen and select the “Roll Up Detail” button. 

- This screen lists the servicer that the lender utilizes. Select the “**Red Door**” icon to go back to the previous screen and select the **“Roll Up Detail”** button.

**Notes:**
Have them go back to the previous screen and select “Roll Up Detail” to view the breakdown of the portfolio roll up on the lender grouping explained in the previous section.

Also, let them know that we will not cover the guarantor relationship data because that has not been populated.  This area has been recently added.  We expect to populate with data we receive from the Lender Application  (LAP) that are currently being received for the new LaRS system.

## This Roll Up Query screen provides the detail information on the lenders associated with the consolidated portfolio data used to track the lender audits. If you scroll to the right you will see the individual portfolio data for each lender.  Select the “Red Door” icon once you finish scrolling to go back to the main menu. 

- This Roll Up Query screen provides the detail information on the lenders associated with the consolidated portfolio data used to track the lender audits. If you scroll to the right you will see the individual portfolio data for each lender.  Select the “**Red Door**” icon once you finish scrolling to go back to the main menu.

**Notes:**
Have them scroll over to view the information to the right.  Each screen will not be listed in this manual.

## Lender Servicer Audit Tracking and GA Servicer Audit Tracking and Exceptional Performer Audit Tracking: These new sections were recently added.  The screens are similar to the others already covered and starts with the current audit period ending 2003.

**Lender Servicer Audit Tracking and GA Servicer Audit Tracking and Exceptional Performer Audit Tracking: **These new sections were recently added.  The screens are similar to the others already covered and starts with the current audit period ending 2003.

**Notes:**
The only differences is that the servicer audit tracking screens will not have any portfolio information.

## Audit Deficiency Query: To view the deficiencies associated to an audit in a spreadsheet format choose “Menu/Financial Partners/Audits/Audit Deficiency Query.”

## To view the deficiencies that were identified in an audit, enter the year that you are interested in viewing and any other specific criteria relevant to the results you desire.  Select the “Magnifying Glass” icon.

- To view the deficiencies that were identified in an audit, enter the year that you are interested in viewing and any other specific criteria relevant to the results you desire.  Select the “**Magnifying Glass**” icon.

## The query will retrieve records similar to these.  Using the horizontal scroll  bar,  you can view other information located on the right of this screen.

## Audit Deficiency Query  - Second  Screen

**Notes:**
Since this is actual data the OPE ID and Name have been blocked.

## Audit Deficiency Query  - Third  Screen.  Scroll back to the beginning and select “Detail” on the first record to view the deficiency information.

## This is the audit deficiency detail of the selected record.  Select the “Red Door” icon to exit.  Select the “Red Door” icon again to return to the main menu.

## Audit Deficiency Detail:  See pages 46 and 66.

**Notes:**
The last two options (ARB Transactions Query, and ARB Transactions Detail) will not be covered.  These are internal screens used when audits are sent to us from the clearinghouse.  The guarantors will not be able to select them.

## Action Query:  To get a list of administrative actions taken against a lender or servicer, choose More/Financial Partners/Actions/Action Query.

**ACTIONS**

## Currently there is no data available to populate this area.  Scroll over to the right to view additional fields.

## Query Admin Actions - Second Screen

## Query Admin Actions - Third Screen.  Select the “Red Door” icon to exit.

## Action Detail: To view additional information on an administrative action, choose More/Financial Partners/Actions/Action Detail.

## There is no data available to populate this screen.  The action detail screen provides more detailed data about the action.  Select the “Red Door”  icon to exit to the main menu.

**Note:**  There is an alternative way to access this screen by selecting **“Dtl**” in the **Action Query** screen.

## Appeal Query:  To view the appeals that have been received in Financial Partners for lenders and servicers choose More/Financial Partners/Appeals/Appeal Query.

**APPEALS**

## Currently this area has not been populated.  Therefore, no data can be viewed.  This area will have the lender and servicer appeals that have been received for audits and reviews.  Scroll over to the right to view the additional fields to the right of this screen.

- Currently this area has not been populated.  Therefore, no data can be viewed.  This area will have the lender and servicer appeals that have been received for audits and reviews.  Scroll over to the right to view the additional fields to the right of this screen.

## Appeals Query - Second Screen.

##  Appeals Query - Third Screen.  Select the “Red Door”  icon to return to the main menu.

## Appeal Detail: Additional information on an appeal received from a lender or servicer can be viewed by choosing More/Financial Partners/Appeal/Appeal Detail.

## The appeal detailed screen provides additional information on the type of activity that is being appealed and the dates associated with the appeal.  Select the “Red Door”icon to return to the main menu.  To see the related detail or deficiencies related to this appeal press “Rltd Dtl” or “Rltd Defic” buttons.

- The appeal detailed screen provides additional information on the type of activity that is being appealed and the dates associated with the appeal.  Select the “**Red Door**”icon to return to the main menu.  To see the related detail or deficiencies related to this appeal press **“Rltd Dtl” **or** “Rltd Defic”** buttons.

**Note:**  There is an alternative way to access this screen by selecting the **“Details” **in the **Appeal Query** screen.

## GA Default Rates:  You can view the default rates of and letters sent to lenders and guarantors.  To view the default rates for guarantors choose More/Financial Partners/Default Information/GA Default Rates.

**DEFAULT INFORMATION**

## To list all guarantor default rates for 2000 enter 2000 in the Cohort Year.  Select the “Magnifying Glass.”

- To list all guarantor default rates for 2000 enter **2000** in the **Cohort Year.**  Select the **“Magnifying Glass.”**

## The query resulted in a list of guarantor’s default rate in ascending order by their 3 digit GA code.  The first record (555) is an internal number used by the Department.  To view the guarantor associated with the GA code, either scroll to the right or click on the three digit number and select the “Double Plus Sign” and the detail of that agency will be displayed or scroll to the right to view that information.

## Guarantor Default Rates Result - Second Screen.  You can view the form letter that was sent to the agencies with a default rate for that year by pressing “Prt Lettr.”  Select the “Red Door” to exit.

## GA Default Rate Letters:  To view the letters that were sent a particular guarantor in a cohort default year choose More/Financial Partners/Default Information/GA Default Letters. 

## To view the letter data for 2000 enter 2000 in the Cohort Yr and select the “Magnifying Glass”.  This screen provides information on the letters that were sent to the guarantors and if there were corrections made to the original letter sent, the corrected rate would be listed on this screen.  To date we have not had any guarantor corrected rates.  Select the “Red Door” to exit.

## Lender Default Rates:  To view the default rates for lenders choose More/Financial Partners/Default Information/Lender Default Rates. The screens for the lender default rates are similar to the guarantor default rates.  Refer to page 81.

## Default Rate Letters:  To view the letters that were sent a particular lender in a cohort default year choose More/Financial Partners/Default Information/ Lender Default Letters.   The screens for the lender default letters are similar to the guarantor default letters.  Refer to page 85.

**Notes:**
The Maintain Default Data selection is not enabled because that is used by the Department to be able to maintain the rates prior to them being published or made public.