Application data exchange

An MPL sends CRB a daily report/file - the Application Tape - to enable CRB to perform a fair lending review. The report contains the applications from the previous day that were decisioned by the MPL; those that were Approved and sent to Arix for origination and funding, and those that were Declined.

📘

API is coming

CRB will be replacing the file based data exchange with an API in a future release.

Swagger: https://lendingpreapprovalstg.crbnj.net/swagger/index.html
API calls:

  1. POST /v2/PreApproval/Approve
  2. POST /v2/PreApproval/deny

The table below is the reference information for applications submitted.

Notes:

  • If a loan changes status (such as from denied to funded), the updated loan record should be included on the tape with the UpdatedFlag. (A flag indicates that this record updates a previous credit decision for this loan).
  • During implementation, CRB and the MPL will agree on additional fields to be passed to CRB based on the MPL's unique credit model.

File conventions

  • File format is CSV.
  • Naming convention: MplId_ApplicationTape_yyyymmdd.csv, where yyyymmdd is the date of file generation.
  • Data in the report should be prior day applications.

Dictionary updates

Attribute

Action

Date

ProgramType
MarketingChannel
CreditPolicyVersion
CreditModelVersion
InvestorName
InvestorDecisioned
UnderwriterNotes
DenialReason
PolicyDeclineReason
VantageScore
VantageScoreDate
NetDisposableIncome
PreDTIExMortgage
PreDTIInMortgage
PreDTIDate
PostDTIDate
PostDTIExMortgage
PostDTIInMortgage

Added

June 16, 2021

DenialReason 1 - 10
PolicyDeclineReason 1-10
DTI

Consolidated
Expanded

June 16, 2021

Attribute

Description

BorrowerId
alphanumeric

Unique identifier for the borrower.

ApplicationId
alphanumeric

Unique identifier for the application.

LoanNumber
alphanumeric

Unique identifier for the loan.

Platform
text

MPL name.

ProgramType
text

MPL defined program to which the loan belongs Same as the program fields sent to Arix.

MarketingChannel
text

Marketing channel name and code as defined by the credit policy.

CreditPolicyVersion
alphanumeric

Credit policy version.

CreditModelVersion
alphanumeric

Credit model version.

InvestorName
text

Name of the investor that decisioned this loan, if applicable.

InvestorDecisioned
1 or 0

1 if the investor decision overrode the MPL decision, otherwise 0.

LoanPurpose
text

Borrower-stated loan purpose.

AssetClass
integer

1 - Student
2 - Solar
3 - Debt consolidation
4 - Home improvement
5 - POS
6 - Medical
7 - Auto loan
99 - Other

FinalActionTaken
text

Decisioning: Approved, Denied, Incomplete, or Counteroffer

  • Approved - the application was approved, the offer was accepted and approved by CRB, or it hasn't yet passed the offer stage.
  • Denied - if the application is declined at credit checks.
  • Counteroffer - if a counteroffer is sent to the borrower.
  • Counteroffer accepted - if a counteroffer was sent to a borrower and the borrower accepted.
  • Counteroffer not accepted - if a counteroffer was sent to a borrower and the borrower declined.
  • Approved not accepted - if the application was approved but the offer wasn't accepted.
  • CRB denied - if the offer was accepted and then rejected by CRB.
  • Incomplete - if the borrower didn't complete the application.

UnderwriterNotes
text

Free text field for underwriter notes.

DenialReason
json blob

json blob of all denial reasons.
The blob must EXCLUDE text delimiters and line feeds.

""DenialReasons"": {
""DenialReason1"": ""denial_reason_1"",
""DenialReason2"": ""denial_reason_2""
}"
See note below for explanation

PolicyDeclineReason
json blob

Decline reason per credit policy (DTI, FICO, etc.)

json blob of all policy decline reasons.
The blob must EXCLUDE text delimiters and line feeds.

""PolicyDeclineReasons"": {
""PolicyDeclineReason1"": ""policy_decline_reason_1"",
""PolicyDeclineReason2"": ""policy_decline_reason_2""
}"
See note below for explanation.

DenialDate
date

Date the application was denied.

Application Date
date

Date the consumer applied for the loan.

