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.