ZenotiHelp

Opportunity Source Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing opportunity source definitions used to track how sales or business opportunities originate.

Columns

Column Name Data Type Nullable Description
opportunitysourcewid BIGINT IDENTITY No Surrogate warehouse key for the opportunity source (Primary Key)
opportunitysourceid VARCHAR(36) Yes Natural unique identifier (GUID) for the opportunity source
opportunitysourcecode VARCHAR(256) Yes Short code representing the opportunity source
opportunitysourcename VARCHAR(256) Yes Display name of the opportunity source
opportunitysourcedescription VARCHAR(4096) Yes Detailed description of the opportunity source
active BOOLEAN Yes Flag indicating if the source is currently active
void BOOLEAN Yes Soft-delete flag indicating if the record is voided
optionalfield1 VARCHAR(16000) Yes Custom optional field 1 for extensibility
optionalfield2 VARCHAR(16000) Yes Custom optional field 2 for extensibility
optionalfield3 VARCHAR(16000) Yes Custom optional field 3 for extensibility
optionalfield4 VARCHAR(16000) Yes Custom optional field 4 for extensibility

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

opportunitysourcewid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Was this article helpful?
Your feedback helps us improve our documentation.