ZenotiHelp

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)
email 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.