Partner Program Slab History Fact Table
Databricks Table Name: : partner_program_slab_history
Column Name | Data Type | Description | Linked Table |
---|---|---|---|
auto_update_time_pp_slab_history | bigint | Indicates the date and time when the slab change log record was last updated in the source table. It is in the Unix timestamp format. | - |
dim_event_date_id | bigint | Indicates the 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. | program |
dim_event_user_id | bigint | The Unique Identifier/customer ID for the user associated with the slab change event. This is a system-assigned unique ID for the customer. | - |
dim_event_zone_till_id | bigint | The till ID where the slab change transaction occurred. | zone_tills |
dim_external_partner_program_id | integer | The Unique Identifier for the external partner program linked to the slab history. | - |
dim_last_slab_action_id | string | The Unique Identifier for the action associated with the slab change such as tier downgrade, tier upgrade or tier renewal. | - |
dim_latest_updated_date_id | bigint | Indicates the date when the data corresponding to this row was last updated in the source table. | date |
dim_latest_updated_time_id | bigint | Indicates the time when the data corresponding to this row was last updated in the source table. | time |
dim_partner_program_id | integer | The Unique Identifier for the partner program associated with the slab history. | partner_programs |
dim_partner_program_tier_expiry_date_id | bigint | The Unique Identifier for the expiry date of the partner program tier. | - |
id | bigint | The Unique identifier for the slab history record. It is the primary key for this table. | - |
partner_program_tier_id | integer | Indicates the ID of the partner program tier (slab) the customer belongs to in this history record. | - |
year | integer | Indicates the year in which the slab change occurred. | date |
Updated about 6 hours ago