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 |