Membership status dimension table (Redshift)
Table name: Bi_DimMembershipStatus
Dimension table storing membership status definitions, mapping numeric status codes to human-readable membership and recurring status values. This is a static lookup table populated via seed data.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
MembershipStatusWID | BIGINT IDENTITY | Surrogate warehouse key for the membership status (Primary Key) | PK | ||
Status | INT | Numeric status code identifying the membership state | |||
MembershipStatusValue | VARCHAR(500) | Human-readable label for the membership status | |||
RecurringStatusValue | VARCHAR(500) | Human-readable label for the associated recurring billing status |