Add on user membership dimension table
bi_dimaddonusermembership
Field | Description | Field Type | Primary Key |
|---|---|---|---|
adddate | Date on which the corresponding guest is added to the membership. If the same guest is added and removed multiple times from the same membership, this is tracked in different rows in this table. | timestamp without time zone | |
addedbywid | Unique identifier of the employee who added the guest to the membership. | bigint | |
addonusermembershipid | Unique identifier for every membership sold. This is same for both the primary and add-on members belonging to the same membership. This maps to 'user mmebership id' in the Memberships data source. | varchar ( 36 ) | |
addonusermembershipwid | A primary key for this table generated in analytics. | bigint | Yes |
centerwid | Unique identifier of the center where the membership is sold. | bigint | |
dimaddonusermembershipid | A primary key for this table generated in analytics. | integer | |
etlcreateddate | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
isrecordvoided | Indicates whether the corresponding record has a 'voiddate' populated -1: voiddate is populated -0: voiddate is blank | integer | |
membershipcode | Unique identifier for every membership sold. This is same for both the primary and add-on members belonging to the same membership. This is similar to the 'addonusermembershipid' field. | varchar ( 500 ) | |
membershipenddate | Expiry date of the corresponding membership. This remains constant throughout the membership lifecycle. | timestamp without time zone | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
primarymember | Indicates whether the guest is a primary member or an add-on member -1: Primary member -0: Add-on member | integer | |
removedbywid | Unique identifier of the employee who removed the guest from the membership. | bigint | |
userwid | Unique identifier of the guest who belongs to the membership. | bigint | |
void | A field generated for use in analytics. Not relevant for analysis. | integer | |
voiddate | Date on which the corresponding guest is removed from the membership. If the same guest is added and removed multiple times from the same membership, this is tracked in different rows in this table. | timestamp without time zone | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |