ZenotiHelp

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.