Fact & Dimension Tables in EI

Bill LineItems Fact Table
Column Descriptionbill_discountThe total bill level discount provided for a transactionbill_idA unique id generated for the bill internally by capillary syst...
Wed, 22 May, 2019 at 3:16 PM
Return Bill Lineitem Fact Table
Column Descriptionbill_amountThe net bill amount after returning a purchase - Bill amount - the cost of return itembill_idThe unique id generated for a parti...
Wed, 22 May, 2019 at 3:26 PM
Points Fact Table
Points are a type of incentives issued to customers as a part of loyalty or promotion. This table consists of columns related to points.  ColumnDescripti...
Tue, 21 May, 2019 at 11:06 AM
Customer Summary Fact Table
Column Descriptionaverage_spent_per_skuThis is average amount of money a customer spends on a single quantity of product purchased in its lifetime with the b...
Tue, 21 May, 2019 at 11:07 AM
Response Info Fact Table
Column DescriptionBill AmountThe amount of the bill which has been made by the target customerBill DiscountDenotes the discount availed by the target custome...
Wed, 22 May, 2019 at 5:07 PM
Date Dimension Table
ColumnDescriptiondate_idUnique identifier of a date in the tabledateRepresents date in the format of DD-MM-YYYY. For example, 2018-01-01day_of_monthStands fo...
Tue, 21 May, 2019 at 11:09 AM
Zone_Till Dimension Table
Column Descriptiontill_idDenotes point of sale identifiertillPoint of sale nametypeIf general the store is a genuine data contributing store, if admin the st...
Tue, 21 May, 2019 at 11:08 AM
Contact_Info
Column Descriptionmessage_countSum of credits used for the individual communicationmsg_id This is the template id generated for each message template of a ca...
Thu, 23 May, 2019 at 11:34 AM
Campaign Group Dimension Table
Column Descriptionis_recurringIf yes, the campaign belong to a repeat occurring campaign who audience group is auto generated by system from time to timename...
Tue, 21 May, 2019 at 11:08 AM
Delivery Status Dimension Table
Column DescriptionidIt is the campaign delivery status that gets mapped to dim_campaign_delivery_status_id of the contact and response tables nsadmin_deliver...
Tue, 21 May, 2019 at 11:08 AM