Table: dbo.Pay_Item_Exclusion_Detail
Table used to store selected payroll items exclusions.
Columns
Name | Type | Constraints | Description
pay_item_exclusion_detail_KEY | int (4) | NOT NULL | Primary key.
client_payroll_item_KEY | int (4) | NOT NULL | Foreign key to the client payroll item.
excluded__client_payroll_item_KEY | int (4) | NOT NULL | Key corresponding to the excluded payroll item.
exclude_regular | bit (1) | NOT NULL | Indicates that the client payroll item should exclude regular wages from this pay item.
exclude_OT | bit (1) | NOT NULL | Indicates that the client payroll item should exclude overtime wages from this pay item.
exclude_DT | bit (1) | NOT NULL | Indicates that the client payroll item should exclude doubletime wages from this pay item.
exclude_accruable_benefits | bit (1) | NOT NULL | Indicates that the client payroll item should exclude accruable benefit wages from this pay item.

Primary key
Name | Columns | Description
PK_Pay_Item_Exclusion_Detail | pay_item_exclusion_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Pay_Item_Exclusion_Detail$client_payroll_item_KEY$excluded__client_payroll_item_KEY | client_payroll_item_KEY, excluded__client_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Pay_Item_Exclusion_Detail__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Pay_Item_Exclusion_Detail__Client_Payroll_Item__excluded__client_payroll_item_KEY | excluded__client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |