Membership user dimension table

Bi_DimMembershipUser_s3

UserId

VARCHAR(36)

Bi_DimMembershipUser_s3

MembershipId

VARCHAR(36)

Bi_DimMembershipUser_s3

CreationDate

TIMESTAMP

Bi_DimMembershipUser_s3

StartDate

TIMESTAMP

Bi_DimMembershipUser_s3

EndDate

TIMESTAMP

Bi_DimMembershipUser_s3

Void

BOOLEAN

Bi_DimMembershipUser_s3

CreditAmount

FLOAT

Bi_DimMembershipUser_s3

invoiceid

VARCHAR(36)

Bi_DimMembershipUser_s3

TransactionInvoiceNo

NVARCHAR(128)

Bi_DimMembershipUser_s3

SubscriptionStatus

INT

Bi_DimMembershipUser_s3

SubscriptionSource

INT

Bi_DimMembershipUser_s3

CancelledDate

TIMESTAMP

Bi_DimMembershipUser_s3

Recurring

INT

Bi_DimMembershipUser_s3

CancellationSource

NVARCHAR(128)

Bi_DimMembershipUser_s3

FirstSale

BOOLEAN

Bi_DimMembershipUser_s3

Closed

BOOLEAN

Bi_DimMembershipUser_s3

ClosedBy

VARCHAR(36)

Bi_DimMembershipUser_s3

ClosedOn

TIMESTAMP

Bi_DimMembershipUser_s3

ClosedInvoice

VARCHAR(36)

Bi_DimMembershipUser_s3

GroupUserMembershipid

VARCHAR(36)

Bi_DimMembershipUser_s3

RecurrenceOrder

INT

Bi_DimMembershipUser_s3

MembershipStatus

INT

Bi_DimMembershipUser_s3

AcceptedOn

TIMESTAMP

Bi_DimMembershipUser_s3

AcceptedFromIP

NVARCHAR(1024)

Bi_DimMembershipUser_s3

CancelledBy

VARCHAR(36)

Bi_DimMembershipUser_s3

NoOfCyclesPaid

INT

Bi_DimMembershipUser_s3

RenewalMembershipId

VARCHAR(36)

Bi_DimMembershipUser_s3

PreviousUserMembershipId

VARCHAR(36)

Bi_DimMembershipUser_s3

ChildInvoiceId

VARCHAR(36)

Bi_DimMembershipUser_s3

RedeemPostExpiry

BOOLEAN

Bi_DimMembershipUser_s3

ServiceCreditAmt

FLOAT

Bi_DimMembershipUser_s3

ProductCreditAmt

FLOAT

Bi_DimMembershipUser_s3

OtherCreditAmt

FLOAT

Bi_DimMembershipUser_s3

RenewMembershipAmount

FLOAT

Bi_DimMembershipUser_s3

RenewalDiscountAppliedBy

VARCHAR(36)

Bi_DimMembershipUser_s3

RenewalDiscountAppliedOn

TIMESTAMP

Bi_DimMembershipUser_s3

NumVisits

INT

Bi_DimMembershipUser_s3

SaleCenterId

VARCHAR(36)

Bi_DimMembershipUser_s3

OrganizationId

VARCHAR(36)

Bi_DimMembershipUser_s3

MembershipName

NVARCHAR(256)

Bi_DimMembershipUser_s3

Code

NVARCHAR(128)

Bi_DimMembershipUser_s3

DisplayPrice

NVARCHAR(256)

Bi_DimMembershipUser_s3

BusinessUnitId

VARCHAR(36)

Bi_DimMembershipUser_s3

FirstName

NVARCHAR(160)

Bi_DimMembershipUser_s3

LastName

NVARCHAR(256)

Bi_DimMembershipUser_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimMembershipUser_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimMembershipUser_s3

PodName

VARCHAR(20)

Bi_DimMembershipUser_s3

CenterId

VARCHAR(36)

Bi_DimMembershipUser_s3

primarypaymenttype

NVARCHAR(800)

Bi_DimMembershipUser_s3

primarypaymentbrand

NVARCHAR(256)

Bi_DimMembershipUser_s3

backuppaymenttype

NVARCHAR(800)

Bi_DimMembershipUser_s3

backuppaymentbrand

NVARCHAR(256)

Bi_DimMembershipUser_s3

groupid

BIGINT

Bi_DimMembershipUser_s3

primarypaymentcardtype

varchar(50)

Bi_DimMembershipUser_s3

backuppaymentcardtype

varchar(50)

Bi_DimMembershipUser_s3

isprimarycardfromvault

boolean

Bi_DimMembershipUser_s3

isbackupcardfromvault

boolean

Bi_DimMembershipUser_s3

primaryisscotiasupported

boolean

Bi_DimMembershipUser_s3

backupisscotiasupported

boolean

Bi_DimMembershipUser_s3

paymentamount

float

Bi_DimMembershipUser_s3

discountamount

float

Bi_DimMembershipUser_s3

taxamount

float

Bi_DimMembershipUser_s3

annualfeeamount

float

Bi_DimMembershipUser_s3

annualfeediscount

float

Bi_DimMembershipUser_s3

annualfeetaxamount

float

Bi_DimMembershipUser_s3

cancellationinitiatedon

timestamp

Bi_DimMembershipUser_s3

graceperioddate

timestamp