Membership status fact table
Bi_FactMembershipStatusLog
Field | Field Type | Primary Key |
|---|---|---|
FactMembershipStatusLogWID | BIGINT IDENTITY NOT NULL | Yes |
FactMembershipStatusLogId | bigint | |
MembershipStatusLogPK | bigint | |
UserMembershipPK | bigint | |
Status | int | |
StartDate | TIMESTAMP | |
ChangedTo | int | |
Comments | varchar(65535) | |
EndDate | TIMESTAMP | |
StartedManually | boolean | |
EndedManually | boolean | |
CreatedDate | TIMESTAMP | |
IsCurrentRecord | boolean | |
Source | int | |
MembershipStartDate | date | |
MembershipEndDate | date | |
CancellationDate | TIMESTAMP | |
usermembershipwid | BIGINT | |
CenterWId | BIGINT | |
RenewedFromUMId | varchar(36) | |
RenewedToUMId | varchar(36) | |
CancellationReasonFK | bigint | |
GroupId | bigint | |
UserWId | BIGINT | |
OrganizationId | varchar(36) | |
membershipversionwid | BIGINT | |
UpgradeDate | TIMESTAMP | |
etlCreatedBy | bigint | |
etlCreatedDate | TIMESTAMP | |
podname | VARCHAR(100) | |
void | INT | |
EtlLastUpdatedOn | TIMESTAMP DEFAULT convert_timezone('UTC'sysdate) | |
EtlLastUpdatedBy | VARCHAR(50) DEFAULT current_user |