Membership transfers fact table
bi_factmembershiptransfers_s3
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field | |
|---|---|---|---|---|---|
factmembershiptransferid | Unique identifier for the row in the table. | BIGINT | yes | ||
usermembershipid | Unique identifier of the membership sold to user. Unique for a member and membership | VARCHAR(36) | |||
invoiceid | unique identifier for the invoice | VARCHAR(36) | |||
transfereddate | date on which membership is transferred | TIMESTAMP | |||
transfertocenterid | center to which membership is transferred | VARCHAR(36) | bi_dimcenter centerid | ||
salecenterid | center at which sale is made | VARCHAR(36) | bi_dimcenter centerid | ||
membershipversionid | unique identifier for the membership that is transferred | VARCHAR(36) | |||
price | price to transfer membership | FLOAT | |||
isdiscount | indicates if there is a discount on the membership transfer price | BOOLEAN | |||
transferredbyid | userwid of the employee who transferred the membership | VARCHAR(36) | |||
actualnextcollectiondate | next collection date if membership is not transferred | TIMESTAMP | |||
nextcollectiondate | next collection date after membership is transferred | TIMESTAMP | |||
recurringenddate | date on which recurring membership ends | TIMESTAMP | |||
comments | employee comments when transferring the membership | VARCHAR(MAX) | |||
updatedinvoiceid | Invoice id that got created in the new center | VARCHAR(36) | |||
updatedusermembershipid | New membership user that got generated in the new center | VARCHAR(36) | |||
active | indicates if membership is active | BOOLEAN | |||
etlcreateddate | Date and Time on which row is created | TIMESTAMP | |||
etlcreatedby | System user which created the row. Internal to Zenoti | BIGINT | |||
etllastupdatedon | Date and Time on which row is updated | TIMESTAMP | |||
void | Indicates if row is void or not. 0-active, 1- void | BOOLEAN | |||
podname | Identifer for the region customer belongs to. Internal to Zenoti | VARCHAR(200) | |||
organizationid | Unique identifier for the organization | VARCHAR(36) | bi_dimcenter organizationid | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||