Skip Site Summary NavigationFDIC Home - Federal Deposit Insurance Corporation Stars graphic

Advanced Search
HomeDeposit InsuranceConsumer ProtectionIndustry AnalysisRegulation and ExaminationsAsset SalesNews and EventsAbout FDIC
Skip Navigation RIS Data Warehouse Dictionary
RIS Home RIS Dictionary Data Availability RIS Alert RIS New Variables RIS User Group RIS Tablekey
 
RIS Data Element Definition
RIS Name / Label: SPECGRP  -   Industry Specialization Group
Unique ID Number: 00935     Report: STRU     RIS Database: STRU
Description:
A MUTUALLY EXCLUSIVE INDUSTRY SPECIALIZATION CLASSIFICATION
GROUPING ASSIGNED BY THE DIVISION OF RESEARCH AND
STATISTICS WHICH INDICATES AN INSTITUTIONS PRIMARY
SPECIALIZATION. INDUSTRY SPECIALIZATION GROUPS ARE
AVAILABLE FROM MARCH 1984 (19840331) TO THE PRESENT.

THE CURRENT VALID VALUE RANGE IS 1, 2, 3, 4, 5, 6, 7, 8,
AND 9.

THE SPECGRP VARIABLE IS USED FOR REPORTING PURPOSES WITHIN
DRS.

SPECGRP. - SAS FORMAT FOR SPECIALIZATION GROUP

   . = NOT AVAILABLE
   0 = NO SPECIALIZATION GROUP
   1 = INTERNATIONAL SPECIALIZATION
   2 = AGRICULTURAL SPECIALIZATION
   3 = CREDIT-CARD SPECIALIZATION
   4 = COMMERCIAL LENDING SPECIALIZATION
   5 = MORTGAGE LENDING SPECIALIZATION
   6 = CONSUMER LENDING SPECIALIZATION
   7 = OTHER SPECIALIZED UNDER 1 BILLION
   8 = ALL OTHER UNDER 1 BILLION
   9 = ALL OTHER OVER 1 BILLION
FRB Number:
Repetitions: 01
Sequence: SAVE001: 0
WORK001: F-LNCON + F-LNRERES
WORK002: F-LNCI + F-LNRECONS + LNRENRES + LNREMULT
WORK003: F-ASSETFOR / F-ASSET * 100
WORK004: ( ( F-LNRECONS + F-LNCI + F-LNREMULT + F-LNRENRES ) / F-ASSET ) * 100
WORK005: ( ( F-SCGTY + F-SCCOL + F-SCODPC + F-SCODPI + F-LNRERES ) / F-ASSET ) * 100
WORK006: ( ( F-LNCON + F-LNRERES ) / F-ASSET ) * 100
WORK007: F-LNLSGR / F-ASSET * 100
Decision Logic: DEC001: IF REPDTEYMD > 19840101 AND S-INSTCRCD = 1 THEN 3
DEC002:
IF REPDTEYMD > 19840101 AND WORK003 > 25 AND F-ASSET > 10000000 THEN 1
DEC003:
IF REPDTEYMD > 19840101 AND S-INSTAG = 1 THEN 2
DEC004:
IF REPDTEYMD > 19840101 AND WORK004 > 25 THEN 4
DEC005:
IF REPDTEYMD > 19840101 AND WORK005 > 50 THEN 5
DEC006:
IF REPDTEYMD > 19840101 AND WORK006 > 50 THEN 6
DEC007:
IF REPDTEYMD > 19840101 AND ( WORK007 = 40 OR WORK007 < 40 ) AND F-ASSET < 1000000 THEN 7
DEC008:
IF REPDTEYMD > 19840101 AND ( F-ASSET < 1000000 OR F-ASSET = 1000000 ) THEN 8
DEC009:
IF REPDTEYMD > 19840101 AND F-ASSET > 1000000 THEN 9
Edit Specification:

Last Updated: 1/28/2009 RIS Dictionary Home Questions, Suggestions & Requests

Home    Contact Us    Search    Help    SiteMap    Forms
Freedom of Information Act (FOIA) Service Center    Website Policies    USA.gov
FDIC Office of Inspector General