Partner Program Slab History Fact Table
Databricks Table Name: supplementary_partner_program_enrollment
| Column Name | Data Type | Description | Linked Table(s) |
|---|---|---|---|
| auto_update_time_supp_pp_enrollment | bigint | Indicates the last update to the loyalty table record in Unix timestamp format. | - |
| dim_event_date_id | bigint | Indicates the date when the slab change occurred. | date |
| dim_event_program_id | Integer | The unique identifier of the program associated with the customer's slab change. | - |
| dim_event_user_id | bigint | The unique identifier/Customer ID of the user, set internally by the Capillary system. | - |
| dim_event_zone_till_id | bigint | The till ID of the terminal within a store, where the slab change occurred. It distinguishes one checkout location from another within the same store | - |
| dim_external_partner_program_id | Integer | Indicates the external partner program associated with the slab history. | - |
| dim_last_slab_action_id | String | The unique identifier of the action associated with the slab change such as tier upgrade, tier renewal and tier upgrade. | - |
| dim_latest_updated_date_id | bigint | The unique identifier of the date when the data for this row was last changed in the source table. | - |
| dim_latest_updated_time_id | bigint | Indicates the time when the data for this row was last changed in the source table in Unix timestamp format. | - |
| dim_partner_program_id | Integer | Indicates dimension ID for the partner program associated with the slab history. | - |
| dim_partner_program_tier_expiry_date_id | Date | Indicates the dimension ID for the partner program tier expiry date. | - |
| id | Bigint | A unique identifier of the table record, set by the Capillary system. | - |
| partner_program_tier_id | int | Indicates the unique identifier of the partner program tier (slab) to which the customer belongs in this history record. | - |
| is_active | boolean | Indicates whether the program is currently active. | program |
| is_linked | boolean | Indicates whether the program is linked. | - |
| year | integer | Indicates the year of the slab history record. | date |
Updated about 6 hours ago