Script

USE [master]
GO
/****** Object:  Database [CAPROJ_HRIS]    Script Date: 11/08/2018 7:32:31 PM ******/
CREATE DATABASE [CAPROJ_HRIS]

USE [CAPROJ_HRIS]
GO

CREATE TABLE [dbo].[ApplicantInformation](
    [ApplicantID] [INT] IDENTITY(1,1) NOT NULL,
    [FirstName] [VARCHAR](80) NOT NULL,
    [MiddleName] [VARCHAR](80) NOT NULL,
    [LastName] [VARCHAR](80) NOT NULL,
    [Birthdate] [DATE] NOT NULL,
    [Birthplace] [VARCHAR](50) NOT NULL,
    [Gender] [VARCHAR](6) NOT NULL,
    [Nationality] [VARCHAR](20) NOT NULL,
    [CivilStatus] [VARCHAR](20) NOT NULL,
    [Address] [VARCHAR](150) NOT NULL,
    [PhoneNumber] [VARCHAR](12) NOT NULL,
    [Email] [VARCHAR](50) NOT NULL,
    [Password] [VARCHAR](MAX) NOT NULL,
    [ActivationCode] [uniqueidentifier] NULL,
    [DesiredJobPosition] [INT] NOT NULL,
    [Attachments] [VARCHAR](MAX) NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_ApplicantInformation] PRIMARY KEY CLUSTERED