Reg B Decision Date
date

Date decisioning occurred.

AdverseActionNoticeDate
date

Date the MPL emailed/mailed the adverse action notice to the applicant.  
Note: All adverse action notices must be provided to a consumer within 30 days of a denial of credit.

CounterofferDate
date

Date the MPL provided a consumer with a counter offer in response to their credit application.
Note: Counter offers must be presented to an applicant within 30 days of receiving a complete application.

NoticeOfIncompleteness
date

Date that a notice of incomplete application was sent to the borrower.

InitialFraudAlert
Y or N

An initial fraud alert can be placed on a consumer's credit report if they think they were a victim of fraud or identity theft.
The alert is found on the credit report and stays on file for 90 days.
Yes for an initial fraud alert, otherwise no.

ExtendedFraudAlert
Y or N

An extended fraud alert can be placed on a consumer's credit report if they were a victim of identity theft.
The alert is found on the credit report and stays on file for 7 years.
Yes for an extended fraud alert, otherwise no.

AddressDiscrepancyFlag
Y or N

This alert, found on the credit report, indicates that the address provided by a user to obtain a report substantially differs from the address the NCRA has in the consumer’s file.
Yes if there is an address discrepancy, otherwise no.

CreditFreeze
Y or N

This alert, found on the credit report, restricts access to the credit report.
Yes to restrict access, otherwise no.

ExceptionFlag
Y or N

Indicates if there are any exceptions to the policy.
Yes if there are exceptions, otherwise no.

ExceptionNotes
text

Description of the exception detailing why an exception was granted.

BorrowerLastName
text

Borrower's last name.

BorrowerFirstName
text

Borrower's first name.

BorrowerDOB
alphanumeric

Borrower's date of birth.

BorrowerSSN
alphanumeric

Borrower's Social Security Number.

BorrowerAddress
text

Borrower's street address.
Must be a physical address and not a PO Box.

BorrowerCity
text

Borrower's city of residence.

BorrowerState
text

Borrower's State of residence.

BorrowerZip
alphanumeric

Borrower's 5-digit zip code.

BorrowerPhone
alphanumeric

Borrower's phone number.

BorrowerEmail
alphanumeric

Borrower's email address.

RequestedLoanAmount
number to 2 decimals

Amount the borrower requested at the time of application.
The requested amount can change before the final loan amount is settled, for borrower or lender related reasons.

LoanAmount
number to 2 decimals

Actual gross amount borrowed.

OriginationFee
number to 2 decimals

Charge to the borrower for the loan per the guidelines.

PeriodicPmt
number to 2 decimals

Amount of regular payment per the note.

FinalPaymentDate
date

Date of the last regular payment.

FinalPayment
number to 2 decimals

Amount of the final payment.

FinanceCharge
number to 2 decimals

Finance charge paid by the borrower.

TotalPayments
number to 2 decimals

Total paid by the borrower after all payments are made.

PPY
integer

Number of payments per year.

Rate
number to 2 decimals

Interest rate, as a percent.

APR
number to 2 decimals

Annual percentage rate, as a percent.

Amortization
integer

Number of payments at origination to pay off the loan.

Term
integer

Number of months at origination to pay off the loan.

RateType
integer - 1 or 2

1 - Fixed
2 - Floating

PriorLoanFlag
Y or N

Has the borrower had other loans with the sponsor.
Yes if the borrower has had other loans with the sponsor, otherwise no.

FICO
integer - 3 digits

Use the 3-digit FICO score only.

FICODate
date

Date FICO score was obtained.

VantageScore
text

Vantage score at application.

VantageScoreDate
date

Date Vantage Score was obtained.

CreditGrade
alphanumeric

If applicable, internal grade for the loan from the credit policy (Risk Group).

DebtUtilization
number to 2 decimals

Percent of credit used by the borrower.

TotalRevolvingDebt
number to 2 decimals

Dollar amount of all revolving debt on the credit report.

CreditInquiries12months
integer

Number of credit report inquiries in the last 12 months.

DQPast24Months
integer

Number of times the borrower submitted late payments in the past 24 months on all accounts, per the credit report.

AccountsOpenedPast24Months
integer

