Table: dbo.Employee_Tip_Total
The table used to store client level information for employee tip allocations (employee tip allocation totals).
Columns
NameTypeConstraintsDescription
employee_tip_total_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLForeign key to the Client table. Relationship is 0..M - 1 from this table to Client.
form_yearint (4)NOT NULLYear which the tip allocations apply.
gross_tipped_salesdecimal (9, 2)NOT NULLUser-entered amount for client. Contains total of all employee's gross tipped sales.
tipped_percentagedecimal (5, 2)NOT NULLValue represents the percentage used to calculate tip allocation (default is 8.0).
indirect_tipsdecimal (9, 2)NOT NULLContains the total amount of all of a client's employee Indirect Tips pay items.
indirect_tips_overridedecimal (9, 2)This field will hold the override amount for indirect tips reported (takes precedence over indirect_tips if not null).
direct_tips_reporteddecimal (9, 2)NOT NULLContains the total amount of all of a client's employee Reported Tips pay items
tip_allocation_method_KEYint (4)NOT NULLForeign key that represents the binary state of the 'Method' radio button.
Primary key
NameColumnsDescription
PK_Employee_Tip_Totalemployee_tip_total_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Tip_Total$client_KEY$form_yearclient_KEY, form_year
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Tip_Total__Client__client_KEYclient_KEYClient (client_KEY)
FK_Employee_Tip_Total__Tip_Allocation_Method__tip_allocation_method_KEYtip_allocation_method_KEYTip_Allocation_Method (tip_allocation_method_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Tip_Allocation__Employee_Tip_Total__employee_tip_total_KEYemployee_tip_total_KEYEmployee_Tip_Allocation

Schema diagram