ZenotiHelp

Employeeinvoiceitemrevenue Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated fact table storing employee-level revenue breakdowns per invoice item, including cash revenue, membership/gift card/loyalty point redemptions, package redemptions, commissions, and various FSR (full service revenue) components.

Columns

Column Name Data Type Nullable Description
employeewid BIGINT YES Warehouse identifier for the employee. Sourced from DimEmployee.employee wid.
employee first name VARCHAR(160) 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(128) YES Middle name of the employee. Sourced from DimEmployee.employee middle name.
employee code VARCHAR(128) YES Code for the employee. Sourced from DimEmployee.employee code.
employee - code VARCHAR(128) YES Alternate employee code identifier. Sourced from DimEmployee.employee - code.
employee tags VARCHAR(65535) YES Tags associated with the employee. Sourced from DimEmployee.employee tags.
employee gender VARCHAR(14) YES Gender of the employee. Sourced from DimEmployee.employee gender.
employee job name VARCHAR(510) YES Job title of the employee. Sourced from DimEmployee.employee job name.
employee job code VARCHAR(2000) 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 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.
invoiceid VARCHAR(36) YES Unique identifier for the invoice.
itemwid BIGINT YES Warehouse identifier for the item. Sourced from DimItem.item wid.
item name VARCHAR(512) YES Name of the item. Sourced from DimItem.item name.
item code VARCHAR(256) YES Code of the item. Sourced from DimItem.item code.
packageserviceid VARCHAR(36) YES Identifier for the package service association.
invoiceitemid VARCHAR(36) YES Unique identifier for the invoice item.
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization account name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center name.
itemtypewid BIGINT YES Warehouse identifier for the item type. Sourced from DimItemType.item type wid.
itemtypecode VARCHAR(100) YES Code of the item type. Sourced from DimItemType.item type code.
itemtypevalue NUMERIC(19,0) YES Numeric value representing the item type. Sourced from DimItemType.item type value.
cashrevenue DOUBLE PRECISION YES Cash revenue amount for this invoice item.
membershipredemption DOUBLE PRECISION YES Membership redemption amount applied to this invoice item.
gcredemption DOUBLE PRECISION YES Gift card redemption amount applied to this invoice item.
lpredemption DOUBLE PRECISION YES Loyalty points redemption amount applied to this invoice item.
cashbackredemption DOUBLE PRECISION YES Cashback redemption amount applied to this invoice item.
commission DOUBLE PRECISION YES Commission amount earned by the employee on this invoice item.
invoicecloseddate TIMESTAMP WITHOUT TIME ZONE YES Date and time the invoice was closed (UTC).
invoicecloseddateincenter TIMESTAMP WITHOUT TIME ZONE YES Date and time the invoice was closed in center local time.
lastupdatedincore TIMESTAMP WITHOUT TIME ZONE YES Timestamp of the last update in the core system.
packageredemption DOUBLE PRECISION YES Package redemption amount applied to this invoice item.
membershipfsr DOUBLE PRECISION YES Membership full service revenue component.
campaignfsr DOUBLE PRECISION YES Campaign full service revenue component.
lpfsr DOUBLE PRECISION YES Loyalty points full service revenue component.
manualdiscountfsr DOUBLE PRECISION YES Manual discount full service revenue component.
gcfsr DOUBLE PRECISION YES Gift card full service revenue component.
orgpaymentorrevenue SMALLINT YES Flag indicating organization-level payment or revenue classification.
processedon TIMESTAMP WITHOUT TIME ZONE YES Timestamp when the record was processed.
quantity INTEGER YES Quantity of items on the invoice line.
cancelornoshowstatus INTEGER YES Status code for cancellation or no-show.
therapistrequesttype_statuswid BIGINT YES Warehouse identifier for the therapist request type status.
actualsaleprice DOUBLE PRECISION YES Actual sale price of the item.
daypackageprice DOUBLE PRECISION YES Day package price of the item.
packageitemprice DOUBLE PRECISION YES Price of the item within a package.
prepaidcardfsr DOUBLE PRECISION YES Prepaid card full service revenue component.
refundedprepaidcardfsr DOUBLE PRECISION YES Refunded prepaid card full service revenue component.
gcpayment DOUBLE PRECISION YES Gift card payment amount.
leftmembershipredemption DOUBLE PRECISION YES Remaining membership redemption balance.
leftgcredemption DOUBLE PRECISION YES Remaining gift card redemption balance.
leftlpredemption DOUBLE PRECISION YES Remaining loyalty points redemption balance.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
membershipcreditfsrbasedonmembershipprice DOUBLE PRECISION YES Membership credit FSR based on membership price.
membershipcreditfsr DOUBLE PRECISION YES Membership credit full service revenue component.
appointmentid VARCHAR(36) YES Unique identifier for the associated appointment.
appointmentsegmentid VARCHAR(36) YES Unique identifier for the associated appointment segment.
factemployeeinvoiceitemrevenueid BIGINT YES Business identifier for the employee invoice item revenue fact.
empinvoiceitemwid BIGINT YES Warehouse identifier for the employee invoice item record.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.Center Code.

Primary Key

empinvoiceitemwid -- BIGINT warehouse surrogate key uniquely identifying each employee invoice item revenue record.

Foreign Keys

  • employeewid references DimEmployee
  • itemwid references DimItem
  • invoiceid references FactInvoice
  • invoiceitemid references FactInvoiceItem
  • packageserviceid references DimPackageService
  • itemtypewid references DimItemType
  • appointmentid references FactAppointment
  • appointmentsegmentid references FactAppointmentSegment
  • groupid references the tenant/data group

Enumerator Values

Column Name Known Values
cancelornoshowstatus -2 = No Show
orgpaymentorrevenue 0 = Center-level

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.