Employee salary fact table
Bi_FactEmployeeSalary_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
centercommission | DECIMAL(19,4) | Employees may receive commissions when their center achieves a given target or newly-opened centers may want to boost morale by offering a commission to all employees for the first three months after opening. This is called a center-based commission. This field populates the total Center Commission for the employee in the pay period. | |||
CenterID | VARCHAR(36) | Unique identifier for the center | Bi_DimCenter_s3 centerID | ||
EffectiveDateEnd | TIMESTAMP | The effective end date of the period in consideration for Salary. | |||
EffectiveDateStart | TIMESTAMP | The effective start date of the period in consideration for Salary. | |||
EmployeeCommissionPK | DECIMAL(19,0) | unique identifier for the row in the table | |||
EmployeeId | VARCHAR(36) | Unique identifier for employee. Unique across organization | Bi_DimUser_S3 userid | ||
EmpTotalDeductions | DECIMAL(19,4) | Commission deductions can be set up on the total commission that an employee earns during a pay period. This field displays the amount that is to be deducted from the total commission of the employee in the corresponding pay period | |||
etlCreatedBy | DECIMAL(19,0) | indicates who executed ETL sync. | |||
etlCreatedDate | TIMESTAMP | Time stamp to indicate time when the row is updated in Zenoti. | |||
FactEmployeeSalaryId | DECIMAL(19,0) | Unique for the table. Primary key | Yes | ||
organizationid | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationID | ||
PayPeriodName | VARCHAR(2048) | The name of the payroll generation period | |||
PayrollEndDate | DATE | The end date of the payroll period | |||
PayrollStartDate | DATE | The start date of the payroll period | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
redopenalty | DECIMAL(19,4) | When a guest is not entirely pleased with their service, the center may offer to perform either the same service or another service for free or at a discounted price. Zenoti’s Redo Appointment functionality enables the center to mark a service as a redo service and process a reversal of the initial service provider’s commission. This field populates the amount that is to be deducted from the initial service provider's commission | |||
Salary | DECIMAL(19,4) | Salary per pay period of the corresponding employee | |||
tenurebonus | DECIMAL(19,4) | Employees may earn commissions when they complete a given number of years at their company. This is called a tenure-based commission. This field populates the total Tenure Commission for the employee in the pay period | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||