Table: dbo.ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition
This table contains the selected pay and tax items in the After The Fact Handwritten Batch Check entry["BR"] options screen. A row in this table can represent either a pay or a tax item (but not both).
Columns
NameTypeConstraintsDescription
atf_payroll_check_entry_option_pay_and_tax_item_definition_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLEach employee can have a different list Handwritten Batch Check options when creating a batch.
client_payroll_item_KEYint (4)Indicates which payroll item we want displayed. A null value indicates that this row is a selected tax item.
payroll_item_calculation_type_qualifier_KEYint (4)Indicates the calculation type of the payroll item to determine if hours or amounts are going to be entered. A null value indicates that this row is a selected tax item and not a pay item.
client_benefit_KEYint (4)Indicates that a benefit item for this payroll item is wanted on the display. This is optional so a null value means that no benefits were selected.
sequence_numberint (4)NOT NULLUsed to track the user-defined order that the columns appear in the display.
row_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
client_tax_item_KEYint (4)Represents the tax item selected in a row in the grid. A null value indicates that the row is a pay item and not a tax item.
Primary key
NameColumnsDescription
PK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definitionatf_payroll_check_entry_option_pay_and_tax_item_definition_KEY
Unique constraints
NameColumnsDescription
UK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition$client_KEY$client_payroll_item_KEY$payroll_item_calculation_type_qclient_KEY, client_payroll_item_KEY, payroll_item_calculation_type_qualifier_KEY, client_benefit_KEY, client_tax_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client__client_KEYclient_KEYClient (client_KEY)
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Payroll_Item_Calculation_Type_Qualifier__payroll_item_calculationpayroll_item_calculation_type_qualifier_KEYPayroll_Item_Calculation_Type_Qualifier (payroll_item_calculation_type_qualifier_KEY)
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)

Schema diagram