BBHT

Zurück zu Niederlande (De Nederlandsche Bank)

Validierungsregeln – Niederlande (De Nederlandsche Bank)

Gegliedert nach den Abschnitten des Validierungsregeln-Handbuchs, alphabetisch innerhalb jeder Kategorie.

Wertebereich (domain constraint) (53)

  1. dmc0001 - The reporting reference date is always the last day of the month
  2. dmc0002 - Mandatory constraint for a column with Non-applicable allowed: the accumulated changes in…
  3. dmc0003 - Mandatory constraint for a column with Non-applicable allowed: the accumulated impairment…
  4. dmc0004 - Mandatory constraint for a column with Non-applicable allowed: the interest rate must be…
  5. dmc0005 - Mandatory constraint for a column with Non-applicable allowed: the legal final maturity…
  6. dmc0006 - Mandatory constraint for a column with Non-applicable allowed: the maturity date of the…
  7. dmc0007 - Mandatory constraint for a column with Non-applicable allowed: the next interest rate…
  8. dmc0008 - Mandatory constraint for a column with Non-applicable allowed: the date of initiation of…
  9. dmc0009 - Mandatory constraint for a column with Non-applicable allowed: the cumulative recoveries…
  10. dmc0010 - Mandatory constraint for a column with Non-applicable allowed: the provisions associated…
  11. dmc0011 - Mandatory constraint for a column with Non-applicable allowed: accrued interest must be…
  12. dmc0012 - Mandatory constraint for a column with Non-applicable allowed: the interest rate cap must…
  13. dmc0013 - Mandatory constraint for a column with Non-applicable allowed: the interest rate floor…
  14. dmc0014 - Mandatory constraint for attribute 'inception date' of entity type 'contract', it must be…
  15. dmc0015 - Mandatory constraint for attribute 'inception date of the instrument' of entity type…
  16. dmc0016 - Mandatory constraint for attribute 'commitment amount at inception' of entity type…
  17. dmc0017 - Mandatory constraint for attribute 'street' of entity type 'address', it must be reported…
  18. dmc0018 - Mandatory constraint for attribute 'city / town / village' of entity type 'address', it…
  19. dmc0019 - Mandatory constraint for attribute 'postal code' of entity type 'address', it must be…
  20. dmc0020 - Mandatory constraint for attribute 'protection value' of entity type 'protection…
  21. dmc0021 - Mandatory constraint for attribute 'date of protection value' of entity type 'protection…
  22. dmc0022 - Mandatory constraint for attribute 'original protection value' of entity type 'protection…
  23. dmc0023 - Mandatory constraint for attribute 'date of original protection value' of entity type…
  24. dmc0024 - Mandatory constraint for attribute 'protection allocated value' of entity type…
  25. dmc0025 - Mandatory constraint for attribute 'third party priority claims against the protection'…
  26. dmc0026 - Mandatory constraint for attribute 'joint liability amount' of entity type 'joint…
  27. dmc0027 - Mandatory constraint for attribute 'date of the performing status of the instrument' of…
  28. dmc0028 - Mandatory constraint for attribute 'date of the forbearance and renegotiation status' of…
  29. dmc0029 - Mandatory constraint for attribute 'syndicated contract identifier' of entity type…
  30. dmc0030 - Mandatory constraint for attribute 'fair value changes due to changes in credit risk…
  31. dmc0031 - Mandatory constraint for attribute 'end date of interest-only period' of entity type…
  32. dmc0032 - Mandatory constraint for attribute 'date of the default status of the instrument' of…
  33. dmc0033 - Mandatory constraint for attribute 'outstanding nominal amount' of entity type 'financial…
  34. dmc0034 - Mandatory constraint for attribute 'date of the default status of the counterparty' of…
  35. dmc0035 - Mandatory constraint for attribute 'name' of entity type 'foreign counterparty', it must…
  36. dmc0036 - Mandatory constraint for attribute 'address street' of entity type 'foreign…
  37. dmc0037 - Mandatory constraint for attribute 'address city / town / village' of entity type…
  38. dmc0038 - Mandatory constraint for attribute 'address postal code' of entity type 'foreign…
  39. dmc0039 - Mandatory constraint for attribute 'syndicated contract identifier' of entity type…
  40. dmc0040 - Mandatory constraint for attribute 'date of the default status of the counterparty' of…
  41. dmc0041 - Mandatory constraint for attribute 'accumulated write-offs' of entity type 'recognised…
  42. dmc0042 - Mandatory constraint for attribute 'carrying amount' of entity type 'recognised…
  43. dmc0043 - Mandatory constraint for attribute 'off-balance sheet amount' of entity type 'credit card…
  44. dmc0044 - Mandatory constraint for attribute 'off-balance sheet amount' of entity type 'revolving…
  45. dmc0045 - Mandatory constraint for attribute 'off-balance sheet amount' of entity type 'credit…
  46. dmc0046 - Mandatory constraint for attribute 'off-balance sheet amount' of entity type 'current…
  47. dmc0047 - Mandatory constraint for attribute 'arrears for the instrument' of entity type…
  48. dmc0048 - Mandatory constraint for attribute 'date of past due for the instrument' of entity type…
  49. dmc0049 - Mandatory constraint for attribute 'settlement date' of entity type 'drawn instrument'…
  50. dmc0050 - Mandatory constraint for attribute 'transferred amount' of entity type 'drawn…
  51. dmc0051 - Mandatory constraint for attribute 'interest rate spread/margin' of entity type…
  52. dmc0052 - Mandatory constraint for attribute 'real estate collateral location postal code' of…
  53. dmc0053 - address / immovable property dmc0053 postal code conforms to format validates that…

