| Home > Industry Analysis > Bank Data & Statistics > RIS Data Warehouse Dictionary Home > RIS Dictionary |
| RIS Data Warehouse Dictionary | | | RIS Dictionary | | | Data Availability | | | RIS Alert | | | RIS New Variables | | | RIS Tablekey |
| RIS Data Element Definition | |
| RIS Name / Label: | NTRTMLGJ - TIME DEP OVER INSURANCE LIMIT Unique ID Number: 02634 Report: RC-E RIS Database: FTS |
| Description: | TIME DEPOSITS OVER THE STANDARD INSURANCE LIMIT HELD IN |
| FRB Number: | RCONJ474 RCON6645 RCON2604 |
| Repetitions: | 01 |
| Sequence: | |
| Decision Logic: | DEC001: U-CALL-FORM = 41 AND REPDTEYMD > 20100101 THEN H-RCONJ474 DEC002: U-CALL-FORM = 41 AND REPDTEYMD > 20010101 AND REPDTEYMD < 20100101 THEN H-TMDEPGT100 DEC003: U-CALL-FORM = 34 AND REPDTEYMD > 19970101 AND REPDTEYMD < 20010101 THEN H-TMDEPGT100 DEC004: U-CALL-FORM = 34 AND REPDTEYMD > 19840101 AND REPDTEYMD < 19970101 THEN H-TMCDS100 + H-TMOPEN100 DEC005: U-CALL-FORM = 33 AND REPDTEYMD > 19970101 AND REPDTEYMD < 20010101 THEN H-TMDEPGT100 DEC006: U-CALL-FORM = 33 AND REPDTEYMD > 19840101 AND REPDTEYMD < 19970101 THEN H-TMCDS100 + H-TMOPEN100 DEC007: U-CALL-FORM = 32 AND REPDTEYMD > 19970101 AND REPDTEYMD < 20010101 THEN H-TMDEPGT100 DEC008: U-CALL-FORM = 32 AND REPDTEYMD > 19840101 AND REPDTEYMD < 19970101 THEN H-TMCDS100 + H-TMOPEN100 DEC009: U-CALL-FORM = 31 AND REPDTEYMD > 20100101 THEN H-RCONJ474 DEC010: U-CALL-FORM = 31 AND REPDTEYMD > 19970101 AND REPDTEYMD < 20100101 THEN H-TMDEPGT100 DEC011: U-CALL-FORM = 31 AND REPDTEYMD > 19840101 AND REPDTEYMD < 19970101 THEN H-TMCDS100 + H-TMOPEN100 DEC012: U-CLASS = 'SI' AND REPDTEYMD > 19860101 AND REPDTEYMD < 19890101 THEN H-TMCDS100 DEC013: DB-FLAG = 'TFR' AND REPDTEYMD > 20100101 THEN T-DI352 DEC014: DB-FLAG = 'TFR' AND REPDTEYMD > 20070101 AND REPDTEYMD < 20100101 THEN T-DI350 DEC015: DB-FLAG = 'TFR' AND REPDTEYMD > 20061001 AND REPDTEYMD < 20070101 THEN T-DI130 + T-DI175 DEC016: DB-FLAG = 'TFR' AND REPDTEYMD > 20040101 AND REPDTEYMD < 20061001 THEN T-DI130 DEC017: DB-FLAG = 'TFR' AND REPDTEYMD > 19960401 AND REPDTEYMD < 20040101 THEN T-SI175 DEC018: DB-FLAG = 'TFR' AND REPDTEYMD > 19840101 AND REPDTEYMD < 19960401 THEN T-SI190 + T-SI200 DEC019: DB-FLAG = 'IBA' AND REPDTEYMD > 19970101 THEN I-RCON2604 DEC020: DB-FLAG = 'IBA' AND REPDTEYMD > 19851001 AND REPDTEYMD < 19970101 THEN I-RCON6645 + I-RCON6646 |
| Edit Specification: | |
| Last Updated: 10/22/2010 | RIS Dictionary Home | Questions, Suggestions & Requests |