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 idreferences FactAppointmentinvoice idreferences FactInvoiceinvoice item idreferences FactInvoiceItemsource appointment id/source appointment pkreferences FactAppointment (original appointment)parent appointment id/parent appointment pkreferences FactAppointment (parent appointment)groupidreferences 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.