Table: dbo.Payroll_Check_Entry_Option_Payroll_Item_Definition
This table contains the data entry column definitions to configure the batch check entry grid.
Columns
NameTypeConstraintsDescription
payroll_check_entry_option_payroll_item_definition_KEYint (4)NOT NULLPrimary Key.
client_pay_schedule_KEYint (4)NOT NULLIndicates the payroll check option or pay schedule this record is tied to.
client_payroll_item_KEYint (4)NOT NULLIndicates which payroll item we want displayed.
payroll_item_calculation_type_qualifier_KEYint (4)NOT NULLIndicates the calculation type of the payroll item to determine if hours or amounts are going to be entered.
client_benefit_KEYint (4)Indicates that a benefit item for this payroll item is wanted on the display.
sequence_numberint (4)NOT NULLUsed to track the user-defined order that the columns appear in the display.
payroll_check_entry_option_payroll_item_definition_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_Definitionpayroll_check_entry_option_payroll_item_definition_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Entry_Option_Payroll_Item_Definition$client_pay_schedule_KEY$client_payroll_item_KEY$payroll_item_calculation_tclient_pay_schedule_KEY, client_payroll_item_KEY, payroll_item_calculation_type_qualifier_KEY, client_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option (client_pay_schedule_KEY)
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Payroll_Item_Calculation_Type_Qualifier__payroll_item_calculation_type_qupayroll_item_calculation_type_qualifier_KEYPayroll_Item_Calculation_Type_Qualifier (payroll_item_calculation_type_qualifier_KEY)

Schema diagram