Appointment Redo Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Tracks appointment redo information linking original and redo appointments to employees, invoices, and centers with commission factors and discount details.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factappointmentredowid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the appointment redo record. |
| factappointmentredoid | BIGINT | YES | Source system identifier for the appointment redo fact. |
| appointmentid | VARCHAR(36) | YES | GUID of the redo appointment. |
| invoiceitemid | VARCHAR(36) | YES | GUID of the associated invoice item. |
| employeewid | BIGINT | YES | Foreign key to the employee dimension (Bi_DimUser.userwid). |
| invoiceid | VARCHAR(36) | YES | GUID of the associated invoice. |
| commissionfactor | FLOAT | YES | Commission factor applied to the redo appointment. |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| invoicediscount | FLOAT | YES | Discount applied on the invoice for the redo. |
| itemwid | VARCHAR(36) | YES | Identifier for the associated item. |
| isredo | BOOLEAN | YES | Flag indicating whether this record represents a redo appointment. |
| sourceappointmentid | VARCHAR(36) | YES | GUID of the original appointment that this redo is based on. |
| starttimeincenter | TIMESTAMP | YES | Appointment start time in center local time. |
| endtimeincenter | TIMESTAMP | YES | Appointment end time in center local time. |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
| primaryemp | BOOLEAN | YES | Whether this is the primary employee. |
| appstatuswid | BIGINT | YES | Status code of the appointment. |
| processed | SMALLINT | YES | Processing status. |
| parentappointmentid | VARCHAR(36) | YES | Parent appointment identifier. |
| issegment | BOOLEAN | YES | Whether this is a segment. |
| appointmentpk | BIGINT | YES | Primary key of the appointment. |
| sourceappointmentpk | BIGINT | YES | Primary key of the source appointment. |
| parentappointmentpk | BIGINT | YES | Primary key of the parent appointment. |
| invoiceno | VARCHAR(160) | YES | Human-readable invoice number. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factappointmentredowid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| starttimeincenter | Bi_DimDate.datewid |
| endtimeincenter | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| isredo | TRUE if this is a redo appointment; FALSE otherwise. |
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
| primaryemp | true = Primary employee, false = Secondary employee |
| issegment | true = Segment, false = Not a segment |
Was this article helpful?
Your feedback helps us improve our documentation.