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. |