Survivorship groups for SAP Reltio's velocity pack for Retail
Learn what survivorship groups are preconfigured in entity types for Reltio for Retail.
The Reltio for Retail data model includes survivorship groups for some entity types which help you define the golden record of any object that your business considers important.
For general information on survivorship, see topic Survivorship groups. For details on the preconfigured entity types that come with Reltio for Retail, see Entity types for SAP Reltio's velocity pack for Retail .
Individual entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Individual entity type.
| Rule attribute | Strategy |
|---|---|
| FirstName | Recency |
| LastName | Recency |
| MiddleName | Recency |
| Name | Recency |
| NamePrefix | Recency |
| NameSuffix | Recency |
| DoB | Recency |
| Gender | Recency |
| MaritalStatus | Recency |
| SSN | Source system |
| SSNLast4 | Source system |
| TaxID | Source system |
| PreferredName | Recency |
| Nickname | Recency |
| IndividualRole | Recency |
| Status | Recency |
| PreferredLanguage | Recency |
| CustomerLifecycleStatus | Recency |
| Ethnicity | Recency |
| ChildrenInHousehold | Recency |
| PersonsInHousehold | Recency |
| DeceasedIndicator | Recency |
| DeleteEntity | Recency |
| Aggregation | |
| Email.Type | Recency |
| Email.Email | Recency |
| Email.Domain | Aggregation |
| Email.DomainType | Aggregation |
| Email.Username | Aggregation |
| Email.Rank | Aggregation |
| Email.ValidationStatus | Aggregation |
| Email.Active | Aggregation |
| Phone | Aggregation |
| Phone.Type | Recency |
| Phone.Number | Recency |
| Phone.CountryCode | Aggregation |
| Phone.FormattedNumber | Recency |
| Phone.Extension | Aggregation |
| Phone.Rank | Aggregation |
| Phone.AreaCode | Aggregation |
| Phone.LocalNumber | Aggregation |
| Phone.ValidationStatus | Aggregation |
| Phone.LineType | Aggregation |
| Phone.FormatMask | Aggregation |
| Phone.DigitCount | Aggregation |
| Phone.GeoArea | Aggregation |
| Phone.GeoCountry | Aggregation |
| Phone.PrimaryPhoneFlag | Aggregation |
| Phone.Active | Aggregation |
| Phone.Unreachable | Aggregation |
| Identifiers | Aggregation |
| Identifiers.Type | Recency |
| Identifiers.Value | Recency |
| Acquisition | Aggregation |
| Acquisition.Source | Recency |
| Acquisition.Date | Recency |
| Acquisition.Channel | Recency |
| PurchaseSummary | Aggregation |
| PurchaseSummary.LastPurchaseDate | Recency |
| PurchaseSummary.TransactionCount | Recency |
| PurchaseSummary.LifetimeValue | Recency |
| Consent | Aggregation |
| Consent.Purpose | Recency |
| Consent.Channel | Recency |
| Consent.Status | Recency |
| Consent.ConsentDate | Recency |
| Consent.WithdrawalDate | Recency |
| Consent.LegalBasis | Recency |
| Consent.OptInMethod | Recency |
| ChannelPreference | Aggregation |
| ChannelPreference.PreferredChannel | Recency |
| ChannelPreference.EmailFrequency | Recency |
| ChannelPreference.SMSOptIn | Recency |
| ChannelPreference.PushOptIn | Recency |
| ChannelPreference.PostalOptIn | Recency |
| ChannelPreference.ContactTimePreference | Recency |
| Address | Aggregation |
| DigitalIdentity | Aggregation |
| DigitalIdentity.Type | Aggregation |
| DigitalIdentity.Value | Aggregation |
| DigitalIdentity.LastSeen | Aggregation |
| DigitalIdentity.Active | Aggregation |
Location entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Location entity type.
| Rule attribute | Strategy |
|---|---|
| AddressLine1 | Recency |
| AddressLine2 | Recency |
| City | Recency |
| StateProvince | Recency |
| PostalCode | Recency |
| PostalCode.PostalCode | Recency |
| PostalCode.Zip5 | Recency |
| PostalCode.Zip4 | Recency |
| Country | Source system |
| VerificationStatus | Recency |
| Neighborhood | Recency |
| County | Recency |
| GeoLocation | Recency |
| GeoLocation.Latitude | Recency |
| GeoLocation.Longitude | Recency |
| GeoLocation.GeoAccuracy | Recency |
Organization entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Organization entity type.
| Rule attribute | Strategy |
|---|---|
| Name | Recency |
| DUNSNumber | Source system |
| LEI | Source system |
| GLN | Source system |
| VATNumber | Source system |
| TaxID | Recency |
| CUSIP | Recency |
| WebsiteURL | Recency |
| Industry | Recency |
| CompanyType | Recency |
| AccountType | Recency |
| BannerBrand | Recency |
| ChannelType | Recency |
| StatusCode | Recency |
| Aggregation | |
| Email.Type | Recency |
| Email.Email | Recency |
| Email.Domain | Aggregation |
| Email.DomainType | Aggregation |
| Email.Username | Aggregation |
| Email.Rank | Aggregation |
| Email.ValidationStatus | Aggregation |
| Email.Active | Aggregation |
| Phone | Aggregation |
| Phone.Type | Recency |
| Phone.Number | Recency |
| Phone.CountryCode | Aggregation |
| Phone.FormattedNumber | Aggregation |
| Phone.Extension | Aggregation |
| Phone.Rank | Aggregation |
| Phone.AreaCode | Aggregation |
| Phone.LocalNumber | Aggregation |
| Phone.ValidationStatus | Aggregation |
| Phone.LineType | Aggregation |
| Phone.FormatMask | Aggregation |
| Phone.DigitCount | Aggregation |
| Phone.GeoArea | Aggregation |
| Phone.GeoCountry | Aggregation |
| Phone.PrimaryPhoneFlag | Aggregation |
| Phone.Active | Aggregation |
| Phone.Unreachable | Aggregation |
| FinancialTerms | Aggregation |
| FinancialTerms.CreditTerms | Recency |
| FinancialTerms.PaymentTerms | Recency |
| FinancialTerms.CreditLimit | Recency |
| FinancialTerms.CreditLimitCurrency | Aggregation |
| DUNSHierarchy | Aggregation |
| DUNSHierarchy.ParentDUNS | Recency |
| DUNSHierarchy.GlobalUltimateDUNS | Recency |
| DUNSHierarchy.HierarchyLevel | Recency |
| Address | Aggregation |
Household entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Household entity type.
| Rule attribute | Strategy |
|---|---|
| HHID | Recency |
| HHName | Recency |
| HHDescription | Recency |
| Address | Aggregation |
LoyaltyProgram entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the LoyaltyProgram entity type.
| Rule attribute | Strategy |
|---|---|
| ProgramName | Recency |
| ProgramType | Recency |
| LoyaltyCurrencyType | Recency |
| StartDate | Recency |
| EndDate | Recency |
| IsActive | Recency |
Store entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Store entity type.
| Rule attribute | Strategy |
|---|---|
| StoreName | Recency |
| StoreNumber | Source system |
| StoreType | Recency |
| BannerBrand | Recency |
| ChannelType | Recency |
| OpenDate | Recency |
| CloseDate | Recency |
| Phone | Recency |
| Phone.Type | Recency |
| Phone.Number | Recency |
| Phone.CountryCode | Recency |
| Phone.FormattedNumber | Recency |
| Phone.Extension | Recency |
| Phone.Rank | Recency |
| Phone.AreaCode | Recency |
| Phone.LocalNumber | Recency |
| Phone.ValidationStatus | Recency |
| Phone.LineType | Recency |
| Phone.FormatMask | Recency |
| Phone.DigitCount | Recency |
| Phone.GeoArea | Recency |
| Phone.GeoCountry | Recency |
| Phone.PrimaryPhoneFlag | Recency |
| Phone.Active | Recency |
| Phone.Unreachable | Recency |
| Status | Recency |
| Territory | Aggregation |
| Territory.Region | Aggregation |
| Territory.District | Aggregation |
| Territory.Zone | Aggregation |
| Address | Aggregation |
| Recency | |
| Email.Type | Recency |
| Email.Email | Recency |
| Email.Domain | Recency |
| Email.DomainType | Recency |
| Email.Username | Recency |
| Email.Rank | Recency |
| Email.ValidationStatus | Recency |
| Email.Active | Recency |
| CompanyCode | Recency |
| DistributionChain | Recency |
| DistributionChain.SalesOrg | Recency |
| DistributionChain.DistributionChannel | Recency |
| DistributionChain.IsPrimary | Recency |
| DistributionChain.ValidFrom | Recency |
| DistributionChain.ValidTo | Recency |
| PurchasingOrgAssignment | Recency |
| PurchasingOrgAssignment.PurchasingOrg | Recency |
| PurchasingOrgAssignment.IsPrimary | Recency |
Product entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Product entity type.
| Rule attribute | Strategy |
|---|---|
| ProductId | Recency |
| ProductName | Recency |
| SKU | Source system |
| UPC | Recency |
| GTIN | Source system |
| Brand | Recency |
| ArticleType | Recency |
| IsPricingReference | Recency |
| IsActive | Recency |
| GPCBrickCode | Recency |
| CountryOfOrigin | Recency |
| UnitOfMeasure | Recency |
| IsHazardous | Recency |
| SeasonalFlag | Recency |
| Pricing | Recency |
| Pricing.PriceType | Recency |
| Pricing.Amount | Recency |
| Pricing.Currency | Recency |
| Pricing.ValidFrom | Recency |
| Pricing.ValidTo | Recency |
| TradeCompliance | Aggregation |
| TradeCompliance.HSCode | Aggregation |
| TradeCompliance.TariffCode | Aggregation |
| TradeCompliance.ExportControlClassification | Aggregation |
| TradeCompliance.DutyRatePercent | Aggregation |
| TradeCompliance.UNNumber | Aggregation |
| TradeCompliance.HazardClass | Aggregation |
| TradeCompliance.PackingGroup | Aggregation |
| TradeCompliance.TransportRegulation | Aggregation |
| TradeCompliance.SDSVersion | Aggregation |
| TradeCompliance.SDSIssueDate | Aggregation |
| TradeCompliance.MarketabilityStatus | Aggregation |
| TradeCompliance.MarketabilityCountry | Aggregation |
| Traceability | Aggregation |
| Traceability.LotNumber | Aggregation |
| Traceability.BatchNumber | Aggregation |
| Traceability.RecallStatus | Aggregation |
| Traceability.RecallDate | Aggregation |
| VariantAxis | Recency |
| VariantAxis.Size | Recency |
| VariantAxis.Colour | Recency |
| PackagingIdentifiers | Recency |
| PackagingIdentifiers.UnitOfMeasure | Recency |
| PackagingIdentifiers.GTIN | Recency |
| PackagingIdentifiers.ConversionFactor | Recency |
| PackagingIdentifiers.IsBaseUoM | Recency |
Promotion entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Promotion entity type.
| Rule attribute | Strategy |
|---|---|
| PromotionName | Recency |
| PromotionType | Recency |
| StartDate | Recency |
| EndDate | Recency |
| IsActive | Recency |
| CouponCode | Recency |
| EligibleChannels | Recency |
| Discount | Aggregation |
| Discount.Value | Recency |
| Discount.Unit | Recency |
| RedemptionLimit | Aggregation |
| RedemptionLimit.PerCustomer | Recency |
| RedemptionLimit.Total | Recency |
Supplier entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Supplier entity type.
| Rule attribute | Strategy |
|---|---|
| SupplierName | Recency |
| SupplierCode | Recency |
| GLN | Source system |
| DUNS | Recency |
| VendorClassification | Recency |
| PaymentTerms | Recency |
| PreferredCurrency | Recency |
| OnboardingStatus | Recency |
| Status | Recency |
| IsOrganizationAccount | Recency |
| Address | Aggregation |
| LeadTimeDays | Recency |
| PerformanceScore | Recency |
| PerformanceScore.Overall | Recency |
| PerformanceScore.Price | Recency |
| PerformanceScore.Quality | Recency |
| PerformanceScore.Delivery | Recency |
| PerformanceScore.Service | Recency |
| PerformanceScore.EvaluatedDate | Recency |
RegulatoryDocument entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the RegulatoryDocument entity type.
| Rule attribute | Strategy |
|---|---|
| RegulationId | Source system |
| Title | Recency |
| RegulationType | Recency |
| Jurisdiction | Recency |
| EffectiveDate | Recency |
| ExpirationDate | Recency |
| IssuingAuthority | Recency |
| Status | Recency |
Warranty entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Warranty entity type.
| Rule attribute | Strategy |
|---|---|
| WarrantyId | Source system |
| WarrantyType | Recency |
| Status | Recency |
| CoverageType | Recency |
| Provider | Recency |
| SerialNumber | Recency |
| StartDate | Recency |
| EndDate | Recency |
| DurationMonths | Recency |
| RegistrationDate | Recency |
| TermsURL | Recency |
Campaign entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the Campaign entity type.
| Rule attribute | Strategy |
|---|---|
| CampaignId | Source system |
| CampaignName | Recency |
| CampaignType | Recency |
| Channel | Recency |
| Objective | Recency |
| StartDate | Recency |
| EndDate | Recency |
| Budget | Recency |
| Status | Recency |
| TargetSegment | Recency |
| Description | Recency |
ProductCategory entity type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the ProductCategory entity type.
| Rule attribute | Strategy |
|---|---|
| CategoryID | Recency |
| Name | Recency |
| Description | Recency |
| ParentCategoryId | Recency |
| HierarchyLevel | Recency |
| GPCBrickCode | Recency |
| SAPCategoryCode | Recency |
| IsNavigational | Recency |
| IsPrimaryCategory | Recency |
| SortOrder | Recency |
| CategoryLanguage | Recency |
| NumberOfProducts | Recency |
| IsActive | Recency |
IndividualHasAddress relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the IndividualHasAddress relationship type.
| Rule attribute | Strategy |
|---|---|
| AddressType | Recency |
| Status | Recency |
| AddressRank | Recency |
| CareOf | Recency |
| Primary | Recency |
| Active | Recency |
| Registered | Recency |
| Business | Recency |
| Residential | Recency |
IndividualEnrolledInLoyaltyPr relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the IndividualEnrolledInLoyaltyPr relationship type.
| Rule attribute | Strategy |
|---|---|
| MembershipNumber | Recency |
| MemberStatus | Recency |
| CurrentTier | Recency |
| PointsBalance | Recency |
| LifetimePoints | Recency |
| LifetimeSpend | Recency |
| TransactionCount | Recency |
| EnrollmentDate | Recency |
| EnrollmentChannel | Recency |
| LastActivityDate | Recency |
| LoyaltyCard | Aggregation |
| LoyaltyCard.Number | Aggregation |
| LoyaltyCard.Type | Aggregation |
| LoyaltyCard.Status | Aggregation |
| LoyaltyCard.IssueDate | Aggregation |
| LoyaltyCard.ExpiryDate | Aggregation |
IndividualOwnsProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the IndividualOwnsProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| PurchaseDate | Recency |
| OwnershipStatus | Recency |
IndividualHoldsWarranty relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the IndividualHoldsWarranty relationship type.
| Rule attribute | Strategy |
|---|---|
| RegistrationDate | Recency |
| ProofOfPurchaseURL | Recency |
OrganizationHasAddress relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationHasAddress relationship type.
| Rule attribute | Strategy |
|---|---|
| AddressType | Recency |
| Status | Recency |
| AddressRank | Recency |
| CareOf | Recency |
| Primary | Recency |
| Active | Recency |
| Registered | Recency |
| Business | Recency |
| Residential | Recency |
OrganizationOperatesStore relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationOperatesStore relationship type.
| Rule attribute | Strategy |
|---|---|
| OperationStartDate | Recency |
| FranchiseAgreementDate | Recency |
OrganizationIndividual relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationIndividual relationship type.
| Rule attribute | Strategy |
|---|---|
| ContactRole | Recency |
| JobTitle | Recency |
| Department | Recency |
| IsPrimaryContact | Recency |
| Status | Recency |
| StartDate | Recency |
| EndDate | Recency |
OrganizationOwnsProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationOwnsProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| PurchaseDate | Recency |
| OwnershipStatus | Recency |
OrganizationHoldsWarranty relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationHoldsWarranty relationship type.
| Rule attribute | Strategy |
|---|---|
| RegistrationDate | Recency |
| ProofOfPurchaseURL | Recency |
OrganizationEnrolledInLoyalty relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the OrganizationEnrolledInLoyalty relationship type.
| Rule attribute | Strategy |
|---|---|
| MembershipNumber | Recency |
| MemberStatus | Recency |
| CurrentTier | Recency |
| PointsBalance | Recency |
| LifetimePoints | Recency |
| LifetimeSpend | Recency |
| LifetimeSpendCurrency | Recency |
| TransactionCount | Recency |
| EnrollmentDate | Recency |
| EnrollmentChannel | Recency |
| LastActivityDate | Recency |
| LoyaltyCard | Aggregation |
| LoyaltyCard.Number | Aggregation |
| LoyaltyCard.Type | Aggregation |
| LoyaltyCard.Status | Aggregation |
| LoyaltyCard.IssueDate | Aggregation |
| LoyaltyCard.ExpiryDate | Aggregation |
HouseholdHasAddress relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the HouseholdHasAddress relationship type.
| Rule attribute | Strategy |
|---|---|
| AddressType | Recency |
| Status | Recency |
| AddressRank | Recency |
| CareOf | Recency |
| Primary | Recency |
| Active | Recency |
| Registered | Recency |
| Business | Recency |
| Residential | Recency |
LoyaltyProgramCoversProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the LoyaltyProgramCoversProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| PointsMultiplier | Recency |
| BonusPoints | Recency |
| EligibilityStartDate | Recency |
| EligibilityEndDate | Recency |
StoreHasAddress relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the StoreHasAddress relationship type.
| Rule attribute | Strategy |
|---|---|
| AddressType | Recency |
| Status | Recency |
| AddressRank | Recency |
| CareOf | Recency |
| Primary | Recency |
| Active | Recency |
| Registered | Recency |
| Business | Recency |
| Residential | Recency |
StoreStocksProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the StoreStocksProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| ListingStatus | Recency |
| ListingStartDate | Recency |
| ListingEndDate | Recency |
| ReorderPoint | Recency |
| SafetyStockQty | Recency |
| MinOrderQty | Recency |
| AssortmentGrade | Recency |
| MRPType | Recency |
| GRProcessingDays | Recency |
ProductHasWarranty relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the ProductHasWarranty relationship type.
| Rule attribute | Strategy |
|---|---|
| CoveredSince | Recency |
ProducttoProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the ProducttoProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| ProductID | Recency |
| BundledProducts | Recency |
| SKU | Recency |
| Brand | Recency |
| SubBrand | Recency |
| GTIN | Recency |
| ProductName | Recency |
| ExpirationDate | Recency |
| Status | Recency |
| VariantType | Recency |
| SequenceNumber | Recency |
| ComponentQuantity | Recency |
PromotionAppliesToProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the PromotionAppliesToProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| Priority | Recency |
| IsFeaturedProduct | Recency |
PromotionValidAtStore relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the PromotionValidAtStore relationship type.
| Rule attribute | Strategy |
|---|---|
| StoreStartDate | Recency |
| StoreEndDate | Recency |
PromotionLinkedToLoyaltyProgr relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the PromotionLinkedToLoyaltyProgr relationship type.
| Rule attribute | Strategy |
|---|---|
| PointsMultiplier | Recency |
| BonusPointsAwarded | Recency |
| TierEligibility | Recency |
SupplierHasAddress relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the SupplierHasAddress relationship type.
| Rule attribute | Strategy |
|---|---|
| AddressType | Recency |
| Status | Recency |
| AddressRank | Recency |
| CareOf | Recency |
| Primary | Recency |
| Active | Recency |
| Registered | Recency |
| Business | Recency |
| Residential | Recency |
SupplierSuppliesProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the SupplierSuppliesProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| ContractedPrice | Recency |
| ContractedPriceCurrency | Recency |
| LeadTimeDays | Recency |
| PreferredSupplierFlag | Recency |
| MinOrderQty | Recency |
CategorytoCategory relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the CategorytoCategory relationship type.
| Rule attribute | Strategy |
|---|---|
| CategoryID | Recency |
| CategoryName | Recency |
| Description | Recency |
| ParentCategoryID | Recency |
| HierarchyLevel | Recency |
| IsActive | Recency |
| StartDate | Recency |
| EndDate | Recency |
CategorytoProduct relationship type survivorship groups
This table identifies the Reltio for Retail default survivorship group for the CategorytoProduct relationship type.
| Rule attribute | Strategy |
|---|---|
| ProductID | Recency |
| ProductName | Recency |
| ProductSKU | Recency |
| CategoryID | Recency |
| CategoryName | Recency |
| CategoryPath | Recency |
| StartDate | Recency |
| EndDate | Recency |