Look to Book Dashboard - Summary

Screen ID: ILOOKB-02
Screen Title: Look-to-Book Ratio Analysis
Panel ID: 6045
Tool Number: 484
    Click here to magnify

Access this screen after selecting filters on the initial Look to Book Dashboard selection screen and using Enter.

Why am I seeing all 9s in fields on this screen? What are the affected tables?

Introduction to this Screen

This Look to Book dashboard lists application data that fits the entry filters selected on the previous screen broken out by pending, booked and denied.  The middle section breaks the data by credit score range.  Use this dashboard and the screens that follow to answer these questions:

  • How many loans you are approving, denying and booking in each range?

  • How many days does a loan remains in pending status or do booked or denied loans take until they receive a decision?  

  • How many members versus non-members are applying in each credit score range?  

  • What is the high/low and average score of applications for mortgages (or other loan categories)?  

  • What similarities can are their of pending applications from your lowest credit score tier versus a higher score?  

  • What is the number of loans you need to look at to book a loan (ratio)?

Some of the statistics you find on this dashboard are similar to what you will find on the Activity Tracking dashboard; however, because this dashboard eliminates all loan applications with a credit score greater that 999 and less than zero, results between the two dashboards may vary slightly.

Using this Screen

At the top of this screen view the filters that were selected on the previous screen.  To view specifically what was selected, use the Filters button to reveal a screen showing the detail.

Pending, denied, and booked applications that meet the selection criteria are displayed broken down by credit score range.  The dashboard shows the number and amount of applications and their percentage by credit score range. Use the Show #App/Show $Amt (F8) button to toggle between these views.  The average days are also provided.  This is the number of days a loan stays in pending status based on the application date (APPLDT in LNAPL3).  The ratio of total number of applications to total applications is also provided.  This data defaults to show data on members and non member.  View a description of specifically how each column is calculated below in the Columns section below.

  • Use the next to the specific data group to view a screen listing the applications included in that group. This screen allows you to do further analysis using the Common Bonds analysis tools.

  • NOTE:  This screen excludes credit scores that are greater than 999 and that are zero.

From this screen you can view details of filters and adjust the data analyzed by using the following buttons:

Columns

Field Name

Description

Score

The credit scores used on this dashboard are the most recent non-zero score for the Social Security Number found in the CRBCSH file.

The default credit score ranges used come from the LRISKS record of file SSCNTL; if LRISKS is not found then IRISK1 is used.  These ranges can be adjusted by using the Modify Score Range button.

#Application/$Amount

Toggle between showing number of applications or dollar amount of applications

Percent

The number (or $ amount) of applications shown for the credit score range divided by the total number (or $ amount) of applications.

Ratio

The look-to-book ratio; how many apps need to be looked at before one is booked.  (Total apps divided by number booked).

Pending

The dashboard shows the number and amount of applications and their percentage of the credit score range.  Use the Show #App/Show $Amt (F8) button to toggle between these views.  The average days are also provided.  This is the number of days between application date (APPLDT in LNAPL3) and the current date.

Denied

The dashboard shows the number and amount of applications and their percentage of the credit score range.  Use the Show #App/Show $Amt (F8) button to toggle between these views.  The average days are also provided.  This is the number of days between application date (APPLDT in LNAPL3) and the denied date (DNDNDT in table DNAPPSL1).

Booked

The dashboard shows the number and amount of applications and their percentage of the credit score range.  Use the Show #App/Show $Amt (F8) button to toggle between these views.  The average days are also provided.  This is the number of days between application date (APPLDT in LNAPL3) and the loan creation date (ACTYMD in table LNAPL3).

 

Filters

Field Name

Description

Loan app range

This will include applications with a Date that is between the “from” and “to” dates.  The “from” date defaults to 30 days before the current date, while the “to” date defaults to the current date.  The field being compared is APPLDT in file LNAPL3.

Branch

Only applications that have a Branch that match one of the selected codes will be included.  The field being compared is BRANCH in file LNAPL3. 

Underwriter status

 Only applications that have an Underwriter Status that match one of the selected codes will be included.  The field being compared is LNCODE in file LNAPL3.  

Underwriter ID

Only applications that have an Underwriter ID that match one of the selected codes will be included.  The field being compared is LNEMPI in file LNAPL3. 

Dealer

Only applications that have a Dealer that match one of the selected codes will be included.  The field being compared is DEALR# in file LNAPL3.

Loan category

Only applications that have a Loan Category that match one of the selected codes will be included.  The field being compared is LNCATG in file LNAPL3.  Note: Loan Category and Business Unit cannot both be selected.

Product code

Only applications that have a Product Code that match one of the selected codes will be included.  The field being compared is PRCODE in file LNAPL3.  

Interviewer branch

Only applications that have an Interviewer Branch that match one of the selected codes will be included.  The field being compared is SMBVLT in file SECMAST (based on PRCSSR in LNAPL3).  

Interviewer ID

Only applications that have an Interviewer ID that match one of the selected codes will be included.  The field being compared is PRCSSR in LNAPL3.

Delivery channel

Only applications that have a Delivery Channel that match one of the selected codes will be included.  The field being compared is LNDELC in file LNAPL3.  

Business unit

Only applications that have a Business Unit that match one of the selected codes will be included.  The field being compared is an LBU record in file SYSCTL (based on LNCATG in LNAPL3).  Note: Loan Category and Business Unit cannot both be selected.    

 

Buttons

Field Name

Description

Show $Amt/Show #App (F8)

Toggle between showing the dollar amount of the application and the number of applications.

Filters

Display the detail of the filters currently being used.

Change View (F15)

Display the analysis selection window allowing you to select a filter an view the data by it.

Application Type (F20)

Display a window allowing you to select to view member applications, non-member applications or both.

Modify Score Range (F21)

Display a window allowing you to modify the score ranges.