Employee hourly pay fact table

centerwid

bigint

A unique identifier for the center, generated in Centre dimension(Bi_DimCentre).

bi_dimcenter

centerwid

considerhourlypay

boolean

Indicates whether hourly pay should be considered while generating the corresponding payroll. This honors the 'Calculate employee pay based on higher of total hourly pay and service commission' setting in the core system.

considerservicecommission

boolean

Indicates whether service commission should be considered while generating the corresponding payroll. This honors the 'Calculate employee pay based on higher of total hourly pay and service commission' setting in the core system.

declaredtip

numeric(19,4)

Declared tips paid by guests to service providers

deductionsontotalcommission

float8

Displays the deduction on the total commission the employee earned in the pay period.

dontconsiderothercenterinvoicesforpayroll

boolean

Indicates invoices from other centres should not be considered for payroll processing.

employeewid

bigint

unique identifier for an employee in a center

bi_dimuser

userwid

etlcreatedby

numeric(19)

ETL system admin user who inserted or updated the corresponding record in this table.

etlcreateddate

timestamp

Latest timestamp at which the corresponding record was either inserted or updated in this table.

factemployeepayid

numeric(19)

A unique identifier(integer value) for each record generated in the fact table.

yes

factemployeepaywid

bigint

A unique identifier(integer value) for each record generated in the fact table.

yes

hourlyorservice

varchar(2048)

Indicates if the payment is to be based on hourly pay or service commission.

hourlyrate

float8

The hourly rate or charges of the employee.

intervalenddate

timestamp

end date of the week

intervalstartdate

timestamp

start date of the week

intervaltype

varchar(50)

The interval at which overtime hours are configured. Possible values are:

1. day

2.week

3.payperiod

maxofhourlypayorservicecomm

boolean

Indicates if the payment is to be based on the higher amount between hourly pay or service commission.

maxofhourlypayorservicecommvalue

float8

Indicates the maximum payment amount that can be made in lieu of hourly pay or service commission.

nonservicecommission

float8

The non-service commission earned by the employee in the pay period.

noofinvoices

integer

Displays the total number of closed invoices in which the employee has sold at least one item.

Note: The # Invoices it is not the number of items sold by the employee, but the number of invoices in which they have sold at least one sales item such as performing a service, or selling a product, membership, package, or gift card.

noofrequested

integer

Displays the number of times guests requested for a particular employee to perform a service and where the invoice was closed.

noofservices

integer

Displays the number of services the employee has closed or performed.

organizationid

varchar(36)

A code that uniquely identifies an Organization

payout

numeric(19,4)

payperiodname

varchar(512)

The name of the payroll generation period.

payrollenddate

date

The end date of the payroll period.

payrollid

numeric(19)

A code that uniquely identifies a Payroll.

payrollstartdate

date

The start date of the payroll period.

podid

integer

Internal to the ETL, says from which POD data is being synced the table

podname

varchar(20)

Db value (Unique for each region)

rtbonus

float8

Request Therapist Bonus. Displays the total amount an employee earns as a bonus in the selected pay period because a guest requested a particular employee to perform a service and where the invoice was closed. Read: Employee Overtime and Therapist Request Bonus

Requested Therapist Bonus is configured in the Employee profile: Employee > Employees > [Employee Name] > General > Requested Therapist Bonus.

The Requested Therapist Bonus for the pay period is calculated as follows: Requested (total number of requests for the therapist) x Requested Therapist Bonus (from the employee profile).

salary

float8

Salary per pay period of the corresponding employee.

serviceandinvoiceleveldeductions

float8

Displays the deduction at service and invoice level from the commission the employee earned.

servicecommission

numeric(19,4)

The service commission earned by the employee in the pay period. Service commission includes Add-On commission and Request Therapist Bonus.

servicehours

float8

The total hours utilized to perform services by the employee in the pay period. Only closed appointments are considered.

ssg

float8

Support Staff Gratuity. Displays the total SSG amount the employee earns as SSG (gratuity or service charge) on closed invoices in the selected pay period.

tip

float8

Total tips the employee earns in the selected pay period.

tipspaidamountthroughzenoti

numeric(19,4)

Tips paid through Zenoti wallet

totalhourlypay

numeric(19,4)

The total pay as per regular and overtime hourly rate for the employee in the pay period.

Note: Calculation of this field is as per the 'Total Hourly Pay' column in the 'Employee Payroll Summary' report in the core system.

totalhours

float8

The total hours of work for the employee in the pay period.

Note: Calculation of this field is as per the 'Total Hours' column in the 'Employee Payroll Summary' report in the core system.

totalhourswithrounding

float8

Indicates if total hours is to arrived at, with rounding off.

void

boolean

Indicates if the row should be inserted or deleted. 1- delete, 0-insert

ProductionHours

DECIMAL(19,4)

Number of production hours in a pay period for an employee

NonProductionHours

DECIMAL(19,4)

Number of non-production hours in a pay period for an employee

OvertimeHours

FLOAT

Number of Overtime hours employee worked in a pay period

OvertimeHourlyPay

DECIMAL(19,4)

Total overtime pay for an employee in payperiod

OvertimeMultiplier

FLOAT

Multiplying factor to arrive at overtime pay from normal pay. This value is set in the product.

groupid

Internal to Zenoti. Used for data processing.

BIGINT