Number of accounts opened by the borrower in the past 24 months, per the credit report.

OpenCreditLines
integer

Number of open trade lines on the credit report.

CollectionsExcludingMedical
integer

Number of open collection accounts per the credit report, not including medical.

PublicRecordsOnFile
number of negative public records

Number of open public records shown on the credit report such as bankruptcies, tax liens and judgements.

MonthsSinceLastRecord
integer

Number of months since the borrower’s last public record.

HomeownerFlag
Y or N

If the borrower is already a homeowner - use multiple sources to determine, including the application.
Yes if the borrower is a homeowner, otherwise no.

EmploymentLength
integer

Number of months the borrower has been employed at their current job.

EmployementLengthDescription
text

Number of years the borrower has been employed at their current job.

Employer
text

Employer's name.

AnnualIncome
number up to 2 decimals

Dollar amount of annual income.

NetDisposableIncome
number up to 2 decimals

Net income remaining after debt (as defined by credit policy, if applicable).

PreDTIExMortgage
number up to 2 decimals

Debt to Income Ratio
DTI excluding mortgage pre-loan as a percentage.

PreDTIInMortgage
number up to 2 decimals

Debt to Income Ratio
DTI including mortgage pre-loan as a percentage.

PreDTIDate
number up to 2 decimals

Debt to Income Ratio
DTI date pulled pre-loan as a percentage.

PostDTIDate
number up to 2 decimals

Debt to Income Ratio
DTI date pulled post-loan as a percentage.

PostDTIExMortgage
number up to 2 decimals

Debt to Income Ratio
DTI excluding Mortgage post-loan as a percentage.

PostDTIInMortgage
number up to 2 decimals

Debt to Income Ratio
DTI including Mortgage post-loan as a percentage.

IPAddress
xxx.xxx.xxx.xxx

IP address of the computer the borrower applied on.

MLAFLAG
Y or N

If the loan is being made to a covered borrower.
Yes if the borrower is covered, otherwise No.

MAPR
number up to 2 decimals

Military APRA standard calculation used by lenders for loans covered by the Department of Defense's Military Lending Act & Regulation Z.

MAPR is required if MLAFLAG = Yes

For more information, see: https://www.fdic.gov/regulations/compliance/manual/5/V-13.1.pdf

UpdatedFlag
1 or 0

Flag indicates that this record updates a previous credit decision for this loan.
1 - True - Updates a previous credit decision.
0 - False - Doesn't update a previous credit decision.

MerchantName
text

Name of merchant, if applicable.

MerchantFee
number to 2 decimals

Amount paid to merchant, if applicable.

CoBorrowerLastName
text

CoBorrower's last name, if applicable.

CoBorrowerFirstName
text

CoBorrower's first name, if applicable.

CoBorrowerAddress
alphanumeric

CoBorrower's address.
Must be a physical address and not a PO Box.

CoBorrowerCity
alphanumeric

CoBorrower's city of residence

CoBorrowerState
text

CoBorrower's State of residence.

CoBorrowerZip
text

CoBorrower's zip code.

CoBorrowerDOB
text

CoBorrower's date of birth.

CoBorrowerSSN
alphanumeric

CoBorrower's Social Security Number.

CoBorrowerPhone
alphanumeric

CoBorrower's phone number.

CoBorrowerEmail
alphanumeric

CoBorrower's email address.

CoBorrowerFICO
numeric

CoBorrower's FICO score.

ExtraFields
json blob

json blob allowing for all extra fields. The blob must EXCLUDE text delimiters and line feeds. Any changes/additions to this field must go through change management.

Note: DenialReason versus PolicyDeclineReason
The difference between DenialReason and PolicyDeclineReason is a conceptual one:

  • The DeclineReason should be the one stated in the AAN.
  • The PolicyDeclineReason is the specific rule in the underwriting policy that the applicant didn't satisfy.
    Most of the time they match, but there can be instances when the AAN reason is worded differently than the PolicyDeclineReason.

Example: The AAN (DenialReason) stated "Our partner bank can't approve the loan you requested because we couldn't verify your identity based on the information we received". The reason stated in the PolicyDeclineReason however, is that the applicant was found on OFAC.


Did this page help you?