Membership recurring statuses log fact table (Redshift)
Table name: Bi_FactRecurringStatusLogDeleted
This table captures recurring membership status transitions and lifecycle details (start/end, cancellation, renewal/upgrade).
Column Name | Column Type |
|---|---|
FactRecurringStatusLogId | BIGINT |
RecurringStatusLogPK | 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 | BIGINT |
UserId | VARCHAR(36) |
OrganizationId | VARCHAR(36) |
MembershipVersionId | VARCHAR(36) |
UpgradeDate | TIMESTAMP |
etlCreatedBy | BIGINT |
etlCreatedDate | TIMESTAMP |
Void | BOOLEAN |
PodName | VARCHAR(20) |