Partner Program Slab History Fact Table

Databricks Table Name: : partner_program_slab_history

Column NameData TypeDescriptionLinked Table
auto_update_time_pp_slab_historybigintIndicates 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_idbigintIndicates the the date when the slab change occurred.date
dim_event_program_idintegerThe Unique identifier of the program associated with the customer's slab change.program
dim_event_user_idbigintThe 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_idbigintThe till ID where the slab change transaction occurred.zone_tills
dim_external_partner_program_idintegerThe Unique Identifier for the external partner program linked to the slab history.-
dim_last_slab_action_idstringThe Unique Identifier for the action associated with the slab change such as tier downgrade, tier upgrade or tier renewal.-
dim_latest_updated_date_idbigintIndicates the date when the data corresponding to this row was last updated in the source table.date
dim_latest_updated_time_idbigintIndicates the time when the data corresponding to this row was last updated in the source table.time
dim_partner_program_idintegerThe Unique Identifier for the partner program associated with the slab history.partner_programs
dim_partner_program_tier_expiry_date_idbigintThe Unique Identifier for the expiry date of the partner program tier.-
idbigintThe Unique identifier for the slab history record. It is the primary key for this table.-
partner_program_tier_idintegerIndicates the ID of the partner program tier (slab) the customer belongs to in this history record.-
yearintegerIndicates the year in which the slab change occurred.date