Entitätstyp (entity type constraint) (16)

  1. etc0002 - For each protection received in protection provider-protection received exactly one…
  2. etc0003 - A change in the value reported in the 'default status of the instrument' attribute…
  3. etc0004 - This validation check ensures that a change in the 'performing status of the instrument'…
  4. etc0005 - This validation check ensures that a change in the 'status of forbearance and…
  5. etc0006 - This validation check ensures that a change in the 'default status of the counterparty'…
  6. etc0007 - This validation check ensures that a change in the 'default status of the counterparty'…
  7. etc0008 - This validation check ensures that a change in the 'status of legal proceedings'…
  8. etc0009 - This validation check ensures that a change in the 'enterprise size' attribute has a…
  9. etc0010 - This validation check ensures that the value reported for the 'date of protection value'…
  10. etc0012 - This validation check ensures that the value reported for the 'commitment amount at…
  11. etc0013 - This validation check ensures that the value reported for the 'fair value changes due to…
  12. etc0014 - This validation check ensures that the value reported for the 'type of protection'…
  13. etc0015 - This validation check ensures that the value reported for the 'original protection value'…
  14. etc0016 - This validation check ensures that the value reported for the 'date of original…
  15. etc0040 - This validation check ensures that the value reported for the attribute…
  16. etc0041 - This validation check ensures that the value reported for the attribute 'drawn…

