ZenotiHelp

Appointmentredo Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated fact table storing appointment redo (rework) records, tracking appointments that were redone along with their source appointments, associated employees, and invoice details.

Columns

Column Name Data Type Nullable Description
fact appointment redo wid BIGINT YES Warehouse identifier uniquely identifying the appointment redo fact record.
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.
zone name VARCHAR(800) YES Name of the geographic zone. Sourced from DimCenter.zone name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center name.
center city VARCHAR(128) YES City where the center is located. Sourced from DimCenter.center city.
center zip VARCHAR(32) YES ZIP/postal code of the center. Sourced from DimCenter.center zip.
center state name VARCHAR(4096) YES State name of the center. Sourced from DimCenter.center state name.
country name VARCHAR(4096) YES Country name of the center. Sourced from DimCenter.country name.
operating center BOOLEAN YES Indicates whether the center is an operating center. Sourced from DimCenter.operating center.
employee first name VARCHAR(256) YES First name of the employee. Sourced from DimEmployee.employee first name.
employee last name VARCHAR(256) YES Last name of the employee. Sourced from DimEmployee.employee last name.
employee middle name VARCHAR(256) YES Middle name of the employee. Sourced from DimEmployee.employee middle name.
employee mobile phone VARCHAR(64) YES Mobile phone number of the employee. Sourced from DimEmployee.employee mobile phone.
employee - code VARCHAR(512) YES Employee code identifier. Sourced from DimEmployee.employee - code.
employee gender VARCHAR(14) YES Gender of the employee. Sourced from DimEmployee.employee gender.
employee job name VARCHAR(1020) YES Job title of the employee. Sourced from DimEmployee.employee job name.
employee job code VARCHAR(8000) YES Job code of the employee. Sourced from DimEmployee.employee job code.
is employee inactive BOOLEAN YES Indicates whether the employee is inactive. Sourced from DimEmployee.is employee inactive.
employee tags VARCHAR(65535) YES Tags associated with the employee. Sourced from DimEmployee.employee tags.
employee start date TIMESTAMP WITHOUT TIME ZONE YES Start date of the employee. Sourced from DimEmployee.employee start date.
employee last date TIMESTAMP WITHOUT TIME ZONE YES Last working date of the employee. Sourced from DimEmployee.employee last date.
item name VARCHAR(512) YES Name of the service/item. Sourced from DimItem.item name.
item code VARCHAR(256) YES Code of the service/item. Sourced from DimItem.item code.
businessunit VARCHAR(65535) YES Business unit the item belongs to. Sourced from DimItem.businessunit.
is item inactive BOOLEAN YES Indicates whether the item is inactive. Sourced from DimItem.is item inactive.
item tags VARCHAR(65535) YES Tags associated with the item. Sourced from DimItem.item tags.
appointment id VARCHAR(36) YES Unique identifier for the redo appointment.
invoice id VARCHAR(36) YES Unique identifier for the associated invoice.
invoice item id VARCHAR(36) YES Unique identifier for the associated invoice item.
commission factor DOUBLE PRECISION YES Commission factor applied to the redo appointment.
invoice discount DOUBLE PRECISION YES Discount amount on the invoice.
is redo BOOLEAN YES Indicates whether this record is a redo appointment.
start time in center TIMESTAMP WITHOUT TIME ZONE YES Appointment start time in center local time.
end time in center TIMESTAMP WITHOUT TIME ZONE YES Appointment end time in center local time.
source appointment id VARCHAR(36) YES Unique identifier of the original appointment that was redone.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
center code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.center code.
appointment status VARCHAR(100) YES Current status of the appointment.
invoice status VARCHAR(14) YES Status of the associated invoice.
is primary employee BOOLEAN YES Indicates whether this employee is the primary employee on the appointment.
parent appointment id VARCHAR(36) YES Unique identifier of the parent appointment (for grouped appointments).
is segment BOOLEAN YES Indicates whether the record represents a segment within a multi-segment appointment.
appointment pk BIGINT YES Primary key of the appointment record.
source appointment pk BIGINT YES Primary key of the source (original) appointment.
parent appointment pk BIGINT YES Primary key of the parent appointment.
invoice no VARCHAR(160) YES Human-readable invoice number.

Primary Key

fact appointment redo wid -- BIGINT warehouse surrogate key uniquely identifying each appointment redo fact record.

Foreign Keys

  • appointment id references FactAppointment
  • invoice id references FactInvoice
  • invoice item id references FactInvoiceItem
  • source appointment id / source appointment pk references FactAppointment (original appointment)
  • parent appointment id / parent appointment pk references FactAppointment (parent appointment)
  • groupid references the tenant/data group

Enumerator Values

Column Name Known Values
appointment status VARCHAR(100)
invoice status 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.