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 2.3.22 household.csv
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. ;"logical_ data_model_code";"entity_type_code";"attribute_cod e";"checksum" 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 attribute_code Variable multibyte (255) 255 code 6 checksum Variable multibyte (255) 255 medium sized string
More Definitions of reporting_reference_date
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 (60) 60 identifier 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 5 address_street Variable multibyte (255) 255 medium sized string 6 address_city_town_village Variable multibyte (255) 255 medium sized string 7 address_postal_code Variable multibyte (20) 20 code 20 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
reporting_reference_date party_id entifier";"type_of_non_natural_person_identifier";"iss uing_country";"registration_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_non_natural_person_identifier Variable multibyte (255) 255 code 5 issuing_country Characters (2) 2 iso 3166 country 6 registration_number Variable characters (64) 64
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 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 country";"protection_provi der_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 (60) 60 identifier domain 2 counterparty_identifier Variable characters (60) 60 identifier domain 3 reporting_reference_date Date reporting reference date 4 country Characters (2) 2 ISO 3166 Country 5 protection_provider_indicator Variable characters (50) 50 protection provider indicator 6 legal_entity_indicator Variable characters (50) 50 legal entity indicator
reporting_reference_date party_id entifier";"structured_address_indicator";"country" 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 structured_address_indicator Variable characters (20) 20 structured address indicator 5 country Characters (2) 2 iso 3166 country
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