Partner Program Enrollment Fact Table

Databricks Table Name: Partner_program_enrollment

Column Name	Data Type	Description	Linked Table
auto_update_time_pp_enrollment	bigint	Indicates the date and time when the corresponding enrollment record was last updated at the source in the Unix timestamp format.	date
current_slab_id	bigint	The Unique Identifier for the current slab or tier a customer has achieved within their program enrollment.	_
dim_current_partner_program_tier_expiry_date_id	bigint	The Unique Identifier for the expiry date of the customer's current tier in the partner program.	date
dim_event_date_id	bigint	Date when the customer was enrolled to the partner program.	date
dim_event_program_id	bigint	The Unique Identifier for the specific loyalty program associated with the enrollment event.	program
dim_event_user_id	bigint	The Unique identifier/Customer ID of the user associated with the event. It is an internally assigned value by Capillary for user identification.	users
dim_external_partner_program_id	bigint	The Unique Identifier for an external partner program that is linked to the enrollment.	partner_programs
dim_is_linked_id	bigint	The Unique Identifier that indicates the linkage status, such as whether a card or account is linked and active.	partner_program_is_linked
dim_latest_updated_date_id	bigint	The Unique Identifier for the date when the data for this enrollment record was last changed in the source table.	date
dim_partner_program_id	bigint	The Unique Identifier for the partner program in which the customer is enrolled.	partner_programs
id	bigint	The Unique identifier assigned to the enrollment record. It is the primary key for this table.	_
is_active	boolean	Indicates whether the customer's enrollment in the program is currently active.	_
is_linked	boolean	Indicates whether the customer's account is successfully linked to the partner program.	_
partner_program_membership_id	string	The Unique membership identifier provided by the partner for the enrolled customer.	_