Application Launcher

The following tables outline the join relationships among Summary Entities within the system:

Customer Summary

These entities represent individual master-customer records after the Customer Data Platform (CDP) deduplicated the raw child-customer data.

Entity Name Key Join Join

CUSTOMERSUMMARY

mastercustomerid

customersummary.mastercustomerid=transactionsummary.mastercustomerid

customersummary.mastercustomerid=mastercustomer.mastercustomerid

customersummary.mastercustomerid=
customerfirsttransactionproductcategory.mastercustomerid

customersummary.mastercustomerid=
customerlasttransactionproductcategory.mastercustomerid

customersummary.FirstPromoID=promotiontypesummary.id

customersummary.FirstOfflinePromoID=promotiontypesummary.id

customersummary.closeststoreid=organizationsummary.id

customersummary.primarystoreid=organizationsummary.id

Organization Summary

A list of sales organizations and their associated stores.

Entity Name Key Join Join

ORGANIZATIONSUMMARY

id

transactionsummary.organizationid=organizationsummary.id

Product Summary

A list of products available in the catalog.

Entity Name Key Join Join

PRODUCTSUMMARY

id

productsummary.id=transactionsummary.productid

Product Category Summary

A list of available product categories.

Entity Name Key Join Join

PRODUCTCATEGORYSUMMARY

id

productcategorysummary.id=productcategoryxref.productcategoryid

productcategorysummary.id=customerfirsttransaction
productcategory.productcategoryid

productcategorysummary.id=customerlasttransaction
productcategory.productcategoryid

productcategorysummary.id=event.productcategoryid

Promotion Type Summary

A list of online and offline marketing promotions that influenced transactions.

Entity Name Key Join Join

PROMOTIONTYPESUMMARY

id

promotiontypesummary.id=event.messageid

promotiontypesummary.id=customersummary.FirstPromoID

promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOffline
MarketingTouchIDHousehold

Time Summary

Fiscal calendar mapping for each calendar date enables any datetime attribute to join with the timesummary table to find the corresponding fiscal calendar date. The following are a few examples:

Entity Name Key Join Join

TIMESUMMARY

id

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)

Transaction Summary

Line-level transaction records across all sales channels.

Entity Name Key Join Join

TRANSACTIONSUMMARY

mastercustomerid, customerid, organizationid, productid

transactionsummary.customerid=customer.id

transactionsummary.mastercustomerid=customersummary.mastercustomerid

transactionsummary.organizationid=organization.id

transactionsummary.organizationid=organizationsummary.id

transactionsummary.productid=productsummary.id

The following tables outline the join relationships among Summary Entities within the system:

Customer Summary

These entities represent individual master-customer records after the Customer Data Platform (CDP) deduplicated the raw child-customer data.

Entity Name Key Join Join

CUSTOMERSUMMARY

mastercustomerid

customersummary.mastercustomerid=transactionsummary.mastercustomerid

customersummary.mastercustomerid=mastercustomer.mastercustomerid

customersummary.mastercustomerid=
customerfirsttransactionproductcategory.mastercustomerid

customersummary.mastercustomerid=
customerlasttransactionproductcategory.mastercustomerid

customersummary.FirstPromoID=promotiontypesummary.id

customersummary.FirstOfflinePromoID=promotiontypesummary.id

customersummary.closeststoreid=organizationsummary.id

customersummary.primarystoreid=organizationsummary.id

Organization Summary

The following tables outline the join relationships among Summary Entities within the system:

Customer Summary

These entities represent individual master-customer records after the Customer Data Platform (CDP) deduplicated the raw child-customer data.

Entity Name Key Join Join

CUSTOMERSUMMARY

mastercustomerid

customersummary.mastercustomerid=transactionsummary.mastercustomerid

customersummary.mastercustomerid=mastercustomer.mastercustomerid

customersummary.mastercustomerid=
customerfirsttransactionproductcategory.mastercustomerid

customersummary.mastercustomerid=
customerlasttransactionproductcategory.mastercustomerid

