| 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 | |||
| Name | Type | Constraints | Description |
| payroll_check_entry_option_payroll_item_definition_KEY | int (4) | NOT NULL | Primary Key. |
| client_pay_schedule_KEY | int (4) | NOT NULL | Indicates the payroll check option or pay schedule this record is tied to. |
| client_payroll_item_KEY | int (4) | NOT NULL | Indicates which payroll item we want displayed. |
| payroll_item_calculation_type_qualifier_KEY | int (4) | NOT NULL | Indicates the calculation type of the payroll item to determine if hours or amounts are going to be entered. |
| client_benefit_KEY | int (4) | Indicates that a benefit item for this payroll item is wanted on the display. | |
| sequence_number | int (4) | NOT NULL | Used to track the user-defined order that the columns appear in the display. |
| payroll_check_entry_option_payroll_item_definition_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Payroll_Check_Entry_Option_Payroll_Item_Definition | payroll_check_entry_option_payroll_item_definition_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Payroll_Check_Entry_Option_Payroll_Item_Definition$client_pay_schedule_KEY$client_payroll_item_KEY$payroll_item_calculation_t | client_pay_schedule_KEY, client_payroll_item_KEY, payroll_item_calculation_type_qualifier_KEY, client_benefit_KEY | ||