Sonstige Modellbedingung (other model constraint) (70)

  1. omc0005 - Status of legal proceedings is only mandatory when the foreign legal entity is from a…
  2. omc0006 - Date of initiation of legal proceedings is only mandatory when the foreign legal entity…
  3. omc0008 - Enterprise size is only mandatory when the foreign legal entity is from a reporting…
  4. omc0010 - Number of employees is only mandatory when the foreign legal entity is from a reporting…
  5. omc0011 - Balance sheet total is only mandatory when the foreign legal entity is from a reporting…
  6. omc0012 - Economic activity is mandatory when the foreign counterparty is not a reporting agent nor…
  7. omc0013 - This validation check ensures that the values reported for the 'protection value'…
  8. omc0014 - For debit balances on current accounts with no credit limit, the value “Other purposes”…
  9. omc0015 - Debit balances on current account with no credit limit must be reported as “on demand or…
  10. omc0016 - Default status of the counterparty that is both a debtor and a protection provider must…
  11. omc0017 - Date of the default status of the counterparty that is both a debtor and a protection…
  12. omc0018 - Probability of default of the counterparty that is both a debtor and a protection…
  13. omc0019 - Head office undertaking of the counterparty that is both a debtor and a protection…
  14. omc0020 - Annual turnover is only mandatory when the foreign legal entity is from a reporting…
  15. omc0021 - If there is more than one debtor taking part in an instrument, then for each debtor…
  16. omc0022 - If the debtor has at least one instrument that is a recognized instrument, then the…
  17. omc0023 - The settlement date of the instrument must be either on the inception date of the…
  18. omc0029 - Default status of the instrument can only be reported as "Non-applicable" when the…
  19. omc0031 - The reporting reference date must match the date given as the reporting reference date in…
  20. omc0032 - The reporting agent identifier must match the identifier given as the reporting agent…
  21. omc0034 - For each entity type E, the total number of rows of E must correspond to the value of the…
  22. omc0035 - Date of enterprise size is mandatory when at least one of the roles of the counterparty…
  23. omc0036 - NUTS 3 region of the address is mandatory when the foreign counterparty is in a reporting…
  24. omc0037 - If the LEI is supplied and the counterparty is a foreign counterparty, only then the…
  25. omc0042 - If a counterparty is a foreign counterparty and if it is also a legal entity, then that…
  26. omc0043 - If a counterparty is a Dutch counterparty and if it is also a legal entity, then that…
  27. omc0044 - When the debtor is also a legal entity that is situated in a reporting member state, then…
  28. omc0045 - When the debtor is also a legal entity that is situated in a reporting member state, then…
  29. omc0046 - When the protection provider is also a legal entity in a reporting member state, then the…
  30. omc0047 - When the protection provider is also a legal entity in a reporting member state, then the…
  31. omc0048 - The value reported in the 'end date of interest-only period' attribute cannot be earlier…
  32. omc0049 - The value reported in the 'legal final maturity date' attribute cannot be earlier than…
  33. omc0050 - The value reported in the 'legal final maturity date' attribute cannot be earlier than…
  34. omc0052 - The value reported in the 'legal final maturity date' attribute cannot be earlier than…
  35. omc0057 - The value reported in the 'next interest rate reset date' attribute cannot be earlier…
  36. omc0058 - The value reported in the 'date of the default status of the instrument' attribute cannot…
  37. omc0059 - The value reported in the 'date of past due for the instrument' attribute cannot be…
  38. omc0061 - The value reported in the 'next interest rate reset date' attribute cannot be earlier…
  39. omc0062 - The value reported in the 'end date of interest-only period' attribute cannot be earlier…
  40. omc0063 - If a synthetic securitisation has been reported in the 'type of securitisation'…
  41. omc0064 - If a value of the 'default status of the instrument' attribute indicates a default, then…
  42. omc0066 - Checks if the value reported for the 'outstanding nominal amount' attribute is consistent…
  43. omc0067 - Checks if the value reported for the 'date of the performing status of the instrument'…
  44. omc0068 - Checks if the value reported for the 'date of the forbearance and renegotiation status'…
  45. omc0070 - This validation check ensures that the value reported for the 'type of securitisation'…
  46. omc0074 - This validation check ensures that an originating counterparty is reported accordingly…
  47. omc0075 - This validation check ensures that an originating counterparty is reported accordingly…
  48. omc0076 - This validation check ensures that that the same counterparty is not both a creditor and…
  49. omc0077 - This validation check ensures that the same counterparty is not both a creditor and a…
  50. omc0078 - This validation check ensures that the value reported for the 'maturity date of the…
  51. omc0079 - This validation check ensures that the 'outstanding nominal amount' attribute is reported…
  52. omc0081 - This validation check ensures that for instruments which have a positive value reported…
  53. omc0082 - This validation check ensures that the value reported for the 'fiduciary instrument'…
  54. omc0083 - This validation check ensures that the value reported for the 'project finance loan'…
  55. omc0084 - This validation check ensures that the value reported for the 'purpose' attribute is…
  56. omc0085 - This validation check ensures that the value reported for the 'recourse' attribute is…
  57. omc0086 - This validation check ensures that the value reported for the 'repayment rights'…
  58. omc0087 - This validation check ensures that the value reported for the 'settlement date' attribute…
  59. omc0088 - This validation check ensures that the value reported for the 'accumulated changes in…
  60. omc0094 - This validation check ensures that the values reported for the 'default status of the…
  61. omc0096 - This validation check ensures that the values reported for the 'off-balance sheet amount'…
  62. omc0097 - This validation check ensures that the values reported for the 'counterparty identifier'…
  63. omc0098 - National identifier is only allowed to be "Not required", when the value of the attribute…
  64. omc0100 - This validation check ensures that the amount of provisions associated with offbalance…
  65. omc0105 - This business rule validates whether the observed agent is present in the published list…
  66. omc0116 - A validation rule should be added which checks that in case a counterparty is classified…
  67. omc0124 - This validation check ensures that the values reported for the 'counterparty identifier'…
  68. omc0125 - This validation check ensures that the value reported for the attribute 'recognised…
  69. omc0126 - This validation check ensures that the attribute 'instrument'.'commitment amount at…
  70. omc0127 - At least one of the three attributes that indicate the real estate location is reported

