﻿------------------------------Sayed 2023-06-18------------------

CREATE TABLE [dbo].[Promotions](
	[Serial] [float] NOT NULL,
	[EmployeeCode] [int] NULL,
	[PromotionReasonCode] [tinyint] NULL,
	[PromotionDate] [datetime] NULL,
	[OldSalary] [float] NULL,
	[NewSalary] [float] NULL,
	[Oldguest] [tinyint] NULL,
	[OldSection] [nvarchar](6) NULL,
	[OldPosition] [nvarchar](30) NULL,
	[OldLevel] [tinyint] NULL,
	[Newguest] [tinyint] NULL,
	[NewSection] [nvarchar](6) NULL,
	[NewPosition] [nvarchar](30) NULL,
	[NewLevel] [tinyint] NULL,
	[Closed] [bit] NULL,
	[OldLocation] [tinyint] NULL,
	[NewLocation] [tinyint] NULL,
	[OldBasicSalary] [float] NULL,
	[NewBasicSalary] [float] NULL,
	[PositingDate] [datetime] NULL,
	[IncreasesAmount] [float] NULL,
	[Fixedinsurance] [float] NULL,
	[OldExSalary] [float] NULL,
	[NewExSalary] [float] NULL,
	[CurrencyCode] [tinyint] NULL,
	[IncreasesCurrencyAmount] [float] NULL,
	[OldBasicCurrency] [float] NULL,
	[NewBasicCurrency] [float] NULL,
	[SystemType] [int] NULL,
	[PositingDateHijri] [nvarchar](10) NULL,
	[PromotionDateHijri] [nvarchar](10) NULL,
	[RecordAddBy] [nvarchar](20) NULL,
	[RecordAddDate] [datetime] NULL,
	[RecordLastChangeBy] [nvarchar](20) NULL,
	[RecordChangeDate] [datetime] NULL,
	[Comment] [nvarchar](255) NULL,
	[OldProjectCode] [int] NULL,
	[NewProjectCode] [int] NULL,
	[OldEmployeeGradeCode] [int] NULL,
	[NewEmployeeGradeCode] [int] NULL,
	[ChangeTypeCode] [int] NULL,
	[LocationApprovedProgressNumber] [int] NULL,
	[LocationApproved] [bit] NULL,
	[DepartmentalProgressNumber] [int] NULL,
	[DepartmentalApproved] [bit] NULL,
	[SalaryApproved] [bit] NULL,
	[IndemnityAmount] [float] NULL,
	[VacationsAmount] [float] NULL,
	[BAnnual] [float] NULL,
	[BDayOff] [float] NULL,
	[BHolidays] [float] NULL,
	[MDT] [datetime] NULL,
	[FutureDates] [bit] NULL,
 CONSTRAINT [PK_Promotions] PRIMARY KEY CLUSTERED 
(
	[Serial] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_Serial]  DEFAULT ((0)) FOR [Serial]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_PromotionReasonCode]  DEFAULT ((0)) FOR [PromotionReasonCode]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_NewSalary]  DEFAULT ((0)) FOR [NewSalary]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_Oldguest]  DEFAULT ((0)) FOR [Oldguest]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_OldLevel]  DEFAULT ((0)) FOR [OldLevel]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_Newguest]  DEFAULT ((0)) FOR [Newguest]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_NewLevel]  DEFAULT ((0)) FOR [NewLevel]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_Closed]  DEFAULT ((0)) FOR [Closed]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_OldLocation]  DEFAULT ((0)) FOR [OldLocation]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_NewLocation]  DEFAULT ((0)) FOR [NewLocation]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_LocationApproved]  DEFAULT ((0)) FOR [LocationApproved]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_DepartmentalApproved]  DEFAULT ((0)) FOR [DepartmentalApproved]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_SalaryApproved]  DEFAULT ((0)) FOR [SalaryApproved]
GO

ALTER TABLE [dbo].[Promotions] ADD  CONSTRAINT [DF_Promotions_FutureDates]  DEFAULT ((0)) FOR [FutureDates]
GO

--------------------------------------- End  2023-06-18 ----------------