| The table used to store client level information for employee tip allocations (employee tip allocation totals). |
| 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. |