Agent dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column | |
|---|---|---|---|---|---|---|
BI_DimAgent_s3 | AgentId | VARCHAR(36) | PK | |||
BI_DimAgent_s3 | Name | NVARCHAR(400) | ||||
BI_DimAgent_s3 | void | BOOLEAN | ||||
BI_DimAgent_s3 | CreatedBy | VARCHAR(36) | ||||
BI_DimAgent_s3 | CreatedOn | TIMESTAMP | ||||
BI_DimAgent_s3 | NVARCHAR(256) | |||||
BI_DimAgent_s3 | Address1 | NVARCHAR(256) | ||||
BI_DimAgent_s3 | Address2 | NVARCHAR(256) | ||||
BI_DimAgent_s3 | City | NVARCHAR(128) | ||||
BI_DimAgent_s3 | ZipCode | NVARCHAR(32) | ||||
BI_DimAgent_s3 | StateOther | NVARCHAR(128) | ||||
BI_DimAgent_s3 | Phone | NVARCHAR(64) | ||||
BI_DimAgent_s3 | CommissionFactor | FLOAT | ||||
BI_DimAgent_s3 | AccrueLoyaltyPointsOnPayment | BOOLEAN | ||||
BI_DimAgent_s3 | CollectAdditionalData | BOOLEAN | ||||
BI_DimAgent_s3 | ConsiderInFinancials | BOOLEAN | ||||
BI_DimAgent_s3 | ConsiderInRoyalty | BOOLEAN | ||||
BI_DimAgent_s3 | ShowInPos | BOOLEAN | ||||
BI_DimAgent_s3 | OrganizationId | VARCHAR(36) | ||||
BI_DimAgent_s3 | EtlLastUpdatedOn | TIMESTAMP | ||||
BI_DimAgent_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||||
BI_DimAgent_s3 | PodName | VARCHAR(20) | ||||
Bi_DimAgent_s3 | groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||