﻿-------------------------Mostafa 2021-10-20----------------------
ALTER TABLE WF_NewHireRequest ALTER COLUMN LocationCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN DivisionCode nvarchar(20) NULL;
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN DepartmentCode nvarchar(20) NULL;
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN SectionCode nvarchar(20) NULL;
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN PositionCode nvarchar(30) NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN LevelCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN CurrencyCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN VacationCalcCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN ContractCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN GeneralTypeCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN HiringDate datetime NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN HiringDateHijri nvarchar(10) NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN ContractDate datetime NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN ContractDateHijri nvarchar(10) NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN InsuranceCode tinyint NULL; 
GO
ALTER TABLE WF_NewHireRequest ALTER COLUMN ReferenceCheck bit NULL; 
GO
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireAdministrativeDataRequired',N'Administrative Data Required',N'البيانات الإدارية إجبارية',N'true',2,11,1,1,Null,Null,5)
Go

INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHireContractDataRequired',N'Contract Data Required',N'بيانات التعاقد إجبارية',N'true',2,12,1,1,Null,Null,5)
Go
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFNewHirePrintReportForm',N'Report print form',N'نموذج طباعه التقرير',N'81',2,19,6,1,Null,Null,5)
Go
  
INSERT into [dbo].[ConfigLookup] ([ConfigLookupCode],[Arabic_Name],[Name],[ConfigKey])
values(81,N'نموذج الاول',N'First Model',N'WFNewHirePrintReportForm')
GO
INSERT into [dbo].[ConfigLookup] ([ConfigLookupCode],[Arabic_Name],[Name],[ConfigKey])
values(82,N' نموذج الثاني',N'Second Model',N'WFNewHirePrintReportForm')
GO



ALTER TABLE [dbo].[WF_NewHireRequest] ADD
EmployeeImage [nvarchar](max) NULL
GO
--------------------------End 2021-10-20----------------------
