Table: dbo.Import_Template_Column_Payroll_Item_Data
List of payroll items(deductions and pay item) and their types associated with a template column.
Columns
NameTypeConstraintsDescription
import_template_column_payroll_item_data_KEYint (4)NOT NULLPrimary key.
import_template_column_KEYint (4)NOT NULLParent record for the Import_Template_Column.
client_payroll_item_KEYint (4)NOT NULLPayroll item key for pay item.
is_pay_item_regular_hoursbit (1)NOT NULLSet it if this record is used by pay item only.
is_pay_item_overtime_hoursbit (1)NOT NULLSet if this record is used by pay item only.
is_pay_item_double_time_hoursbit (1)NOT NULLSet it if this record is used by pay item only.
is_amountbit (1)NOT NULLSet it if this record is used by both deductions and pay items.
is_ratebit (1)NOT NULLRate for pay items or deductions.
is_used_accrued_benefitbit (1)NOT NULLUsed Accrued Benefits used to mark the accrued benefit selection as column type.
client_benefit_KEYint (4)It will store user client benefit key selection for accrued benefits
Primary key
NameColumnsDescription
PK_Import_Template_Column_Payroll_Item_Dataimport_template_column_payroll_item_data_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_Payroll_Item_Data__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Import_Template_Column_Payroll_Item_Data__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Import_Template_Column_Payroll_Item_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)

Schema diagram