(
    [ApplicantID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ApplicantMessage]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ApplicantMessage](
    [ApplicantMessageID] [INT] IDENTITY(1,1) NOT NULL,
    [ApplicantID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [Message] [VARCHAR](1000) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_ApplicantMessage] PRIMARY KEY CLUSTERED
(
    [ApplicantMessageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ApplicantStatus]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ApplicantStatus](
    [ApplicantStatusID] [INT] IDENTITY(1,1) NOT NULL,
    [ApplicantID] [INT] NOT NULL,
    [UserID] [INT] NULL,
    [MetQuali] [VARCHAR](20) NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [Remarks] [VARCHAR](500) NULL,
    [DateModified] [datetime] NULL,
 CONSTRAINT [PK_ApplicantStatus] PRIMARY KEY CLUSTERED
(
    [ApplicantStatusID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Course]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Course](
    [CourseID] [INT] IDENTITY(1,1) NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [TrainingManager] [INT] NOT NULL,
    [CourseName] [VARCHAR](30) NOT NULL,
    [TYPE] [VARCHAR](30) NOT NULL,
    [Category] [VARCHAR](30) NOT NULL,
    [CourseDescription] [VARCHAR](500) NOT NULL,
    [CourseStart] [DATE] NOT NULL,
    [CourseEnd] [DATE] NOT NULL,
    [CourseExpiryDate] [DATE] NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_TrainingModule] PRIMARY KEY CLUSTERED
(
    [CourseID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CourseContent]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CourseContent](
    [CourseContentID] [INT] IDENTITY(1,1) NOT NULL,
    [TrainingModuleID] [INT] NOT NULL,
    [ModuleMaterial] [VARCHAR](MAX) NOT NULL,
    [Title] [VARCHAR](30) NULL,
    [Details] [VARCHAR](MAX) NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_CourseModule] PRIMARY KEY CLUSTERED
(
    [CourseContentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CourseParticipants]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CourseParticipants](
    [CourseParticipantsID] [INT] IDENTITY(1,1) NOT NULL,
    [CourseID] [INT] NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [Active] [INT] NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_CourseParticipants] PRIMARY KEY CLUSTERED
(
    [CourseParticipantsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CourseQuiz]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CourseQuiz](
    [CourseQuizID] [INT] IDENTITY(1,1) NOT NULL,
    [CourseID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [QuizName] [VARCHAR](100) NOT NULL,
    [Description] [VARCHAR](600) NOT NULL,
    [PassingScore] [INT] NOT NULL,
    [TotalScore] [INT] NOT NULL,
    [DateTimeStart] [datetime] NOT NULL,
    [DateTimeEnd] [datetime] NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_CourseQuiz] PRIMARY KEY CLUSTERED
(
    [CourseQuizID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CourseStatus]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CourseStatus](
    [CourseStatusID] [INT] IDENTITY(1,1) NOT NULL,
    [CourseQuizID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [Score] [INT] NOT NULL,
    [TotalMark] [INT] NOT NULL,
    [STATUS] [VARCHAR](10) NOT NULL,
    [DateEvaluated] [datetime] NOT NULL,
 CONSTRAINT [PK_TraingModuleStatus] PRIMARY KEY CLUSTERED
(
    [CourseStatusID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Employees]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
    [EmployeeID] [INT] IDENTITY(1,1) NOT NULL,
    [UserID] [INT] NOT NULL,
    [FirstName] [VARCHAR](80) NOT NULL,
    [MiddleName] [VARCHAR](80) NOT NULL,
    [LastName] [VARCHAR](80) NOT NULL,
    [EmployeeNumber] [INT] NOT NULL,
    [Gender] [VARCHAR](10) NOT NULL,
    [Birthdate] [DATE] NOT NULL,
    [Birthplace] [VARCHAR](80) NOT NULL,
    [Nationality] [VARCHAR](30) NOT NULL,
    [CivilStatus] [VARCHAR](20) NOT NULL,
    [HouseNo] [VARCHAR](100) NOT NULL,
    [City] [VARCHAR](50) NOT NULL,
    [Province] [NCHAR](50) NOT NULL,
    [ContactNumber] [VARCHAR](12) NOT NULL,
    [Email] [VARCHAR](30) NOT NULL,
    [POSITION] [VARCHAR](50) NOT NULL,
    [Department] [VARCHAR](50) NOT NULL,
    [Designation] [VARCHAR](50) NOT NULL,
    [DateHired] [DATE] NOT NULL,
    [EmploymentStatus] [VARCHAR](50) NOT NULL,
    [TIN] [VARCHAR](30) NOT NULL,
    [SSS] [VARCHAR](30) NOT NULL,
    [HDMF] [VARCHAR](30) NOT NULL,
    [PHIC] [VARCHAR](30) NOT NULL,
    [Supervisor] [VARCHAR](80) NOT NULL,
    [Remarks] [VARCHAR](150) NOT NULL,
    [Photo] [VARCHAR](MAX) NOT NULL,
    [Attachments] [VARCHAR](MAX) NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
    [EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EvaluationFormDetails]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EvaluationFormDetails](
    [EvaluationFormDetailsID] [INT] IDENTITY(1,1) NOT NULL,
    [UserID] [INT] NOT NULL,
    [TYPE] [VARCHAR](20) NOT NULL,
    [Description] [VARCHAR](600) NOT NULL,
    [DateTimeStart] [datetime] NOT NULL,
    [DateTimeEnd] [datetime] NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_EvaluationFormDetails] PRIMARY KEY CLUSTERED
(
    [EvaluationFormDetailsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EvaluationOptions]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EvaluationOptions](
    [EvaluationOptionsID] [INT] IDENTITY(1,1) NOT NULL,
    [EvaluationQuestionsID] [INT] NOT NULL,
    [OptionOne] [VARCHAR](500) NULL,
    [OptionTwo] [VARCHAR](500) NULL,
    [OptionThree] [VARCHAR](500) NULL,
    [LastUpdated] [datetime] NOT NULL,
 CONSTRAINT [PK_EvaluationOptions] PRIMARY KEY CLUSTERED
(
    [EvaluationOptionsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EvaluationResponse]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EvaluationResponse](
    [EvaluationResponseID] [INT] IDENTITY(1,1) NOT NULL,
    [EvaluationQuestiondID] [INT] NOT NULL,
    [EvaluationOptionsID] [INT] NOT NULL,
    [LastUpdated] [datetime] NOT NULL,
 CONSTRAINT [PK_EvaluationResponse] PRIMARY KEY CLUSTERED
(
    [EvaluationResponseID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[EvaluationResult]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EvaluationResult](
    [EvaluationResultID] [INT] IDENTITY(1,1) NOT NULL,
    [UserID] [INT] NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [EvaluationResponseID] [INT] NOT NULL,
    [RatingScore] [DECIMAL](18, 2) NOT NULL,
    [Remarks] [VARCHAR](30) NOT NULL,
    [LastUpdated] [datetime] NOT NULL,
 CONSTRAINT [PK_EvaluationResult] PRIMARY KEY CLUSTERED
(
    [EvaluationResultID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EvaluationsQuestions]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EvaluationsQuestions](
    [EvaluationsQuestionsID] [INT] IDENTITY(1,1) NOT NULL,
    [EvaluationFormDetailsID] [INT] NOT NULL,
    [QuestionOrder] [INT] NOT NULL,
    [TYPE] [VARCHAR](20) NOT NULL,
    [Questions] [VARCHAR](500) NOT NULL,
    [LastUpdated] [datetime] NOT NULL,
 CONSTRAINT [PK_EvaluationsQuestions] PRIMARY KEY CLUSTERED
(
    [EvaluationsQuestionsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[InterviewSchedule]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InterviewSchedule](
    [InterviewSchedID] [INT] IDENTITY(1,1) NOT NULL,
    [ApplicantID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [DATE] [DATE] NOT NULL,
    [TIME] [TIME](7) NOT NULL,
    [Notes] [VARCHAR](500) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_InterviewSchedule] PRIMARY KEY CLUSTERED
(
    [InterviewSchedID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[JobPosting]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[JobPosting](
    [JobPostID] [INT] IDENTITY(1,1) NOT NULL,
    [PostedBy] [INT] NOT NULL,
    [JobTitle] [VARCHAR](100) NOT NULL,
    [JobDescription] [VARCHAR](MAX) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_JobPosting] PRIMARY KEY CLUSTERED
(
    [JobPostID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[JobPostingStatus]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[JobPostingStatus](
    [JobPostStatusID] [INT] IDENTITY(1,1) NOT NULL,
    [JobPostID] [INT] NOT NULL,
    [ApprovedBy] [INT] NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [Remarks] [VARCHAR](500) NULL,
    [DateModified] [datetime] NULL,
 CONSTRAINT [PK_JobPostingStatus] PRIMARY KEY CLUSTERED
(
    [JobPostStatusID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LeaveRequest]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LeaveRequest](
    [LeaveRequestID] [INT] IDENTITY(1,1) NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [LeaveType] [VARCHAR](50) NOT NULL,
    [Reason] [VARCHAR](300) NOT NULL,
    [DateFrom] [DATE] NOT NULL,
    [DateTo] [DATE] NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_LeaveRequest] PRIMARY KEY CLUSTERED
(
    [LeaveRequestID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LeaveRequestStatus]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LeaveRequestStatus](
    [LeaveRequestStatusID] [INT] IDENTITY(1,1) NOT NULL,
    [LeaveRequestID] [INT] NOT NULL,
    [UserID] [INT] NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [Remarks] [VARCHAR](500) NULL,
    [DateModified] [datetime] NULL,
 CONSTRAINT [PK_LeaveRequestStatus] PRIMARY KEY CLUSTERED
(
    [LeaveRequestStatusID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PayCheck]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PayCheck](
    [PaycheckID] [INT] IDENTITY(1,1) NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [PayDateFrom] [DATE] NOT NULL,
    [PayDateTo] [DATE] NOT NULL,
    [RateType] [VARCHAR](50) NOT NULL,
    [PayHours] [DECIMAL](18, 2) NOT NULL,
    [RegularDays] [DECIMAL](18, 2) NOT NULL,
    [DaysAbsent] [DECIMAL](18, 2) NULL,
    [HoursLate] [DECIMAL](18, 2) NULL,
    [OtHours] [DECIMAL](18, 2) NULL,
    [Regular] [DECIMAL](18, 2) NOT NULL,
    [VacationLeave] [DECIMAL](18, 2) NULL,
    [SickLeave] [DECIMAL](18, 2) NULL,
    [MaternLPaternL] [DECIMAL](18, 2) NULL,
    [OrdinaryL] [DECIMAL](18, 2) NULL,
    [Absences] [DECIMAL](18, 2) NULL,
    [Lates] [DECIMAL](18, 2) NULL,
    [Undertime] [DECIMAL](18, 2) NULL,
    [OTND] [DECIMAL](18, 2) NULL,
    [Month13] [DECIMAL](18, 2) NULL,
    [Bonus] [DECIMAL](18, 2) NULL,
    [COLA] [DECIMAL](18, 2) NULL,
    [Transpo] [DECIMAL](18, 2) NULL,
    [Repre] [DECIMAL](18, 2) NULL,
    [Housing] [DECIMAL](18, 2) NULL,
    [Backpay] [DECIMAL](18, 2) NULL,
    [OtherEarnings] [DECIMAL](18, 2) NULL,
    [TotalEarnings] [DECIMAL](18, 2) NOT NULL,
    [SSS] [DECIMAL](18, 2) NOT NULL,
    [PHIC] [DECIMAL](18, 2) NOT NULL,
    [HDMF] [DECIMAL](18, 2) NOT NULL,
    [HealthIns] [DECIMAL](18, 2) NULL,
    [TaxAdj] [DECIMAL](18, 2) NULL,
    [PayUnion] [DECIMAL](18, 2) NULL,
    [Tax] [DECIMAL](18, 2) NULL,
    [OtherDeductions] [DECIMAL](18, 2) NULL,
    [LoanDeductions] [DECIMAL](18, 2) NULL,
    [Bereave] [DECIMAL](18, 2) NULL,
    [TotalDeductions] [DECIMAL](18, 2) NOT NULL,
    [RegularRate] [DECIMAL](18, 2) NOT NULL,
    [NetPay] [DECIMAL](18, 2) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_PayCheck] PRIMARY KEY CLUSTERED
(
    [PaycheckID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PayCheckDiscrepancy]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PayCheckDiscrepancy](
    [PaycheckDiscrepancyID] [INT] IDENTITY(1,1) NOT NULL,
    [PaycheckID] [INT] NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [Details] [VARCHAR](300) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_PayCheckDiscrepancy] PRIMARY KEY CLUSTERED
(
    [PaycheckDiscrepancyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PaycheckDiscStatus]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PaycheckDiscStatus](
    [PayCheckDiscStatusID] [INT] IDENTITY(1,1) NOT NULL,
    [PaycheckDiscrepancyID] [INT] NOT NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [Remarks] [VARCHAR](500) NULL,
    [UserID] [INT] NULL,
    [DateModified] [datetime] NULL,
 CONSTRAINT [PK_PaycheckDiscStatus] PRIMARY KEY CLUSTERED
(
    [PayCheckDiscStatusID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PreEmloymentChecklists]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PreEmloymentChecklists](
    [PreEmploymentChecklistsID] [INT] IDENTITY(1,1) NOT NULL,
    [ApplicantID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [Task] [VARCHAR](100) NOT NULL,
    [Due] [DATE] NOT NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_PreEmloymentChecklists_1] PRIMARY KEY CLUSTERED
(
    [PreEmploymentChecklistsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PreEmploymentChecklists]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PreEmploymentChecklists](
    [PreEmploymentChecklistsID] [INT] IDENTITY(1,1) NOT NULL,
    [ApplicantID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [Task] [VARCHAR](100) NOT NULL,
    [Due] [DATE] NOT NULL,
    [STATUS] [VARCHAR](20) NOT NULL,
    [DateAdded] [datetime] NOT NULL,
 CONSTRAINT [PK_PreEmloymentChecklists] PRIMARY KEY CLUSTERED
(
    [PreEmploymentChecklistsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QuizQuestionAnswer]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QuizQuestionAnswer](
    [QuestionAnswerID] [INT] IDENTITY(1,1) NOT NULL,
    [QuizQuestionsID] [INT] NOT NULL,
    [Answer] [INT] NOT NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_QuizAnswer] PRIMARY KEY CLUSTERED
(
    [QuestionAnswerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[QuizQuestionOptions]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QuizQuestionOptions](
    [QuestionOptionsID] [INT] IDENTITY(1,1) NOT NULL,
    [QuizQuestionsID] [INT] NOT NULL,
    [OptionOne] [VARCHAR](100) NOT NULL,
    [OptionTwo] [VARCHAR](100) NOT NULL,
    [OptionThree] [VARCHAR](100) NOT NULL,
    [OptionFour] [VARCHAR](100) NOT NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_QuizOptions] PRIMARY KEY CLUSTERED
(
    [QuestionOptionsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QuizQuestions]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QuizQuestions](
    [QuizQuestionsID] [INT] IDENTITY(1,1) NOT NULL,
    [CourseQuizID] [INT] NOT NULL,
    [Question] [VARCHAR](500) NOT NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_QuizQuestions] PRIMARY KEY CLUSTERED
(
    [QuizQuestionsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[QuizUserResponse]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[QuizUserResponse](
    [QuizResponseID] [INT] IDENTITY(1,1) NOT NULL,
    [EmployeeID] [INT] NOT NULL,
    [QuizQuestionsID] [INT] NOT NULL,
    [QuizOptionsID] [INT] NOT NULL,
    [LastUpdated] [datetime] NOT NULL,
 CONSTRAINT [PK_QuizResponse] PRIMARY KEY CLUSTERED
(
    [QuizResponseID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Users]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users](
    [UserID] [INT] IDENTITY(1,1) NOT NULL,
    [TypeID] [INT] NOT NULL,
    [EmployeeID] [INT] NULL,
    [Username] [VARCHAR](40) NOT NULL,
    [Password] [VARCHAR](MAX) NOT NULL,
    [SecurityQuestion1] [VARCHAR](80) NOT NULL,
    [SecurityAnswer1] [VARCHAR](80) NOT NULL,
    [SecurityQuestion2] [VARCHAR](80) NOT NULL,
    [SecurityAnswer2] [VARCHAR](80) NOT NULL,
    [DateModified] [datetime] NOT NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
    [UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[UserType]    Script Date: 11/08/2018 7:32:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UserType](
    [TypeID] [INT] IDENTITY(1,1) NOT NULL,
    [UserType] [VARCHAR](30) NOT NULL,
 CONSTRAINT [PK_UserType] PRIMARY KEY CLUSTERED
(
    [TypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[ApplicantInformation] ON

INSERT [dbo].[ApplicantInformation] ([ApplicantID], [FirstName], [MiddleName], [LastName], [Birthdate], [Birthplace], [Gender], [Nationality], [CivilStatus], [Address], [PhoneNumber], [Email], [Password], [ActivationCode], [DesiredJobPosition], [Attachments], [DateAdded]) VALUES (6, N'Emmanuel', N'Dango', N'Genito', CAST(N'1998-07-13' AS DATE), N'Makati', N'Male', N'Filipino', N'Single', N'B5 L7', N'0916667038', N'ejgenito@gmail.com', N'DdPlEmQsl8o/dH+aduN0+9pz+SkoI8AxO+nXit183Y9yI1rwxVPdJnl+eOGFTt7grgAviroHSwZt/OGvEU4y+A==', NULL, 1012, N'20181104214625-', CAST(N'2018-11-04 21:46:25.933' AS DateTime))
INSERT [dbo].[ApplicantInformation] ([ApplicantID], [FirstName], [MiddleName], [LastName], [Birthdate], [Birthplace], [Gender], [Nationality], [CivilStatus], [Address], [PhoneNumber], [Email], [Password], [ActivationCode], [DesiredJobPosition], [Attachments], [DateAdded]) VALUES (8, N'Meredith', N'Pacia', N'De La Cruz', CAST(N'1989-09-18' AS DATE), N'Sorsogon ', N'Female', N'Filipino', N'Single', N'B43 Manila', N'09166908767', N'akoayaco123@gmail.com', N'DdPlEmQsl8o/dH+aduN0+9pz+SkoI8AxO+nXit183Y9yI1rwxVPdJnl+eOGFTt7grgAviroHSwZt/OGvEU4y+A==', NULL, 1011, N'20181106232426-', CAST(N'2018-11-06 23:24:26.960' AS DateTime))
SET IDENTITY_INSERT [dbo].[ApplicantInformation] OFF
SET IDENTITY_INSERT [dbo].[ApplicantMessage] ON

INSERT [dbo].[ApplicantMessage] ([ApplicantMessageID], [ApplicantID], [UserID], [Message], [DateAdded]) VALUES (3, 6, 1022, N'Hello!', CAST(N'2018-11-04 23:22:27.783' AS DateTime))
SET IDENTITY_INSERT [dbo].[ApplicantMessage] OFF
SET IDENTITY_INSERT [dbo].[ApplicantStatus] ON

INSERT [dbo].[ApplicantStatus] ([ApplicantStatusID], [ApplicantID], [UserID], [MetQuali], [STATUS], [Remarks], [DateModified]) VALUES (2, 6, 1022, N'On Screening', N'Processing', N'N/A', CAST(N'2018-11-04 23:16:57.027' AS DateTime))
INSERT [dbo].[ApplicantStatus] ([ApplicantStatusID], [ApplicantID], [UserID], [MetQuali], [STATUS], [Remarks], [DateModified]) VALUES (4, 8, NULL, NULL, N'Pending', NULL, NULL)
SET IDENTITY_INSERT [dbo].[ApplicantStatus] OFF
SET IDENTITY_INSERT [dbo].[Course] ON

INSERT [dbo].[Course] ([CourseID], [EmployeeID], [TrainingManager], [CourseName], [TYPE], [Category], [CourseDescription], [CourseStart], [CourseEnd], [CourseExpiryDate], [DateAdded]) VALUES (19, 3, 1022, N'Business Math', N'Personal Skills', N'Managerial', N'Math', CAST(N'2018-11-08' AS DATE), CAST(N'2018-11-17' AS DATE), CAST(N'2018-11-28' AS DATE), CAST(N'2018-11-01 13:52:52.033' AS DateTime))
INSERT [dbo].[Course] ([CourseID], [EmployeeID], [TrainingManager], [CourseName], [TYPE], [Category], [CourseDescription], [CourseStart], [CourseEnd], [CourseExpiryDate], [DateAdded]) VALUES (20, 3, 1022, N'Manegerial', N'Operations', N'Managerial', N'Naala', CAST(N'2018-11-01' AS DATE), CAST(N'2018-11-08' AS DATE), CAST(N'2018-11-26' AS DATE), CAST(N'2018-11-07 20:59:25.053' AS DateTime))
SET IDENTITY_INSERT [dbo].[Course] OFF
SET IDENTITY_INSERT [dbo].[CourseContent] ON

INSERT [dbo].[CourseContent] ([CourseContentID], [TrainingModuleID], [ModuleMaterial], [Title], [Details], [DateModified]) VALUES (14, 19, N'20181101210646-', N'Lesson 1', N'dsfafa', CAST(N'2018-11-01 21:06:46.893' AS DateTime))
INSERT [dbo].[CourseContent] ([CourseContentID], [TrainingModuleID], [ModuleMaterial], [Title], [Details], [DateModified]) VALUES (15, 19, N'20181101210656-', N'Lesson 2', N'asd', CAST(N'2018-11-01 21:06:56.147' AS DateTime))
INSERT [dbo].[CourseContent] ([CourseContentID], [TrainingModuleID], [ModuleMaterial], [Title], [Details], [DateModified]) VALUES (16, 19, N'20181101210707-', N'Chapter 12', N'asas', CAST(N'2018-11-01 21:07:07.053' AS DateTime))
INSERT [dbo].[CourseContent] ([CourseContentID], [TrainingModuleID], [ModuleMaterial], [Title], [Details], [DateModified]) VALUES (17, 19, N'20181101210716-', N'Chapter 10', N'aa', CAST(N'2018-11-01 21:07:16.917' AS DateTime))
INSERT [dbo].[CourseContent] ([CourseContentID], [TrainingModuleID], [ModuleMaterial], [Title], [Details], [DateModified]) VALUES (18, 19, N'20181101210809-', N'3', N'faf', CAST(N'2018-11-01 21:08:09.207' AS DateTime))
SET IDENTITY_INSERT [dbo].[CourseContent] OFF
SET IDENTITY_INSERT [dbo].[CourseParticipants] ON

INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (8, 19, 1002, 1, CAST(N'2018-11-01 20:04:44.483' AS DateTime))
INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (9, 19, 1003, 1, CAST(N'2018-11-01 20:11:29.160' AS DateTime))
INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (10, 20, 3, 1, CAST(N'2018-11-07 20:59:39.167' AS DateTime))
INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (11, 20, 1002, 1, CAST(N'2018-11-07 20:59:39.170' AS DateTime))
INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (12, 20, 1003, 1, CAST(N'2018-11-07 20:59:39.197' AS DateTime))
INSERT [dbo].[CourseParticipants] ([CourseParticipantsID], [CourseID], [EmployeeID], [Active], [DateAdded]) VALUES (13, 19, 3, 1, CAST(N'2018-11-07 21:04:28.037' AS DateTime))
SET IDENTITY_INSERT [dbo].[CourseParticipants] OFF
SET IDENTITY_INSERT [dbo].[CourseQuiz] ON

INSERT [dbo].[CourseQuiz] ([CourseQuizID], [CourseID], [UserID], [QuizName], [Description], [PassingScore], [TotalScore], [DateTimeStart], [DateTimeEnd], [DateAdded]) VALUES (3, 19, 1022, N'Quiz 1', N'sasf', 7, 10, CAST(N'2018-11-01 00:00:00.000' AS DateTime), CAST(N'2018-11-02 00:00:00.000' AS DateTime), CAST(N'2018-11-01 14:02:57.640' AS DateTime))
SET IDENTITY_INSERT [dbo].[CourseQuiz] OFF
SET IDENTITY_INSERT [dbo].[CourseStatus] ON

INSERT [dbo].[CourseStatus] ([CourseStatusID], [CourseQuizID], [UserID], [Score], [TotalMark], [STATUS], [DateEvaluated]) VALUES (2, 3, 2019, 1, 2, N'Fail', CAST(N'2018-11-02 22:35:32.000' AS DateTime))
SET IDENTITY_INSERT [dbo].[CourseStatus] OFF
SET IDENTITY_INSERT [dbo].[Employees] ON

INSERT [dbo].[Employees] ([EmployeeID], [UserID], [FirstName], [MiddleName], [LastName], [EmployeeNumber], [Gender], [Birthdate], [Birthplace], [Nationality], [CivilStatus], [HouseNo], [City], [Province], [ContactNumber], [Email], [POSITION], [Department], [Designation], [DateHired], [EmploymentStatus], [TIN], [SSS], [HDMF], [PHIC], [Supervisor], [Remarks], [Photo], [Attachments], [DateModified]) VALUES (3, 1022, N'Emmanuel Jr', N'Dango', N'Genito', 2313, N'Male', CAST(N'1900-01-01' AS DATE), N'Makati', N'Filipino', N'Single', N'B21, L6, GPH, Mambog 6', N'Bacoor', N'Cavite                                            ', N'0916667038', N'ejgenito@gmail.com', N'HR Administrator', N'Corporate Affairs', N'PromoSphere Inc.', CAST(N'1900-01-01' AS DATE), N'Permanent', N'123', N'2313', N'1231', N'213', N'Ana Montengero', N'N/A', N'20181107234349-IMG_20181006_223713.jpg', N'20181107234349-', CAST(N'2018-11-07 23:43:49.973' AS DateTime))
INSERT [dbo].[Employees] ([EmployeeID], [UserID], [FirstName], [MiddleName], [LastName], [EmployeeNumber], [Gender], [Birthdate], [Birthplace], [Nationality], [CivilStatus], [HouseNo], [City], [Province], [ContactNumber], [Email], [POSITION], [Department], [Designation], [DateHired], [EmploymentStatus], [TIN], [SSS], [HDMF], [PHIC], [Supervisor], [Remarks], [Photo], [Attachments], [DateModified]) VALUES (1002, 2019, N'Tony', N'Mario', N'Starks', 1234, N'Male', CAST(N'1989-11-22' AS DATE), N'Sorsogon ', N'Filipino', N'Single', N'', N'', N'                                                  ', N'0916668979', N'tonymario@gmail.com', N'Merchandiser', N'Operations', N'PromoSphere Inc.', CAST(N'2017-09-18' AS DATE), N'Contractual', N'123', N'123', N'1213', N'1213', N'Ana Montenegro', N'N/A', N'20181101170838-37.jpg', N'20181101170838-001SD.txt', CAST(N'2018-11-01 17:08:38.103' AS DateTime))
INSERT [dbo].[Employees] ([EmployeeID], [UserID], [FirstName], [MiddleName], [LastName], [EmployeeNumber], [Gender], [Birthdate], [Birthplace], [Nationality], [CivilStatus], [HouseNo], [City], [Province], [ContactNumber], [Email], [POSITION], [Department], [Designation], [DateHired], [EmploymentStatus], [TIN], [SSS], [HDMF], [PHIC], [Supervisor], [Remarks], [Photo], [Attachments], [DateModified]) VALUES (1003, 2020, N'Brendon', N'Boyd', N'Urie', 123, N'Male', CAST(N'1984-04-04' AS DATE), N'Makati City', N'Filipino', N'Single', N'#456, Brgy. Maharlika', N'Manila', N'NCR                                               ', N'0916667680', N'brendonurie@gmail.com', N'Promodiser', N'Operations', N'PromoSphere Inc.', CAST(N'2018-09-18' AS DATE), N'Permanent', N'1234', N'1234', N'1233', N'1234', N'Ana Montenegro', N'N/A', N'20181101201121-20170221_202529.jpg', N'20181101201121-001SD.txt', CAST(N'2018-11-01 20:11:21.477' AS DateTime))
SET IDENTITY_INSERT [dbo].[Employees] OFF
SET IDENTITY_INSERT [dbo].[EvaluationFormDetails] ON

INSERT [dbo].[EvaluationFormDetails] ([EvaluationFormDetailsID], [UserID], [TYPE], [Description], [DateTimeStart], [DateTimeEnd], [DateAdded]) VALUES (1, 1022, N'Merchandiser', N'Almdsd', CAST(N'2018-10-01 00:00:00.000' AS DateTime), CAST(N'2018-11-30 00:00:00.000' AS DateTime), CAST(N'2018-11-07 23:48:58.023' AS DateTime))
SET IDENTITY_INSERT [dbo].[EvaluationFormDetails] OFF
SET IDENTITY_INSERT [dbo].[EvaluationOptions] ON

INSERT [dbo].[EvaluationOptions] ([EvaluationOptionsID], [EvaluationQuestionsID], [OptionOne], [OptionTwo], [OptionThree], [LastUpdated]) VALUES (1, 1, N'', N'', N'', CAST(N'2018-11-08 00:51:37.173' AS DateTime))
SET IDENTITY_INSERT [dbo].[EvaluationOptions] OFF
SET IDENTITY_INSERT [dbo].[EvaluationsQuestions] ON

INSERT [dbo].[EvaluationsQuestions] ([EvaluationsQuestionsID], [EvaluationFormDetailsID], [QuestionOrder], [TYPE], [Questions], [LastUpdated]) VALUES (1, 1, 1, N'Skills', N'asfafaf', CAST(N'2018-11-08 00:51:37.110' AS DateTime))
SET IDENTITY_INSERT [dbo].[EvaluationsQuestions] OFF
SET IDENTITY_INSERT [dbo].[InterviewSchedule] ON

INSERT [dbo].[InterviewSchedule] ([InterviewSchedID], [ApplicantID], [UserID], [DATE], [TIME], [Notes], [DateAdded]) VALUES (3, 6, 1022, CAST(N'2018-11-08' AS DATE), CAST(N'12:30:00' AS TIME), N'Please wear formal attire, and look for Mr. Adrian.', CAST(N'2018-11-04 23:18:18.060' AS DateTime))
SET IDENTITY_INSERT [dbo].[InterviewSchedule] OFF
SET IDENTITY_INSERT [dbo].[JobPosting] ON

INSERT [dbo].[JobPosting] ([JobPostID], [PostedBy], [JobTitle], [JobDescription], [DateAdded]) VALUES (1010, 1022, N'Marketing Services Account Manager', N'<h2>
    <strong>Qualifications:</strong></h2>
<ul>
    <li>
        Female</li>
    <li>
        Age 21-28 years old</li>
    <li>
        Marketing / Management / Business Administration / Advertising course from a reputable school</li>
    <li>
        At least 2 years in advertising, marketing / brand management. promotions or events</li>
    <li>
        Good track record of accomplishment from previous employers</li>
    <li>
        Possesses good oral and written communication skills</li>
    <li>
        Good interpersonal skills.</li>
    <li>
        Good analytical skills</li>
    <li>
        Pleasing personality</li>
    <li>
        Advanced MS applications user (Word, Excel and Powerpoint)</li>
    <li>
        Holder of a driver’s license is an advantage</li>
</ul>
<h2>
    <br />
    Functions/Job Description (core responsibilities)</h2>
<ul>
    <li>
        Represents the Company and all of its transactions to assigned Clients</li>
    <li>
        Opens new Clients to increase the Company’s Clients Portfolio</li>
    <li>
        Plots marketing services solutions</li>
    <li>
        Represents the Company in Client initiated pitches/bidding</li>
    <li>
        Gain Client trust and confidence by managing demands and requirements with zero complains</li>
    <li>
        Appoints possible partners in the execution of marketing services</li>
    <li>
        Submits required reports on time</li>
    <li>
        Manages on-board projects assigned by direct superior</li>
    <li>
        Other tasks that may be assigned by superior from time to time</li>
</ul>
<p>
     </p>
', CAST(N'2018-11-03 19:07:28.060' AS DateTime))
INSERT [dbo].[JobPosting] ([JobPostID], [PostedBy], [JobTitle], [JobDescription], [DateAdded]) VALUES (1011, 1022, N'Merchandising Coordinator', N'<h3>
    Qualifications</h3>
<p>
     </p>
<ul>
    <li>
        Male / Female</li>
    <li>
        Age 24-32 years old</li>
    <li>
        Marketing / Management / Business Administration / Advertising / Communications / Psychology</li>
    <li>
        At least 1-2 years in managing people</li>
    <li>
        Good track record of accomplishment from previous employers</li>
    <li>
        Possesses good oral and written communication skills</li>
    <li>
        Pleasing personality</li>
    <li>
        MS applications user (Word, Excel and Powerpoint)</li>
</ul>
<h3>
    Functions/Job Description (core responsibilities)</h3>
<ul>
    <li>
        Ensures 100% deployment of personnel at all times</li>
    <li>
        Monitors strictly absenteeism and ensures the deployment of reliever basis personnel</li>
    <li>
        At least 100% account monitoring achievement vis-à-vis monthly coverage plan</li>
    <li>
        Maintains good relationship with retail account/outlet based personnel</li>
    <li>
        Ensures Merchandising Systems (FIFO, Correct Pricing, Optimized use of POS and Fullness of Display ) are followed at all times</li>
    <li>
        Ensures Merchandisers’ Basic Call Procedure are followed at all times</li>
    <li>
        Ensures 100% compliance of merchandisers over corporate/brand released planograms</li>
    <li>
        On time execution of promotions and activities</li>
    <li>
        Adherence to retail and account policies</li>
    <li>
        Ensure the timeliness and accurateness of all reports submitted (product inventory, offtake report, pricing surveys, facings, etc.)</li>
</ul>
', CAST(N'2018-11-04 18:02:18.997' AS DateTime))
INSERT [dbo].[JobPosting] ([JobPostID], [PostedBy], [JobTitle], [JobDescription], [DateAdded]) VALUES (1012, 1022, N'Administrative Assistants ', N'<h3>
    Qualifications:</h3>
<p>
     </p>
<ul>
    <li>
        Female</li>
    <li>
        Age 21-28 years old</li>
    <li>
        Computer Science and other computer related courses</li>
    <li>
        At least 6 months experience as Admin Assistant or secretary</li>
    <li>
        Good track record of accomplishment from previous employers</li>
    <li>
        Possesses good oral and written communication skills</li>
    <li>
        Good analytical skills</li>
    <li>
        Pleasing personality</li>
    <li>
        Advanced MS applications user (Word, Excel and Powerpoint)</li>
</ul>
<h3>
    <br />
    Functions/Job Description (core responsibilities)</h3>
<ul>
    <li>
        Encodes, Analyzes and  summarizes all required reports</li>
    <li>
        Coordinates with all concerned parties to address issues and concerns</li>
    <li>
        Other tasks that maybe assigned by direct superior</li>
</ul>
', CAST(N'2018-11-04 18:58:15.737' AS DateTime))
INSERT [dbo].[JobPosting] ([JobPostID], [PostedBy], [JobTitle], [JobDescription], [DateAdded]) VALUES (1013, 1022, N'Sales Promoters and Brand Ambassadors ', N'<h3>
    Qualifications:</h3>
<ul>
    <li>
        Female</li>
    <li>
        Age 21-28 years old</li>
    <li>
        College Level</li>
    <li>
        At least 6 months experience In implementing marketing activities</li>
    <li>
        Good track record of accomplishment from previous employers</li>
    <li>
        Possesses good oral communication skills</li>
    <li>
        Pleasing personality</li>
    <li>
        Good PR Abilities</li>
</ul>
<h3>
    <br />
    Functions/Job Description (core responsibilities)</h3>
<ul>
    <li>
        Responsible for hitting Account Specific given Sales Targets</li>
    <li>
        Encourages shoppers to buy the product</li>
    <li>
        Represents the Company and its brands and products in the trade</li>
    <li>
        Develops goodwill among the consumers of our brands</li>
    <li>
        Communicates the features, advantages, and benefits of our products to targeted consumers</li>
    <li>
        Engages the consumers – not just dependent on spiel but can really put up a good conversation with consumers</li>
    <li>
        Gathers feedback from consumers</li>
    <li>
        Addresses queries of consumer about the brand and the product – technical knowledge on the usage of the product Encodes, Analyzes and  summarizes all required reports</li>
    <li>
        Coordinates with all concerned parties to address issues and concerns</li>
    <li>
        Submits Inventory, Competitive Activities, Out of Stock (OS) and all other needed reports are submitted on time and are accurate </li>
</ul>
', CAST(N'2018-11-04 18:59:30.760' AS DateTime))
SET IDENTITY_INSERT [dbo].[JobPosting] OFF
SET IDENTITY_INSERT [dbo].[JobPostingStatus] ON

INSERT [dbo].[JobPostingStatus] ([JobPostStatusID], [JobPostID], [ApprovedBy], [STATUS], [Remarks], [DateModified]) VALUES (2, 1010, 1022, N'Posted', N'N/A', CAST(N'2018-11-03 19:12:53.853' AS DateTime))
INSERT [dbo].[JobPostingStatus] ([JobPostStatusID], [JobPostID], [ApprovedBy], [STATUS], [Remarks], [DateModified]) VALUES (3, 1011, 1022, N'Posted', N'N/A', CAST(N'2018-11-04 19:02:55.283' AS DateTime))
INSERT [dbo].[JobPostingStatus] ([JobPostStatusID], [JobPostID], [ApprovedBy], [STATUS], [Remarks], [DateModified]) VALUES (4, 1012, 1022, N'Posted', N'N/A', CAST(N'2018-11-04 19:03:23.090' AS DateTime))
INSERT [dbo].[JobPostingStatus] ([JobPostStatusID], [JobPostID], [ApprovedBy], [STATUS], [Remarks], [DateModified]) VALUES (5, 1013, 1022, N'Posted', N'N/A', CAST(N'2018-11-04 19:03:28.097' AS DateTime))
SET IDENTITY_INSERT [dbo].[JobPostingStatus] OFF
SET IDENTITY_INSERT [dbo].[LeaveRequest] ON

INSERT [dbo].[LeaveRequest] ([LeaveRequestID], [EmployeeID], [LeaveType], [Reason], [DateFrom], [DateTo], [DateAdded]) VALUES (10, 1002, N'Sick', N'Im very sick', CAST(N'2018-11-01' AS DATE), CAST(N'2018-11-02' AS DATE), CAST(N'2018-11-02 12:16:57.153' AS DateTime))
SET IDENTITY_INSERT [dbo].[LeaveRequest] OFF
SET IDENTITY_INSERT [dbo].[LeaveRequestStatus] ON

INSERT [dbo].[LeaveRequestStatus] ([LeaveRequestStatusID], [LeaveRequestID], [UserID], [STATUS], [Remarks], [DateModified]) VALUES (1003, 10, 1022, N'Approve', N'', CAST(N'2018-11-02 12:50:51.037' AS DateTime))
SET IDENTITY_INSERT [dbo].[LeaveRequestStatus] OFF
SET IDENTITY_INSERT [dbo].[PayCheck] ON

INSERT [dbo].[PayCheck] ([PaycheckID], [EmployeeID], [UserID], [PayDateFrom], [PayDateTo], [RateType], [PayHours], [RegularDays], [DaysAbsent], [HoursLate], [OtHours], [Regular], [VacationLeave], [SickLeave], [MaternLPaternL], [OrdinaryL], [Absences], [Lates], [Undertime], [OTND], [Month13], [Bonus], [COLA], [Transpo], [Repre], [Housing], [Backpay], [OtherEarnings], [TotalEarnings], [SSS], [PHIC], [HDMF], [HealthIns], [TaxAdj], [PayUnion], [Tax], [OtherDeductions], [LoanDeductions], [Bereave], [TotalDeductions], [RegularRate], [NetPay], [DateAdded]) VALUES (1, 1002, 1022, CAST(N'2018-11-30' AS DATE), CAST(N'2018-11-01' AS DATE), N'sad', CAST(15.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(11.99 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(250.00 AS DECIMAL(18, 2)), CAST(12.00 AS DECIMAL(18, 2)), CAST(N'2018-11-02 15:04:31.107' AS DateTime))
SET IDENTITY_INSERT [dbo].[PayCheck] OFF
SET IDENTITY_INSERT [dbo].[PayCheckDiscrepancy] ON

INSERT [dbo].[PayCheckDiscrepancy] ([PaycheckDiscrepancyID], [PaycheckID], [EmployeeID], [Details], [DateAdded]) VALUES (6, 1, 1002, N'N/A', CAST(N'2018-11-02 16:29:51.157' AS DateTime))
SET IDENTITY_INSERT [dbo].[PayCheckDiscrepancy] OFF
SET IDENTITY_INSERT [dbo].[PaycheckDiscStatus] ON

INSERT [dbo].[PaycheckDiscStatus] ([PayCheckDiscStatusID], [PaycheckDiscrepancyID], [STATUS], [Remarks], [UserID], [DateModified]) VALUES (1002, 6, N'Approve', N'We will reflect on it', 1022, CAST(N'2018-11-02 17:28:52.360' AS DateTime))
SET IDENTITY_INSERT [dbo].[PaycheckDiscStatus] OFF
SET IDENTITY_INSERT [dbo].[PreEmploymentChecklists] ON

INSERT [dbo].[PreEmploymentChecklists] ([PreEmploymentChecklistsID], [ApplicantID], [UserID], [Task], [Due], [STATUS], [DateAdded]) VALUES (1, 6, 1022, N'Submit Mayor''s Permit', CAST(N'2018-11-08' AS DATE), N'Pending', CAST(N'2018-11-08 19:29:48.087' AS DateTime))
SET IDENTITY_INSERT [dbo].[PreEmploymentChecklists] OFF
SET IDENTITY_INSERT [dbo].[QuizQuestionAnswer] ON

INSERT [dbo].[QuizQuestionAnswer] ([QuestionAnswerID], [QuizQuestionsID], [Answer], [DateModified]) VALUES (1, 1, 1, CAST(N'2018-11-01 18:45:41.743' AS DateTime))
INSERT [dbo].[QuizQuestionAnswer] ([QuestionAnswerID], [QuizQuestionsID], [Answer], [DateModified]) VALUES (2, 2, 4, CAST(N'2018-11-01 18:56:06.493' AS DateTime))
INSERT [dbo].[QuizQuestionAnswer] ([QuestionAnswerID], [QuizQuestionsID], [Answer], [DateModified]) VALUES (3, 3, 1, CAST(N'2018-11-01 19:21:12.757' AS DateTime))
SET IDENTITY_INSERT [dbo].[QuizQuestionAnswer] OFF
SET IDENTITY_INSERT [dbo].[QuizQuestionOptions] ON

INSERT [dbo].[QuizQuestionOptions] ([QuestionOptionsID], [QuizQuestionsID], [OptionOne], [OptionTwo], [OptionThree], [OptionFour], [DateModified]) VALUES (1, 2, N'An animal', N'A plant', N'A fungi', N'A human', CAST(N'2018-11-01 18:56:06.453' AS DateTime))
INSERT [dbo].[QuizQuestionOptions] ([QuestionOptionsID], [QuizQuestionsID], [OptionOne], [OptionTwo], [OptionThree], [OptionFour], [DateModified]) VALUES (2, 3, N'Earth', N'Mars', N'Pluto', N'Jupiter', CAST(N'2018-11-01 19:21:12.720' AS DateTime))
SET IDENTITY_INSERT [dbo].[QuizQuestionOptions] OFF
SET IDENTITY_INSERT [dbo].[QuizQuestions] ON

INSERT [dbo].[QuizQuestions] ([QuizQuestionsID], [CourseQuizID], [Question], [DateModified]) VALUES (1, 3, N'What is a dog?', CAST(N'2018-11-01 18:45:41.737' AS DateTime))
INSERT [dbo].[QuizQuestions] ([QuizQuestionsID], [CourseQuizID], [Question], [DateModified]) VALUES (2, 3, N'Who is Batman?', CAST(N'2018-11-01 18:56:06.437' AS DateTime))
INSERT [dbo].[QuizQuestions] ([QuizQuestionsID], [CourseQuizID], [Question], [DateModified]) VALUES (3, 3, N'What is the 3rd planet in our solar system?', CAST(N'2018-11-01 19:21:12.700' AS DateTime))
SET IDENTITY_INSERT [dbo].[QuizQuestions] OFF
SET IDENTITY_INSERT [dbo].[Users] ON

INSERT [dbo].[Users] ([UserID], [TypeID], [EmployeeID], [Username], [Password], [SecurityQuestion1], [SecurityAnswer1], [SecurityQuestion2], [SecurityAnswer2], [DateModified]) VALUES (1, 1, NULL, N'ejgenito', N'DdPlEmQsl8o/dH+aduN0+9pz+SkoI8AxO+nXit183Y9yI1rwxVPdJnl+eOGFTt7grgAviroHSwZt/OGvEU4y+A==', N'What is your favorite color?', N'Blue', N'Name of cat', N'Apple', CAST(N'2018-10-04 22:19:40.517' AS DateTime))
INSERT [dbo].[Users] ([UserID], [TypeID], [EmployeeID], [Username], [Password], [SecurityQuestion1], [SecurityAnswer1], [SecurityQuestion2], [SecurityAnswer2], [DateModified]) VALUES (1022, 1, NULL, N'emmanueljr.genito', N'rOVb7153uQHxK3MSLS1E9CXHM7DsNsLJIfxt3qsPejZvVYEMDe+vmwFSAUZ8ODnF8TguMZmXMHl5fjoFpbZGjg==', N'Name of cat', N'apple', N'Name of dog', N'Acer', CAST(N'2018-11-01 14:10:14.277' AS DateTime))
INSERT [dbo].[Users] ([UserID], [TypeID], [EmployeeID], [Username], [Password], [SecurityQuestion1], [SecurityAnswer1], [SecurityQuestion2], [SecurityAnswer2], [DateModified]) VALUES (2019, 2, NULL, N'tony.starks', N'DdPlEmQsl8o/dH+aduN0+9pz+SkoI8AxO+nXit183Y9yI1rwxVPdJnl+eOGFTt7grgAviroHSwZt/OGvEU4y+A==', N'Name of last child?', N'charles', N'What is your favorite color?', N'green', CAST(N'2018-11-01 17:08:38.077' AS DateTime))
INSERT [dbo].[Users] ([UserID], [TypeID], [EmployeeID], [Username], [Password], [SecurityQuestion1], [SecurityAnswer1], [SecurityQuestion2], [SecurityAnswer2], [DateModified]) VALUES (2020, 2, NULL, N'brendon.urie', N'DdPlEmQsl8o/dH+aduN0+9pz+SkoI8AxO+nXit183Y9yI1rwxVPdJnl+eOGFTt7grgAviroHSwZt/OGvEU4y+A==', N'What is your favorite color?', N'Red', N'What is your favorite color?', N'green', CAST(N'2018-11-01 20:11:21.430' AS DateTime))
SET IDENTITY_INSERT [dbo].[Users] OFF
SET IDENTITY_INSERT [dbo].[UserType] ON

INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (1, N'HR Admin')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (2, N'Employee')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (3, N'Training Manager')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (4, N'Talent Acquisition')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (5, N'Director')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (6, N'Data Analyst')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (7, N'Accounting Staff')
INSERT [dbo].[UserType] ([TypeID], [UserType]) VALUES (8, N'IT Admin')
SET IDENTITY_INSERT [dbo].[UserType] OFF
ALTER TABLE [dbo].[ApplicantInformation]  WITH CHECK ADD  CONSTRAINT [FK_ApplicantInformation_JobPosting] FOREIGN KEY([DesiredJobPosition])
REFERENCES [dbo].[JobPosting] ([JobPostID])
GO
ALTER TABLE [dbo].[ApplicantInformation] CHECK CONSTRAINT [FK_ApplicantInformation_JobPosting]
GO
ALTER TABLE [dbo].[ApplicantMessage]  WITH CHECK ADD  CONSTRAINT [FK_ApplicantMessage_ApplicantInformation1] FOREIGN KEY([ApplicantID])
REFERENCES [dbo].[ApplicantInformation] ([ApplicantID])
GO
ALTER TABLE [dbo].[ApplicantMessage] CHECK CONSTRAINT [FK_ApplicantMessage_ApplicantInformation1]
GO
ALTER TABLE [dbo].[ApplicantMessage]  WITH CHECK ADD  CONSTRAINT [FK_ApplicantMessage_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[ApplicantMessage] CHECK CONSTRAINT [FK_ApplicantMessage_Users]
GO
ALTER TABLE [dbo].[ApplicantStatus]  WITH CHECK ADD  CONSTRAINT [FK_ApplicantStatus_ApplicantInformation] FOREIGN KEY([ApplicantID])
REFERENCES [dbo].[ApplicantInformation] ([ApplicantID])
GO
ALTER TABLE [dbo].[ApplicantStatus] CHECK CONSTRAINT [FK_ApplicantStatus_ApplicantInformation]
GO
ALTER TABLE [dbo].[ApplicantStatus]  WITH CHECK ADD  CONSTRAINT [FK_ApplicantStatus_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[ApplicantStatus] CHECK CONSTRAINT [FK_ApplicantStatus_Users]
GO
ALTER TABLE [dbo].[Course]  WITH CHECK ADD  CONSTRAINT [FK_Course_Users] FOREIGN KEY([TrainingManager])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Course] CHECK CONSTRAINT [FK_Course_Users]
GO
ALTER TABLE [dbo].[Course]  WITH CHECK ADD  CONSTRAINT [FK_TrainingModule_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[Course] CHECK CONSTRAINT [FK_TrainingModule_Employees]
GO
ALTER TABLE [dbo].[CourseContent]  WITH CHECK ADD  CONSTRAINT [FK_CourseModule_TrainingModule] FOREIGN KEY([TrainingModuleID])
REFERENCES [dbo].[Course] ([CourseID])
GO
ALTER TABLE [dbo].[CourseContent] CHECK CONSTRAINT [FK_CourseModule_TrainingModule]
GO
ALTER TABLE [dbo].[CourseParticipants]  WITH CHECK ADD  CONSTRAINT [FK_CourseParticipants_Course] FOREIGN KEY([CourseID])
REFERENCES [dbo].[Course] ([CourseID])
GO
ALTER TABLE [dbo].[CourseParticipants] CHECK CONSTRAINT [FK_CourseParticipants_Course]
GO
ALTER TABLE [dbo].[CourseParticipants]  WITH CHECK ADD  CONSTRAINT [FK_CourseParticipants_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[CourseParticipants] CHECK CONSTRAINT [FK_CourseParticipants_Employees]
GO
ALTER TABLE [dbo].[CourseQuiz]  WITH CHECK ADD  CONSTRAINT [FK_CourseQuiz_Course] FOREIGN KEY([CourseID])
REFERENCES [dbo].[Course] ([CourseID])
GO
ALTER TABLE [dbo].[CourseQuiz] CHECK CONSTRAINT [FK_CourseQuiz_Course]
GO
ALTER TABLE [dbo].[CourseQuiz]  WITH CHECK ADD  CONSTRAINT [FK_CourseQuiz_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[CourseQuiz] CHECK CONSTRAINT [FK_CourseQuiz_Users]
GO
ALTER TABLE [dbo].[CourseStatus]  WITH CHECK ADD  CONSTRAINT [FK_TraingModuleStatus_CourseQuiz] FOREIGN KEY([CourseQuizID])
REFERENCES [dbo].[CourseQuiz] ([CourseQuizID])
GO
ALTER TABLE [dbo].[CourseStatus] CHECK CONSTRAINT [FK_TraingModuleStatus_CourseQuiz]
GO
ALTER TABLE [dbo].[CourseStatus]  WITH CHECK ADD  CONSTRAINT [FK_TraingModuleStatus_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[CourseStatus] CHECK CONSTRAINT [FK_TraingModuleStatus_Users]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Users]
GO
ALTER TABLE [dbo].[EvaluationFormDetails]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationFormDetails_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[EvaluationFormDetails] CHECK CONSTRAINT [FK_EvaluationFormDetails_Users]
GO
ALTER TABLE [dbo].[EvaluationOptions]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationOptions_EvaluationsQuestions] FOREIGN KEY([EvaluationQuestionsID])
REFERENCES [dbo].[EvaluationsQuestions] ([EvaluationsQuestionsID])
GO
ALTER TABLE [dbo].[EvaluationOptions] CHECK CONSTRAINT [FK_EvaluationOptions_EvaluationsQuestions]
GO
ALTER TABLE [dbo].[EvaluationResponse]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationResponse_EvaluationOptions] FOREIGN KEY([EvaluationOptionsID])
REFERENCES [dbo].[EvaluationOptions] ([EvaluationOptionsID])
GO
ALTER TABLE [dbo].[EvaluationResponse] CHECK CONSTRAINT [FK_EvaluationResponse_EvaluationOptions]
GO
ALTER TABLE [dbo].[EvaluationResponse]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationResponse_EvaluationsQuestions] FOREIGN KEY([EvaluationQuestiondID])
REFERENCES [dbo].[EvaluationsQuestions] ([EvaluationsQuestionsID])
GO
ALTER TABLE [dbo].[EvaluationResponse] CHECK CONSTRAINT [FK_EvaluationResponse_EvaluationsQuestions]
GO
ALTER TABLE [dbo].[EvaluationResult]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationResult_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[EvaluationResult] CHECK CONSTRAINT [FK_EvaluationResult_Employees]
GO
ALTER TABLE [dbo].[EvaluationResult]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationResult_EvaluationResponse] FOREIGN KEY([EvaluationResponseID])
REFERENCES [dbo].[EvaluationResponse] ([EvaluationResponseID])
GO
ALTER TABLE [dbo].[EvaluationResult] CHECK CONSTRAINT [FK_EvaluationResult_EvaluationResponse]
GO
ALTER TABLE [dbo].[EvaluationResult]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationResult_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[EvaluationResult] CHECK CONSTRAINT [FK_EvaluationResult_Users]
GO
ALTER TABLE [dbo].[EvaluationsQuestions]  WITH CHECK ADD  CONSTRAINT [FK_EvaluationsQuestions_EvaluationFormDetails] FOREIGN KEY([EvaluationFormDetailsID])
REFERENCES [dbo].[EvaluationFormDetails] ([EvaluationFormDetailsID])
GO
ALTER TABLE [dbo].[EvaluationsQuestions] CHECK CONSTRAINT [FK_EvaluationsQuestions_EvaluationFormDetails]
GO
ALTER TABLE [dbo].[InterviewSchedule]  WITH CHECK ADD  CONSTRAINT [FK_InterviewSchedule_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[InterviewSchedule] CHECK CONSTRAINT [FK_InterviewSchedule_Users]
GO
ALTER TABLE [dbo].[JobPosting]  WITH CHECK ADD  CONSTRAINT [FK_JobPosting_Users1] FOREIGN KEY([PostedBy])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[JobPosting] CHECK CONSTRAINT [FK_JobPosting_Users1]
GO
ALTER TABLE [dbo].[JobPostingStatus]  WITH CHECK ADD  CONSTRAINT [FK_JobPostingStatus_JobPosting] FOREIGN KEY([JobPostID])
REFERENCES [dbo].[JobPosting] ([JobPostID])
GO
ALTER TABLE [dbo].[JobPostingStatus] CHECK CONSTRAINT [FK_JobPostingStatus_JobPosting]
GO
ALTER TABLE [dbo].[JobPostingStatus]  WITH CHECK ADD  CONSTRAINT [FK_JobPostingStatus_Users] FOREIGN KEY([ApprovedBy])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[JobPostingStatus] CHECK CONSTRAINT [FK_JobPostingStatus_Users]
GO
ALTER TABLE [dbo].[LeaveRequest]  WITH CHECK ADD  CONSTRAINT [FK_LeaveRequest_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[LeaveRequest] CHECK CONSTRAINT [FK_LeaveRequest_Employees]
GO
ALTER TABLE [dbo].[LeaveRequestStatus]  WITH CHECK ADD  CONSTRAINT [FK_LeaveRequestStatus_LeaveRequest] FOREIGN KEY([LeaveRequestID])
REFERENCES [dbo].[LeaveRequest] ([LeaveRequestID])
GO
ALTER TABLE [dbo].[LeaveRequestStatus] CHECK CONSTRAINT [FK_LeaveRequestStatus_LeaveRequest]
GO
ALTER TABLE [dbo].[LeaveRequestStatus]  WITH CHECK ADD  CONSTRAINT [FK_LeaveRequestStatus_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[LeaveRequestStatus] CHECK CONSTRAINT [FK_LeaveRequestStatus_Users]
GO
ALTER TABLE [dbo].[PayCheck]  WITH CHECK ADD  CONSTRAINT [FK_PayCheck_Employees1] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[PayCheck] CHECK CONSTRAINT [FK_PayCheck_Employees1]
GO
ALTER TABLE [dbo].[PayCheck]  WITH CHECK ADD  CONSTRAINT [FK_PayCheck_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[PayCheck] CHECK CONSTRAINT [FK_PayCheck_Users]
GO
ALTER TABLE [dbo].[PayCheckDiscrepancy]  WITH CHECK ADD  CONSTRAINT [FK_PayCheckDiscrepancy_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[PayCheckDiscrepancy] CHECK CONSTRAINT [FK_PayCheckDiscrepancy_Employees]
GO
ALTER TABLE [dbo].[PayCheckDiscrepancy]  WITH CHECK ADD  CONSTRAINT [FK_PayCheckDiscrepancy_PayCheck] FOREIGN KEY([PaycheckID])
REFERENCES [dbo].[PayCheck] ([PaycheckID])
GO
ALTER TABLE [dbo].[PayCheckDiscrepancy] CHECK CONSTRAINT [FK_PayCheckDiscrepancy_PayCheck]
GO
ALTER TABLE [dbo].[PaycheckDiscStatus]  WITH CHECK ADD  CONSTRAINT [FK_PaycheckDiscStatus_PayCheckDiscrepancy] FOREIGN KEY([PaycheckDiscrepancyID])
REFERENCES [dbo].[PayCheckDiscrepancy] ([PaycheckDiscrepancyID])
GO
ALTER TABLE [dbo].[PaycheckDiscStatus] CHECK CONSTRAINT [FK_PaycheckDiscStatus_PayCheckDiscrepancy]
GO
ALTER TABLE [dbo].[PaycheckDiscStatus]  WITH CHECK ADD  CONSTRAINT [FK_PaycheckDiscStatus_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[PaycheckDiscStatus] CHECK CONSTRAINT [FK_PaycheckDiscStatus_Users]
GO
ALTER TABLE [dbo].[PreEmloymentChecklists]  WITH CHECK ADD  CONSTRAINT [FK_PreEmloymentChecklists_ApplicantInformation] FOREIGN KEY([ApplicantID])
REFERENCES [dbo].[ApplicantInformation] ([ApplicantID])
GO
ALTER TABLE [dbo].[PreEmloymentChecklists] CHECK CONSTRAINT [FK_PreEmloymentChecklists_ApplicantInformation]
GO
ALTER TABLE [dbo].[PreEmloymentChecklists]  WITH CHECK ADD  CONSTRAINT [FK_PreEmloymentChecklists_Users] FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[PreEmloymentChecklists] CHECK CONSTRAINT [FK_PreEmloymentChecklists_Users]
GO
ALTER TABLE [dbo].[QuizQuestionAnswer]  WITH CHECK ADD  CONSTRAINT [FK_QuizAnswer_QuizQuestions] FOREIGN KEY([QuizQuestionsID])
REFERENCES [dbo].[QuizQuestions] ([QuizQuestionsID])
GO
ALTER TABLE [dbo].[QuizQuestionAnswer] CHECK CONSTRAINT [FK_QuizAnswer_QuizQuestions]
GO
ALTER TABLE [dbo].[QuizQuestionOptions]  WITH CHECK ADD  CONSTRAINT [FK_QuizOptions_QuizQuestions] FOREIGN KEY([QuizQuestionsID])
REFERENCES [dbo].[QuizQuestions] ([QuizQuestionsID])
GO
ALTER TABLE [dbo].[QuizQuestionOptions] CHECK CONSTRAINT [FK_QuizOptions_QuizQuestions]
GO
ALTER TABLE [dbo].[QuizUserResponse]  WITH CHECK ADD  CONSTRAINT [FK_QuizResponse_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[QuizUserResponse] CHECK CONSTRAINT [FK_QuizResponse_Employees]
GO
ALTER TABLE [dbo].[QuizUserResponse]  WITH CHECK ADD  CONSTRAINT [FK_QuizResponse_QuizOptions] FOREIGN KEY([QuizOptionsID])
REFERENCES [dbo].[QuizQuestionOptions] ([QuestionOptionsID])
GO
ALTER TABLE [dbo].[QuizUserResponse] CHECK CONSTRAINT [FK_QuizResponse_QuizOptions]
GO
ALTER TABLE [dbo].[QuizUserResponse]  WITH CHECK ADD  CONSTRAINT [FK_QuizResponse_QuizQuestions] FOREIGN KEY([QuizQuestionsID])
REFERENCES [dbo].[QuizQuestions] ([QuizQuestionsID])
GO
ALTER TABLE [dbo].[QuizUserResponse] CHECK CONSTRAINT [FK_QuizResponse_QuizQuestions]
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_Employees] FOREIGN KEY([EmployeeID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Employees]
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_UserType] FOREIGN KEY([TypeID])
REFERENCES [dbo].[UserType] ([TypeID])
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_UserType]
GO
USE [master]
GO
ALTER DATABASE [CAPROJ_HRIS] SET  READ_WRITE
GO