ZenotiHelp

Service Segment Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing the individual segments that compose a service, including segment ordering, duration, type, and commission information.

Columns

Column Name Data Type Nullable Description
serviceid VARCHAR(36) Yes Unique identifier of the parent service
servicesegmentwid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
servicesegmentid VARCHAR(36) Yes Source system unique identifier for the service segment
servicesegmentname VARCHAR(512) Yes Display name of the segment
servicesegmenttype INTEGER Yes Enumerator indicating the type of segment
servicesegmentlength INTEGER Yes Duration/length of the segment in minutes
segmentorder INTEGER Yes Order/sequence of the segment within the service
void SMALLINT Yes Soft-delete flag (non-zero indicates voided)
commission DOUBLE PRECISION Yes Commission value associated with the segment

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

servicesegmentwid

Foreign Keys

Column References
serviceid the service dimension (Bi_DimService or equivalent)

Enumerator Values

Column Values
servicesegmenttype Processing
Finish
Break
Was this article helpful?
Your feedback helps us improve our documentation.