ZenotiHelp

Appointmentsegment Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Consolidated fact table storing appointment segment details, including therapist assignment, segment timing, and actual start/completion timestamps for multi-segment appointments.

Columns

Column Name Data Type Nullable Description
organization name VARCHAR(512) YES Name of the organization. Sourced from DimOrganization.organization name.
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization account name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center name.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
appointment pk BIGINT YES Primary key of the parent appointment record.
service name VARCHAR(1024) YES Name of the service being performed. Sourced from DimService.service name.
therapist wid BIGINT YES Warehouse identifier for the therapist. Sourced from DimEmployee.employee wid.
therapist first name VARCHAR(256) YES First name of the therapist. Sourced from DimEmployee.employee first name.
therapist middle name VARCHAR(256) YES Middle name of the therapist. Sourced from DimEmployee.employee middle name.
therapist last name VARCHAR(256) YES Last name of the therapist. Sourced from DimEmployee.employee last name.
therapist last date TIMESTAMP WITHOUT TIME ZONE YES Last working date of the therapist. Sourced from DimEmployee.employee last date.
therapist job name VARCHAR(1020) YES Job title of the therapist. Sourced from DimEmployee.employee job name.
therapist gender VARCHAR(14) YES Gender of the therapist. Sourced from DimEmployee.employee gender.
therapist employee - code VARCHAR(512) YES Employee code of the therapist. Sourced from DimEmployee.employee - code.
therapist additional field 1 VARCHAR(8000) YES Custom additional field 1 for the therapist. Sourced from DimEmployee.employee additional field 1.
therapist additional field 2 VARCHAR(8000) YES Custom additional field 2 for the therapist. Sourced from DimEmployee.employee additional field 2.
segment pk INTEGER YES Primary key of the segment record.
segment name VARCHAR(512) YES Name or label of the segment.
segment length INTEGER YES Duration of the segment in minutes.
segment start date DATE YES Scheduled start date of the segment.
segment start date and time TIMESTAMP WITHOUT TIME ZONE YES Scheduled start date and time of the segment.
segment end date DATE YES Scheduled end date of the segment.
segment end date and time TIMESTAMP WITHOUT TIME ZONE YES Scheduled end date and time of the segment.
segment actual start date and time TIMESTAMP WITHOUT TIME ZONE YES Actual start date and time of the segment.
segment actual completed date and time TIMESTAMP WITHOUT TIME ZONE YES Actual completion date and time of the segment.
fact appointment wid BIGINT YES Warehouse identifier linking to the parent appointment fact record.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.Center Code.

Primary Key

segment pk -- INTEGER key uniquely identifying each appointment segment record.

Foreign Keys

  • appointment pk references FactAppointment
  • fact appointment wid references FactAppointment (warehouse key)
  • therapist wid references DimEmployee
  • groupid references the tenant/data group

Enumerator Values

Column Name Known Values
therapist gender VARCHAR(14)

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

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