Spezialisierung (specialisation model constraint) (24)

  1. spc0001 - Interest-only indicator must correspond to the subtype that is used
  2. spc0002 - Resident counterparty indicator must correspond to the subtype that is used
  3. spc0003 - Legal entity indicator must correspond to the subtype that is used
  4. spc0004 - Foreign branch in reporting member state indicator must correspond to the subtype that is…
  5. spc0005 - National identifier type must correspond to the subtype that is used
  6. spc0006 - Resident legal entity indicator must correspond to the subtype that is used
  7. spc0007 - Foreign legal entity in reporting member state indicator must correspond to the subtype…
  8. spc0008 - Fully derecognised instrument being serviced indicator must correspond to the subtype…
  9. spc0009 - Counterparty role must correspond to the subtype that is used
  10. spc0010 - Credit risk deterioration purchase indicator must correspond to the subtype that is used
  11. spc0011 - Current account type must correspond to the subtype that is used
  12. spc0012 - Enumeration type must correspond to the subtype that is used
  13. spc0013 - Immediate parent undertaking indicator must correspond to the subtype that is used
  14. spc0014 - Immovable property indicator must correspond to the subtype that is used
  15. spc0015 - Immovable property location indicator must correspond to the subtype that is used
  16. spc0016 - Protection provider indicator must correspond to the subtype that is used
  17. spc0017 - Securitized instrument indicator must correspond to the subtype that is used
  18. spc0018 - Syndicated contract indicator must correspond to the subtype that is used
  19. spc0019 - The type of instrument of the instrument of the financial data must correspond to the…
  20. spc0020 - Ultimate parent undertaking indicator must correspond to the subtype that is used
  21. spc0021 - Past due instrument indicator must correspond to the subtype that is used
  22. spc0022 - Impairment assessment method must correspond to the subtype that is used
  23. spc0023 - Drawn instrument indicator must correspond to the subtype that is used
  24. spc0024 - Interest rate type must correspond to the subtype that is used

Tupelbedingung (tuple constraint) (28)

  1. tpc0001 - For fiduciary instruments, the servicer must be a different counterparty than the creditor
  2. tpc0007 - This validation checks if the value reported for the attribute 'collateral located in a…
  3. tpc0010 - This validation check ensures that the value reported for the 'provisions associated with…
  4. tpc0012 - When the amortisation type is - 'French', or - 'Fixed amortisation schedule' Then the…
  5. tpc0013 - The value reported in the 'reporting reference date' attribute cannot be earlier than the…
  6. tpc0014 - The value reported in the 'next interest rate reset date' attribute cannot be earlier…
  7. tpc0015 - The value reported in the 'reference date' attribute cannot be earlier than the value…
  8. tpc0016 - The value reported in the 'reporting reference date' attribute cannot be earlier than the…
  9. tpc0017 - Checks if the value reported for the 'default status of the instrument' attribute is…
  10. tpc0018 - Checks if the value reported for the 'reference date' attribute is consistent with the…
  11. tpc0019 - Checks if the value reported for the 'reference date' attribute is consistent with the…
  12. tpc0020 - This validation check ensures that the value reported for the 'reporting reference date'…
  13. tpc0021 - This validation check ensures that the value reported for the 'reference date' attribute…
  14. tpc0024 - This validation check ensures that the value reported for the 'reporting reference date'…
  15. tpc0025 - This validation check ensures that the value reported for the 'reporting reference date'…
  16. tpc0026 - This validation check ensures that the 'reference date' attribute is consistent with the…
  17. tpc0027 - This validation check ensures that the value reported for the 'date of the default status…
  18. tpc0028 - This validation check ensures that the value reported for the 'date of the default status…
  19. tpc0029 - This validation check ensures that the value reported for the 'accumulated impairment…
  20. tpc0030 - This validation check ensures that the values reported for the 'counterparty identifier'…
  21. tpc0031 - Counterparty tpc0031 national identifier conforms to format business rule validates if…
  22. tpc0032 - Checks if other mandatory indicators are there if the counterparty is NOT "Nonapplicable"…
  23. tpc0038 - Make sure that the value of attribute ‘national identifier type type’ corresponds _ to…
  24. tpc0042 - The value reported in 'drawn instrument'.'settlement date' cannot be later than the value…
  25. tpc0043 - The value reported in the 'protection received'.'date of original protection value'…
  26. tpc0044 - This validation check ensures that the attribute 'financial'.'interest rate' cannot have…
  27. tpc0046 - The reference rate valuess SOFR and €STR are only allowed when the reference rate…
  28. tpc0047 - A region is always part of a country