UPDATE [dbo].[REF_CUSTOM_CONTROL_FRAME] SET [ReadOnly]=1, [SaveMode]=0 WHERE [Table_Name] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Full_Entitlement' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Full_Remaining' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Full_Taken' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'NoPay_Taken' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Person' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Plan_Type' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced1_Entitlement' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced1_Remaining' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced1_Taken' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced2_Entitlement' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced2_Remaining' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Reduced2_Taken' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Total_Full_Entitlement' AND [CustomisationID] = 0 UPDATE [dbo].[REF_CUSTOM_CONTROL] SET [Enabled]=1 WHERE [TableName] = N'VW_ADV_ABSENCE_PLAN_YEAR' AND [FieldName] = N'Year' AND [CustomisationID] = 0