| 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 | ||