{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Data Dictionary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Data Dictionary","index":0,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["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\nFormat: YYYY-MM-DDT00:00:00","No",null,null,"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",null,null,"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",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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\nFormat: YYYY-MM-DDT00:00:00","No",null,null,"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",null,null,"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",null,null,"No Change"]
["DFAST14A","OPSRISK","OPSRISK_RI","OPSRISKA_Data_Collect_RI","Material Operational Risk Identification",20171231,99991231,"CAORHP08","Material Operational Risks","Text","Varchar (250)","Yes",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"Added"]
["DFAST14A","OPSRISK","OPSRISK_RI","OPSRISKA_Data_Collect_RI","Material Operational Risk Identification",20201231,99991231,"CAORKY35","Loss Estimation Methodology(ies)","Text","Varchar (5000)","No",null,"No",null,null,"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\nExcluded = 2","No",null,null,"No Change"]
["DFAST14A","OPSRISK","OPSRISK_RI","OPSRISKA_Data_Collect_RI","Material Operational Risk Identification",20171231,20200630,"CAORHP09","Risk Name","Text","Varchar (250)","No",null,"No",null,null,"Archived"]
["DFAST14A","OPSRISK","OPSRISK_RI","OPSRISKA_Data_Collect_RI","Material Operational Risk Identification",20171231,20200630,"CAORHP10","Risk Segment","Text","Varchar (250)","No",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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\nFormat: YYYY-MM-DDT00:00:00","No",null,null,"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",null,null,"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",null,null,"No Change"]
["DFAST14A","OPSRISK","OPSRISK_RS","OPSRISKA_Data_Collect_RS","Operational Risk Scenarios",20171231,99991231,"CAORHP13","Operational Risk Scenario Name","Text","Varchar (250)","Yes",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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",null,"No",null,null,"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\nFormat: YYYY-MM-DDT00:00:00","No",null,null,"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",null,null,"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",null,null,"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",null,null,"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",null,null,"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)",null,"No Change"]