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
employeewidreferences DimEmployeeitemwidreferences DimIteminvoiceidreferences FactInvoiceinvoiceitemidreferences FactInvoiceItempackageserviceidreferences DimPackageServiceitemtypewidreferences DimItemTypeappointmentidreferences FactAppointmentappointmentsegmentidreferences FactAppointmentSegmentgroupidreferences 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.