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
Name | Type | Constraints | Description
import_template_column_payroll_item_data_KEY | int (4) | NOT NULL | Primary key.
import_template_column_KEY | int (4) | NOT NULL | Parent record for the Import_Template_Column.
client_payroll_item_KEY | int (4) | NOT NULL | Payroll item key for pay item.
is_pay_item_regular_hours | bit (1) | NOT NULL | Set it if this record is used by pay item only.
is_pay_item_overtime_hours | bit (1) | NOT NULL | Set if this record is used by pay item only.
is_pay_item_double_time_hours | bit (1) | NOT NULL | Set it if this record is used by pay item only.
is_amount | bit (1) | NOT NULL | Set it if this record is used by both deductions and pay items.
is_rate | bit (1) | NOT NULL | Rate for pay items or deductions.
is_used_accrued_benefit | bit (1) | NOT NULL | Used Accrued Benefits used to mark the accrued benefit selection as column type.
client_benefit_KEY | int (4) |  | It will store user client benefit key selection for accrued benefits

Primary key
Name | Columns | Description
PK_Import_Template_Column_Payroll_Item_Data | import_template_column_payroll_item_data_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_Payroll_Item_Data__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |
FK_Import_Template_Column_Payroll_Item_Data__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Import_Template_Column_Payroll_Item_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |