Thread Options
#2163679 - 02/08/18 06:18 PM Data Collection/Reporting
wblewis935 Offline
Member
Joined: Feb 2011
Posts: 53
Hey all!

When you gather data to report for CRA, do you nearly exclusively use call report codes 1e1, 1e2, and 4 for small business and 1b and 3 for small farm?

I think we may have gotten too complicated in how we gather what loans to report. Unless it is a community development loan, it would have to be one of those 5 call report codes, correct?

In other words, all CRA Loan type 1 - Small Business loans MUST have a call report code of either 1E1, 1E2, or 4 as the call report defines them. (assuming the original loan amount is $1MM or less, of course) Am I thinking through this correctly?

Any ideas on how you collect that data is also welcome smile
Last edited by wblewis935; 02/08/18 06:20 PM.
Return to Top
CRA
#2164167 - 02/13/18 12:26 AM Re: Data Collection/Reporting wblewis935
DNana Offline
Junior Member
DNana
Joined: Nov 2010
Posts: 41
TN
Since we are getting close to having to report, I'm interested in this as well.
_________________________
Nana, CRCM

Return to Top
#2164169 - 02/13/18 01:11 AM Re: Data Collection/Reporting wblewis935
Princess Romeo Offline

Power Poster
Princess Romeo
Joined: Jun 2001
Posts: 8,272
Where the heart is
You may very well have an over-complicated process, but without knowing how accurate your call report process is, I would hesitate to say "yeah - just go with those call codes."

Having said that, if you start with the definition in the Regulation, 12 CFR 228.12(v), it's pretty clear you need to start with the Call Report instructions and determine which loans meet the definition.
- (v) Small business loan means a loan included in “loans to small businesses” as defined in the instructions for preparation of the Consolidated Report of Condition and Income.
- (w) Small farm loan means a loan included in “loans to small farms” as defined in the instructions for preparation of the Consolidated Report of Condition and Income.

As you indicated, the current Call Report instructions will direct you to the call report codes you have identified for the loans that must be reported. Now, if your Call Report process has some holes, then you will need a more complicated process to find the loans that should:
1. Be reported on the CRA LR, and
2. Have the Call Report code corrected in your system of record.
_________________________
CRCM,CAMS
Regulations are a poor substitute for ethics.
Just sayin'

Return to Top
#2164293 - 02/13/18 07:10 PM Re: Data Collection/Reporting wblewis935
RR Jen Offline
Power Poster
RR Jen
Joined: May 2003
Posts: 3,759
Running and riding everywhere ...
I agree with PR. I "just go with those call codes" but am also brainstorming ideas for queries to attempt to identify any loans that were incorrectly call coded and should have been reported. Kind of the old audit philosophy of "trust, but verify".
_________________________
I don't need any more negativity in my life...be positive and helpful people or I will kick you in the shins!!!

Return to Top
#2164504 - 02/14/18 06:27 PM Re: Data Collection/Reporting wblewis935
wblewis935 Offline
Member
Joined: Feb 2011
Posts: 53
This helps so much. Thank you for your input! The call report codes can be somewhat complicated when selecting one for a loan, so I should probably find out how those codes are being chosen to, hopefully, gain comfort in that process. Thanks again!

Return to Top
#2164543 - 02/14/18 08:11 PM Re: Data Collection/Reporting wblewis935
wblewis935 Offline
Member
Joined: Feb 2011
Posts: 53
So, as an example... lol

A loan is secured by Farmland and call report coded as 1b. However, the purpose of the loan is to purchase real commercial real estate. And the borrower is a commercial business. This would still be considered a small farm loan since the call report code is 1b - secured by farmland and the amount is less than $500K?

It's a hypothetical and may never happen, but I wanted to make sure that I'm thinking this through properly....

Return to Top