The table used to store employee-level tip allocation data and overrides. |
employee_tip_allocation_KEY | int (4) | NOT NULL | Primary key for this table. |
employee_KEY | int (4) | NOT NULL | Foreign key to the Employee table. Relationship is 0..M - 1 from this table to Employee. |
employee_tip_total_KEY | int (4) | NOT NULL | Foreign key to the Employee_Tip_Total table. Relationship is M - 1 from this table to CTA. |
sales_hours | decimal (9, 2) | NOT NULL | Employee's total sales for the year to date (if Client_Tip_Allocation.method is 0) or total hours (reg + ot + dt) associated with Tipped Wages pay items that the employee has worked for the year (if CTA.method is 1). |
sales_hours_override | decimal (9, 2) | | User-entered override amount that will take precedence over sales_hours (if non-null value). |
direct_tips_reported | decimal (9, 2) | NOT NULL | Holds the employee's total pay item Reported Tips amount for the year (takes precedence over sales_hours if not null). |
direct_tips_reported_override | decimal (9, 2) | | User-entered override amount that will take precedence over direct_tips_reported (if non-null value). |
tips_to_allocate | decimal (9, 2) | NOT NULL | Holds the amount of tips to allocate (client level total) * shortfall % (see docs). |
tips_to_allocate_override | decimal (9, 2) | | User-entered override amount that will take precedence over tips_to_allocate (if non-null value). |