reporting_reference_date. ;"pd_mo del_id";"initial_pd";"regulatory_pd";"regulatory_el";"re gulatory_rwa" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (60) 60 identifier domain 2 obsrvd_agnt_cd Variable characters (60) 60 identifier domain 3 cntrct_id Variable characters (60) 60 identifier domain 4 instrmnt_id Variable characters (60) 60 identifier domain 5 reporting_reference_date Date reporting reference date 6 pd_model_id Variable multibyte (255) 255 medium sized string with unknown 7 initial_pd Decimal (7,0) 7 real number from 0 to 1 with 6 decimals with exclusions 8 regulatory_pd Decimal (7,0) 7 real number from 0 to 1 with 6 decimals with exclusions 9 regulatory_el Decimal (20,0) 20 real number of 20 numbers with 2 decimals with exclusions 10 regulatory_rwa Decimal (20,0) 20 real number of 20 numbers with 2 decimals with exclusions
reporting_reference_date name";"address_street";" address_city_town_village";"address_postal_code";" address_country";"institutional_sector";"nace_code" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 name Variable multibyte (1024) 1024 large sized string with unknown 5 address_street Variable multibyte (255) 255 medium sized string with unknown 6 address_city_town_village Variable multibyte (255) 255 medium sized string with unknown 7 address_postal_code Variable multibyte (20) 20 postal code with exclusions 8 address_country Characters (2) 2 ISO 3166 Country 9 institutional_sector Variable multibyte (255) 255 code 10 nace_code Variable characters (5) 5 xxxx code 2.4.23 foreign_counterparty_with_other_national_identifier.csv
reporting_reference_date. ;"logical_ data_model_code";"entity_type_code";"checksum";"r owcount" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 bank_identifier Variable characters (20) 20 2 reporting_reference_date Date reporting reference date 3 logical_data_model_code Variable multibyte (255) 255 code 4 entity_type_code Variable multibyte (255) 255 code 5 checksum Variable multibyte (255) 255 medium sized string 6 rowcount Integer
More Definitions of reporting_reference_date
reporting_reference_date immediate_parent_undert aking_identifier";"ultimate_parent_undertaking_identif ier" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 immediate_parent_undertaking_identifier Variable characters (60) 60 identifier domain 5 ultimate_parent_undertaking_identifier Variable characters (60) 60 identifier domain 2.4.42 protection_provider_default_data.csv 1 "reporting_agent_identifier";"obsrvd_agnt_cd";"count erparty_identifier";"reporting_reference_date";"crdt_q lty_dflt_stts_ancrdt_cllctn_code";"dt_dflt_stts" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 obsrvd_agnt_cd Variable characters (50) 50 riad counterparty domain 3 counterparty_identifier Variable characters (60) 60 identifier domain 4 reporting_reference_date Date reporting reference date 5 crdt_qlty_dflt_stts_ancrdt_cllctn_code Variable multibyte (255) 255 code 6 dt_dflt_stts Date date with exclusions
reporting_reference_date. ;"national_identifier_type_t ype";"national_identifier_type_country";"national_ide ntifier";"lei";"protection_provider_indicator";"resident_ counterparty_indicator";"legal_entity_indicator" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 national_identifier_type_type Variable multibyte (255) 255 medium sized string 5 national_identifier_type_country Characters (2) 2 ISO 3166 Country 6 national_identifier Variable characters (50) 50 national identifier domain with exclusions 7 lei Variable characters (20) 20 string with strictly 20 characters with unknown 8 protection_provider_indicator Variable characters (50) 50 protection provider indicator 9 resident_counterparty_indicator Variable characters (50) 50 resident counterparty indicator 10 legal_entity_indicator Variable characters (50) 50 legal entity indicator
reporting_reference_date otstnd ng_nmnl_amnt";"bwdpt_amnt";"periodic_repayment_ due";"periodic_interest_payment_due";"next_intrst_rt _reset_dt";"cumulative_repayments";"cumulative_pre payments";"annlsd_agrd_rt";"accrued_interest";"exit_ status";"dflt_stts";"securitized_instrument_indicator";" past_due_instrument_indicator" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (60) 60 identifier domain 2 obsrvd_agnt_cd Variable characters (60) 60 identifier domain 3 cntrct_id Variable characters (60) 60 identifier domain 4 instrmnt_id Variable characters (60) 60 identifier domain 5 reporting_reference_date Date reporting reference date 6 otstndng_nmnl_amnt Decimal (12,0) 12 euro amount (non-negative) with unknown 7 bwdpt_amnt Decimal (12,0) 12 euro amount (non-negative) with exclusions 8 periodic_repayment_due Decimal (12,0) 12 euro amount (non-negative) with unknown 9 periodic_interest_payment_due Decimal (12,0) 12 euro amount (non-negative) with unknown 10 next_intrst_rt_reset_dt Date date with exclusions 11 cumulative_repayments Decimal (12,0) 12 euro amount (non-negative) with unknown 12 cumulative_prepayments Decimal (12,0) 12 euro amount (non-negative) with unknown 13 annlsd_agrd_rt Decimal (12,0) 12 real number (positive or negative) with exclusions 14 accrued_interest Decimal (12,0) 12 euro amount (positive and negative) with unknown 15 exit_status Variable multibyte (255) 255 code 16 dflt_stts Variable multibyte (255) 255 code 17 securitized_instrument_indicator Variable characters (50) 50 securitisation indicator 18 past_due_instrument_indicator Variable characters (50) 50 past due instrument indicator
reporting_reference_date status_of_legal_proceedi ngs";"date_of_initiation_of_legal_proceedings";"es_c ode";"legal_form";"foreign_legal_entity_in_reporting_ member_state_indicator" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 status_of_legal_proceedings Variable multibyte (255) 255 code 5 date_of_initiation_of_legal_proceedings Date date with exclusions 6 es_code Variable multibyte (255) 255 code 7 legal_form Variable multibyte (255) 255 code 8 foreign_legal_entity_in_reporting_member _state_indicator Variable characters (75) 75 foreign legal entity in reporting member state indicator
reporting_reference_date party_id entifier";"type_of_natural_person_identifier";"issuing_ country";"identification_number" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 bank_identifier Variable characters (20) 20 2 reporting_reference_date Date reporting reference date 3 party_identifier Variable characters (34) 34 4 type_of_natural_person_identifier Variable multibyte (255) 255 code 5 issuing_country Characters (2) 2 iso 3166 country 6 identification_number Variable characters (20) 20
reporting_reference_date immediate_parent_undert aking_indicator";"ultimate_parent_undertaking_indica tor";"resident_legal_entity_indicator" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 immediate_parent_undertaking_indicator Variable characters (50) 50 immediate parent undertaking indicator 5 ultimate_parent_undertaking_indicator Variable characters (50) 50 ultimate parent undertaking indicator 6 resident_legal_entity_indicator Variable characters (50) 50 resident legal entity indicator
reporting_reference_date date_of_enterprise_size"; "number_of_employees";"balance_sheet_total";"xxx ual_turnover" Alpha-numeric Semicolon-separated string of all column names. Field names are put in double quotation marks. 1 reporting_agent_identifier Variable characters (50) 50 riad counterparty domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 date_of_enterprise_size Date date with unknown 5 number_of_employees Decimal (12,0) 12 real number (non-negative) with exclusions 6 balance_sheet_total Decimal (16,0) 16 euro amount (non-negative) with unknown 7 annual_turnover Decimal (16,0) 16 euro amount (positive and negative) with unknown