﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="ERPModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="AllowanceMaster">
          <Key>
            <PropertyRef Name="AllowanceID" />
          </Key>
          <Property Name="AllowanceID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Allowance" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="IsConsider" Type="bit" Nullable="false" />
          <Property Name="SortNo" Type="int" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="Percentage" Type="float" />
        </EntityType>
        <EntityType Name="CompanyMaster">
          <Key>
            <PropertyRef Name="CompanyID" />
          </Key>
          <Property Name="CompanyID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="CompanyName" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="CompanyLogo" Type="varchar" MaxLength="50" />
          <Property Name="EmailAddress" Type="varchar" MaxLength="200" Nullable="false" />
          <Property Name="CountryId" Type="uniqueidentifier" />
          <Property Name="StateId" Type="uniqueidentifier" />
          <Property Name="City" Type="varchar" MaxLength="50" />
          <Property Name="Address" Type="varchar" MaxLength="1000" />
          <Property Name="MobileNo" Type="varchar" MaxLength="15" />
          <Property Name="PhoneNo" Type="varchar" MaxLength="15" />
          <Property Name="HotlineNo" Type="varchar" MaxLength="15" />
          <Property Name="FaxNo" Type="varchar" MaxLength="15" />
          <Property Name="Website" Type="varchar" MaxLength="500" />
          <Property Name="LicenseKey" Type="varchar" MaxLength="50" />
          <Property Name="IsKeyActive" Type="bit" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="CountryMaster">
          <Key>
            <PropertyRef Name="CountryID" />
          </Key>
          <Property Name="CountryID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="CountryName" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="Code" Type="varchar" MaxLength="50" />
          <Property Name="CreatedDate" Type="datetime" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="CurrencyMaster">
          <Key>
            <PropertyRef Name="CurrencyID" />
          </Key>
          <Property Name="CurrencyID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="CurrencyCode" Type="varchar" MaxLength="10" Nullable="false" />
          <Property Name="CurrencySymbol" Type="nvarchar" MaxLength="50" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="DeductionMaster">
          <Key>
            <PropertyRef Name="DeductionID" />
          </Key>
          <Property Name="DeductionID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Deduction" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="IsConsider" Type="bit" Nullable="false" />
          <Property Name="SortNo" Type="int" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="DepartmentMaster">
          <Key>
            <PropertyRef Name="DepartmentID" />
          </Key>
          <Property Name="DepartmentID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Department" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="DesignationMaster">
          <Key>
            <PropertyRef Name="DesignationID" />
          </Key>
          <Property Name="DesignationID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Designation" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="DeviceMaster">
          <Key>
            <PropertyRef Name="DeviceID" />
          </Key>
          <Property Name="DeviceID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DeviceName" Type="nvarchar" MaxLength="100" />
          <Property Name="Address" Type="nvarchar" MaxLength="500" />
          <Property Name="DeviceCode" Type="nvarchar" MaxLength="20" />
          <Property Name="PhoneNo" Type="nvarchar" MaxLength="20" />
          <Property Name="Port" Type="int" />
          <Property Name="IPAddress" Type="nvarchar" MaxLength="50" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="CreatedDate" Type="datetime" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="EducationMaster">
          <Key>
            <PropertyRef Name="EducationID" />
          </Key>
          <Property Name="EducationID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EducationName" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeAllowanceMap">
          <Key>
            <PropertyRef Name="EmployeeAllowanceMapID" />
          </Key>
          <Property Name="EmployeeAllowanceMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="AllowanceId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeAttachment">
          <Key>
            <PropertyRef Name="EmployeeAttachmentMapID" />
          </Key>
          <Property Name="EmployeeAttachmentMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Name" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="Description" Type="varchar" MaxLength="1000" />
          <Property Name="AttachmentName" Type="varchar" MaxLength="50" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeAttendance">
          <Key>
            <PropertyRef Name="EmployeeAttendanceID" />
          </Key>
          <Property Name="EmployeeAttendanceID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="FinancialYearId" Type="uniqueidentifier" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="AttendanceDate" Type="datetime" Nullable="false" />
          <Property Name="TimeIn" Type="varchar" MaxLength="50" />
          <Property Name="TimeOut" Type="varchar" MaxLength="50" />
          <Property Name="WorkingHours" Type="decimal" Precision="10" Scale="2" />
          <Property Name="OverTimeHours" Type="decimal" Precision="10" Scale="2" />
          <Property Name="AttendanceType" Type="int" />
          <Property Name="Attendance" Type="decimal" Precision="6" Scale="2" />
          <Property Name="Description" Type="varchar" MaxLength="1000" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeAttendanceDevice">
          <Key>
            <PropertyRef Name="EmployeeAttendanceID" />
          </Key>
          <Property Name="EmployeeAttendanceID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" />
          <Property Name="DeviceId" Type="uniqueidentifier" />
          <Property Name="ShiftId" Type="uniqueidentifier" />
          <Property Name="EnrollNo" Type="nvarchar" MaxLength="15" />
          <Property Name="AttendanceDate" Type="datetime" />
          <Property Name="AttendanceDateTime" Type="datetime" />
          <Property Name="PunchTime" Type="nvarchar" MaxLength="11" />
          <Property Name="VerifyMethod" Type="nvarchar" MaxLength="10" />
          <Property Name="PunchType" Type="varchar" MaxLength="10" />
          <Property Name="PunchMethod" Type="varchar" MaxLength="10" />
          <Property Name="Latitude" Type="nvarchar" MaxLength="1000" />
          <Property Name="Longitude" Type="nvarchar" MaxLength="1000" />
          <Property Name="LocationName" Type="nvarchar" MaxLength="250" />
          <Property Name="CreatedDate" Type="datetime" />
          <Property Name="ModifiedDate" Type="datetime" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="EmployeeDeductionMap">
          <Key>
            <PropertyRef Name="EmployeeDeductionMapID" />
          </Key>
          <Property Name="EmployeeDeductionMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DeductionId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeDeviceMap">
          <Key>
            <PropertyRef Name="EmployeeDeviceID" />
          </Key>
          <Property Name="EmployeeDeviceID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" />
          <Property Name="DeviceId" Type="uniqueidentifier" />
          <Property Name="EnrollNo" Type="nvarchar" MaxLength="15" />
          <Property Name="CreatedDate" Type="datetime" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="EmployeeGradeMaster">
          <Key>
            <PropertyRef Name="EmployeeGradeID" />
          </Key>
          <Property Name="EmployeeGradeID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeGrade" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeLeaveCategory">
          <Key>
            <PropertyRef Name="EmployeeLeaveCategoryMapID" />
          </Key>
          <Property Name="EmployeeLeaveCategoryMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="LeaveCategoryId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="StartDate" Type="datetime" />
          <Property Name="EndDate" Type="datetime" />
          <Property Name="TotalDay" Type="decimal" Precision="12" Scale="2" />
          <Property Name="IsFirstHalfDay" Type="bit" Nullable="false" />
          <Property Name="IsLastHalfDay" Type="bit" Nullable="false" />
          <Property Name="Reason" Type="varchar" MaxLength="1000" Nullable="false" />
          <Property Name="Comments" Type="varchar" MaxLength="1000" />
          <Property Name="ApplyDate" Type="datetime" />
          <Property Name="ApprovedBy" Type="varchar" MaxLength="150" />
          <Property Name="ApproveDate" Type="datetime" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="IsApprove" Type="bit" />
        </EntityType>
        <EntityType Name="EmployeeLeaveMap">
          <Key>
            <PropertyRef Name="EmployeeLeaveID" />
          </Key>
          <Property Name="EmployeeLeaveID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" />
          <Property Name="LeaveId" Type="uniqueidentifier" />
          <Property Name="LeaveCount" Type="int" />
        </EntityType>
        <EntityType Name="EmployeeLoan">
          <Key>
            <PropertyRef Name="EmployeeLoanMapID" />
          </Key>
          <Property Name="EmployeeLoanMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" Nullable="false" />
          <Property Name="LoanDate" Type="datetime" Nullable="false" />
          <Property Name="LoanTitle" Type="varchar" MaxLength="100" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="ApprovedBy" Type="varchar" MaxLength="150" />
          <Property Name="TotalMonths" Type="int" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="IsComplete" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeMaster">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeTypeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeGradeId" Type="uniqueidentifier" />
          <Property Name="DepartmentId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DesignationId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="ShiftId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="FirstName" Type="varchar" MaxLength="50" />
          <Property Name="MiddleName" Type="varchar" MaxLength="50" />
          <Property Name="LastName" Type="varchar" MaxLength="50" />
          <Property Name="BirthDate" Type="datetime" />
          <Property Name="Gender" Type="bit" />
          <Property Name="MaratialStatus" Type="varchar" MaxLength="50" />
          <Property Name="PhotoName" Type="varchar" MaxLength="50" />
          <Property Name="CountryId" Type="uniqueidentifier" />
          <Property Name="StateId" Type="uniqueidentifier" />
          <Property Name="City" Type="varchar" MaxLength="50" />
          <Property Name="Address" Type="varchar" MaxLength="1000" />
          <Property Name="PinCode" Type="varchar" MaxLength="10" />
          <Property Name="MobileNo" Type="varchar" MaxLength="15" />
          <Property Name="PhoneNo" Type="varchar" MaxLength="15" />
          <Property Name="JoinDate" Type="datetime" />
          <Property Name="EmployeeNo" Type="int" Nullable="false" />
          <Property Name="Email" Type="varchar" MaxLength="200" />
          <Property Name="BankName" Type="varchar" MaxLength="50" />
          <Property Name="BranchName" Type="varchar" MaxLength="50" />
          <Property Name="AccountName" Type="varchar" MaxLength="150" />
          <Property Name="AccountNo" Type="varchar" MaxLength="50" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="IsLeave" Type="bit" Nullable="false" />
          <Property Name="LeaveDate" Type="datetime" />
          <Property Name="LeaveDescription" Type="varchar(max)" />
          <Property Name="Previlage" Type="nvarchar" MaxLength="20" />
          <Property Name="Password" Type="nvarchar" MaxLength="50" />
          <Property Name="FaceTemplate" Type="nvarchar(max)" />
          <Property Name="IsHavingFace" Type="bit" />
          <Property Name="FaceLength" Type="int" />
          <Property Name="FingureTemplate" Type="nvarchar(max)" />
          <Property Name="finger_template_data_bw" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft1" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft2" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft3" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft4" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft5" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft6" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft7" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft8" Type="varbinary(max)" />
          <Property Name="finger_template_data_tft9" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw1" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw2" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw3" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw4" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw5" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw6" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw7" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw8" Type="varbinary(max)" />
          <Property Name="finger_template_data_bw9" Type="varbinary(max)" />
          <Property Name="is_having_fingureprint" Type="bit" />
          <Property Name="IsSend" Type="bit" />
          <Property Name="FaceTemplateData" Type="varbinary(max)" />
          <Property Name="PANNo" Type="nchar" MaxLength="10" />
          <Property Name="TotalLeaveCount" Type="int" />
          <Property Name="OverTimeAmount" Type="decimal" Precision="18" Scale="2" />
        </EntityType>
        <EntityType Name="EmployeePaidAllowanceMap">
          <Key>
            <PropertyRef Name="EmployeePaidAllowanceMapID" />
          </Key>
          <Property Name="EmployeePaidAllowanceMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeePaidSalaryId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="AllowanceId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidAmount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeePaidDeductionMap">
          <Key>
            <PropertyRef Name="EmployeePaidDeductionMapID" />
          </Key>
          <Property Name="EmployeePaidDeductionMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeePaidSalaryId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DeductionId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidAmount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeePaidLoan">
          <Key>
            <PropertyRef Name="EmployeePaidLoanMapID" />
          </Key>
          <Property Name="EmployeePaidLoanMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeLoanMapId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="PaidAmount" Type="decimal" Precision="12" Scale="2" Nullable="false" />
          <Property Name="PaidDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="Month" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="Year" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeePaidSalary">
          <Key>
            <PropertyRef Name="EmployeePaidSalaryID" />
          </Key>
          <Property Name="EmployeePaidSalaryID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Basic" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalEarning" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalDeduction" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalSalary" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidBasic" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalEarning" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalDeduction" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalSalary" Type="decimal" Precision="12" Scale="2" />
          <Property Name="Month" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="Year" Type="int" Nullable="false" />
          <Property Name="TotalOverTimeDays" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalOverTimeHours" Type="decimal" Precision="18" Scale="2" />
          <Property Name="TotalDays" Type="int" Nullable="false" />
          <Property Name="TotalHours" Type="decimal" Precision="18" Scale="2" />
          <Property Name="AllowLeave" Type="decimal" Precision="6" Scale="2" />
          <Property Name="TotalUseLeave" Type="decimal" Precision="6" Scale="1" />
          <Property Name="TotalHoliday" Type="decimal" Precision="6" Scale="1" />
          <Property Name="TotalPaidLeave" Type="decimal" Precision="6" Scale="1" />
          <Property Name="TotalPaidLeaveAmount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalOverTimeAmount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidLoanAmount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="PaidDate" Type="datetime" Nullable="false" />
          <Property Name="PaidBy" Type="varchar" MaxLength="150" />
          <Property Name="SalaryFromDate" Type="datetime" />
          <Property Name="SalaryToDate" Type="datetime" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="IsPaid" Type="bit" Nullable="false" />
          <Property Name="FinancialYearId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="TotalPresentDays" Type="decimal" Precision="6" Scale="1" />
          <Property Name="ProfessionalTax" Type="decimal" Precision="12" Scale="2" />
        </EntityType>
        <EntityType Name="EmployeeSalary">
          <Key>
            <PropertyRef Name="EmployeeSalaryID" />
          </Key>
          <Property Name="EmployeeSalaryID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Basic" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalEarning" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalDeduction" Type="decimal" Precision="12" Scale="2" />
          <Property Name="TotalSalary" Type="decimal" Precision="12" Scale="2" />
          <Property Name="SalaryType" Type="int" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeTypeMaster">
          <Key>
            <PropertyRef Name="EmployeeTypeID" />
          </Key>
          <Property Name="EmployeeTypeID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeType" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="NoOfLeavePerMonth" Type="decimal" Precision="5" Scale="1" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeWorkingDay">
          <Key>
            <PropertyRef Name="EmployeeWorkingDayMapID" />
          </Key>
          <Property Name="EmployeeWorkingDayMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DayName" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="FinancialYearMaster">
          <Key>
            <PropertyRef Name="FinancialYearID" />
          </Key>
          <Property Name="FinancialYearID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Year" Type="int" Nullable="false" />
          <Property Name="FinancialYear" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="GlobalSetting">
          <Key>
            <PropertyRef Name="GlobalSettingId" />
          </Key>
          <Property Name="GlobalSettingId" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="GlobalSettingName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="GlobalSettingEnum" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="GlobalSettingValue" Type="ntext" Nullable="false" />
        </EntityType>
        <EntityType Name="History">
          <Key>
            <PropertyRef Name="HistoryID" />
          </Key>
          <Property Name="HistoryID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="TableId" Type="varchar" MaxLength="50" />
          <Property Name="TableTypeId" Type="int" Nullable="false" />
          <Property Name="OperationTypeId" Type="int" Nullable="false" />
          <Property Name="UserId" Type="uniqueidentifier" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="XmlContent" Type="varchar(max)" />
          <Property Name="IPAddress" Type="varchar" MaxLength="20" />
        </EntityType>
        <EntityType Name="HolidayMaster">
          <Key>
            <PropertyRef Name="HolidayID" />
          </Key>
          <Property Name="HolidayID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="StartDate" Type="datetime" />
          <Property Name="EndDate" Type="datetime" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="InterviewAttachment">
          <Key>
            <PropertyRef Name="InterviewAttachmentMapID" />
          </Key>
          <Property Name="InterviewAttachmentMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="InterviewId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Name" Type="varchar" MaxLength="100" />
          <Property Name="AttachmentType" Type="int" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="InterviewMaster">
          <Key>
            <PropertyRef Name="InterviewID" />
          </Key>
          <Property Name="InterviewID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="InterviewNo" Type="int" Nullable="false" />
          <Property Name="Name" Type="varchar" MaxLength="200" Nullable="false" />
          <Property Name="Email" Type="varchar" MaxLength="200" Nullable="false" />
          <Property Name="MobileNo" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="EducationId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DepartmentId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="DesignationId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="CurrentSalary" Type="decimal" Precision="18" Scale="2" />
          <Property Name="ExpectedSalary" Type="decimal" Precision="18" Scale="2" />
          <Property Name="ExperienceYear" Type="int" />
          <Property Name="ExperienceMonth" Type="int" />
          <Property Name="IsJoinDays" Type="bit" />
          <Property Name="JoinAfterDaysOrMonth" Type="int" />
          <Property Name="PersonalDetail" Type="varchar(max)" />
          <Property Name="InterviewStatusId" Type="int" />
          <Property Name="InterviewDate" Type="datetime" />
          <Property Name="InterviewTime" Type="varchar" MaxLength="50" />
          <Property Name="JoinDate" Type="datetime" />
          <Property Name="Reason" Type="varchar(max)" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="InvoiceDetail">
          <Key>
            <PropertyRef Name="InvoiceDetailID" />
          </Key>
          <Property Name="InvoiceDetailID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="InvoiceId" Type="int" />
          <Property Name="ItemDescription" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="ItemDate" Type="datetime" Nullable="false" />
          <Property Name="Hours" Type="decimal" Precision="8" Scale="2" />
          <Property Name="HourRate" Type="decimal" Precision="8" Scale="2" />
          <Property Name="Amount" Type="decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="InvoiceMaster">
          <Key>
            <PropertyRef Name="InvoiceID" />
          </Key>
          <Property Name="InvoiceID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="InvoiceNo" Type="int" Nullable="false" />
          <Property Name="InvoiceDate" Type="datetime" Nullable="false" />
          <Property Name="CurrencyId" Type="int" />
          <Property Name="PartyName" Type="nvarchar" MaxLength="50" />
          <Property Name="PartyAddress" Type="nvarchar" MaxLength="500" />
          <Property Name="Description" Type="nvarchar" MaxLength="100" />
          <Property Name="SubTotal" Type="decimal" Precision="12" Scale="2" />
          <Property Name="ServiceTax" Type="decimal" Precision="12" Scale="2" />
          <Property Name="GrandTotal" Type="decimal" Precision="12" Scale="2" />
          <Property Name="SubTotalINR" Type="decimal" Precision="12" Scale="2" />
          <Property Name="ServiceTaxINR" Type="decimal" Precision="12" Scale="2" />
          <Property Name="GrandTotalINR" Type="decimal" Precision="12" Scale="2" />
          <Property Name="IsFixed" Type="bit" />
          <Property Name="IsPaid" Type="bit" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="IpInformation">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IpAddress" Type="nvarchar" MaxLength="100" />
          <Property Name="DeviceName" Type="nvarchar(max)" />
          <Property Name="BrowserName" Type="nvarchar" MaxLength="100" />
          <Property Name="DeviceType" Type="varchar" MaxLength="100" />
          <Property Name="CreatedDate" Type="datetime" />
        </EntityType>
        <EntityType Name="LeaveCategoryMaster">
          <Key>
            <PropertyRef Name="LeaveCategoryID" />
          </Key>
          <Property Name="LeaveCategoryID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="LeaveCategory" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="LicenseKeyMaster">
          <Key>
            <PropertyRef Name="LicenseKeyID" />
          </Key>
          <Property Name="LicenseKeyID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Email" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="KeyID" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="IsUsed" Type="bit" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ModuleMaster">
          <Key>
            <PropertyRef Name="ModuleID" />
          </Key>
          <Property Name="ModuleID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EnumName" Type="varchar" MaxLength="200" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="ParentId" Type="uniqueidentifier" />
          <Property Name="TreeLevel" Type="int" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
          <Property Name="SortOrder" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="RoleMaster">
          <Key>
            <PropertyRef Name="RoleID" />
          </Key>
          <Property Name="RoleID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RoleName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ShiftMaster">
          <Key>
            <PropertyRef Name="ShiftID" />
          </Key>
          <Property Name="ShiftID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Shift" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="FromTime" Type="varchar" MaxLength="20" />
          <Property Name="ToTime" Type="varchar" MaxLength="20" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="StateMaster">
          <Key>
            <PropertyRef Name="StateID" />
          </Key>
          <Property Name="StateID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="CountryId" Type="uniqueidentifier" />
          <Property Name="StateName" Type="varchar" MaxLength="100" />
          <Property Name="CreatedDate" Type="datetime" />
          <Property Name="IsActive" Type="bit" />
        </EntityType>
        <EntityType Name="UserMaster">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RoleId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="EmployeeId" Type="uniqueidentifier" />
          <Property Name="Username" Type="varchar" MaxLength="200" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="500" Nullable="false" />
          <Property Name="LastLogin" Type="datetime" />
          <Property Name="Token" Type="nvarchar(max)" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="CreatedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedBy" Type="uniqueidentifier" />
          <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
          <Property Name="IsActive" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="UserModuleMap">
          <Key>
            <PropertyRef Name="UserModuleMapID" />
          </Key>
          <Property Name="UserModuleMapID" Type="uniqueidentifier" Nullable="false" />
          <Property Name="UserId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="ModuleId" Type="uniqueidentifier" Nullable="false" />
        </EntityType>
        <Association Name="FK_EmployeeAllowanceMap_AllowanceMaster">
          <End Role="AllowanceMaster" Type="Self.AllowanceMaster" Multiplicity="1" />
          <End Role="EmployeeAllowanceMap" Type="Self.EmployeeAllowanceMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AllowanceMaster">
              <PropertyRef Name="AllowanceID" />
            </Principal>
            <Dependent Role="EmployeeAllowanceMap">
              <PropertyRef Name="AllowanceId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAllowanceMap_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeAllowanceMap" Type="Self.EmployeeAllowanceMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAllowanceMap">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAttachment_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeAttachment" Type="Self.EmployeeAttachment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAttachment">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAttendance_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeAttendance" Type="Self.EmployeeAttendance" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAttendance">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeDeductionMap_DeductionMaster">
          <End Role="DeductionMaster" Type="Self.DeductionMaster" Multiplicity="1" />
          <End Role="EmployeeDeductionMap" Type="Self.EmployeeDeductionMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DeductionMaster">
              <PropertyRef Name="DeductionID" />
            </Principal>
            <Dependent Role="EmployeeDeductionMap">
              <PropertyRef Name="DeductionId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeDeductionMap_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeDeductionMap" Type="Self.EmployeeDeductionMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeDeductionMap">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLeaveCategory_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeLeaveCategory" Type="Self.EmployeeLeaveCategory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeLeaveCategory">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLeaveCategory_LeaveCategoryMaster">
          <End Role="LeaveCategoryMaster" Type="Self.LeaveCategoryMaster" Multiplicity="1" />
          <End Role="EmployeeLeaveCategory" Type="Self.EmployeeLeaveCategory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="LeaveCategoryMaster">
              <PropertyRef Name="LeaveCategoryID" />
            </Principal>
            <Dependent Role="EmployeeLeaveCategory">
              <PropertyRef Name="LeaveCategoryId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLoan_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeLoan" Type="Self.EmployeeLoan" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeLoan">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_DepartmentMaster">
          <End Role="DepartmentMaster" Type="Self.DepartmentMaster" Multiplicity="1" />
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DepartmentMaster">
              <PropertyRef Name="DepartmentID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="DepartmentId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_DesignationMaster">
          <End Role="DesignationMaster" Type="Self.DesignationMaster" Multiplicity="1" />
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DesignationMaster">
              <PropertyRef Name="DesignationID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="DesignationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_EmployeeGradeMaster">
          <End Role="EmployeeGradeMaster" Type="Self.EmployeeGradeMaster" Multiplicity="0..1" />
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeGradeMaster">
              <PropertyRef Name="EmployeeGradeID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="EmployeeGradeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_EmployeeTypeMaster">
          <End Role="EmployeeTypeMaster" Type="Self.EmployeeTypeMaster" Multiplicity="1" />
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeTypeMaster">
              <PropertyRef Name="EmployeeTypeID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="EmployeeTypeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_ShiftMaster">
          <End Role="ShiftMaster" Type="Self.ShiftMaster" Multiplicity="1" />
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ShiftMaster">
              <PropertyRef Name="ShiftID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="ShiftId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidLoan_EmployeeLoan">
          <End Role="EmployeeLoan" Type="Self.EmployeeLoan" Multiplicity="1" />
          <End Role="EmployeePaidLoan" Type="Self.EmployeePaidLoan" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeLoan">
              <PropertyRef Name="EmployeeLoanMapID" />
            </Principal>
            <Dependent Role="EmployeePaidLoan">
              <PropertyRef Name="EmployeeLoanMapId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidSalary_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeePaidSalary" Type="Self.EmployeePaidSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeePaidSalary">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidSalary_FinancialYearMaster">
          <End Role="FinancialYearMaster" Type="Self.FinancialYearMaster" Multiplicity="1" />
          <End Role="EmployeePaidSalary" Type="Self.EmployeePaidSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="FinancialYearMaster">
              <PropertyRef Name="FinancialYearID" />
            </Principal>
            <Dependent Role="EmployeePaidSalary">
              <PropertyRef Name="FinancialYearId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeSalary_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeSalary" Type="Self.EmployeeSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeSalary">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeWorkingDay_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="1" />
          <End Role="EmployeeWorkingDay" Type="Self.EmployeeWorkingDay" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeWorkingDay">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewAttechment_InterviewMaster">
          <End Role="InterviewMaster" Type="Self.InterviewMaster" Multiplicity="1" />
          <End Role="InterviewAttachment" Type="Self.InterviewAttachment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="InterviewMaster">
              <PropertyRef Name="InterviewID" />
            </Principal>
            <Dependent Role="InterviewAttachment">
              <PropertyRef Name="InterviewId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_DepartmentMaster">
          <End Role="DepartmentMaster" Type="Self.DepartmentMaster" Multiplicity="1" />
          <End Role="InterviewMaster" Type="Self.InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DepartmentMaster">
              <PropertyRef Name="DepartmentID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="DepartmentId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_DesignationMaster">
          <End Role="DesignationMaster" Type="Self.DesignationMaster" Multiplicity="1" />
          <End Role="InterviewMaster" Type="Self.InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DesignationMaster">
              <PropertyRef Name="DesignationID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="DesignationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_EducationMaster">
          <End Role="EducationMaster" Type="Self.EducationMaster" Multiplicity="1" />
          <End Role="InterviewMaster" Type="Self.InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EducationMaster">
              <PropertyRef Name="EducationID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="EducationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InvoiceDetail_InvoiceMaster">
          <End Role="InvoiceMaster" Type="Self.InvoiceMaster" Multiplicity="0..1" />
          <End Role="InvoiceDetail" Type="Self.InvoiceDetail" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="InvoiceMaster">
              <PropertyRef Name="InvoiceID" />
            </Principal>
            <Dependent Role="InvoiceDetail">
              <PropertyRef Name="InvoiceId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InvoiceMaster_CurrencyMaster">
          <End Role="CurrencyMaster" Type="Self.CurrencyMaster" Multiplicity="0..1" />
          <End Role="InvoiceMaster" Type="Self.InvoiceMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CurrencyMaster">
              <PropertyRef Name="CurrencyID" />
            </Principal>
            <Dependent Role="InvoiceMaster">
              <PropertyRef Name="CurrencyId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_StateMaster_CountryMaster">
          <End Role="CountryMaster" Type="Self.CountryMaster" Multiplicity="0..1" />
          <End Role="StateMaster" Type="Self.StateMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CountryMaster">
              <PropertyRef Name="CountryID" />
            </Principal>
            <Dependent Role="StateMaster">
              <PropertyRef Name="CountryId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserMaster_EmployeeMaster">
          <End Role="EmployeeMaster" Type="Self.EmployeeMaster" Multiplicity="0..1" />
          <End Role="UserMaster" Type="Self.UserMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="UserMaster">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserMaster_RoleMaster">
          <End Role="RoleMaster" Type="Self.RoleMaster" Multiplicity="1" />
          <End Role="UserMaster" Type="Self.UserMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RoleMaster">
              <PropertyRef Name="RoleID" />
            </Principal>
            <Dependent Role="UserMaster">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserModuleMap_ModuleMaster">
          <End Role="ModuleMaster" Type="Self.ModuleMaster" Multiplicity="1" />
          <End Role="UserModuleMap" Type="Self.UserModuleMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ModuleMaster">
              <PropertyRef Name="ModuleID" />
            </Principal>
            <Dependent Role="UserModuleMap">
              <PropertyRef Name="ModuleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserModuleMap_UserMaster">
          <End Role="UserMaster" Type="Self.UserMaster" Multiplicity="1" />
          <End Role="UserModuleMap" Type="Self.UserModuleMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserMaster">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserModuleMap">
              <PropertyRef Name="UserId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="GetTime" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" ReturnType="varchar(max)">
          <Parameter Name="Date" Type="datetime" Mode="In" />
          <Parameter Name="EmployeeId" Type="uniqueidentifier" Mode="In" />
        </Function>
        <EntityContainer Name="ERPModelStoreContainer">
          <EntitySet Name="AllowanceMaster" EntityType="Self.AllowanceMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CompanyMaster" EntityType="Self.CompanyMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CountryMaster" EntityType="Self.CountryMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CurrencyMaster" EntityType="Self.CurrencyMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="DeductionMaster" EntityType="Self.DeductionMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="DepartmentMaster" EntityType="Self.DepartmentMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="DesignationMaster" EntityType="Self.DesignationMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="DeviceMaster" EntityType="Self.DeviceMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EducationMaster" EntityType="Self.EducationMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeAllowanceMap" EntityType="Self.EmployeeAllowanceMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeAttachment" EntityType="Self.EmployeeAttachment" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeAttendance" EntityType="Self.EmployeeAttendance" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeAttendanceDevice" EntityType="Self.EmployeeAttendanceDevice" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeDeductionMap" EntityType="Self.EmployeeDeductionMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeDeviceMap" EntityType="Self.EmployeeDeviceMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeGradeMaster" EntityType="Self.EmployeeGradeMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeLeaveCategory" EntityType="Self.EmployeeLeaveCategory" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeLeaveMap" EntityType="Self.EmployeeLeaveMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeLoan" EntityType="Self.EmployeeLoan" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeMaster" EntityType="Self.EmployeeMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeePaidAllowanceMap" EntityType="Self.EmployeePaidAllowanceMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeePaidDeductionMap" EntityType="Self.EmployeePaidDeductionMap" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeePaidLoan" EntityType="Self.EmployeePaidLoan" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeePaidSalary" EntityType="Self.EmployeePaidSalary" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeSalary" EntityType="Self.EmployeeSalary" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeTypeMaster" EntityType="Self.EmployeeTypeMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeWorkingDay" EntityType="Self.EmployeeWorkingDay" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="FinancialYearMaster" EntityType="Self.FinancialYearMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="GlobalSetting" EntityType="Self.GlobalSetting" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="History" EntityType="Self.History" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="HolidayMaster" EntityType="Self.HolidayMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="InterviewAttachment" EntityType="Self.InterviewAttachment" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="InterviewMaster" EntityType="Self.InterviewMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="InvoiceDetail" EntityType="Self.InvoiceDetail" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="InvoiceMaster" EntityType="Self.InvoiceMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="IpInformation" EntityType="Self.IpInformation" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="LeaveCategoryMaster" EntityType="Self.LeaveCategoryMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="LicenseKeyMaster" EntityType="Self.LicenseKeyMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ModuleMaster" EntityType="Self.ModuleMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RoleMaster" EntityType="Self.RoleMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ShiftMaster" EntityType="Self.ShiftMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="StateMaster" EntityType="Self.StateMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="UserMaster" EntityType="Self.UserMaster" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="UserModuleMap" EntityType="Self.UserModuleMap" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_EmployeeAllowanceMap_AllowanceMaster" Association="Self.FK_EmployeeAllowanceMap_AllowanceMaster">
            <End Role="AllowanceMaster" EntitySet="AllowanceMaster" />
            <End Role="EmployeeAllowanceMap" EntitySet="EmployeeAllowanceMap" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAllowanceMap_EmployeeMaster" Association="Self.FK_EmployeeAllowanceMap_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeAllowanceMap" EntitySet="EmployeeAllowanceMap" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAttachment_EmployeeMaster" Association="Self.FK_EmployeeAttachment_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeAttachment" EntitySet="EmployeeAttachment" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAttendance_EmployeeMaster" Association="Self.FK_EmployeeAttendance_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeAttendance" EntitySet="EmployeeAttendance" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeDeductionMap_DeductionMaster" Association="Self.FK_EmployeeDeductionMap_DeductionMaster">
            <End Role="DeductionMaster" EntitySet="DeductionMaster" />
            <End Role="EmployeeDeductionMap" EntitySet="EmployeeDeductionMap" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeDeductionMap_EmployeeMaster" Association="Self.FK_EmployeeDeductionMap_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeDeductionMap" EntitySet="EmployeeDeductionMap" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLeaveCategory_EmployeeMaster" Association="Self.FK_EmployeeLeaveCategory_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeLeaveCategory" EntitySet="EmployeeLeaveCategory" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLeaveCategory_LeaveCategoryMaster" Association="Self.FK_EmployeeLeaveCategory_LeaveCategoryMaster">
            <End Role="LeaveCategoryMaster" EntitySet="LeaveCategoryMaster" />
            <End Role="EmployeeLeaveCategory" EntitySet="EmployeeLeaveCategory" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLoan_EmployeeMaster" Association="Self.FK_EmployeeLoan_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeLoan" EntitySet="EmployeeLoan" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_DepartmentMaster" Association="Self.FK_EmployeeMaster_DepartmentMaster">
            <End Role="DepartmentMaster" EntitySet="DepartmentMaster" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_DesignationMaster" Association="Self.FK_EmployeeMaster_DesignationMaster">
            <End Role="DesignationMaster" EntitySet="DesignationMaster" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_EmployeeGradeMaster" Association="Self.FK_EmployeeMaster_EmployeeGradeMaster">
            <End Role="EmployeeGradeMaster" EntitySet="EmployeeGradeMaster" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_EmployeeTypeMaster" Association="Self.FK_EmployeeMaster_EmployeeTypeMaster">
            <End Role="EmployeeTypeMaster" EntitySet="EmployeeTypeMaster" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_ShiftMaster" Association="Self.FK_EmployeeMaster_ShiftMaster">
            <End Role="ShiftMaster" EntitySet="ShiftMaster" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidLoan_EmployeeLoan" Association="Self.FK_EmployeePaidLoan_EmployeeLoan">
            <End Role="EmployeeLoan" EntitySet="EmployeeLoan" />
            <End Role="EmployeePaidLoan" EntitySet="EmployeePaidLoan" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidSalary_EmployeeMaster" Association="Self.FK_EmployeePaidSalary_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeePaidSalary" EntitySet="EmployeePaidSalary" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidSalary_FinancialYearMaster" Association="Self.FK_EmployeePaidSalary_FinancialYearMaster">
            <End Role="FinancialYearMaster" EntitySet="FinancialYearMaster" />
            <End Role="EmployeePaidSalary" EntitySet="EmployeePaidSalary" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeSalary_EmployeeMaster" Association="Self.FK_EmployeeSalary_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeSalary" EntitySet="EmployeeSalary" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeWorkingDay_EmployeeMaster" Association="Self.FK_EmployeeWorkingDay_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="EmployeeWorkingDay" EntitySet="EmployeeWorkingDay" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewAttechment_InterviewMaster" Association="Self.FK_InterviewAttechment_InterviewMaster">
            <End Role="InterviewMaster" EntitySet="InterviewMaster" />
            <End Role="InterviewAttachment" EntitySet="InterviewAttachment" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_DepartmentMaster" Association="Self.FK_InterviewMaster_DepartmentMaster">
            <End Role="DepartmentMaster" EntitySet="DepartmentMaster" />
            <End Role="InterviewMaster" EntitySet="InterviewMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_DesignationMaster" Association="Self.FK_InterviewMaster_DesignationMaster">
            <End Role="DesignationMaster" EntitySet="DesignationMaster" />
            <End Role="InterviewMaster" EntitySet="InterviewMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_EducationMaster" Association="Self.FK_InterviewMaster_EducationMaster">
            <End Role="EducationMaster" EntitySet="EducationMaster" />
            <End Role="InterviewMaster" EntitySet="InterviewMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_InvoiceDetail_InvoiceMaster" Association="Self.FK_InvoiceDetail_InvoiceMaster">
            <End Role="InvoiceMaster" EntitySet="InvoiceMaster" />
            <End Role="InvoiceDetail" EntitySet="InvoiceDetail" />
          </AssociationSet>
          <AssociationSet Name="FK_InvoiceMaster_CurrencyMaster" Association="Self.FK_InvoiceMaster_CurrencyMaster">
            <End Role="CurrencyMaster" EntitySet="CurrencyMaster" />
            <End Role="InvoiceMaster" EntitySet="InvoiceMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_StateMaster_CountryMaster" Association="Self.FK_StateMaster_CountryMaster">
            <End Role="CountryMaster" EntitySet="CountryMaster" />
            <End Role="StateMaster" EntitySet="StateMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_UserMaster_EmployeeMaster" Association="Self.FK_UserMaster_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMaster" />
            <End Role="UserMaster" EntitySet="UserMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_UserMaster_RoleMaster" Association="Self.FK_UserMaster_RoleMaster">
            <End Role="RoleMaster" EntitySet="RoleMaster" />
            <End Role="UserMaster" EntitySet="UserMaster" />
          </AssociationSet>
          <AssociationSet Name="FK_UserModuleMap_ModuleMaster" Association="Self.FK_UserModuleMap_ModuleMaster">
            <End Role="ModuleMaster" EntitySet="ModuleMaster" />
            <End Role="UserModuleMap" EntitySet="UserModuleMap" />
          </AssociationSet>
          <AssociationSet Name="FK_UserModuleMap_UserMaster" Association="Self.FK_UserModuleMap_UserMaster">
            <End Role="UserMaster" EntitySet="UserMaster" />
            <End Role="UserModuleMap" EntitySet="UserModuleMap" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="ERPModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="ERPEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="AllowanceMasters" EntityType="ERPModel.AllowanceMaster" />
          <EntitySet Name="CompanyMasters" EntityType="ERPModel.CompanyMaster" />
          <EntitySet Name="CountryMasters" EntityType="ERPModel.CountryMaster" />
          <EntitySet Name="CurrencyMasters" EntityType="ERPModel.CurrencyMaster" />
          <EntitySet Name="DeductionMasters" EntityType="ERPModel.DeductionMaster" />
          <EntitySet Name="DepartmentMasters" EntityType="ERPModel.DepartmentMaster" />
          <EntitySet Name="DesignationMasters" EntityType="ERPModel.DesignationMaster" />
          <EntitySet Name="DeviceMasters" EntityType="ERPModel.DeviceMaster" />
          <EntitySet Name="EducationMasters" EntityType="ERPModel.EducationMaster" />
          <EntitySet Name="EmployeeAllowanceMaps" EntityType="ERPModel.EmployeeAllowanceMap" />
          <EntitySet Name="EmployeeAttachments" EntityType="ERPModel.EmployeeAttachment" />
          <EntitySet Name="EmployeeAttendances" EntityType="ERPModel.EmployeeAttendance" />
          <EntitySet Name="EmployeeAttendanceDevices" EntityType="ERPModel.EmployeeAttendanceDevice" />
          <EntitySet Name="EmployeeDeductionMaps" EntityType="ERPModel.EmployeeDeductionMap" />
          <EntitySet Name="EmployeeDeviceMaps" EntityType="ERPModel.EmployeeDeviceMap" />
          <EntitySet Name="EmployeeGradeMasters" EntityType="ERPModel.EmployeeGradeMaster" />
          <EntitySet Name="EmployeeLeaveCategories" EntityType="ERPModel.EmployeeLeaveCategory" />
          <EntitySet Name="EmployeeLeaveMaps" EntityType="ERPModel.EmployeeLeaveMap" />
          <EntitySet Name="EmployeeLoans" EntityType="ERPModel.EmployeeLoan" />
          <EntitySet Name="EmployeeMasters" EntityType="ERPModel.EmployeeMaster" />
          <EntitySet Name="EmployeePaidAllowanceMaps" EntityType="ERPModel.EmployeePaidAllowanceMap" />
          <EntitySet Name="EmployeePaidDeductionMaps" EntityType="ERPModel.EmployeePaidDeductionMap" />
          <EntitySet Name="EmployeePaidLoans" EntityType="ERPModel.EmployeePaidLoan" />
          <EntitySet Name="EmployeePaidSalaries" EntityType="ERPModel.EmployeePaidSalary" />
          <EntitySet Name="EmployeeSalaries" EntityType="ERPModel.EmployeeSalary" />
          <EntitySet Name="EmployeeTypeMasters" EntityType="ERPModel.EmployeeTypeMaster" />
          <EntitySet Name="EmployeeWorkingDays" EntityType="ERPModel.EmployeeWorkingDay" />
          <EntitySet Name="FinancialYearMasters" EntityType="ERPModel.FinancialYearMaster" />
          <EntitySet Name="Histories" EntityType="ERPModel.History" />
          <EntitySet Name="HolidayMasters" EntityType="ERPModel.HolidayMaster" />
          <EntitySet Name="InterviewAttachments" EntityType="ERPModel.InterviewAttachment" />
          <EntitySet Name="InterviewMasters" EntityType="ERPModel.InterviewMaster" />
          <EntitySet Name="InvoiceDetails" EntityType="ERPModel.InvoiceDetail" />
          <EntitySet Name="InvoiceMasters" EntityType="ERPModel.InvoiceMaster" />
          <EntitySet Name="IpInformations" EntityType="ERPModel.IpInformation" />
          <EntitySet Name="LeaveCategoryMasters" EntityType="ERPModel.LeaveCategoryMaster" />
          <EntitySet Name="LicenseKeyMasters" EntityType="ERPModel.LicenseKeyMaster" />
          <EntitySet Name="ModuleMasters" EntityType="ERPModel.ModuleMaster" />
          <EntitySet Name="RoleMasters" EntityType="ERPModel.RoleMaster" />
          <EntitySet Name="ShiftMasters" EntityType="ERPModel.ShiftMaster" />
          <EntitySet Name="StateMasters" EntityType="ERPModel.StateMaster" />
          <EntitySet Name="UserMasters" EntityType="ERPModel.UserMaster" />
          <EntitySet Name="UserModuleMaps" EntityType="ERPModel.UserModuleMap" />
          <AssociationSet Name="FK_EmployeeAllowanceMap_AllowanceMaster" Association="ERPModel.FK_EmployeeAllowanceMap_AllowanceMaster">
            <End Role="AllowanceMaster" EntitySet="AllowanceMasters" />
            <End Role="EmployeeAllowanceMap" EntitySet="EmployeeAllowanceMaps" />
          </AssociationSet>
          <AssociationSet Name="FK_StateMaster_CountryMaster" Association="ERPModel.FK_StateMaster_CountryMaster">
            <End Role="CountryMaster" EntitySet="CountryMasters" />
            <End Role="StateMaster" EntitySet="StateMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_InvoiceMaster_CurrencyMaster" Association="ERPModel.FK_InvoiceMaster_CurrencyMaster">
            <End Role="CurrencyMaster" EntitySet="CurrencyMasters" />
            <End Role="InvoiceMaster" EntitySet="InvoiceMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeDeductionMap_DeductionMaster" Association="ERPModel.FK_EmployeeDeductionMap_DeductionMaster">
            <End Role="DeductionMaster" EntitySet="DeductionMasters" />
            <End Role="EmployeeDeductionMap" EntitySet="EmployeeDeductionMaps" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_DepartmentMaster" Association="ERPModel.FK_EmployeeMaster_DepartmentMaster">
            <End Role="DepartmentMaster" EntitySet="DepartmentMasters" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_DepartmentMaster" Association="ERPModel.FK_InterviewMaster_DepartmentMaster">
            <End Role="DepartmentMaster" EntitySet="DepartmentMasters" />
            <End Role="InterviewMaster" EntitySet="InterviewMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_DesignationMaster" Association="ERPModel.FK_EmployeeMaster_DesignationMaster">
            <End Role="DesignationMaster" EntitySet="DesignationMasters" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_DesignationMaster" Association="ERPModel.FK_InterviewMaster_DesignationMaster">
            <End Role="DesignationMaster" EntitySet="DesignationMasters" />
            <End Role="InterviewMaster" EntitySet="InterviewMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewMaster_EducationMaster" Association="ERPModel.FK_InterviewMaster_EducationMaster">
            <End Role="EducationMaster" EntitySet="EducationMasters" />
            <End Role="InterviewMaster" EntitySet="InterviewMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAllowanceMap_EmployeeMaster" Association="ERPModel.FK_EmployeeAllowanceMap_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeAllowanceMap" EntitySet="EmployeeAllowanceMaps" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAttachment_EmployeeMaster" Association="ERPModel.FK_EmployeeAttachment_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeAttachment" EntitySet="EmployeeAttachments" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeAttendance_EmployeeMaster" Association="ERPModel.FK_EmployeeAttendance_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeAttendance" EntitySet="EmployeeAttendances" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeDeductionMap_EmployeeMaster" Association="ERPModel.FK_EmployeeDeductionMap_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeDeductionMap" EntitySet="EmployeeDeductionMaps" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_EmployeeGradeMaster" Association="ERPModel.FK_EmployeeMaster_EmployeeGradeMaster">
            <End Role="EmployeeGradeMaster" EntitySet="EmployeeGradeMasters" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLeaveCategory_EmployeeMaster" Association="ERPModel.FK_EmployeeLeaveCategory_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeLeaveCategory" EntitySet="EmployeeLeaveCategories" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLeaveCategory_LeaveCategoryMaster" Association="ERPModel.FK_EmployeeLeaveCategory_LeaveCategoryMaster">
            <End Role="LeaveCategoryMaster" EntitySet="LeaveCategoryMasters" />
            <End Role="EmployeeLeaveCategory" EntitySet="EmployeeLeaveCategories" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeLoan_EmployeeMaster" Association="ERPModel.FK_EmployeeLoan_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeLoan" EntitySet="EmployeeLoans" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidLoan_EmployeeLoan" Association="ERPModel.FK_EmployeePaidLoan_EmployeeLoan">
            <End Role="EmployeeLoan" EntitySet="EmployeeLoans" />
            <End Role="EmployeePaidLoan" EntitySet="EmployeePaidLoans" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_EmployeeTypeMaster" Association="ERPModel.FK_EmployeeMaster_EmployeeTypeMaster">
            <End Role="EmployeeTypeMaster" EntitySet="EmployeeTypeMasters" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeMaster_ShiftMaster" Association="ERPModel.FK_EmployeeMaster_ShiftMaster">
            <End Role="ShiftMaster" EntitySet="ShiftMasters" />
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidSalary_EmployeeMaster" Association="ERPModel.FK_EmployeePaidSalary_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeePaidSalary" EntitySet="EmployeePaidSalaries" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeSalary_EmployeeMaster" Association="ERPModel.FK_EmployeeSalary_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeSalary" EntitySet="EmployeeSalaries" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeWorkingDay_EmployeeMaster" Association="ERPModel.FK_EmployeeWorkingDay_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="EmployeeWorkingDay" EntitySet="EmployeeWorkingDays" />
          </AssociationSet>
          <AssociationSet Name="FK_UserMaster_EmployeeMaster" Association="ERPModel.FK_UserMaster_EmployeeMaster">
            <End Role="EmployeeMaster" EntitySet="EmployeeMasters" />
            <End Role="UserMaster" EntitySet="UserMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeePaidSalary_FinancialYearMaster" Association="ERPModel.FK_EmployeePaidSalary_FinancialYearMaster">
            <End Role="FinancialYearMaster" EntitySet="FinancialYearMasters" />
            <End Role="EmployeePaidSalary" EntitySet="EmployeePaidSalaries" />
          </AssociationSet>
          <AssociationSet Name="FK_InterviewAttechment_InterviewMaster" Association="ERPModel.FK_InterviewAttechment_InterviewMaster">
            <End Role="InterviewMaster" EntitySet="InterviewMasters" />
            <End Role="InterviewAttachment" EntitySet="InterviewAttachments" />
          </AssociationSet>
          <AssociationSet Name="FK_InvoiceDetail_InvoiceMaster" Association="ERPModel.FK_InvoiceDetail_InvoiceMaster">
            <End Role="InvoiceMaster" EntitySet="InvoiceMasters" />
            <End Role="InvoiceDetail" EntitySet="InvoiceDetails" />
          </AssociationSet>
          <AssociationSet Name="FK_UserModuleMap_ModuleMaster" Association="ERPModel.FK_UserModuleMap_ModuleMaster">
            <End Role="ModuleMaster" EntitySet="ModuleMasters" />
            <End Role="UserModuleMap" EntitySet="UserModuleMaps" />
          </AssociationSet>
          <AssociationSet Name="FK_UserMaster_RoleMaster" Association="ERPModel.FK_UserMaster_RoleMaster">
            <End Role="RoleMaster" EntitySet="RoleMasters" />
            <End Role="UserMaster" EntitySet="UserMasters" />
          </AssociationSet>
          <AssociationSet Name="FK_UserModuleMap_UserMaster" Association="ERPModel.FK_UserModuleMap_UserMaster">
            <End Role="UserMaster" EntitySet="UserMasters" />
            <End Role="UserModuleMap" EntitySet="UserModuleMaps" />
          </AssociationSet>
          <EntitySet Name="GlobalSettings" EntityType="ERPModel.GlobalSetting" />
        </EntityContainer>
        <EntityType Name="AllowanceMaster">
          <Key>
            <PropertyRef Name="AllowanceID" />
          </Key>
          <Property Name="AllowanceID" Type="Guid" Nullable="false" />
          <Property Name="Allowance" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="IsConsider" Type="Boolean" Nullable="false" />
          <Property Name="SortNo" Type="Int32" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="Percentage" Type="Double" />
          <NavigationProperty Name="EmployeeAllowanceMaps" Relationship="ERPModel.FK_EmployeeAllowanceMap_AllowanceMaster" FromRole="AllowanceMaster" ToRole="EmployeeAllowanceMap" />
        </EntityType>
        <EntityType Name="CompanyMaster">
          <Key>
            <PropertyRef Name="CompanyID" />
          </Key>
          <Property Name="CompanyID" Type="Guid" Nullable="false" />
          <Property Name="CompanyName" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CompanyLogo" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="EmailAddress" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="CountryId" Type="Guid" />
          <Property Name="StateId" Type="Guid" />
          <Property Name="City" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Address" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="MobileNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="PhoneNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="HotlineNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="FaxNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="Website" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
          <Property Name="LicenseKey" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="IsKeyActive" Type="Boolean" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="CountryMaster">
          <Key>
            <PropertyRef Name="CountryID" />
          </Key>
          <Property Name="CountryID" Type="Guid" Nullable="false" />
          <Property Name="CountryName" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
          <Property Name="IsActive" Type="Boolean" />
          <NavigationProperty Name="StateMasters" Relationship="ERPModel.FK_StateMaster_CountryMaster" FromRole="CountryMaster" ToRole="StateMaster" />
        </EntityType>
        <EntityType Name="CurrencyMaster">
          <Key>
            <PropertyRef Name="CurrencyID" />
          </Key>
          <Property Name="CurrencyID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="CurrencyCode" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="false" />
          <Property Name="CurrencySymbol" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IsActive" Type="Boolean" />
          <NavigationProperty Name="InvoiceMasters" Relationship="ERPModel.FK_InvoiceMaster_CurrencyMaster" FromRole="CurrencyMaster" ToRole="InvoiceMaster" />
        </EntityType>
        <EntityType Name="DeductionMaster">
          <Key>
            <PropertyRef Name="DeductionID" />
          </Key>
          <Property Name="DeductionID" Type="Guid" Nullable="false" />
          <Property Name="Deduction" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="IsConsider" Type="Boolean" Nullable="false" />
          <Property Name="SortNo" Type="Int32" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeDeductionMaps" Relationship="ERPModel.FK_EmployeeDeductionMap_DeductionMaster" FromRole="DeductionMaster" ToRole="EmployeeDeductionMap" />
        </EntityType>
        <EntityType Name="DepartmentMaster">
          <Key>
            <PropertyRef Name="DepartmentID" />
          </Key>
          <Property Name="DepartmentID" Type="Guid" Nullable="false" />
          <Property Name="Department" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMasters" Relationship="ERPModel.FK_EmployeeMaster_DepartmentMaster" FromRole="DepartmentMaster" ToRole="EmployeeMaster" />
          <NavigationProperty Name="InterviewMasters" Relationship="ERPModel.FK_InterviewMaster_DepartmentMaster" FromRole="DepartmentMaster" ToRole="InterviewMaster" />
        </EntityType>
        <EntityType Name="DesignationMaster">
          <Key>
            <PropertyRef Name="DesignationID" />
          </Key>
          <Property Name="DesignationID" Type="Guid" Nullable="false" />
          <Property Name="Designation" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMasters" Relationship="ERPModel.FK_EmployeeMaster_DesignationMaster" FromRole="DesignationMaster" ToRole="EmployeeMaster" />
          <NavigationProperty Name="InterviewMasters" Relationship="ERPModel.FK_InterviewMaster_DesignationMaster" FromRole="DesignationMaster" ToRole="InterviewMaster" />
        </EntityType>
        <EntityType Name="DeviceMaster">
          <Key>
            <PropertyRef Name="DeviceID" />
          </Key>
          <Property Name="DeviceID" Type="Guid" Nullable="false" />
          <Property Name="DeviceName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="Address" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="DeviceCode" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="PhoneNo" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Port" Type="Int32" />
          <Property Name="IPAddress" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Precision="3" />
          <Property Name="IsActive" Type="Boolean" />
        </EntityType>
        <EntityType Name="EducationMaster">
          <Key>
            <PropertyRef Name="EducationID" />
          </Key>
          <Property Name="EducationID" Type="Guid" Nullable="false" />
          <Property Name="EducationName" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="InterviewMasters" Relationship="ERPModel.FK_InterviewMaster_EducationMaster" FromRole="EducationMaster" ToRole="InterviewMaster" />
        </EntityType>
        <EntityType Name="EmployeeAllowanceMap">
          <Key>
            <PropertyRef Name="EmployeeAllowanceMapID" />
          </Key>
          <Property Name="EmployeeAllowanceMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="AllowanceId" Type="Guid" Nullable="false" />
          <Property Name="Amount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="AllowanceMaster" Relationship="ERPModel.FK_EmployeeAllowanceMap_AllowanceMaster" FromRole="EmployeeAllowanceMap" ToRole="AllowanceMaster" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeAllowanceMap_EmployeeMaster" FromRole="EmployeeAllowanceMap" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeAttachment">
          <Key>
            <PropertyRef Name="EmployeeAttachmentMapID" />
          </Key>
          <Property Name="EmployeeAttachmentMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="Description" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="AttachmentName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeAttachment_EmployeeMaster" FromRole="EmployeeAttachment" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeAttendance">
          <Key>
            <PropertyRef Name="EmployeeAttendanceID" />
          </Key>
          <Property Name="EmployeeAttendanceID" Type="Guid" Nullable="false" />
          <Property Name="FinancialYearId" Type="Guid" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="AttendanceDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="TimeIn" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="TimeOut" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="WorkingHours" Type="Decimal" Precision="10" Scale="2" />
          <Property Name="OverTimeHours" Type="Decimal" Precision="10" Scale="2" />
          <Property Name="AttendanceType" Type="Int32" />
          <Property Name="Attendance" Type="Decimal" Precision="6" Scale="2" />
          <Property Name="Description" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeAttendance_EmployeeMaster" FromRole="EmployeeAttendance" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeAttendanceDevice">
          <Key>
            <PropertyRef Name="EmployeeAttendanceID" />
          </Key>
          <Property Name="EmployeeAttendanceID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" />
          <Property Name="DeviceId" Type="Guid" />
          <Property Name="ShiftId" Type="Guid" />
          <Property Name="EnrollNo" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="AttendanceDate" Type="DateTime" Precision="3" />
          <Property Name="AttendanceDateTime" Type="DateTime" Precision="3" />
          <Property Name="PunchTime" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="VerifyMethod" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="PunchType" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
          <Property Name="PunchMethod" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
          <Property Name="Latitude" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
          <Property Name="Longitude" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
          <Property Name="LocationName" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
          <Property Name="ModifiedDate" Type="DateTime" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="IsActive" Type="Boolean" />
        </EntityType>
        <EntityType Name="EmployeeDeductionMap">
          <Key>
            <PropertyRef Name="EmployeeDeductionMapID" />
          </Key>
          <Property Name="EmployeeDeductionMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="DeductionId" Type="Guid" Nullable="false" />
          <Property Name="Amount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="DeductionMaster" Relationship="ERPModel.FK_EmployeeDeductionMap_DeductionMaster" FromRole="EmployeeDeductionMap" ToRole="DeductionMaster" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeDeductionMap_EmployeeMaster" FromRole="EmployeeDeductionMap" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeDeviceMap">
          <Key>
            <PropertyRef Name="EmployeeDeviceID" />
          </Key>
          <Property Name="EmployeeDeviceID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" />
          <Property Name="DeviceId" Type="Guid" />
          <Property Name="EnrollNo" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
          <Property Name="IsActive" Type="Boolean" />
        </EntityType>
        <EntityType Name="EmployeeGradeMaster">
          <Key>
            <PropertyRef Name="EmployeeGradeID" />
          </Key>
          <Property Name="EmployeeGradeID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeGrade" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMasters" Relationship="ERPModel.FK_EmployeeMaster_EmployeeGradeMaster" FromRole="EmployeeGradeMaster" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeLeaveCategory">
          <Key>
            <PropertyRef Name="EmployeeLeaveCategoryMapID" />
          </Key>
          <Property Name="EmployeeLeaveCategoryMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="LeaveCategoryId" Type="Guid" Nullable="false" />
          <Property Name="StartDate" Type="DateTime" Precision="3" />
          <Property Name="EndDate" Type="DateTime" Precision="3" />
          <Property Name="TotalDay" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="IsFirstHalfDay" Type="Boolean" Nullable="false" />
          <Property Name="IsLastHalfDay" Type="Boolean" Nullable="false" />
          <Property Name="Reason" Type="String" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="Comments" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="ApplyDate" Type="DateTime" Precision="3" />
          <Property Name="ApprovedBy" Type="String" MaxLength="150" FixedLength="false" Unicode="false" />
          <Property Name="ApproveDate" Type="DateTime" Precision="3" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="IsApprove" Type="Boolean" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeLeaveCategory_EmployeeMaster" FromRole="EmployeeLeaveCategory" ToRole="EmployeeMaster" />
          <NavigationProperty Name="LeaveCategoryMaster" Relationship="ERPModel.FK_EmployeeLeaveCategory_LeaveCategoryMaster" FromRole="EmployeeLeaveCategory" ToRole="LeaveCategoryMaster" />
        </EntityType>
        <EntityType Name="EmployeeLeaveMap">
          <Key>
            <PropertyRef Name="EmployeeLeaveID" />
          </Key>
          <Property Name="EmployeeLeaveID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" />
          <Property Name="LeaveId" Type="Guid" />
          <Property Name="LeaveCount" Type="Int32" />
        </EntityType>
        <EntityType Name="EmployeeLoan">
          <Key>
            <PropertyRef Name="EmployeeLoanMapID" />
          </Key>
          <Property Name="EmployeeLoanMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="Amount" Type="Decimal" Nullable="false" Precision="12" Scale="2" />
          <Property Name="LoanDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="LoanTitle" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="ApprovedBy" Type="String" MaxLength="150" FixedLength="false" Unicode="false" />
          <Property Name="TotalMonths" Type="Int32" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="IsComplete" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeLoan_EmployeeMaster" FromRole="EmployeeLoan" ToRole="EmployeeMaster" />
          <NavigationProperty Name="EmployeePaidLoans" Relationship="ERPModel.FK_EmployeePaidLoan_EmployeeLoan" FromRole="EmployeeLoan" ToRole="EmployeePaidLoan" />
        </EntityType>
        <EntityType Name="EmployeeMaster">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeTypeId" Type="Guid" Nullable="false" />
          <Property Name="EmployeeGradeId" Type="Guid" />
          <Property Name="DepartmentId" Type="Guid" Nullable="false" />
          <Property Name="DesignationId" Type="Guid" Nullable="false" />
          <Property Name="ShiftId" Type="Guid" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="BirthDate" Type="DateTime" Precision="3" />
          <Property Name="Gender" Type="Boolean" />
          <Property Name="MaratialStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PhotoName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CountryId" Type="Guid" />
          <Property Name="StateId" Type="Guid" />
          <Property Name="City" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Address" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="PinCode" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
          <Property Name="MobileNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="PhoneNo" Type="String" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="JoinDate" Type="DateTime" Precision="3" />
          <Property Name="EmployeeNo" Type="Int32" Nullable="false" />
          <Property Name="Email" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="BankName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="BranchName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="AccountName" Type="String" MaxLength="150" FixedLength="false" Unicode="false" />
          <Property Name="AccountNo" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="IsLeave" Type="Boolean" Nullable="false" />
          <Property Name="LeaveDate" Type="DateTime" Precision="3" />
          <Property Name="LeaveDescription" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="Previlage" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="FaceTemplate" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="IsHavingFace" Type="Boolean" />
          <Property Name="FaceLength" Type="Int32" />
          <Property Name="FingureTemplate" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="finger_template_data_bw" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft1" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft2" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft3" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft4" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft5" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft6" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft7" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft8" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_tft9" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw1" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw2" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw3" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw4" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw5" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw6" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw7" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw8" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="finger_template_data_bw9" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="is_having_fingureprint" Type="Boolean" />
          <Property Name="IsSend" Type="Boolean" />
          <Property Name="FaceTemplateData" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="PANNo" Type="String" MaxLength="10" FixedLength="true" Unicode="true" />
          <Property Name="TotalLeaveCount" Type="Int32" />
          <NavigationProperty Name="DepartmentMaster" Relationship="ERPModel.FK_EmployeeMaster_DepartmentMaster" FromRole="EmployeeMaster" ToRole="DepartmentMaster" />
          <NavigationProperty Name="DesignationMaster" Relationship="ERPModel.FK_EmployeeMaster_DesignationMaster" FromRole="EmployeeMaster" ToRole="DesignationMaster" />
          <NavigationProperty Name="EmployeeAllowanceMaps" Relationship="ERPModel.FK_EmployeeAllowanceMap_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeAllowanceMap" />
          <NavigationProperty Name="EmployeeAttachments" Relationship="ERPModel.FK_EmployeeAttachment_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeAttachment" />
          <NavigationProperty Name="EmployeeAttendances" Relationship="ERPModel.FK_EmployeeAttendance_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeAttendance" />
          <NavigationProperty Name="EmployeeDeductionMaps" Relationship="ERPModel.FK_EmployeeDeductionMap_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeDeductionMap" />
          <NavigationProperty Name="EmployeeGradeMaster" Relationship="ERPModel.FK_EmployeeMaster_EmployeeGradeMaster" FromRole="EmployeeMaster" ToRole="EmployeeGradeMaster" />
          <NavigationProperty Name="EmployeeLeaveCategories" Relationship="ERPModel.FK_EmployeeLeaveCategory_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeLeaveCategory" />
          <NavigationProperty Name="EmployeeLoans" Relationship="ERPModel.FK_EmployeeLoan_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeLoan" />
          <NavigationProperty Name="EmployeeTypeMaster" Relationship="ERPModel.FK_EmployeeMaster_EmployeeTypeMaster" FromRole="EmployeeMaster" ToRole="EmployeeTypeMaster" />
          <NavigationProperty Name="ShiftMaster" Relationship="ERPModel.FK_EmployeeMaster_ShiftMaster" FromRole="EmployeeMaster" ToRole="ShiftMaster" />
          <NavigationProperty Name="EmployeePaidSalaries" Relationship="ERPModel.FK_EmployeePaidSalary_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeePaidSalary" />
          <NavigationProperty Name="EmployeeSalaries" Relationship="ERPModel.FK_EmployeeSalary_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeSalary" />
          <NavigationProperty Name="EmployeeWorkingDays" Relationship="ERPModel.FK_EmployeeWorkingDay_EmployeeMaster" FromRole="EmployeeMaster" ToRole="EmployeeWorkingDay" />
          <NavigationProperty Name="UserMasters" Relationship="ERPModel.FK_UserMaster_EmployeeMaster" FromRole="EmployeeMaster" ToRole="UserMaster" />
          <Property Name="OverTimeAmount" Type="Decimal" Precision="18" Scale="2" />
        </EntityType>
        <EntityType Name="EmployeePaidAllowanceMap">
          <Key>
            <PropertyRef Name="EmployeePaidAllowanceMapID" />
          </Key>
          <Property Name="EmployeePaidAllowanceMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeePaidSalaryId" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="AllowanceId" Type="Guid" Nullable="false" />
          <Property Name="Amount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidAmount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeePaidDeductionMap">
          <Key>
            <PropertyRef Name="EmployeePaidDeductionMapID" />
          </Key>
          <Property Name="EmployeePaidDeductionMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeePaidSalaryId" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="DeductionId" Type="Guid" Nullable="false" />
          <Property Name="Amount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidAmount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeePaidLoan">
          <Key>
            <PropertyRef Name="EmployeePaidLoanMapID" />
          </Key>
          <Property Name="EmployeePaidLoanMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeLoanMapId" Type="Guid" Nullable="false" />
          <Property Name="PaidAmount" Type="Decimal" Nullable="false" Precision="12" Scale="2" />
          <Property Name="PaidDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="Month" Type="String" Nullable="false" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="Year" Type="Int32" Nullable="false" />
          <NavigationProperty Name="EmployeeLoan" Relationship="ERPModel.FK_EmployeePaidLoan_EmployeeLoan" FromRole="EmployeePaidLoan" ToRole="EmployeeLoan" />
        </EntityType>
        <EntityType Name="EmployeePaidSalary">
          <Key>
            <PropertyRef Name="EmployeePaidSalaryID" />
          </Key>
          <Property Name="EmployeePaidSalaryID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="Basic" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalEarning" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalDeduction" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalSalary" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidBasic" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalEarning" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalDeduction" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidTotalSalary" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="Month" Type="String" Nullable="false" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="Year" Type="Int32" Nullable="false" />
          <Property Name="TotalOverTimeDays" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalOverTimeHours" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="TotalDays" Type="Int32" Nullable="false" />
          <Property Name="TotalHours" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="AllowLeave" Type="Decimal" Precision="6" Scale="2" />
          <Property Name="TotalUseLeave" Type="Decimal" Precision="6" Scale="1" />
          <Property Name="TotalHoliday" Type="Decimal" Precision="6" Scale="1" />
          <Property Name="TotalPaidLeave" Type="Decimal" Precision="6" Scale="1" />
          <Property Name="TotalPaidLeaveAmount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalOverTimeAmount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidLoanAmount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="PaidDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="PaidBy" Type="String" MaxLength="150" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="IsPaid" Type="Boolean" Nullable="false" />
          <Property Name="FinancialYearId" Type="Guid" Nullable="false" />
          <Property Name="TotalPresentDays" Type="Decimal" Precision="6" Scale="1" />
          <Property Name="ProfessionalTax" Type="Decimal" Precision="12" Scale="2" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeePaidSalary_EmployeeMaster" FromRole="EmployeePaidSalary" ToRole="EmployeeMaster" />
          <NavigationProperty Name="FinancialYearMaster" Relationship="ERPModel.FK_EmployeePaidSalary_FinancialYearMaster" FromRole="EmployeePaidSalary" ToRole="FinancialYearMaster" />
          <Property Name="SalaryFromDate" Type="DateTime" Precision="3" />
          <Property Name="SalaryToDate" Type="DateTime" Precision="3" />
        </EntityType>
        <EntityType Name="EmployeeSalary">
          <Key>
            <PropertyRef Name="EmployeeSalaryID" />
          </Key>
          <Property Name="EmployeeSalaryID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="Basic" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalEarning" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalDeduction" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="TotalSalary" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="SalaryType" Type="Int32" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeSalary_EmployeeMaster" FromRole="EmployeeSalary" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeTypeMaster">
          <Key>
            <PropertyRef Name="EmployeeTypeID" />
          </Key>
          <Property Name="EmployeeTypeID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeType" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="NoOfLeavePerMonth" Type="Decimal" Nullable="false" Precision="5" Scale="1" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMasters" Relationship="ERPModel.FK_EmployeeMaster_EmployeeTypeMaster" FromRole="EmployeeTypeMaster" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="EmployeeWorkingDay">
          <Key>
            <PropertyRef Name="EmployeeWorkingDayMapID" />
          </Key>
          <Property Name="EmployeeWorkingDayMapID" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" Nullable="false" />
          <Property Name="DayName" Type="String" Nullable="false" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_EmployeeWorkingDay_EmployeeMaster" FromRole="EmployeeWorkingDay" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="FinancialYearMaster">
          <Key>
            <PropertyRef Name="FinancialYearID" />
          </Key>
          <Property Name="FinancialYearID" Type="Guid" Nullable="false" />
          <Property Name="Year" Type="Int32" Nullable="false" />
          <Property Name="FinancialYear" Type="String" Nullable="false" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeePaidSalaries" Relationship="ERPModel.FK_EmployeePaidSalary_FinancialYearMaster" FromRole="FinancialYearMaster" ToRole="EmployeePaidSalary" />
        </EntityType>
        <EntityType Name="History">
          <Key>
            <PropertyRef Name="HistoryID" />
          </Key>
          <Property Name="HistoryID" Type="Guid" Nullable="false" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="TableId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="TableTypeId" Type="Int32" Nullable="false" />
          <Property Name="OperationTypeId" Type="Int32" Nullable="false" />
          <Property Name="UserId" Type="Guid" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="XmlContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="IPAddress" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
        </EntityType>
        <EntityType Name="HolidayMaster">
          <Key>
            <PropertyRef Name="HolidayID" />
          </Key>
          <Property Name="HolidayID" Type="Guid" Nullable="false" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="StartDate" Type="DateTime" Precision="3" />
          <Property Name="EndDate" Type="DateTime" Precision="3" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="InterviewAttachment">
          <Key>
            <PropertyRef Name="InterviewAttachmentMapID" />
          </Key>
          <Property Name="InterviewAttachmentMapID" Type="Guid" Nullable="false" />
          <Property Name="InterviewId" Type="Guid" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="AttachmentType" Type="Int32" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="InterviewMaster" Relationship="ERPModel.FK_InterviewAttechment_InterviewMaster" FromRole="InterviewAttachment" ToRole="InterviewMaster" />
        </EntityType>
        <EntityType Name="InterviewMaster">
          <Key>
            <PropertyRef Name="InterviewID" />
          </Key>
          <Property Name="InterviewID" Type="Guid" Nullable="false" />
          <Property Name="InterviewNo" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="Email" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="MobileNo" Type="String" Nullable="false" MaxLength="15" FixedLength="false" Unicode="false" />
          <Property Name="EducationId" Type="Guid" Nullable="false" />
          <Property Name="DepartmentId" Type="Guid" Nullable="false" />
          <Property Name="DesignationId" Type="Guid" Nullable="false" />
          <Property Name="CurrentSalary" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="ExpectedSalary" Type="Decimal" Precision="18" Scale="2" />
          <Property Name="ExperienceYear" Type="Int32" />
          <Property Name="ExperienceMonth" Type="Int32" />
          <Property Name="IsJoinDays" Type="Boolean" />
          <Property Name="JoinAfterDaysOrMonth" Type="Int32" />
          <Property Name="PersonalDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="InterviewStatusId" Type="Int32" />
          <Property Name="InterviewDate" Type="DateTime" Precision="3" />
          <Property Name="InterviewTime" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="JoinDate" Type="DateTime" Precision="3" />
          <Property Name="Reason" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="DepartmentMaster" Relationship="ERPModel.FK_InterviewMaster_DepartmentMaster" FromRole="InterviewMaster" ToRole="DepartmentMaster" />
          <NavigationProperty Name="DesignationMaster" Relationship="ERPModel.FK_InterviewMaster_DesignationMaster" FromRole="InterviewMaster" ToRole="DesignationMaster" />
          <NavigationProperty Name="EducationMaster" Relationship="ERPModel.FK_InterviewMaster_EducationMaster" FromRole="InterviewMaster" ToRole="EducationMaster" />
          <NavigationProperty Name="InterviewAttachments" Relationship="ERPModel.FK_InterviewAttechment_InterviewMaster" FromRole="InterviewMaster" ToRole="InterviewAttachment" />
        </EntityType>
        <EntityType Name="InvoiceDetail">
          <Key>
            <PropertyRef Name="InvoiceDetailID" />
          </Key>
          <Property Name="InvoiceDetailID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="InvoiceId" Type="Int32" />
          <Property Name="ItemDescription" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="ItemDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="Hours" Type="Decimal" Precision="8" Scale="2" />
          <Property Name="HourRate" Type="Decimal" Precision="8" Scale="2" />
          <Property Name="Amount" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="InvoiceMaster" Relationship="ERPModel.FK_InvoiceDetail_InvoiceMaster" FromRole="InvoiceDetail" ToRole="InvoiceMaster" />
        </EntityType>
        <EntityType Name="InvoiceMaster">
          <Key>
            <PropertyRef Name="InvoiceID" />
          </Key>
          <Property Name="InvoiceID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="InvoiceNo" Type="Int32" Nullable="false" />
          <Property Name="InvoiceDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CurrencyId" Type="Int32" />
          <Property Name="PartyName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="PartyAddress" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="Description" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="SubTotal" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="ServiceTax" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="GrandTotal" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="SubTotalINR" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="ServiceTaxINR" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="GrandTotalINR" Type="Decimal" Precision="12" Scale="2" />
          <Property Name="IsFixed" Type="Boolean" />
          <Property Name="IsPaid" Type="Boolean" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="CurrencyMaster" Relationship="ERPModel.FK_InvoiceMaster_CurrencyMaster" FromRole="InvoiceMaster" ToRole="CurrencyMaster" />
          <NavigationProperty Name="InvoiceDetails" Relationship="ERPModel.FK_InvoiceDetail_InvoiceMaster" FromRole="InvoiceMaster" ToRole="InvoiceDetail" />
        </EntityType>
        <EntityType Name="IpInformation">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" />
          <Property Name="IpAddress" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="DeviceName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="BrowserName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="DeviceType" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
        </EntityType>
        <EntityType Name="LeaveCategoryMaster">
          <Key>
            <PropertyRef Name="LeaveCategoryID" />
          </Key>
          <Property Name="LeaveCategoryID" Type="Guid" Nullable="false" />
          <Property Name="LeaveCategory" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeLeaveCategories" Relationship="ERPModel.FK_EmployeeLeaveCategory_LeaveCategoryMaster" FromRole="LeaveCategoryMaster" ToRole="EmployeeLeaveCategory" />
        </EntityType>
        <EntityType Name="LicenseKeyMaster">
          <Key>
            <PropertyRef Name="LicenseKeyID" />
          </Key>
          <Property Name="LicenseKeyID" Type="Guid" Nullable="false" />
          <Property Name="Email" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="KeyID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IsUsed" Type="Boolean" Nullable="false" />
          <Property Name="CreatedBy" Type="Guid" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="ModuleMaster">
          <Key>
            <PropertyRef Name="ModuleID" />
          </Key>
          <Property Name="ModuleID" Type="Guid" Nullable="false" />
          <Property Name="EnumName" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="ParentId" Type="Guid" />
          <Property Name="TreeLevel" Type="Int32" Nullable="false" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <Property Name="SortOrder" Type="Int32" Nullable="false" />
          <NavigationProperty Name="UserModuleMaps" Relationship="ERPModel.FK_UserModuleMap_ModuleMaster" FromRole="ModuleMaster" ToRole="UserModuleMap" />
        </EntityType>
        <EntityType Name="RoleMaster">
          <Key>
            <PropertyRef Name="RoleID" />
          </Key>
          <Property Name="RoleID" Type="Guid" Nullable="false" />
          <Property Name="RoleName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="UserMasters" Relationship="ERPModel.FK_UserMaster_RoleMaster" FromRole="RoleMaster" ToRole="UserMaster" />
        </EntityType>
        <EntityType Name="ShiftMaster">
          <Key>
            <PropertyRef Name="ShiftID" />
          </Key>
          <Property Name="ShiftID" Type="Guid" Nullable="false" />
          <Property Name="Shift" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="FromTime" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
          <Property Name="ToTime" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMasters" Relationship="ERPModel.FK_EmployeeMaster_ShiftMaster" FromRole="ShiftMaster" ToRole="EmployeeMaster" />
        </EntityType>
        <EntityType Name="StateMaster">
          <Key>
            <PropertyRef Name="StateID" />
          </Key>
          <Property Name="StateID" Type="Guid" Nullable="false" />
          <Property Name="CountryId" Type="Guid" />
          <Property Name="StateName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="CreatedDate" Type="DateTime" Precision="3" />
          <Property Name="IsActive" Type="Boolean" />
          <NavigationProperty Name="CountryMaster" Relationship="ERPModel.FK_StateMaster_CountryMaster" FromRole="StateMaster" ToRole="CountryMaster" />
        </EntityType>
        <EntityType Name="UserMaster">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="Guid" Nullable="false" />
          <Property Name="RoleId" Type="Guid" Nullable="false" />
          <Property Name="EmployeeId" Type="Guid" />
          <Property Name="Username" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" />
          <Property Name="Password" Type="String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="LastLogin" Type="DateTime" Precision="3" />
          <Property Name="Token" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="CreatedBy" Type="Guid" />
          <Property Name="ModifiedBy" Type="Guid" />
          <Property Name="ModifiedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsActive" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="EmployeeMaster" Relationship="ERPModel.FK_UserMaster_EmployeeMaster" FromRole="UserMaster" ToRole="EmployeeMaster" />
          <NavigationProperty Name="RoleMaster" Relationship="ERPModel.FK_UserMaster_RoleMaster" FromRole="UserMaster" ToRole="RoleMaster" />
          <NavigationProperty Name="UserModuleMaps" Relationship="ERPModel.FK_UserModuleMap_UserMaster" FromRole="UserMaster" ToRole="UserModuleMap" />
        </EntityType>
        <EntityType Name="UserModuleMap">
          <Key>
            <PropertyRef Name="UserModuleMapID" />
          </Key>
          <Property Name="UserModuleMapID" Type="Guid" Nullable="false" />
          <Property Name="UserId" Type="Guid" Nullable="false" />
          <Property Name="ModuleId" Type="Guid" Nullable="false" />
          <NavigationProperty Name="ModuleMaster" Relationship="ERPModel.FK_UserModuleMap_ModuleMaster" FromRole="UserModuleMap" ToRole="ModuleMaster" />
          <NavigationProperty Name="UserMaster" Relationship="ERPModel.FK_UserModuleMap_UserMaster" FromRole="UserModuleMap" ToRole="UserMaster" />
        </EntityType>
        <Association Name="FK_EmployeeAllowanceMap_AllowanceMaster">
          <End Type="ERPModel.AllowanceMaster" Role="AllowanceMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeAllowanceMap" Role="EmployeeAllowanceMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AllowanceMaster">
              <PropertyRef Name="AllowanceID" />
            </Principal>
            <Dependent Role="EmployeeAllowanceMap">
              <PropertyRef Name="AllowanceId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_StateMaster_CountryMaster">
          <End Type="ERPModel.CountryMaster" Role="CountryMaster" Multiplicity="0..1" />
          <End Type="ERPModel.StateMaster" Role="StateMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CountryMaster">
              <PropertyRef Name="CountryID" />
            </Principal>
            <Dependent Role="StateMaster">
              <PropertyRef Name="CountryId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InvoiceMaster_CurrencyMaster">
          <End Type="ERPModel.CurrencyMaster" Role="CurrencyMaster" Multiplicity="0..1" />
          <End Type="ERPModel.InvoiceMaster" Role="InvoiceMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CurrencyMaster">
              <PropertyRef Name="CurrencyID" />
            </Principal>
            <Dependent Role="InvoiceMaster">
              <PropertyRef Name="CurrencyId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeDeductionMap_DeductionMaster">
          <End Type="ERPModel.DeductionMaster" Role="DeductionMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeDeductionMap" Role="EmployeeDeductionMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DeductionMaster">
              <PropertyRef Name="DeductionID" />
            </Principal>
            <Dependent Role="EmployeeDeductionMap">
              <PropertyRef Name="DeductionId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_DepartmentMaster">
          <End Type="ERPModel.DepartmentMaster" Role="DepartmentMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DepartmentMaster">
              <PropertyRef Name="DepartmentID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="DepartmentId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_DepartmentMaster">
          <End Type="ERPModel.DepartmentMaster" Role="DepartmentMaster" Multiplicity="1" />
          <End Type="ERPModel.InterviewMaster" Role="InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DepartmentMaster">
              <PropertyRef Name="DepartmentID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="DepartmentId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_DesignationMaster">
          <End Type="ERPModel.DesignationMaster" Role="DesignationMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DesignationMaster">
              <PropertyRef Name="DesignationID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="DesignationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_DesignationMaster">
          <End Type="ERPModel.DesignationMaster" Role="DesignationMaster" Multiplicity="1" />
          <End Type="ERPModel.InterviewMaster" Role="InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="DesignationMaster">
              <PropertyRef Name="DesignationID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="DesignationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewMaster_EducationMaster">
          <End Type="ERPModel.EducationMaster" Role="EducationMaster" Multiplicity="1" />
          <End Type="ERPModel.InterviewMaster" Role="InterviewMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EducationMaster">
              <PropertyRef Name="EducationID" />
            </Principal>
            <Dependent Role="InterviewMaster">
              <PropertyRef Name="EducationId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAllowanceMap_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeAllowanceMap" Role="EmployeeAllowanceMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAllowanceMap">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAttachment_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeAttachment" Role="EmployeeAttachment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAttachment">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeAttendance_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeAttendance" Role="EmployeeAttendance" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeAttendance">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeDeductionMap_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeDeductionMap" Role="EmployeeDeductionMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeDeductionMap">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_EmployeeGradeMaster">
          <End Type="ERPModel.EmployeeGradeMaster" Role="EmployeeGradeMaster" Multiplicity="0..1" />
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeGradeMaster">
              <PropertyRef Name="EmployeeGradeID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="EmployeeGradeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLeaveCategory_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeLeaveCategory" Role="EmployeeLeaveCategory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeLeaveCategory">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLeaveCategory_LeaveCategoryMaster">
          <End Type="ERPModel.LeaveCategoryMaster" Role="LeaveCategoryMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeLeaveCategory" Role="EmployeeLeaveCategory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="LeaveCategoryMaster">
              <PropertyRef Name="LeaveCategoryID" />
            </Principal>
            <Dependent Role="EmployeeLeaveCategory">
              <PropertyRef Name="LeaveCategoryId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeLoan_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeLoan" Role="EmployeeLoan" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeLoan">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidLoan_EmployeeLoan">
          <End Type="ERPModel.EmployeeLoan" Role="EmployeeLoan" Multiplicity="1" />
          <End Type="ERPModel.EmployeePaidLoan" Role="EmployeePaidLoan" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeLoan">
              <PropertyRef Name="EmployeeLoanMapID" />
            </Principal>
            <Dependent Role="EmployeePaidLoan">
              <PropertyRef Name="EmployeeLoanMapId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_EmployeeTypeMaster">
          <End Type="ERPModel.EmployeeTypeMaster" Role="EmployeeTypeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeTypeMaster">
              <PropertyRef Name="EmployeeTypeID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="EmployeeTypeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeMaster_ShiftMaster">
          <End Type="ERPModel.ShiftMaster" Role="ShiftMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ShiftMaster">
              <PropertyRef Name="ShiftID" />
            </Principal>
            <Dependent Role="EmployeeMaster">
              <PropertyRef Name="ShiftId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidSalary_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeePaidSalary" Role="EmployeePaidSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeePaidSalary">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeSalary_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeSalary" Role="EmployeeSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeSalary">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeWorkingDay_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeeWorkingDay" Role="EmployeeWorkingDay" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeWorkingDay">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserMaster_EmployeeMaster">
          <End Type="ERPModel.EmployeeMaster" Role="EmployeeMaster" Multiplicity="0..1" />
          <End Type="ERPModel.UserMaster" Role="UserMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeMaster">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="UserMaster">
              <PropertyRef Name="EmployeeId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeePaidSalary_FinancialYearMaster">
          <End Type="ERPModel.FinancialYearMaster" Role="FinancialYearMaster" Multiplicity="1" />
          <End Type="ERPModel.EmployeePaidSalary" Role="EmployeePaidSalary" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="FinancialYearMaster">
              <PropertyRef Name="FinancialYearID" />
            </Principal>
            <Dependent Role="EmployeePaidSalary">
              <PropertyRef Name="FinancialYearId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InterviewAttechment_InterviewMaster">
          <End Type="ERPModel.InterviewMaster" Role="InterviewMaster" Multiplicity="1" />
          <End Type="ERPModel.InterviewAttachment" Role="InterviewAttachment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="InterviewMaster">
              <PropertyRef Name="InterviewID" />
            </Principal>
            <Dependent Role="InterviewAttachment">
              <PropertyRef Name="InterviewId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_InvoiceDetail_InvoiceMaster">
          <End Type="ERPModel.InvoiceMaster" Role="InvoiceMaster" Multiplicity="0..1" />
          <End Type="ERPModel.InvoiceDetail" Role="InvoiceDetail" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="InvoiceMaster">
              <PropertyRef Name="InvoiceID" />
            </Principal>
            <Dependent Role="InvoiceDetail">
              <PropertyRef Name="InvoiceId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserModuleMap_ModuleMaster">
          <End Type="ERPModel.ModuleMaster" Role="ModuleMaster" Multiplicity="1" />
          <End Type="ERPModel.UserModuleMap" Role="UserModuleMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ModuleMaster">
              <PropertyRef Name="ModuleID" />
            </Principal>
            <Dependent Role="UserModuleMap">
              <PropertyRef Name="ModuleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserMaster_RoleMaster">
          <End Type="ERPModel.RoleMaster" Role="RoleMaster" Multiplicity="1" />
          <End Type="ERPModel.UserMaster" Role="UserMaster" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RoleMaster">
              <PropertyRef Name="RoleID" />
            </Principal>
            <Dependent Role="UserMaster">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserModuleMap_UserMaster">
          <End Type="ERPModel.UserMaster" Role="UserMaster" Multiplicity="1" />
          <End Type="ERPModel.UserModuleMap" Role="UserModuleMap" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserMaster">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserModuleMap">
              <PropertyRef Name="UserId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="GlobalSetting">
          <Key>
            <PropertyRef Name="GlobalSettingId" />
          </Key>
          <Property Name="GlobalSettingId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="GlobalSettingName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="GlobalSettingEnum" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="GlobalSettingValue" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
        </EntityType>
        </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="ERPModelStoreContainer" CdmEntityContainer="ERPEntities">
          <EntitySetMapping Name="AllowanceMasters">
            <EntityTypeMapping TypeName="ERPModel.AllowanceMaster">
              <MappingFragment StoreEntitySet="AllowanceMaster">
                <ScalarProperty Name="Percentage" ColumnName="Percentage" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="SortNo" ColumnName="SortNo" />
                <ScalarProperty Name="IsConsider" ColumnName="IsConsider" />
                <ScalarProperty Name="Allowance" ColumnName="Allowance" />
                <ScalarProperty Name="AllowanceID" ColumnName="AllowanceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CompanyMasters">
            <EntityTypeMapping TypeName="ERPModel.CompanyMaster">
              <MappingFragment StoreEntitySet="CompanyMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="IsKeyActive" ColumnName="IsKeyActive" />
                <ScalarProperty Name="LicenseKey" ColumnName="LicenseKey" />
                <ScalarProperty Name="Website" ColumnName="Website" />
                <ScalarProperty Name="FaxNo" ColumnName="FaxNo" />
                <ScalarProperty Name="HotlineNo" ColumnName="HotlineNo" />
                <ScalarProperty Name="PhoneNo" ColumnName="PhoneNo" />
                <ScalarProperty Name="MobileNo" ColumnName="MobileNo" />
                <ScalarProperty Name="Address" ColumnName="Address" />
                <ScalarProperty Name="City" ColumnName="City" />
                <ScalarProperty Name="StateId" ColumnName="StateId" />
                <ScalarProperty Name="CountryId" ColumnName="CountryId" />
                <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
                <ScalarProperty Name="CompanyLogo" ColumnName="CompanyLogo" />
                <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
                <ScalarProperty Name="CompanyID" ColumnName="CompanyID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CountryMasters">
            <EntityTypeMapping TypeName="ERPModel.CountryMaster">
              <MappingFragment StoreEntitySet="CountryMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Code" ColumnName="Code" />
                <ScalarProperty Name="CountryName" ColumnName="CountryName" />
                <ScalarProperty Name="CountryID" ColumnName="CountryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CurrencyMasters">
            <EntityTypeMapping TypeName="ERPModel.CurrencyMaster">
              <MappingFragment StoreEntitySet="CurrencyMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="CurrencySymbol" ColumnName="CurrencySymbol" />
                <ScalarProperty Name="CurrencyCode" ColumnName="CurrencyCode" />
                <ScalarProperty Name="CurrencyID" ColumnName="CurrencyID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DeductionMasters">
            <EntityTypeMapping TypeName="ERPModel.DeductionMaster">
              <MappingFragment StoreEntitySet="DeductionMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="SortNo" ColumnName="SortNo" />
                <ScalarProperty Name="IsConsider" ColumnName="IsConsider" />
                <ScalarProperty Name="Deduction" ColumnName="Deduction" />
                <ScalarProperty Name="DeductionID" ColumnName="DeductionID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DepartmentMasters">
            <EntityTypeMapping TypeName="ERPModel.DepartmentMaster">
              <MappingFragment StoreEntitySet="DepartmentMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="DepartmentID" ColumnName="DepartmentID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DesignationMasters">
            <EntityTypeMapping TypeName="ERPModel.DesignationMaster">
              <MappingFragment StoreEntitySet="DesignationMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Designation" ColumnName="Designation" />
                <ScalarProperty Name="DesignationID" ColumnName="DesignationID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DeviceMasters">
            <EntityTypeMapping TypeName="ERPModel.DeviceMaster">
              <MappingFragment StoreEntitySet="DeviceMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="IPAddress" ColumnName="IPAddress" />
                <ScalarProperty Name="Port" ColumnName="Port" />
                <ScalarProperty Name="PhoneNo" ColumnName="PhoneNo" />
                <ScalarProperty Name="DeviceCode" ColumnName="DeviceCode" />
                <ScalarProperty Name="Address" ColumnName="Address" />
                <ScalarProperty Name="DeviceName" ColumnName="DeviceName" />
                <ScalarProperty Name="DeviceID" ColumnName="DeviceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EducationMasters">
            <EntityTypeMapping TypeName="ERPModel.EducationMaster">
              <MappingFragment StoreEntitySet="EducationMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="EducationName" ColumnName="EducationName" />
                <ScalarProperty Name="EducationID" ColumnName="EducationID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeAllowanceMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeeAllowanceMap">
              <MappingFragment StoreEntitySet="EmployeeAllowanceMap">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="AllowanceId" ColumnName="AllowanceId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeAllowanceMapID" ColumnName="EmployeeAllowanceMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeAttachments">
            <EntityTypeMapping TypeName="ERPModel.EmployeeAttachment">
              <MappingFragment StoreEntitySet="EmployeeAttachment">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="AttachmentName" ColumnName="AttachmentName" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeAttachmentMapID" ColumnName="EmployeeAttachmentMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeAttendances">
            <EntityTypeMapping TypeName="ERPModel.EmployeeAttendance">
              <MappingFragment StoreEntitySet="EmployeeAttendance">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Attendance" ColumnName="Attendance" />
                <ScalarProperty Name="AttendanceType" ColumnName="AttendanceType" />
                <ScalarProperty Name="OverTimeHours" ColumnName="OverTimeHours" />
                <ScalarProperty Name="WorkingHours" ColumnName="WorkingHours" />
                <ScalarProperty Name="TimeOut" ColumnName="TimeOut" />
                <ScalarProperty Name="TimeIn" ColumnName="TimeIn" />
                <ScalarProperty Name="AttendanceDate" ColumnName="AttendanceDate" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="FinancialYearId" ColumnName="FinancialYearId" />
                <ScalarProperty Name="EmployeeAttendanceID" ColumnName="EmployeeAttendanceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeAttendanceDevices">
            <EntityTypeMapping TypeName="ERPModel.EmployeeAttendanceDevice">
              <MappingFragment StoreEntitySet="EmployeeAttendanceDevice">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="LocationName" ColumnName="LocationName" />
                <ScalarProperty Name="Longitude" ColumnName="Longitude" />
                <ScalarProperty Name="Latitude" ColumnName="Latitude" />
                <ScalarProperty Name="PunchMethod" ColumnName="PunchMethod" />
                <ScalarProperty Name="PunchType" ColumnName="PunchType" />
                <ScalarProperty Name="VerifyMethod" ColumnName="VerifyMethod" />
                <ScalarProperty Name="PunchTime" ColumnName="PunchTime" />
                <ScalarProperty Name="AttendanceDateTime" ColumnName="AttendanceDateTime" />
                <ScalarProperty Name="AttendanceDate" ColumnName="AttendanceDate" />
                <ScalarProperty Name="EnrollNo" ColumnName="EnrollNo" />
                <ScalarProperty Name="ShiftId" ColumnName="ShiftId" />
                <ScalarProperty Name="DeviceId" ColumnName="DeviceId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeAttendanceID" ColumnName="EmployeeAttendanceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeDeductionMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeeDeductionMap">
              <MappingFragment StoreEntitySet="EmployeeDeductionMap">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="DeductionId" ColumnName="DeductionId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeDeductionMapID" ColumnName="EmployeeDeductionMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeDeviceMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeeDeviceMap">
              <MappingFragment StoreEntitySet="EmployeeDeviceMap">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="EnrollNo" ColumnName="EnrollNo" />
                <ScalarProperty Name="DeviceId" ColumnName="DeviceId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeDeviceID" ColumnName="EmployeeDeviceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeGradeMasters">
            <EntityTypeMapping TypeName="ERPModel.EmployeeGradeMaster">
              <MappingFragment StoreEntitySet="EmployeeGradeMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="EmployeeGrade" ColumnName="EmployeeGrade" />
                <ScalarProperty Name="EmployeeGradeID" ColumnName="EmployeeGradeID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeLeaveCategories">
            <EntityTypeMapping TypeName="ERPModel.EmployeeLeaveCategory">
              <MappingFragment StoreEntitySet="EmployeeLeaveCategory">
                <ScalarProperty Name="IsApprove" ColumnName="IsApprove" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="ApproveDate" ColumnName="ApproveDate" />
                <ScalarProperty Name="ApprovedBy" ColumnName="ApprovedBy" />
                <ScalarProperty Name="ApplyDate" ColumnName="ApplyDate" />
                <ScalarProperty Name="Comments" ColumnName="Comments" />
                <ScalarProperty Name="Reason" ColumnName="Reason" />
                <ScalarProperty Name="IsLastHalfDay" ColumnName="IsLastHalfDay" />
                <ScalarProperty Name="IsFirstHalfDay" ColumnName="IsFirstHalfDay" />
                <ScalarProperty Name="TotalDay" ColumnName="TotalDay" />
                <ScalarProperty Name="EndDate" ColumnName="EndDate" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="LeaveCategoryId" ColumnName="LeaveCategoryId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeLeaveCategoryMapID" ColumnName="EmployeeLeaveCategoryMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeLeaveMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeeLeaveMap">
              <MappingFragment StoreEntitySet="EmployeeLeaveMap">
                <ScalarProperty Name="LeaveCount" ColumnName="LeaveCount" />
                <ScalarProperty Name="LeaveId" ColumnName="LeaveId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeLeaveID" ColumnName="EmployeeLeaveID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeLoans">
            <EntityTypeMapping TypeName="ERPModel.EmployeeLoan">
              <MappingFragment StoreEntitySet="EmployeeLoan">
                <ScalarProperty Name="IsComplete" ColumnName="IsComplete" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="TotalMonths" ColumnName="TotalMonths" />
                <ScalarProperty Name="ApprovedBy" ColumnName="ApprovedBy" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="LoanTitle" ColumnName="LoanTitle" />
                <ScalarProperty Name="LoanDate" ColumnName="LoanDate" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeLoanMapID" ColumnName="EmployeeLoanMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeMasters">
            <EntityTypeMapping TypeName="ERPModel.EmployeeMaster">
              <MappingFragment StoreEntitySet="EmployeeMaster">
                <ScalarProperty Name="OverTimeAmount" ColumnName="OverTimeAmount" />
                <ScalarProperty Name="TotalLeaveCount" ColumnName="TotalLeaveCount" />
                <ScalarProperty Name="PANNo" ColumnName="PANNo" />
                <ScalarProperty Name="FaceTemplateData" ColumnName="FaceTemplateData" />
                <ScalarProperty Name="IsSend" ColumnName="IsSend" />
                <ScalarProperty Name="is_having_fingureprint" ColumnName="is_having_fingureprint" />
                <ScalarProperty Name="finger_template_data_bw9" ColumnName="finger_template_data_bw9" />
                <ScalarProperty Name="finger_template_data_bw8" ColumnName="finger_template_data_bw8" />
                <ScalarProperty Name="finger_template_data_bw7" ColumnName="finger_template_data_bw7" />
                <ScalarProperty Name="finger_template_data_bw6" ColumnName="finger_template_data_bw6" />
                <ScalarProperty Name="finger_template_data_bw5" ColumnName="finger_template_data_bw5" />
                <ScalarProperty Name="finger_template_data_bw4" ColumnName="finger_template_data_bw4" />
                <ScalarProperty Name="finger_template_data_bw3" ColumnName="finger_template_data_bw3" />
                <ScalarProperty Name="finger_template_data_bw2" ColumnName="finger_template_data_bw2" />
                <ScalarProperty Name="finger_template_data_bw1" ColumnName="finger_template_data_bw1" />
                <ScalarProperty Name="finger_template_data_tft9" ColumnName="finger_template_data_tft9" />
                <ScalarProperty Name="finger_template_data_tft8" ColumnName="finger_template_data_tft8" />
                <ScalarProperty Name="finger_template_data_tft7" ColumnName="finger_template_data_tft7" />
                <ScalarProperty Name="finger_template_data_tft6" ColumnName="finger_template_data_tft6" />
                <ScalarProperty Name="finger_template_data_tft5" ColumnName="finger_template_data_tft5" />
                <ScalarProperty Name="finger_template_data_tft4" ColumnName="finger_template_data_tft4" />
                <ScalarProperty Name="finger_template_data_tft3" ColumnName="finger_template_data_tft3" />
                <ScalarProperty Name="finger_template_data_tft2" ColumnName="finger_template_data_tft2" />
                <ScalarProperty Name="finger_template_data_tft1" ColumnName="finger_template_data_tft1" />
                <ScalarProperty Name="finger_template_data_tft" ColumnName="finger_template_data_tft" />
                <ScalarProperty Name="finger_template_data_bw" ColumnName="finger_template_data_bw" />
                <ScalarProperty Name="FingureTemplate" ColumnName="FingureTemplate" />
                <ScalarProperty Name="FaceLength" ColumnName="FaceLength" />
                <ScalarProperty Name="IsHavingFace" ColumnName="IsHavingFace" />
                <ScalarProperty Name="FaceTemplate" ColumnName="FaceTemplate" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Previlage" ColumnName="Previlage" />
                <ScalarProperty Name="LeaveDescription" ColumnName="LeaveDescription" />
                <ScalarProperty Name="LeaveDate" ColumnName="LeaveDate" />
                <ScalarProperty Name="IsLeave" ColumnName="IsLeave" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="AccountNo" ColumnName="AccountNo" />
                <ScalarProperty Name="AccountName" ColumnName="AccountName" />
                <ScalarProperty Name="BranchName" ColumnName="BranchName" />
                <ScalarProperty Name="BankName" ColumnName="BankName" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="EmployeeNo" ColumnName="EmployeeNo" />
                <ScalarProperty Name="JoinDate" ColumnName="JoinDate" />
                <ScalarProperty Name="PhoneNo" ColumnName="PhoneNo" />
                <ScalarProperty Name="MobileNo" ColumnName="MobileNo" />
                <ScalarProperty Name="PinCode" ColumnName="PinCode" />
                <ScalarProperty Name="Address" ColumnName="Address" />
                <ScalarProperty Name="City" ColumnName="City" />
                <ScalarProperty Name="StateId" ColumnName="StateId" />
                <ScalarProperty Name="CountryId" ColumnName="CountryId" />
                <ScalarProperty Name="PhotoName" ColumnName="PhotoName" />
                <ScalarProperty Name="MaratialStatus" ColumnName="MaratialStatus" />
                <ScalarProperty Name="Gender" ColumnName="Gender" />
                <ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="ShiftId" ColumnName="ShiftId" />
                <ScalarProperty Name="DesignationId" ColumnName="DesignationId" />
                <ScalarProperty Name="DepartmentId" ColumnName="DepartmentId" />
                <ScalarProperty Name="EmployeeGradeId" ColumnName="EmployeeGradeId" />
                <ScalarProperty Name="EmployeeTypeId" ColumnName="EmployeeTypeId" />
                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeePaidAllowanceMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeePaidAllowanceMap">
              <MappingFragment StoreEntitySet="EmployeePaidAllowanceMap">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="PaidAmount" ColumnName="PaidAmount" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="AllowanceId" ColumnName="AllowanceId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeePaidSalaryId" ColumnName="EmployeePaidSalaryId" />
                <ScalarProperty Name="EmployeePaidAllowanceMapID" ColumnName="EmployeePaidAllowanceMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeePaidDeductionMaps">
            <EntityTypeMapping TypeName="ERPModel.EmployeePaidDeductionMap">
              <MappingFragment StoreEntitySet="EmployeePaidDeductionMap">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="PaidAmount" ColumnName="PaidAmount" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="DeductionId" ColumnName="DeductionId" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeePaidSalaryId" ColumnName="EmployeePaidSalaryId" />
                <ScalarProperty Name="EmployeePaidDeductionMapID" ColumnName="EmployeePaidDeductionMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeePaidLoans">
            <EntityTypeMapping TypeName="ERPModel.EmployeePaidLoan">
              <MappingFragment StoreEntitySet="EmployeePaidLoan">
                <ScalarProperty Name="Year" ColumnName="Year" />
                <ScalarProperty Name="Month" ColumnName="Month" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="PaidDate" ColumnName="PaidDate" />
                <ScalarProperty Name="PaidAmount" ColumnName="PaidAmount" />
                <ScalarProperty Name="EmployeeLoanMapId" ColumnName="EmployeeLoanMapId" />
                <ScalarProperty Name="EmployeePaidLoanMapID" ColumnName="EmployeePaidLoanMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeePaidSalaries">
            <EntityTypeMapping TypeName="ERPModel.EmployeePaidSalary">
              <MappingFragment StoreEntitySet="EmployeePaidSalary">
                <ScalarProperty Name="SalaryToDate" ColumnName="SalaryToDate" />
                <ScalarProperty Name="SalaryFromDate" ColumnName="SalaryFromDate" />
                <ScalarProperty Name="ProfessionalTax" ColumnName="ProfessionalTax" />
                <ScalarProperty Name="TotalPresentDays" ColumnName="TotalPresentDays" />
                <ScalarProperty Name="FinancialYearId" ColumnName="FinancialYearId" />
                <ScalarProperty Name="IsPaid" ColumnName="IsPaid" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="PaidBy" ColumnName="PaidBy" />
                <ScalarProperty Name="PaidDate" ColumnName="PaidDate" />
                <ScalarProperty Name="PaidLoanAmount" ColumnName="PaidLoanAmount" />
                <ScalarProperty Name="TotalOverTimeAmount" ColumnName="TotalOverTimeAmount" />
                <ScalarProperty Name="TotalPaidLeaveAmount" ColumnName="TotalPaidLeaveAmount" />
                <ScalarProperty Name="TotalPaidLeave" ColumnName="TotalPaidLeave" />
                <ScalarProperty Name="TotalHoliday" ColumnName="TotalHoliday" />
                <ScalarProperty Name="TotalUseLeave" ColumnName="TotalUseLeave" />
                <ScalarProperty Name="AllowLeave" ColumnName="AllowLeave" />
                <ScalarProperty Name="TotalHours" ColumnName="TotalHours" />
                <ScalarProperty Name="TotalDays" ColumnName="TotalDays" />
                <ScalarProperty Name="TotalOverTimeHours" ColumnName="TotalOverTimeHours" />
                <ScalarProperty Name="TotalOverTimeDays" ColumnName="TotalOverTimeDays" />
                <ScalarProperty Name="Year" ColumnName="Year" />
                <ScalarProperty Name="Month" ColumnName="Month" />
                <ScalarProperty Name="PaidTotalSalary" ColumnName="PaidTotalSalary" />
                <ScalarProperty Name="PaidTotalDeduction" ColumnName="PaidTotalDeduction" />
                <ScalarProperty Name="PaidTotalEarning" ColumnName="PaidTotalEarning" />
                <ScalarProperty Name="PaidBasic" ColumnName="PaidBasic" />
                <ScalarProperty Name="TotalSalary" ColumnName="TotalSalary" />
                <ScalarProperty Name="TotalDeduction" ColumnName="TotalDeduction" />
                <ScalarProperty Name="TotalEarning" ColumnName="TotalEarning" />
                <ScalarProperty Name="Basic" ColumnName="Basic" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeePaidSalaryID" ColumnName="EmployeePaidSalaryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeSalaries">
            <EntityTypeMapping TypeName="ERPModel.EmployeeSalary">
              <MappingFragment StoreEntitySet="EmployeeSalary">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="SalaryType" ColumnName="SalaryType" />
                <ScalarProperty Name="TotalSalary" ColumnName="TotalSalary" />
                <ScalarProperty Name="TotalDeduction" ColumnName="TotalDeduction" />
                <ScalarProperty Name="TotalEarning" ColumnName="TotalEarning" />
                <ScalarProperty Name="Basic" ColumnName="Basic" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeSalaryID" ColumnName="EmployeeSalaryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeTypeMasters">
            <EntityTypeMapping TypeName="ERPModel.EmployeeTypeMaster">
              <MappingFragment StoreEntitySet="EmployeeTypeMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="NoOfLeavePerMonth" ColumnName="NoOfLeavePerMonth" />
                <ScalarProperty Name="EmployeeType" ColumnName="EmployeeType" />
                <ScalarProperty Name="EmployeeTypeID" ColumnName="EmployeeTypeID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeWorkingDays">
            <EntityTypeMapping TypeName="ERPModel.EmployeeWorkingDay">
              <MappingFragment StoreEntitySet="EmployeeWorkingDay">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="DayName" ColumnName="DayName" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="EmployeeWorkingDayMapID" ColumnName="EmployeeWorkingDayMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="FinancialYearMasters">
            <EntityTypeMapping TypeName="ERPModel.FinancialYearMaster">
              <MappingFragment StoreEntitySet="FinancialYearMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="FinancialYear" ColumnName="FinancialYear" />
                <ScalarProperty Name="Year" ColumnName="Year" />
                <ScalarProperty Name="FinancialYearID" ColumnName="FinancialYearID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Histories">
            <EntityTypeMapping TypeName="ERPModel.History">
              <MappingFragment StoreEntitySet="History">
                <ScalarProperty Name="IPAddress" ColumnName="IPAddress" />
                <ScalarProperty Name="XmlContent" ColumnName="XmlContent" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="UserId" ColumnName="UserId" />
                <ScalarProperty Name="OperationTypeId" ColumnName="OperationTypeId" />
                <ScalarProperty Name="TableTypeId" ColumnName="TableTypeId" />
                <ScalarProperty Name="TableId" ColumnName="TableId" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="HistoryID" ColumnName="HistoryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="HolidayMasters">
            <EntityTypeMapping TypeName="ERPModel.HolidayMaster">
              <MappingFragment StoreEntitySet="HolidayMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="EndDate" ColumnName="EndDate" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="HolidayID" ColumnName="HolidayID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="InterviewAttachments">
            <EntityTypeMapping TypeName="ERPModel.InterviewAttachment">
              <MappingFragment StoreEntitySet="InterviewAttachment">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="AttachmentType" ColumnName="AttachmentType" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="InterviewId" ColumnName="InterviewId" />
                <ScalarProperty Name="InterviewAttachmentMapID" ColumnName="InterviewAttachmentMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="InterviewMasters">
            <EntityTypeMapping TypeName="ERPModel.InterviewMaster">
              <MappingFragment StoreEntitySet="InterviewMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Reason" ColumnName="Reason" />
                <ScalarProperty Name="JoinDate" ColumnName="JoinDate" />
                <ScalarProperty Name="InterviewTime" ColumnName="InterviewTime" />
                <ScalarProperty Name="InterviewDate" ColumnName="InterviewDate" />
                <ScalarProperty Name="InterviewStatusId" ColumnName="InterviewStatusId" />
                <ScalarProperty Name="PersonalDetail" ColumnName="PersonalDetail" />
                <ScalarProperty Name="JoinAfterDaysOrMonth" ColumnName="JoinAfterDaysOrMonth" />
                <ScalarProperty Name="IsJoinDays" ColumnName="IsJoinDays" />
                <ScalarProperty Name="ExperienceMonth" ColumnName="ExperienceMonth" />
                <ScalarProperty Name="ExperienceYear" ColumnName="ExperienceYear" />
                <ScalarProperty Name="ExpectedSalary" ColumnName="ExpectedSalary" />
                <ScalarProperty Name="CurrentSalary" ColumnName="CurrentSalary" />
                <ScalarProperty Name="DesignationId" ColumnName="DesignationId" />
                <ScalarProperty Name="DepartmentId" ColumnName="DepartmentId" />
                <ScalarProperty Name="EducationId" ColumnName="EducationId" />
                <ScalarProperty Name="MobileNo" ColumnName="MobileNo" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="InterviewNo" ColumnName="InterviewNo" />
                <ScalarProperty Name="InterviewID" ColumnName="InterviewID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="InvoiceDetails">
            <EntityTypeMapping TypeName="ERPModel.InvoiceDetail">
              <MappingFragment StoreEntitySet="InvoiceDetail">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Amount" ColumnName="Amount" />
                <ScalarProperty Name="HourRate" ColumnName="HourRate" />
                <ScalarProperty Name="Hours" ColumnName="Hours" />
                <ScalarProperty Name="ItemDate" ColumnName="ItemDate" />
                <ScalarProperty Name="ItemDescription" ColumnName="ItemDescription" />
                <ScalarProperty Name="InvoiceId" ColumnName="InvoiceId" />
                <ScalarProperty Name="InvoiceDetailID" ColumnName="InvoiceDetailID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="InvoiceMasters">
            <EntityTypeMapping TypeName="ERPModel.InvoiceMaster">
              <MappingFragment StoreEntitySet="InvoiceMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="IsPaid" ColumnName="IsPaid" />
                <ScalarProperty Name="IsFixed" ColumnName="IsFixed" />
                <ScalarProperty Name="GrandTotalINR" ColumnName="GrandTotalINR" />
                <ScalarProperty Name="ServiceTaxINR" ColumnName="ServiceTaxINR" />
                <ScalarProperty Name="SubTotalINR" ColumnName="SubTotalINR" />
                <ScalarProperty Name="GrandTotal" ColumnName="GrandTotal" />
                <ScalarProperty Name="ServiceTax" ColumnName="ServiceTax" />
                <ScalarProperty Name="SubTotal" ColumnName="SubTotal" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="PartyAddress" ColumnName="PartyAddress" />
                <ScalarProperty Name="PartyName" ColumnName="PartyName" />
                <ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
                <ScalarProperty Name="InvoiceDate" ColumnName="InvoiceDate" />
                <ScalarProperty Name="InvoiceNo" ColumnName="InvoiceNo" />
                <ScalarProperty Name="InvoiceID" ColumnName="InvoiceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="IpInformations">
            <EntityTypeMapping TypeName="ERPModel.IpInformation">
              <MappingFragment StoreEntitySet="IpInformation">
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="DeviceType" ColumnName="DeviceType" />
                <ScalarProperty Name="BrowserName" ColumnName="BrowserName" />
                <ScalarProperty Name="DeviceName" ColumnName="DeviceName" />
                <ScalarProperty Name="IpAddress" ColumnName="IpAddress" />
                <ScalarProperty Name="Id" ColumnName="Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="LeaveCategoryMasters">
            <EntityTypeMapping TypeName="ERPModel.LeaveCategoryMaster">
              <MappingFragment StoreEntitySet="LeaveCategoryMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="LeaveCategory" ColumnName="LeaveCategory" />
                <ScalarProperty Name="LeaveCategoryID" ColumnName="LeaveCategoryID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="LicenseKeyMasters">
            <EntityTypeMapping TypeName="ERPModel.LicenseKeyMaster">
              <MappingFragment StoreEntitySet="LicenseKeyMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="IsUsed" ColumnName="IsUsed" />
                <ScalarProperty Name="KeyID" ColumnName="KeyID" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="LicenseKeyID" ColumnName="LicenseKeyID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ModuleMasters">
            <EntityTypeMapping TypeName="ERPModel.ModuleMaster">
              <MappingFragment StoreEntitySet="ModuleMaster">
                <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="TreeLevel" ColumnName="TreeLevel" />
                <ScalarProperty Name="ParentId" ColumnName="ParentId" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="EnumName" ColumnName="EnumName" />
                <ScalarProperty Name="ModuleID" ColumnName="ModuleID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RoleMasters">
            <EntityTypeMapping TypeName="ERPModel.RoleMaster">
              <MappingFragment StoreEntitySet="RoleMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="RoleName" ColumnName="RoleName" />
                <ScalarProperty Name="RoleID" ColumnName="RoleID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ShiftMasters">
            <EntityTypeMapping TypeName="ERPModel.ShiftMaster">
              <MappingFragment StoreEntitySet="ShiftMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="ToTime" ColumnName="ToTime" />
                <ScalarProperty Name="FromTime" ColumnName="FromTime" />
                <ScalarProperty Name="Shift" ColumnName="Shift" />
                <ScalarProperty Name="ShiftID" ColumnName="ShiftID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="StateMasters">
            <EntityTypeMapping TypeName="ERPModel.StateMaster">
              <MappingFragment StoreEntitySet="StateMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="StateName" ColumnName="StateName" />
                <ScalarProperty Name="CountryId" ColumnName="CountryId" />
                <ScalarProperty Name="StateID" ColumnName="StateID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserMasters">
            <EntityTypeMapping TypeName="ERPModel.UserMaster">
              <MappingFragment StoreEntitySet="UserMaster">
                <ScalarProperty Name="IsActive" ColumnName="IsActive" />
                <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                <ScalarProperty Name="ModifiedBy" ColumnName="ModifiedBy" />
                <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="Token" ColumnName="Token" />
                <ScalarProperty Name="LastLogin" ColumnName="LastLogin" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Username" ColumnName="Username" />
                <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
                <ScalarProperty Name="RoleId" ColumnName="RoleId" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserModuleMaps">
            <EntityTypeMapping TypeName="ERPModel.UserModuleMap">
              <MappingFragment StoreEntitySet="UserModuleMap">
                <ScalarProperty Name="ModuleId" ColumnName="ModuleId" />
                <ScalarProperty Name="UserId" ColumnName="UserId" />
                <ScalarProperty Name="UserModuleMapID" ColumnName="UserModuleMapID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="GlobalSettings">
            <EntityTypeMapping TypeName="ERPModel.GlobalSetting">
              <MappingFragment StoreEntitySet="GlobalSetting">
                <ScalarProperty Name="GlobalSettingValue" ColumnName="GlobalSettingValue" />
                <ScalarProperty Name="GlobalSettingEnum" ColumnName="GlobalSettingEnum" />
                <ScalarProperty Name="GlobalSettingName" ColumnName="GlobalSettingName" />
                <ScalarProperty Name="GlobalSettingId" ColumnName="GlobalSettingId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>