Membership dimension table

Bi_DimMembership_s3

membershipName

NVARCHAR(256)

Bi_DimMembership_s3

membershipdays

INT

Bi_DimMembership_s3

SaleStartDate

TIMESTAMP

Bi_DimMembership_s3

SaleEndDate

TIMESTAMP

Bi_DimMembership_s3

MembershipCategoryName

NVARCHAR(800)

Bi_DimMembership_s3

MembershipCategoryDescription

NVARCHAR(4096)

Bi_DimMembership_s3

MembershipDesc

NVARCHAR(4096)

Bi_DimMembership_s3

creationDate

TIMESTAMP

Bi_DimMembership_s3

organizationID

VARCHAR(36)

Bi_DimMembership_s3

CreditAmount

FLOAT

Bi_DimMembership_s3

Active

BOOLEAN

Bi_DimMembership_s3

ComissionEligible

BOOLEAN

Bi_DimMembership_s3

membershipId

VARCHAR(36)

Bi_DimMembership_s3

enddate

TIMESTAMP

Bi_DimMembership_s3

CreditAmountExpiration

BOOLEAN

Bi_DimMembership_s3

NumGuests

INT

Bi_DimMembership_s3

AllowGiftCertificates

BOOLEAN

Bi_DimMembership_s3

DifferentMembershipCode

BOOLEAN

Bi_DimMembership_s3

CommissionFactor

FLOAT

Bi_DimMembership_s3

InitiallyRecognizedAmt

DECIMAL(19,4)

Bi_DimMembership_s3

MonthlyRecognizedAmt

DECIMAL(19,4)

Bi_DimMembership_s3

RestrictPayment

BOOLEAN

Bi_DimMembership_s3

Code

NVARCHAR(128)

Bi_DimMembership_s3

NeedOtpAuthorization

BOOLEAN

Bi_DimMembership_s3

FreeServiceCommissionEligible

BOOLEAN

Bi_DimMembership_s3

DiscountType

INT

Bi_DimMembership_s3

DisplayName

NVARCHAR(256)

Bi_DimMembership_s3

DisplayPrice

NVARCHAR(256)

Bi_DimMembership_s3

ShowPrice

BOOLEAN

Bi_DimMembership_s3

BusinessUnitId

VARCHAR(36)

Bi_DimMembership_s3

ShowFrequencyInWeeks

BOOLEAN

Bi_DimMembership_s3

MembershipMonths

INT

Bi_DimMembership_s3

RecurringType

INT

Bi_DimMembership_s3

CarryoverMembers

BOOLEAN

Bi_DimMembership_s3

RecurringCycle

NVARCHAR(256)

Bi_DimMembership_s3

RecurringCycleType

INT

Bi_DimMembership_s3

LockCycles

INT

Bi_DimMembership_s3

PaymentType

INT

Bi_DimMembership_s3

StartValidityAtFirstRedemption

BOOLEAN

Bi_DimMembership_s3

VisitFrequencyRedemption

INT

Bi_DimMembership_s3

CanBook

BOOLEAN

Bi_DimMembership_s3

MembershipType

INT

Bi_DimMembership_s3

MembershiptypeDisplayValue

NVARCHAR(MAX)

Bi_DimMembership_s3

SetupMembershipId

VARCHAR(36)

Bi_DimMembership_s3

void

BOOLEAN

Bi_DimMembership_s3

TAGS

VARCHAR(MAX)

Bi_DimMembership_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimMembership_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimMembership_s3

PodName

VARCHAR(20)

Bi_DimMembership_s3

groupid

BIGINT