loans reported on microdata reports-urgent!!

We are having some differences of opinion. What are the parameters that define whether or not the loan should be included in the microdata reports versus the Community Development "spreadsheets" for CRA examinations?
There has to be a limitation or two that qualifies a loan from one report or the other. We thought it was loan amount or revenue but we are seeing loans in excess of $1 million and/or revenue in excess of $ 1 million reported in previous years' microdata reports. Reviewed the FAQs and they are not clear on this point.

I am not sure what you are asking.

For CRA you have small business/small farm loans, HMDA, and then "everything else". The "everything else" loans are the non-small business/small farm loans and non-HMDA loans that you choose to report to make the case that you are serving your communities.

There are CRA codes for everything except HMDA reportable.

Trees, what are you trying to classify the loans as? Affordable Housing, Economic Development, Revitalize/Stabilize, or Community Services to LMI Individuals? I have a spreadsheet that I can send you breaking out the parameters that are measured and it will give you a basis of where to start. It is broken out in a language that helps me understand.

For the micro data reports, using the FFIEC specs, we need the parameters for the small business loans. Not the "everything else" loans.
We were looking for the definition of what falls into the small business category and that would be reported in the FFIEC specs reports.
We've done this for years but we hit an error in the program this year. We are showing loans in excess of $1 million and with revenues in excess of $1 million. When I look at the spec sheets and FAQs etc, the loan amount is maxed at $ 1 million but revenue can be higher than $1 million. I think this is right but want to double check. Thanks.

I could be wrong but it can't be classified as small business if revenue exceeds 1 million. It could be classified as economic development as long the revenue for the loan is lower than the classification in NAICS for total revenue. If you don't have that information, you could look at NAICS info for # of employees vs total # of employees for the company. But I am only relatively new to the business so I would see if Kathleen or someone else might be able to provide better insight.

Okay. For small business, you only take loans in the time frame that you are working with, that are reported as small business on schedule RCC-2. This means loans from lines 1e1, 1e2, and 4/4a on schedule RCC-1.

The small business loans are a subset of loans on those lines. Filter for the time frame you want, and remove all that are over $1 million.

Thanks, all. Your responses were very helpful.

To clarify: revenue does not affect the classification as small business. If the loan is the correct type, and is $1 million of less, and revenue is greater than $1 million, the loan will be CRA Type 1 with revenue code 2.