Package user dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimPackageUser_s3 | PackageUserId | VARCHAR(36) | PK | |
Bi_DimPackageUser_s3 | PackageId | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | UserId | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | CreationDate | TIMESTAMP | ||
Bi_DimPackageUser_s3 | StartDate | TIMESTAMP | ||
Bi_DimPackageUser_s3 | EndDate | TIMESTAMP | ||
Bi_DimPackageUser_s3 | invoiceid | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | EndDateWithGracePeriod | TIMESTAMP | ||
Bi_DimPackageUser_s3 | Closed | BOOLEAN | ||
Bi_DimPackageUser_s3 | ClosedBy | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | ClosedOn | TIMESTAMP | ||
Bi_DimPackageUser_s3 | closedinvoice | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | PackageUserPK | DECIMAL(19,0) | ||
Bi_DimPackageUser_s3 | PackageStatus | INT | ||
Bi_DimPackageUser_s3 | invoiceitemid | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | Void | BOOLEAN | ||
Bi_DimPackageUser_s3 | PodName | VARCHAR(20) | ||
Bi_DimPackageUser_s3 | PackageName | NVARCHAR(512) | ||
Bi_DimPackageUser_s3 | PackageCode | NVARCHAR(512) | ||
Bi_DimPackageUser_s3 | PackagePrice | DECIMAL(19,4) | ||
Bi_DimPackageUser_s3 | BusinessUnitId | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | FirstName | NVARCHAR(160) | ||
Bi_DimPackageUser_s3 | LastName | NVARCHAR(256) | ||
Bi_DimPackageUser_s3 | organizationid | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | SaleCenterId | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimPackageUser_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimPackageUser_s3 | CenterId | VARCHAR(36) | ||
Bi_DimPackageUser_s3 | groupid | BIGINT |