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 pkreferences FactAppointmentfact appointment widreferences FactAppointment (warehouse key)therapist widreferences DimEmployeegroupidreferences 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.