Agent Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing agent (third-party referral/sales partner) information including contact details, commission settings, and operational flags. Populated from the agent master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| agentwid | BIGINT IDENTITY | No | Surrogate warehouse key for the agent dimension, auto-generated |
| agentid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the agent from the source system |
| void | SMALLINT | Yes | Soft-delete flag; non-zero indicates the record is voided/inactive |
| createdby | VARCHAR(36) | Yes | Identifier of the user who created the agent record |
| createdon | TIMESTAMP | Yes | Timestamp when the agent record was created |
| commissionfactor | DOUBLE PRECISION | Yes | Commission factor/multiplier for the agent |
| accrueloyaltypointsonpayment | SMALLINT | Yes | Flag indicating whether loyalty points accrue on agent payments (1 = yes) |
| collectadditionaldata | SMALLINT | Yes | Flag indicating whether additional data is collected for this agent (1 = yes) |
| considerinfinancials | SMALLINT | Yes | Flag indicating whether agent transactions are included in financial reports (1 = yes) |
| considerinroyalty | SMALLINT | Yes | Flag indicating whether agent transactions are included in royalty calculations (1 = yes) |
| showinpos | SMALLINT | Yes | Flag indicating whether the agent is visible in the POS (Point of Sale) system (1 = yes) |
| VARCHAR(512) | Yes | Agent's email address | |
| address1 | VARCHAR(512) | Yes | Primary address line |
| address2 | VARCHAR(512) | Yes | Secondary address line |
| zipcode | VARCHAR(64) | Yes | Postal/ZIP code |
| name | VARCHAR(800) | Yes | Full name of the agent |
| phone | VARCHAR(128) | Yes | Phone number of the agent |
| city | VARCHAR(256) | Yes | City of the agent's address |
| stateother | VARCHAR(256) | Yes | Free-text state field when state is not in the standard list |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
agentwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | Bi_DimCenter |
| createdby | a user ID |
Enumerator Values
| Column | Values |
|---|---|
| void | (0 = active, non-zero = voided) |
| accrueloyaltypointsonpayment | (0 = no, 1 = yes) |
| collectadditionaldata | (0 = no, 1 = yes) |
| considerinfinancials | (0 = no, 1 = yes) |
| considerinroyalty | (0 = no, 1 = yes) |
| showinpos | (0 = no, 1 = yes) |
Was this article helpful?
Your feedback helps us improve our documentation.