|
|||||||||||||
RIS Data Warehouse Dictionary | ||||||
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 |
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 |