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
NameTypeConstraintsDescription
payroll_tracking_portlet_column_screen_option_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
user_interface_grid_column_KEYint (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_KEYint (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_numberint (4)NOT NULLUsed to set the order of columns in the Firm/Payroll Tracking tab grid.
is_visiblebit (1)NOT NULLUsed to show or hide a given column in the Firm/Payroll Tracking tab grid.
Primary key
NameColumnsDescription
PK_Payroll_Tracking_Portlet_Column_Screen_Optionpayroll_tracking_portlet_column_screen_option_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Tracking_Portlet_Column_Screen_Option$custom_field_KEY$user_interface_grid_column_KEYcustom_field_KEY, user_interface_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Tracking_Portlet_Column_Screen_Option__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Field (custom_field_KEY)
FK_Payroll_Tracking_Portlet_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEYuser_interface_grid_column_KEYUser_Interface_Grid_Column (user_interface_grid_column_KEY)

Schema diagram