Employee hourly pay fact table
This table lists the fact table columns used for the Employee hourly pay data model.
Bi_FactEmployeePay
Field | Type | Description | PK |
|---|---|---|---|
factemployeepaywid | BIGINT IDENTITY | Surrogate primary key (auto-generated) | PK |
factemployeepayid | NUMERIC(19,0) | Source system identifier for the employee pay fact | |
payrollid | NUMERIC(19,0) | Source payroll identifier | |
employeewid | BIGINT | FK to the employee (user) dimension | |
centerwid | BIGINT | FK to the center dimension | |
podid | INTEGER | Pod identifier for multi-tenant partitioning | |
totalhours | DOUBLE PRECISION | Total hours worked in the interval | |
totalhourlypay | NUMERIC(19,4) | Total hourly pay for the interval | |
servicecommission | NUMERIC(19,4) | Service commission earned in the interval | |
intervalstartdate | TIMESTAMP | Start datetime of the pay interval | |
intervalenddate | TIMESTAMP | End datetime of the pay interval | |
intervaltype | VARCHAR(50) | Type of pay interval (weekly, biweekly…) | |
payrollstartdate | DATE | Start date of the payroll period | |
payrollenddate | DATE | End date of the payroll period | |
payperiodname | VARCHAR(512) | Name of the payroll period | |
considerhourlypay | BOOLEAN | Whether hourly pay is considered for this record | |
considerservicecommission | BOOLEAN | Whether service commission is considered | |
dontconsiderothercenterinvoicesforpayroll | BOOLEAN | Exclude other-center invoices from payroll calc | |
declaredtip | DECIMAL(19,4) | Declared tip amount | |
tipspaidamountthroughzenoti | DECIMAL(19,4) | Tip amount paid through the Zenoti platform | |
ProductionHours | DECIMAL(19,4) | Hours spent in production (serving guests) | |
NonProductionHours | DECIMAL(19,4) | Hours spent in non-production activities | |
OvertimeHours | FLOAT | Overtime hours worked | |
OvertimeHourlyPay | DECIMAL(19,4) | Hourly pay rate for overtime | |
OvertimeMultiplier | FLOAT | Multiplier applied to overtime pay | |
etlcreatedby | NUMERIC(19,0) | ETL process that created this record | |
etlcreateddate | TIMESTAMP | When the ETL process created this record | |
void | BOOLEAN | Indicates if the record is voided | |
groupid | BIGINT | Group identifier for multi-entity grouping |