Table: dbo.Payroll_Check_Entry_Option_Payroll_Item_Exclusion
Specifies the client payroll items to be excluded from a pay schedule. This table contains rows for excluded payroll items for which the selection scope set to "Selected"
Columns
NameTypeConstraintsDescription
payroll_check_entry_option_payroll_item_exclusion_KEYint (4)NOT NULLPrimary key for this table.
client_pay_schedule_KEYint (4)NOT NULLSpecifies the pay schedule from which the payroll item needs to be excluded.
client_payroll_item_KEYint (4)NOT NULLSpecifies the payroll item to be excluded from the pay schedule.
payroll_check_entry_option_payroll_item_exclusion_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
Primary key
NameColumnsDescription
PK_Payroll_Check_Entry_Option_Payroll_Item_Exclusionpayroll_check_entry_option_payroll_item_exclusion_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion$client_pay_schedule_KEY$client_payroll_item_KEYclient_pay_schedule_KEY, client_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option (client_pay_schedule_KEY)

Schema diagram