Agent dimension table
Table Name | Column Name | Description | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|---|
BI_DimAgent_s3 | AgentId | unique identifier for agent | 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 | Hardcoded values:
| BOOLEAN | |||
BI_DimAgent_s3 | ConsiderInRoyalty | BOOLEAN | ||||
BI_DimAgent_s3 | ShowInPos | BOOLEAN | ||||
BI_DimAgent_s3 | OrganizationId | VARCHAR(36) | ||||
BI_DimAgent_s3 | EtlLastUpdatedOn | Latest timestamp at which the corresponding record was either inserted or updated in this table. | TIMESTAMP | |||
BI_DimAgent_s3 | EtlLastUpdatedBy | ETL system admin user who inserted or updated the corresponding record in this table. | NVARCHAR(50) | |||
BI_DimAgent_s3 | PodName | VARCHAR(20) | ||||
BI_DimAgent_s3 | groupid | Internal to Zenoti. Used for data processing. | BIGINT |