Employee item revenue data model

Employees earn commissions for the services they provide and the products they sell. Employee revenue data source details the revenue earned by employees as commissions.

Commissions are set up by various customers in different ways. In some cases, the commission is earned when a sale is made, in other cases, the commission is earned when revenue is realized.

Employee Revenue data source gives details of the revenue earned by the center on which employees earn commissions. This revenue is further split based on payment types such as cash, Giftcard Redemptions, membership redemptions, etc., as commissions might differ for different payment methods.

Data from Revenue data sources sometimes may not match other data sources as other data sources have non-commissionable revenue. For example, taxes are not included in the Employee revenue data source, in case employees don't earn a commission on taxes.

Group	field name	field description	Example	field type
invoice	actualsaleprice	actual sale price of the item		float8
appointment	appointmentid	appointment id for the service received. This is populated for appointments		varchar(36)
appointment	appointmentsegmentid	unique id for an appointment segment within appointment		varchar(36)
campaign	campaignfsr	discount received on using campaigns		float8
appointment	cancelornoshowstatus	Indicates status of appointment	0- Fulfilled Appointment -1 - Cancelled Appointment -2 - Noshow	integer
cashback	cashbackredemption	amount redeemed from cashbacks on which commissions are applicable. If cashbacks are redeemed but commissions are not applicable, then this value is 0		float8
invoice	cashrevenue	amount collected as cash/creditcard on which commission is applicable	In some cases, commissions are not earned on taxes. So from the collected cash, tax component is deducted to arrive at final amount on which commission is applied	float8
Center, Zone, Organization	center name	The center where the appointment is scheduled to be serviced.		varchar(128)
commission	commission	percentage of commission employee earns out of the total commission employee is supposed to earn	Example: If an employee is supposed to receive 10% of sale price as commission for sale of $100, then ideal commission is $10. If "commission" value is 100%, employee earns $10. If "commission" value is 70%, then employee earns $7	float8
package	daypackageprice	price of day package sold		float8
employee	employee - code	Unique code of the employee. This is the code taken from the employee's profile in Zenoti		varchar(128)
employee	employee code	Unique code of the employee. This is the code from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The 'employee code' is usually the same as 'employee - code' unless someone manually changes it in the employee's guest profile		varchar(128)
employee	employee first name	first name of the employee		varchar(160)
employee	employee gender	Gender of the employee		varchar(14)
employee	employee job code	Job code of the employee		varchar(2000)
employee	employee job name	Job name of the employee		varchar(510)
employee	employee last date	Date on which the employee stopped working for the organization		timestamp
employee	employee last name	last name of the employee		varchar(256)
employee	employee middle name	middle name of the employee		varchar(128)
employee	employee start date	Date on which the employee started working for the organization		timestamp
employee	employee tags	Tags associated with the employee		varchar(65535)
employee	employeewid	Unique identifier for the employee. This is generated in analytics, it does not exist in the core system		bigint
giftcards	gcfsr	discount received on using giftcards		float8
giftcards	gcpayment	amount paid through giftcards. All prepaid cards are giftcards. But giftcards are not prepaid cards		float8
giftcards	gcredemption	amount redeemed from giftcard redemptions on which commissions are applicable. If giftcard is redeemed but commissions are not applicable, then this value is 0		float8
invoice	invoicecloseddate	date on which invoice is closed in UTC time		timestamp
invoice	invoicecloseddateincenter	date on which invoice is closed in center timezone		timestamp
invoice	invoiceid	Unique identifier for the invoice (unique within the organization)		varchar(36)
invoice	InvoiceNo	Invoice number that helps in identifying and tracking the invoice.
invoice	invoiceitemid	Unique identifier for each invoice item within the invoice		varchar(36)
employee	is employee inactive	Flag that indicates whether the primary 'Sold by' employee is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive. - False: Employee is active		boolean
item	item code	code for the item		varchar(256)
item	item name	name of the item sold. It can be product/service/membership/package/GC/etc..		varchar(512)
item	itemtypecode	code for item type		varchar(100)
item	itemtypevalue	ID associated with item type code		numeric(19)
item	itemtypewid	system generated unique identifier for item type. This exists only in Analytics		bigint
item	itemwid	system generated unique identifier for item. This exists only in Analytics		bigint
invoice	lastupdatedincore	date on which invoice is last updated		timestamp
giftcards	leftgcredemption	amount left to redeem using giftcard		float8
loyalty	leftlpredemption	amount left to redeem using giftcards		float8
membership	leftmembershipredemption	amount left to redeem using membership		float8
loyalty	lpfsr	discount received on using loyalty points		float8
loyalty	lpredemption	amount redeemed from loyalty points on which commissions are applicable. If loyalty points are redeemed but commissions are not applicable, then this value is 0		float8
invoice	manualdiscountfsr	manual discount provided for the guest		float8
membership	membershipcreditfsr	service credit value		float8
membership	membershipcreditfsrbasedonmembershipprice	service credit value based on membership price		float8
membership	membershipfsr	discount received on using membership		float8
membership	membershipredemption	amount redeemed from memberships on which commissions are applicable. If membership is redeemed but commissions are not applicable, then this value is 0		float8
Center, Zone, Organization	minutes to add	The number of minutes to add to the UTC time to get the current time at the center. If you use filters such as Today or Tomorrow, Tableau generates the timestamps in UTC. We require this field to calculate the center time. It is not required for timestamps that are in the data source directly, these are already aligned to the center’s time zone.		integer
Center, Zone, Organization	organization account name	The domain name of the organization in Zenoti.		varchar(256)
giftcards	orgpaymentorrevenue	Indicates if commission is on revenue realised or payment in case of giftcard redemptions.	values: 1 - commission on payment amount 0 - commission on revenue realised	smallint
package	packageitemprice	price of day package sold		float8
package	packageredemption	amount redeemed from packages on which commissions are applicable. If packages are redeemed but commissions are not applicable, then this value is 0		float8
package	packageserviceid	service ids of the services in day package		varchar(36)
prepaid card	prepaidcardfsr	amount paid using prepaid card. All prepaid cards are considered as gifts cards also. But giftcards are not prepaid cards		float8
invoice	processedon	date on which invoice is processed		timestamp
invoice	quantity	no of units sold		integer
prepaid card	refundedprepaidcardfsr	amount redeemed using refundprepaidcard.		float8
appointment	therapistrequesttype_statuswid	indicates if guest requested for a therapist of specifc gender	57 - Any 58 - Male 59 - Female 60- Specific	bigint

In this section:

Employee item revenue data model

Search results