Rewards Fact Table

This table captures details of rewards issued to customers. It includes unique identifiers for brands/ organizations, and promotions, points deducted, vouchers issued, and associated expiry dates within the Intouch system.

Databricks Table Name: reward_issue_fact

Reward Issue Fact - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Reward Issue Fact Table

Column Name	Data Type	Description	Linked Table
brand_id	bigint	Unique identifier of the brand.	_
Id	bigint	Unique identifier for the table.	_
intouch_points_deducted	string	Points deducted for the reward in the Intouch system.	_
intouch_user_id	bigint	Intouch user ID of the customer.	_
intouch_voucher	string	Voucher associated with the reward within the Intouch system.	_
intouch_voucher_expiry	string	Date and time for the voucher expiry in the Intouch system.	_
issued_ref_id	string	Reference ID for cart promotion or gift voucher.	_
org_id	bigint	Identifier associated with the org.	_
points_ref_id	bigint	Reference ID for points-related transactions, and is null for transactions that are free or paid with cash.	_
reward_promotion_link_id	bigint	Identifier for the promotion that is linked to the reward.	_
vendor_reward	string	Reward provided by the vendor.	_
dim_catalog_promotion_id	bigint	Identifier for the catalogue promotion.	rewards_catalogue_promotion
dim_event_date_id	bigint	Date when the reward is issued.	date
dim_latest_updated_date_id	bigint	Date when the data corresponding to this event/ row is changed in the source table.	date
dim_latest_updated_time_id	bigint	Time when the data corresponding to this event/ row is changed in the source table.	time
dim_reward_id	bigint	Identifier of the reward.	rewards
dim_reward_issue_update_on_id	bigint	The time at which the reward was issued.	time
year	integer	Year of the reward.	_

LegendPK Primary KeyLK Linking Key

Legend

PK Primary Key

LK Linking Key