## Entity residential real estate purchase purpose instrument

### Details of entity residential real estate purchase purpose instrument

Name | residential real estate purchase purpose instrument
Code | rre_purchase_purpose_instrument
Parent | Logical Data Model 'RRE DDA PER BANK LDM'
Comment | Residential real estate purchase purpose instrument indicates an instrument whose purpose is the financing of residential property.
Parent Entity | instrument

### List of attributes of the entity residential real estate purchase purpose instrument

Name | Code | Comment | Data Type | Domain | Mandatory | Primary Identifier | Foreign Identifier | Keywords
reporting agent identifier | reporting_agent_identifier | Reporting agent identifier is a number, assigned by De Nederlandsche Bank, that uniquely identifies the reporting agent. | Variable characters (60) | identifier domain | X | X |  |
observed agent identifier | obsrvd_agnt_cd | Observed agent identifier is a number, assigned by De Nederlandsche Bank, that uniquely identifies the observed agent. | Variable characters (60) | identifier domain | X | X |  |
contract identifier | cntrct_id | An identifier applied by the reporting agent to uniquely identify each contract. Each contract must have one contract identifier. This value will not change over time and cannot be used as the contract identifier for any other contract. Each contract identifier must be unique for each contract that generates credit risk for the same observed agent. This identifier must not be reused at any point in time to identify a different contract with the same observed agent. | Variable characters (60) | identifier domain | X | X |  |
instrument identifier | instrmnt_id | An identifier applied by the reporting agent to uniquely identify each instrument under a single contract. Each instrument must have one instrument identifier. This value will not change over time and cannot be used as the instrument identifier for any other instrument under the same contract. Each instrument identifier must be unique for each contract, i.e. all instruments embedded in a single contract are to be assigned a different instrument identifier, and these must not be reused at any point in time to identify a different instrument within the contract. However, instruments associated with different contracts may use the same identifier. | Variable characters (60) | identifier domain | X | X |  |
reporting reference date | reporting_reference_date | reporting reference date is a date that indicates the date the entity type delivery pertains to. Defined as yyyy-mm-dd. | Date | reporting reference date | X | X |  |
residential real estate purchase purpose | rre_purchase_purpose | The attribute “residential real estate purchase purpose” indicates the financing of residential property. | Variable multibyte (255) | code | X |  | X |
explain for ltv above legal norm at inception | explain_for_ltv_above_legal_norm_at_inception | Explain for LTV above legal norm at inception indicates the type of legal exception used by the observed agent to grant an instrument with purpose is residential real estate (RRE) purchase when loan-to-value (LTV) exceeds the legal norm. | Variable multibyte (255) | code | X |  | X | to_be_phased_out
explain for lti above legal norm at inception | explain_for_lti_above_legal_norm_at_inception | Explain for LTI above legal norm at inception indicates the type of legal exception used by the observed agent to grant an instrument with purpose residential real estate (RRE) purchase when the loan-to-income (LTI) exceeds the legal norm | Variable multibyte (255) | code | X |  | X |
mortgage tax rebate | mortgage_tax_rebate | Mortgage tax rebate indicates whether an instrument with purpose residential real estate (RRE) purchase qualifies for mortgage interest relief (hypotheekrenteaftrek). | Variable multibyte (255) | code | X |  | X | to_be_phased_out
type of selling channel of mortgage loan | type_of_selling_channel_of_mortgage_loan | Selling channel of mortgage loan indicates the channel used by the observed agent for granting an instrument with purpose residential real estate (RRE) purchase to the debtor. | Variable multibyte (255) | code | X |  | X | to_be_phased_out

### List of relationships of the entity residential real estate purchase purpose instrument

Name | Code | Generate | Entity 2 | Entity 1 | Dependent Role | Entity 1 -> Entity 2 Role Cardinality | Entity 2 -> Entity 1 Role Cardinality
classifies | mortgage_tax_rebate_classifies_residential_real_estate_purchase_instrument | X | residential real estate purchase purpose instrument | mortgage tax rebate |  | 0,n | 1,1
classifies | type_of_selling_channel_of_mortgage_loan_classifies_residential_real_estate_purchase_instrument | X | residential real estate purchase purpose instrument | type of selling channel of mortgage loan |  | 0,n | 1,1
classifies | type_of_explain_for_lti_above_legal_norm_classifies_residential_real_estate_purchase_instrument | X | residential real estate purchase purpose instrument | type of explain for lti above legal norm |  | 0,n | 1,1
classifies | residential_real_estate_purpose_classifies_residential_real_estate_purchase_instrument | X | residential real estate purchase purpose instrument | residential real estate purpose |  | 0,n | 1,1
classifies | type_of_explain_for_ltv_above_legal_norm_classifies_residential_real_estate_purchase_instrument | X | residential real estate purchase purpose instrument | type of explain for ltv above legal norm |  | 0,n | 1,1

### List of parents of the entity residential real estate purchase purpose instrument

Parent | Parent Entity Code
Logical Data Model 'RRE DDA PER BANK LDM' | instrument

### List of identifiers of the entity residential real estate purchase purpose instrument

Name | Code | Parent | Primary Identifier
residential real estate purchase instrument PK | instrument_pk | Entity 'residential real estate purchase purpose instrument' | X

Previous
Home
Next