Account name dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column | |
|---|---|---|---|---|---|---|
Bi_DimAccountName_s3 | AccountId | INT | PK | |||
Bi_DimAccountName_s3 | AccountName | NVARCHAR(400) | ||||
Bi_DimAccountName_s3 | void | BOOLEAN | ||||
Bi_DimAccountName_s3 | EtlLastUpdatedOn | TIMESTAMP | ||||
Bi_DimAccountName_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||||
Bi_DimAccountName_s3 | PodName | VARCHAR(20) | ||||
Bi_DimAccountName_s3 | organizationid | VARCHAR(36) | ||||
Bi_DimAccountName_s3 | groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||