Occ Dfast-14a

Company-Run Annual Stress Test Reporting Template and Documentation for Covered Institutions with Total Consolidated Assets of $250 Billion or More

DFAST14A_2020Q4_OpsRisk_DataDictionary_V1.xls

OCC DFAST-14A

OMB: 1557-0319

Document [xlsx]
Download: xlsx | pdf
Series Schedule Database Table XML Table Worksheet StartDate EndDate Technical Field Name/ MDRM Report Form Line Item Attributes/Format (Date/Text/Numeric) FieldType (DateTime/Varchar/Numeric) Primary Key Item Descriptions Derived Item (Yes/No) Item Derivation Calculation Comments Status
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 D_DT D_DT Date DateTime Yes As-Of date for the reporting quarter
Format: YYYY-MM-DDT00:00:00		 No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 ID_RSSD ID_RSSD Numeric Numeric (7,0) Yes Primary Identifier No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 TRANSTYPE TRANSTYPE Text Varchar (1) No TransType (Insert "I") No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW923 TOTAL LEGAL RESERVE BALANCE AS OF Q4 Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW924 TOTAL LEGAL RESERVE BALANCE Q4 HY1 Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW925 TOTAL LEGAL RESERVE BALANCE Q4 HY2 Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW926 TOTAL LEGAL RESERVE BALANCE Q4 HY3 Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW927 TOTAL LEGAL RESERVE BALANCE Q4 HY4 Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW928 TOTAL REPURCHASE LITIGATION RESERVE BALANCE Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_LR OPSRISKA_Data_Collect_LR Legal Reserves Reporting 20171231 99991231 CAORW929 REPURCHASE LITIGATION RESERVE BALANCE RELATED ONLY TO CONTRACTUAL R&W CLAIMS Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 D_DT D_DT Date DateTime Yes As-Of date for the reporting quarter
Format: YYYY-MM-DDT00:00:00		 No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 ID_RSSD ID_RSSD Numeric Numeric (7,0) Yes Primary Identifier No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 TRANSTYPE TRANSTYPE Text Varchar (1) No TransType (Insert "I") No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 CAORHP08 Material Operational Risks Text Varchar (250) Yes
No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20201231 99991231 CAORMQ53 Brief Description of Material Operational Risk Text Varchar (5000) No
No

Added
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20201231 99991231 CAORKY34 Business Line(s)/Firm-wide Text Varchar (500) No
No

Added
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20201231 99991231 CAORKY35 Loss Estimation Methodology(ies) Text Varchar (5000) No
No

Added
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 CAORHR66 Included/Excluded Numeric Numeric (1,0) Yes Included = 1
Excluded = 2		 No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 20200630 CAORHP09 Risk Name Text Varchar (250) No
No

Archived
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 20200630 CAORHP10 Risk Segment Text Varchar (250) No
No

Archived
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 CAORHP11 Bank Baseline Projection Amount - 9 Quarter Loss Projection Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_RI OPSRISKA_Data_Collect_RI Material Operational Risk Identification 20171231 99991231 CAORHP12 Bank Stress Projection Amount - 9 Quarter Loss Projection Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 D_DT D_DT Date DateTime Yes As-Of date for the reporting quarter
Format: YYYY-MM-DDT00:00:00		 No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 ID_RSSD ID_RSSD Numeric Numeric (7,0) Yes Primary Identifier No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 TRANSTYPE TRANSTYPE Text Varchar (1) No TransType (Insert "I") No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 CAORHP13 Operational Risk Scenario Name Text Varchar (250) Yes
No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 CAORHP14 Operational Risk Bank Baseline 9 Quarter Projection Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 99991231 CAORHP15 Operational Risk Bank Stress 9 Quarter Projection Numeric Numeric (16,6) No
No

No Change
DFAST14A OPSRISK OPSRISK_RS OPSRISKA_Data_Collect_RS Operational Risk Scenarios 20171231 20200630 CAORHP16 Methodology for Applying Operational Risk Scenario Results Text Varchar (max) No
No

Archived
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 D_DT D_DT Date DateTime Yes As-Of date for the reporting quarter
Format: YYYY-MM-DDT00:00:00		 No

No Change
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 ID_RSSD ID_RSSD Numeric Numeric (7,0) Yes Primary Identifier No

No Change
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 TRANSTYPE TRANSTYPE Text Varchar (1) No TransType (Insert "I") No

No Change
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 CCARP006 Scenario Name Text Varchar (50) Yes Value must be "Bank Baseline" or "Bank Stress" No

No Change
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 CAORHR63 Percentage Operational Loss Estimates Numeric Numeric (6,4) No What percentage of the operational loss estimates were generated using scenarios No

No Change
DFAST14A OPSRISK OPSRISK_OL OPSRISKA_Data_Collect_OL Operational Risk Scenarios 20171231 99991231 CAORHR64 Total Operational Risk Scenarios Numeric Numeric (3,0) No Total number of operational risk scenarios used in loss projections Yes Count(CAORHP13)
No Change
File Typeapplication/vnd.ms-excel
File Modified2021-02-24
File Created2017-10-11
© 2024 OMB.report | Privacy Policy