customersummary.FirstPromoID=promotiontypesummary.id

customersummary.FirstOfflinePromoID=promotiontypesummary.id

customersummary.closeststoreid=organizationsummary.id

customersummary.primarystoreid=organizationsummary.id

Organization Summary

A list of sales organizations and their associated stores.

Entity Name Key Join Join

ORGANIZATIONSUMMARY

id

transactionsummary.organizationid=organizationsummary.id

Product Summary

A list of products available in the catalog.

Entity Name Key Join Join

PRODUCTSUMMARY

id

productsummary.id=transactionsummary.productid

Product Category Summary

A list of available product categories.

Entity Name Key Join Join

PRODUCTCATEGORYSUMMARY

id

productcategorysummary.id=productcategoryxref.productcategoryid

productcategorysummary.id=customerfirsttransaction
productcategory.productcategoryid

productcategorysummary.id=customerlasttransaction
productcategory.productcategoryid

productcategorysummary.id=event.productcategoryid

Promotion Type Summary

A list of online and offline marketing promotions that influenced transactions.

Entity Name Key Join Join

PROMOTIONTYPESUMMARY

id

promotiontypesummary.id=event.messageid

promotiontypesummary.id=customersummary.FirstPromoID

promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOffline
MarketingTouchIDHousehold

Time Summary

Fiscal calendar mapping for each calendar date enables any datetime attribute to join with the timesummary table to find the corresponding fiscal calendar date. The following are a few examples:

Entity Name Key Join Join

TIMESUMMARY

id

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)

Transaction Summary

Line-level transaction records across all sales channels.

Entity Name Key Join Join

TRANSACTIONSUMMARY

mastercustomerid, customerid, organizationid, productid

transactionsummary.customerid=customer.id

transactionsummary.mastercustomerid=customersummary.mastercustomerid

transactionsummary.organizationid=organization.id

transactionsummary.organizationid=organizationsummary.id

transactionsummary.productid=productsummary.id

Product Summary

A list of products available in the catalog.

Entity Name Key Join Join

PRODUCTSUMMARY

id

productsummary.id=transactionsummary.productid

Product Category Summary

A list of available product categories.

Entity Name Key Join Join

PRODUCTCATEGORYSUMMARY

id

productcategorysummary.id=productcategoryxref.productcategoryid

productcategorysummary.id=customerfirsttransaction
productcategory.productcategoryid

productcategorysummary.id=customerlasttransaction
productcategory.productcategoryid

productcategorysummary.id=event.productcategoryid

Promotion Type Summary

A list of online and offline marketing promotions that influenced transactions.

Entity Name Key Join Join

PROMOTIONTYPESUMMARY

id

promotiontypesummary.id=event.messageid

promotiontypesummary.id=customersummary.FirstPromoID

promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOffline
MarketingTouchIDHousehold

Time Summary

Fiscal calendar mapping for each calendar date enables any datetime attribute to join with the timesummary table to find the corresponding fiscal calendar date. The following are a few examples:

Entity Name Key Join Join

TIMESUMMARY

id

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)

Transaction Summary

Line-level transaction records across all sales channels.

Entity Name Key Join Join

TRANSACTIONSUMMARY

mastercustomerid, customerid, organizationid, productid

transactionsummary.customerid=customer.id

transactionsummary.mastercustomerid=customersummary.mastercustomerid

transactionsummary.organizationid=organization.id

transactionsummary.organizationid=organizationsummary.id

transactionsummary.productid=productsummary.id

Customer Summary

Organization Summary

Product Summary

Product Category Summary

Promotion Type Summary

Time Summary

Transaction Summary

Customer Summary

Organization Summary

Customer Summary

Organization Summary

Product Summary

Product Category Summary

Promotion Type Summary

Time Summary

Transaction Summary

Product Summary

Product Category Summary

Promotion Type Summary

Time Summary

Transaction Summary

Did not find what you were looking for?

Did not find what you were looking for?