Table: dbo.Payroll_Tracking_Portlet_Column_Screen_Option
This table holds the customized order and visibility of columns on payroll tracking tab grid and links to the user interface grid columns and client custom fields.
Columns
Name | Type | Constraints | Description
payroll_tracking_portlet_column_screen_option_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table.
user_interface_grid_column_KEY | int (4) |  | A link to User_Interface_Grid_Column table to get the key of the column. If custom_field_KEY is null then user_interface_grid_column_KEY must not be null and vice versa.
custom_field_KEY | int (4) |  | A link to Custom_Field table to get the key of client custom field. If user_interface_grid_column_KEY is null then custom_field_KEY must not be null and vice versa.
sequence_number | int (4) | NOT NULL | Used to set the order of columns in the Firm/Payroll Tracking tab grid.
is_visible | bit (1) | NOT NULL | Used to show or hide a given column in the Firm/Payroll Tracking tab grid.

Primary key
Name | Columns | Description
PK_Payroll_Tracking_Portlet_Column_Screen_Option | payroll_tracking_portlet_column_screen_option_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Tracking_Portlet_Column_Screen_Option$custom_field_KEY$user_interface_grid_column_KEY | custom_field_KEY, user_interface_grid_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Tracking_Portlet_Column_Screen_Option__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Field (custom_field_KEY) |
FK_Payroll_Tracking_Portlet_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEY | user_interface_grid_column_KEY | User_Interface_Grid_Column (user_interface_grid_column_KEY) |