Table: dbo.Employee_Tip_Total
The table used to store client level information for employee tip allocations (employee tip allocation totals).
Columns
Name | Type | Constraints | Description
employee_tip_total_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | Foreign key to the Client table. Relationship is 0..M - 1 from this table to Client.
form_year | int (4) | NOT NULL | Year which the tip allocations apply.
gross_tipped_sales | decimal (9, 2) | NOT NULL | User-entered amount for client. Contains total of all employee's gross tipped sales.
tipped_percentage | decimal (5, 2) | NOT NULL | Value represents the percentage used to calculate tip allocation (default is 8.0).
indirect_tips | decimal (9, 2) | NOT NULL | Contains the total amount of all of a client's employee Indirect Tips pay items.
indirect_tips_override | decimal (9, 2) |  | This field will hold the override amount for indirect tips reported (takes precedence over indirect_tips if not null).
direct_tips_reported | decimal (9, 2) | NOT NULL | Contains the total amount of all of a client's employee Reported Tips pay items
tip_allocation_method_KEY | int (4) | NOT NULL | Foreign key that represents the binary state of the 'Method' radio button.

Primary key
Name | Columns | Description
PK_Employee_Tip_Total | employee_tip_total_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Tip_Total$client_KEY$form_year | client_KEY, form_year |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Tip_Total__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Employee_Tip_Total__Tip_Allocation_Method__tip_allocation_method_KEY | tip_allocation_method_KEY | Tip_Allocation_Method (tip_allocation_method_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_Tip_Allocation__Employee_Tip_Total__employee_tip_total_KEY | employee_tip_total_KEY | Employee_Tip_Allocation |