Membership status fact table
Bi_FactMembershipStatusLog_s3
Field | Field Type |
|---|---|
FactMembershipStatusLogId | BIGINT |
MembershipStatusLogPK | BIGINT |
UserMembershipPK | BIGINT |
Status | INT |
StartDate | TIMESTAMP |
ChangedTo | INT |
Comments | NVARCHAR(65535) |
EndDate | TIMESTAMP |
StartedManually | BOOLEAN |
EndedManually | BOOLEAN |
CreatedDate | TIMESTAMP |
IsCurrentRecord | BOOLEAN |
Source | INT |
MembershipStartDate | DATE |
MembershipEndDate | DATE |
CancellationDate | TIMESTAMP |
UserMembershipId | VARCHAR(36) |
CenterId | VARCHAR(36) |
RenewedFromUMId | VARCHAR(36) |
RenewedToUMId | VARCHAR(36) |
CancellationReasonFK | BIGINT |
GroupId | DECIMAL(190) |
UserId | VARCHAR(36) |
OrganizationId | VARCHAR(36) |
MembershipVersionId | VARCHAR(36) |
UpgradeDate | TIMESTAMP |
etlCreatedBy | DECIMAL(190) |
etlCreatedDate | TIMESTAMP |
Void | BOOLEAN |
PodName | VARCHAR(20) |