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
Name | Type | Constraints | Description
payroll_check_entry_option_payroll_item_exclusion_KEY | int (4) | NOT NULL | Primary key for this table.
client_pay_schedule_KEY | int (4) | NOT NULL | Specifies the pay schedule from which the payroll item needs to be excluded.
client_payroll_item_KEY | int (4) | NOT NULL | Specifies the payroll item to be excluded from the pay schedule.
payroll_check_entry_option_payroll_item_exclusion_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row.

Primary key
Name | Columns | Description
PK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion | payroll_check_entry_option_payroll_item_exclusion_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion$client_pay_schedule_KEY$client_payroll_item_KEY | client_pay_schedule_KEY, client_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Payroll_Check_Entry_Option_Payroll_Item_Exclusion__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option (client_pay_schedule_KEY) |