Table: dbo.Employee_Tip_Allocation
The table used to store employee-level tip allocation data and overrides.
Columns
Name | Type | Constraints | Description
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).

Primary key
Name | Columns | Description
PK_Employee_Tip_Allocation | employee_tip_allocation_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Tip_Allocation$employee_KEY$employee_tip_total_KEY | employee_KEY, employee_tip_total_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Tip_Allocation__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Tip_Allocation__Employee_Tip_Total__employee_tip_total_KEY | employee_tip_total_KEY | Employee_Tip_Total (employee_tip_total_KEY) |