We passed over the Large Bank threshold at the end of 2017 and will need to start collecting CRA data next year. Is there a document similar to the HMDA Getting it Right that gives you the codes needed for each field to collect loan level data to eventually report the annual aggregate data? This seems like it would be an easy thing to find but so far I have not had any luck. Any help is much appreciated!
Since your bank will have exceeded the large bank threshold for both 2017 and 2018 it will need to begin collecting data in 2019.
It is possible that you maybe overthinking the issue with the codes. There is no need for a book explaining codes. For small business and small farm loans you only collect:
(1) A unique number or alpha-numeric symbol that can be used to identify the relevant loan file;
(2) The loan amount at origination;
(3) The loan location; and
(4) An indicator whether the loan was to a business or farm with gross annual revenues of $1 million or less.
The FFIEC publishes A Guide to CRA Data Collection and Reporting that may be helpful.