Addresses By Borrower Report

This report is produced when Addresses By Borrower is selected from the Reports drop-down list. The report is a listing of all addresses that are associated with one or more borrowers, grouped by the Address type. For each borrower, the borrower's addresses (current and past) are provided, as well as the addresses (if any) for any comaker(s), reference(s), and/or employer(s). The addresses are grouped/sorted by:

Borrower SSN
Address Type (borrower, comaker, reference, employer)
Name associated with the address (for comaker, reference, and employer addresses only)
From Date
Through Date

Parameter Entry

Addresses can be retrieved for a single borrower, multiple borrowers, or all borrowers. When Addresses By Borrower is selected, the top portion of the Reports screen is replaced with a parameter entry window as shown in the following example:

The borrower should provide an SSN value and then click the Submit button to generate the report. Depending on the value entered, the report will contain the addresses for one or more borrowers as follows:

Entering a complete SSN (9 digits with no dashes; ex: 212001234) will retrieve the CLM addresses (if any) for any matching borrower.
Entering a partial SSN (1 to 8 digits with no dashes; ex: 21200) will retrieve the CLM addresses( if any) for any borrower whose SSN begins with the value entered.
Not entering an SSN value will retrieve all CLM addresses for all borrowers. Warning: Such a report will likely be quite large.

Sample Report

The following is a sample Addresses By Borrower report:

Report Composition

The data elements which comprise the Addresses By Borrower report are described in the following table:

Column Name

Description

Borrower Identification Line

Social Security Number

Borrower's social security number.

Borrower Name

Borrower's name formatted as "Last Name, First Name" .

Address Type Line

Address Type

Indicates the type of addresses displayed in this subsection. Possible values are Borrower, Comaker, Reference, and Employer. If either of the following are true:

the borrower does not have a Comaker, Reference, or Employer information

the Comaker, Reference or Employer information does not include any addresses

then the corresponding Address Type section will not appear.

Address Information Lines

Name

This line appears only for Comaker, Reference and Employer addresses. This field is the name of the associated Comaker, Reference, or Employer.

From Date

The date the address became effective.

Through Date

The date the address was no longer effective.

Bad Date

The date the address was determined to be no longer valid.

Address Block

The street address, comprised of from 1 to 5 lines in the following order: Address 1, Address 2, City/State/Zip, Care Of, and Carrier Route. If any of these does not contain a value, the line will not be presented.

For foreign addresses, the "State" value will be replaced by the Country name/value.

Daytime Phone Number

Daytime phone number and extension (if any).

Evening Phone Number

Evening phone number and extension (if any).

email Address

Electronic mail address (if any).

Address Comment

Any comment pertaining to the address information that was provided by the user.

Record Selection Criteria

This report retrieves all Address data from the CLM database that meets the following conditions:

The Borrower's SSN "matches" the user-supplied SSN parameter value (see above), and the borrower is not marked for deletion.
The borrower has 1 or more addresses that are not marked for deletion.
The borrower has 1 or more comakers that are not marked for deletion, and the comaker has address information on file.
The borrower has 1 or more references that are not marked for deletion, and the reference has address information on file.
The borrower has employer and employer address information on file.

Addresses are grouped by borrower SSN, Address Type, Address Name, From Date and Through Date.

Column Name	Description
Borrower Identification Line
Social Security Number	Borrower's social security number.
Borrower Name	Borrower's name formatted as "Last Name, First Name" .
Address Type Line
Address Type	Indicates the type of addresses displayed in this subsection. Possible values are Borrower, Comaker, Reference, and Employer. If either of the following are true: the borrower does not have a Comaker, Reference, or Employer information the Comaker, Reference or Employer information does not include any addresses then the corresponding Address Type section will not appear.
Address Information Lines
Name	This line appears only for Comaker, Reference and Employer addresses. This field is the name of the associated Comaker, Reference, or Employer.
From Date	The date the address became effective.
Through Date	The date the address was no longer effective.
Bad Date	The date the address was determined to be no longer valid.
Address Block	The street address, comprised of from 1 to 5 lines in the following order: Address 1, Address 2, City/State/Zip, Care Of, and Carrier Route. If any of these does not contain a value, the line will not be presented. For foreign addresses, the "State" value will be replaced by the Country name/value.
Daytime Phone Number	Daytime phone number and extension (if any).
Evening Phone Number	Evening phone number and extension (if any).
email Address	Electronic mail address (if any).
Address Comment	Any comment pertaining to the address information that was provided by the user.