Overview

LoanBeam Processing Automation (LBPA) is a new service which includes LoanBeam income calculation results and in addition will return an Excel workbook that will provide:

Pre-Underwriting Automated Rules – Pre-built set of automated rules which use application and document data to clear pre-underwriting/processing conditions. Rules cover all “C’s” of credit, capacity, capital, collateral, and credit.

Additional documents and XML used to process Pre-Underwriting Automated Rules.

LoanBeam Processing Automation scans and analyzes the following loan documents for Automated rules.

1099	Homeowners Insurance Policy
4506	Loan Estimate
92900LT	PMI Cert
Appraisal	Social Security Benefits 1099 Statement
AUS	Tax Certification
Asset Documentation	Tax Return Transcripts
Contract of Sale	Tax Returns
Closing Protection Letter	Buydown Agreements
Credit Report/Credit Supplement	Prelim Title
FHA Connection	URLA
Flood Certification	VOD
Flood Insurance	VOE
Fraud Report	W-2

Important note! The MISMO 3.4 xml file application data, is critical to LBPA’s AR functionality.

A current version of the MISMO file must be uploaded each time rules are run to provide accurate finding results for new loans and updated loan packages.

File naming convention for LBPA files

The LBPA file naming convention does not support spaces in the filename. Examples of support filenames for upload are as follows:

12345.zip

File-1.zip

File_data_v1.zip

File123.zip

LBPA Excel output report

The Automated Rule results are returned in an Excel spreadsheet to the same location as the Income results. The rules will provide the following information:

Missing document alerts
Missing or inconsistent field value alerts
Document and data verification

Cover Page tab

The report contains an overview section with basic loan information and a summary of the finding alerts found on the loan. Below is a screenshot of the report:

Data Tab

The data tab contains the details of the document indexing, data extraction and findings results.

Columns A – N of data tab

This section of the report contains the general loan information including loan number, processing status and date created.

Columns O – AF of data tab

These columns provide the details of each of the findings tested on a loan. If a finding uses several data fields the report will include a line for each field used in the finding.

Below is a table of field names and definitions of fields related to the findings.

Field name	Field Description	Sample Value
Finding type code	LoanLogics code for finding	P512
Description	Description of finding	Uniform Residential Loan App Single (Borr1) must be present
Category	Finding Category	Credit
Type	Type of finding	Missing document
Description3	Status of test	Failed
Document Type ID	LoanLogics code for document	1915
Document Name	Name of document	URLA - Borrower Information (Borr1) Initial
Descriptor ID	LoanLogics code for data field	81
Descriptor Name	Name of data field	State
Descriptor Value	Value of date field	SC
LOS Name	Name from LOS file	PropertyState
LOS Value	Value in LOS file	SC

This information provided can be used to determine missing documents and data in the submitted loan documents. Additional documents and updated MISMO xml files can be submitted for processing to clear failed findings