Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimAddOnUserMembership_s3 | DimAddOnUserMembershipId | DECIMAL(19) | PK | ||
Bi_DimAddOnUserMembership_s3 | UserId | NVARCHAR(MAX) | |||
Bi_DimAddOnUserMembership_s3 | CenterId | NVARCHAR(MAX) | |||
Bi_DimAddOnUserMembership_s3 | AddOnUserMembershipId | VARCHAR(36) | |||
Bi_DimAddOnUserMembership_s3 | VoidDate | TIMESTAMP | |||
Bi_DimAddOnUserMembership_s3 | AddDate | TIMESTAMP | |||
Bi_DimAddOnUserMembership_s3 | MembershipCode | NVARCHAR(640) | |||
Bi_DimAddOnUserMembership_s3 | AddedBy | NVARCHAR(MAX) | |||
Bi_DimAddOnUserMembership_s3 | RemovedBy | NVARCHAR(MAX) | |||
Bi_DimAddOnUserMembership_s3 | IsRecordVoided | INT | |||
Bi_DimAddOnUserMembership_s3 | PrimaryMember | INT | |||
Bi_DimAddOnUserMembership_s3 | ETLCreatedDate | TIMESTAMP | |||
Bi_DimAddOnUserMembership_s3 | MembershipEndDate | TIMESTAMP | |||
Bi_DimAddOnUserMembership_s3 | Void | BOOLEAN | |||
Bi_DimAddOnUserMembership_s3 | PodName | VARCHAR(20) | |||
Bi_DimAddOnUserMembership_s3 | OrganizationId | VARCHAR(36) | |||
Bi_DimAddOnUserMembership_s3 | groupid | BIGINT |