You've exceeded your PM capacity
according to the BOL mail god. So I'll answer your pm here and hope you see it
I think you need to go clean up your mail box. I know I do so I feel your pain!
Rubaiyat
Heh heh, so ya like a challenge do you? Congrats on the change
I think there are two sources on CRA that are the most valuable if you have little or no time to deal with CRA but want to do it well.
First is the OCC's examiners workbook. It details the exam process from beginning to end. If you're not OCC, don't worry. They're the toughest and fairest regulators so if you use this as your bible, it will get you through ANY regulators exam:
http://www.occ.treas.gov/ftp/bulletin/2000-35a.pdfThen there's the Getting it Right book, which is an easy reference book on a day to day basis for CRA data. While the above is a better reference for exams (including data integrity) this is great for the "how" to get the data right:
http://www.ffiec.gov/cra/guide.htmBoth of these books, as well as the call report guidelines, are within arms reach for me at all times. If you read the OCC book first, you'll have a good grasp on the program as a whole though, so I'd recommend that first, then the GIR, then JUST the pages in the call report that pertain to loan definations.
Obviously data integrity is a key area of focus now for you.
Here's my procedures:
I review a 10% sample of all business loans. Note I said business loans, not small business loans. I look at them to see if the reportable deals really are reportable, and then at the non-reportable deals (type 9 etc) to see if they were reportable. I review for the four key fields (Revenue code, Loan Address, Loan Amount and Loan Number) to see if they're right. If any one person or department has error ratios of over 3% in any one of those key fields (for 99% of the banks out there the first two will be your focus) I then review 100% of their loans for accuracy.
I track the reviews and findings to share with senior management, as well as to show the examiners my procedures.
I'd start with these suggestions and move on to the harder stuff later
and I'd highly recommend you try to get sent to a real CRA seminar like the PCI Conference or the San Francisco Fed for a quick upgrade on your learning. PCI is in the fall this year, the Fed isn't until 2006. You'll pick up so much it will be worth the time