ZenotiHelp

Employee Invoice Item Revenue Fact Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Stores employee-level revenue breakdowns per invoice item, including cash, membership, gift card, loyalty point redemptions, commissions, and various financial split ratios.

Columns

Column Name Data Type Nullable Description
empinvoiceitemwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the employee invoice item revenue record.
factemployeeinvoiceitemrevenueid BIGINT NOT NULL Source system identifier for the revenue fact.
employeewid BIGINT YES Foreign key to the employee dimension (Bi_DimUser.userwid).
invoiceid VARCHAR(36) NOT NULL GUID of the associated invoice.
itemwid BIGINT YES Foreign key to the item dimension.
packageserviceid VARCHAR(36) YES GUID of the associated package service.
invoiceitemid VARCHAR(36) YES GUID of the associated invoice item.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
itemtypewid BIGINT YES Foreign key to the item type dimension.
cashrevenue DOUBLE PRECISION YES Revenue from cash payments.
membershipredemption DOUBLE PRECISION YES Revenue from membership redemptions.
gcredemption DOUBLE PRECISION YES Revenue from gift card redemptions.
lpredemption DOUBLE PRECISION YES Revenue from loyalty point redemptions.
cashbackredemption DOUBLE PRECISION YES Revenue from cashback redemptions.
commission DOUBLE PRECISION YES Commission amount for the employee on this item.
invoicecloseddate TIMESTAMP YES Date/time the invoice was closed (UTC).
invoicecloseddateincenter TIMESTAMP YES Date/time the invoice was closed in center local time.
lastupdatedincore TIMESTAMP YES Timestamp of the last update in the core system.
packageredemption DOUBLE PRECISION YES Revenue from package redemptions.
membershipfsr DOUBLE PRECISION YES Membership financial split ratio.
campaignfsr DOUBLE PRECISION YES Campaign financial split ratio.
lpfsr DOUBLE PRECISION YES Loyalty point financial split ratio.
manualdiscountfsr DOUBLE PRECISION YES Manual discount financial split ratio.
gcfsr DOUBLE PRECISION YES Gift card financial split ratio.
orgpaymentorrevenue SMALLINT YES Flag indicating organization-level payment or revenue.
void SMALLINT YES Soft-delete flag (0 = active, non-zero = voided).
processedon TIMESTAMP YES Timestamp when the record was processed.
quantity INTEGER YES Quantity of items on the invoice line.
cancelornoshowstatus INTEGER YES Status indicating cancellation or no-show.
therapistrequesttype_statuswid BIGINT YES Foreign key to therapist request type status dimension.
actualsaleprice DOUBLE PRECISION YES Actual sale price of the item.
daypackageprice DOUBLE PRECISION YES Day package price for the item.
packageitemprice DOUBLE PRECISION YES Package item price allocation.
prepaidcardfsr DOUBLE PRECISION YES Prepaid card financial split ratio.
refundedprepaidcardfsr DOUBLE PRECISION YES Refunded prepaid card financial split ratio.
gcpayment DOUBLE PRECISION YES Gift card payment amount.
leftmembershipredemption DOUBLE PRECISION YES Remaining membership redemption amount.
leftgcredemption DOUBLE PRECISION YES Remaining gift card redemption amount.
leftlpredemption DOUBLE PRECISION YES Remaining loyalty point redemption amount.
MembershipCreditFSRBasedonMembershipPrice DOUBLE PRECISION YES Membership credit FSR based on membership price.
MembershipCreditFSR DOUBLE PRECISION YES Membership credit financial split ratio.
Appointmentid VARCHAR(36) YES GUID of the associated appointment.
AppointmentSegmentId VARCHAR(36) YES GUID of the associated appointment segment.
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

empinvoiceitemwid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid
invoicecloseddateincenter Bi_DimDate.datewid

Enumerator Values

Column Values
orgpaymentorrevenue 0 = Center-level
1 = Organization-level
void 0 = active; non-zero = voided/soft-deleted.
cancelornoshowstatus -2 = No Show
-1 = Cancelled
0 = New/Open
1 = Closed
2 = Checkin
4 = Confirm
5 = Cancel
7 = Void
10 = Noshow (Redo Penalty)
11 = Cancelled (Redo Penalty)
12 = Closed (Redo Penalty)
Was this article helpful?
Your feedback helps us improve our documentation.