Validation functions for SAP Reltio's velocity pack for Banking
Learn what validation functions are preconfigured in entity types for SAP Reltio's velocity pack for Banking.
The SAP Reltio's velocity pack for Banking data model includes validation functions for some entity types. Use validation functions to ensure data accuracy and improve data quality by checking data ingested into the Reltio platform against a set of validation functions defined for an entity type and then report the correctness of the data.
For general information on validation functions, see Define Data Validation Functions. For details on the preconfigured entity types that come with SAP Reltio's velocity pack for Banking, see Entity types for SAP Reltio's velocity pack for Banking.
Individual entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Individual entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| FirstName | Reports an invalid format if FirstName doesn't match the criteria .*[0-9].*. | First Name Contains Numbers |
| Email.ValidationStatus | Reports an invalid value for Email.ValidationStatus. | Invalid Email Format |
| Phone.ValidationStatus | Reports an invalid value for Phone.ValidationStatus. | Invalid Phone Number |
| LastName | Reports an invalid format if LastName doesn't match the criteria .*[0-9].*. | Last Name Contains Numbers |
| DoD | Reports an invalid date order for DoD based on the configured rule. | Date of birth is later than date of death |
| FirstName | Reports a missing value if FirstName is not provided. | Missing First or Last Name |
| DoB | Reports an invalid value for DoB. | Suspicious Date of Birth |
Organization entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Organization entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| KeyFinancialFiguresOverview.Currency | Reports an invalid format if KeyFinancialFiguresOverview.Currency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| dunsNumber | Reports an invalid format if dunsNumber doesn't match the criteria ^[0-9]{9}$. | DUNS number must be 9 numeric digits |
| Email.ValidationStatus | Reports an invalid value for Email.ValidationStatus. | Invalid Email Format |
| lei | Reports an invalid format if lei doesn't match the criteria ^[A-Z0-9]{20}$. | LEI must be 20 uppercase alphanumeric characters |
| Phone.ValidationStatus | Reports an invalid value for Phone.ValidationStatus. | Invalid Phone Number |
| Name | Reports an invalid format if Name doesn't match the criteria ^.{1,3}$. | Suspiciously Short Name |
Household entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Household entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| TotalHouseholdAssets.Currency | Reports an invalid format if TotalHouseholdAssets.Currency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
FinancialAccount entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the FinancialAccount entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| closingDate | Reports an invalid date order for closingDate based on the configured rule. | Account opening date is later than its closing date |
| balances.currency | Reports an invalid format if balances.currency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| custodianBic | Reports an invalid format if custodianBic doesn't match the criteria ^[A-Z]{4}[A-Z]{2}[A-Z0-9]{2}([A-Z0-9]{3})?$. | BIC must be 8 or 11 characters (ISO 9362) |
| Identifiers.Value | Reports an invalid format if Identifiers.Value doesn't match the criteria ^[A-Z]{2}[0-9]{2}[A-Z0-9]{11,30}$. | IBAN must match ISO 13616 format (15-34 characters) |
| settlementCurrency | Reports an invalid format if settlementCurrency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
Product entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Product entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| currency | Reports an invalid format if currency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| discontinuedDate | Reports an invalid date order for discontinuedDate based on the configured rule. | Product effective date is later than its discontinued date |
Banker entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Banker entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| terminationDate | Reports an invalid date order for terminationDate based on the configured rule. | Hire date is later than the termination date |
Location entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Location entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| GeoLocation.Latitude | Reports an invalid date order for GeoLocation.Latitude based on the configured rule. | Latitude is greater than 90 degrees |
| GeoLocation.Latitude | Reports an invalid value for GeoLocation.Latitude. | Latitude is less than -90 degrees |
| GeoLocation.Longitude | Reports an invalid date order for GeoLocation.Longitude based on the configured rule. | Longitude is greater than 180 degrees |
| GeoLocation.Longitude | Reports an invalid value for GeoLocation.Longitude. | Longitude is less than -180 degrees |
Application entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the Application entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| decisionReason | Reports an invalid value for decisionReason. | Declined applications must record a decisionReason |
| requestedCurrency | Reports an invalid format if requestedCurrency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
BeneficialOwner entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the BeneficialOwner entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| endDate | Reports an invalid date order for endDate based on the configured rule. | Ownership effective date is later than its end date |
| ownershipPercentage | Reports an invalid value for ownershipPercentage. | Ownership percentage must be 0 or higher |
| ownershipPercentage | Reports an invalid date order for ownershipPercentage based on the configured rule. | Ownership percentage must be between 0 and 100 |
| isUltimateBeneficialOwner | Reports an invalid value for isUltimateBeneficialOwner. | UBO flag set below the 25% threshold on this stake alone with no qualifying control type — confirm the designation, including whether the party's other holdings in this company take the total above it |
| votingRights | Reports an invalid value for votingRights. | Voting rights must be 0 or higher |
| votingRights | Reports an invalid date order for votingRights based on the configured rule. | Voting rights must be between 0 and 100 |
ControllingParty entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the ControllingParty entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| controlChainDepth | Reports an invalid value for controlChainDepth. | Control chain depth cannot be negative |
| expirationDate | Reports an invalid date order for expirationDate based on the configured rule. | Control record effective date is later than its expiration date |
| controlPercentage | Reports an invalid value for controlPercentage. | Control percentage must be 0 or higher |
| controlPercentage | Reports an invalid date order for controlPercentage based on the configured rule. | Control percentage must be between 0 and 100 |
| controllingPartyOrganization | Reports an invalid value for controllingPartyOrganization. | Both controllingParty and controllingPartyOrganization are set — a control record names one party, not two |
| controllingParty | Reports a missing value if controllingParty is not provided. | Supply either controllingParty (Individual) or controllingPartyOrganization (Organization) |
| controlChainDepth | Reports an invalid date order for controlChainDepth based on the configured rule. | Control type is DIRECT but the chain depth counts intermediary entities — correct one or the other |
| controlChainDepth | Reports an invalid value for controlChainDepth. | Control type is INDIRECT but the chain depth records no intermediary entities — correct one or the other |
| isUltimateBeneficialOwner | Reports an invalid value for isUltimateBeneficialOwner. | An ultimate beneficial owner is a natural person — clear isUltimateBeneficialOwner or name an Individual in controllingParty |
AccountHolder entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the AccountHolder entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expirationDate | Reports an invalid date order for expirationDate based on the configured rule. | Account holding effective date is later than its expiration date |
| holder | Reports a missing value if holder is not provided. | Supply either holder (Individual) or holderOrganization (Organization) |
| ownershipPercentage | Reports an invalid value for ownershipPercentage. | Ownership percentage must be 0 or higher |
| ownershipPercentage | Reports an invalid date order for ownershipPercentage based on the configured rule. | Ownership percentage must be between 0 and 100 |
AuthorizedSigner entity type validation functions
This table identifies the SAP Reltio's velocity pack for Banking validation functions for the AuthorizedSigner entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expirationDate | Reports an invalid date order for expirationDate based on the configured rule. | Signing authority effective date is later than its expiration date |