Employee pay fact table
Bi_FactEmployeePay_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
centerid | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 centerID | ||
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 | DECIMAL(19,4) | amount of tip declared by employee. These are cash tips paid directly to service provider. | |||
DeductionsOnTotalCommission | FLOAT | 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. | |||
EmployeeId | VARCHAR(36) | A unique identifier for an employee(Bi_Dimuser). | Bi_DimUser_S3 userid | ||
etlCreatedBy | DECIMAL(19,0) | 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 | DECIMAL(19,0) | A unique identifier(integer value) for each record generated in the fact table. | Yes | ||
HourlyorService | NVARCHAR(200) | Indicates if the payment is to be based on hourly pay or service commission. | |||
HourlyRate | DECIMAL(19,4) | The hourly rate or charges of the employee. | |||
IntervalEndDate | TIMESTAMP | end date of the week | |||
IntervalStartDate | TIMESTAMP | start date of the week | |||
IntervalType | NVARCHAR(200) | The interval at which overtime hours are configured. Possible values are: - Daily - Weekly - Pay Period | |||
MaxOfHourlyPayOrServiceComm | BOOLEAN | Indicates if the payment is to be based on the higher amount between hourly pay or service commission. | |||
MaxOfHourlyPayOrServiceCommValue | FLOAT | Indicates the maximum payment amount that can be made in lieu of hourly pay or service commission. | |||
NonServiceCommission | FLOAT | The non-service commission earned by the employee in the pay period. | |||
NoofInvoices | INT | 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 | INT | Displays the number of times guests requested for a particular employee to perform a service and where the invoice was closed. | |||
NoofServices | INT | Displays the number of services the employee has closed or performed. | |||
OrganizationId | VARCHAR(36) | A code that uniquely identifies an Organization | Bi_DimCenter_s3 OrganizationId | ||
Payout | DECIMAL(19,4) | Overtime pay rate of an employee | |||
PayPeriodName | VARCHAR(2048) | The name of the payroll generation period. | |||
PayrollEndDate | DATE | The end date of the payroll period. | |||
payrollid | DECIMAL(19,0) | A code that uniquely identifies a Payroll. | |||
PayrollStartDate | DATE | start date of payroll period | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
RTBonus | DECIMAL(19,4) | 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 | FLOAT | Salary per pay period of the corresponding employee. | |||
ServiceAndInvoiceLevelDeductions | FLOAT | Displays the deduction at service and invoice level from the commission the employee earned. | |||
ServiceCommission | DECIMAL(19,4) | The service commission earned by the employee in the pay period. Service commission includes Add-On commission and Request Therapist Bonus. | |||
ServiceHours | FLOAT | The total hours utilized to perform services by the employee in the pay period. Only closed appointments are considered. | |||
SSG | FLOAT | 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 | FLOAT | Total tips the employee earns in the selected pay period. | |||
TipsPaidAmountThroughZenoti | DECIMAL(19,4) | Amount of tips paid directly to Service provider card/wallet through Zwallet feature | |||
TotalHourlyPay | DECIMAL(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 | FLOAT | 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 | FLOAT | 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 | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||