<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:Reference Uri="https://sap.github.io/odata-vocabularies/vocabularies/Common.xml">
    <edmx:Include Alias="Common" Namespace="com.sap.vocabularies.Common.v1"/>
  </edmx:Reference>
  <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Core.V1.xml">
    <edmx:Include Alias="Core" Namespace="Org.OData.Core.V1"/>
  </edmx:Reference>
  <edmx:DataServices>
    <Schema Namespace="AdminService" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="EntityContainer">
        <EntitySet Name="Roles" EntityType="AdminService.Roles"/>
        <EntitySet Name="UserRoleMappings" EntityType="AdminService.UserRoleMappings"/>
        <EntitySet Name="Users" EntityType="AdminService.Users">
          <NavigationPropertyBinding Path="sbuId" Target="SBUs"/>
          <NavigationPropertyBinding Path="costCenterId" Target="CostCenters"/>
          <NavigationPropertyBinding Path="departmentId" Target="Departments"/>
          <NavigationPropertyBinding Path="divisionId" Target="Divisions"/>
          <NavigationPropertyBinding Path="designationId" Target="Designations"/>
          <NavigationPropertyBinding Path="gradeId" Target="Grades"/>
          <NavigationPropertyBinding Path="companyId" Target="Company"/>
          <NavigationPropertyBinding Path="orgLevel1" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="orgLevel2" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="orgLevel3" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="orgLevel4" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="orgLevel5" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="orgLevel6" Target="OrgHierarchyNodes"/>
          <NavigationPropertyBinding Path="ledgerId" Target="AccountingLedgers"/>
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="currencyId" Target="Currencies"/>
          <NavigationPropertyBinding Path="countryId" Target="Countries"/>
          <NavigationPropertyBinding Path="dependents" Target="UserDependents"/>
        </EntitySet>
        <EntitySet Name="Departments" EntityType="AdminService.Departments"/>
        <EntitySet Name="SBUs" EntityType="AdminService.SBUs"/>
        <EntitySet Name="CostCenters" EntityType="AdminService.CostCenters"/>
        <EntitySet Name="Divisions" EntityType="AdminService.Divisions"/>
        <EntitySet Name="Grades" EntityType="AdminService.Grades"/>
        <EntitySet Name="Designations" EntityType="AdminService.Designations"/>
        <EntitySet Name="Airports" EntityType="AdminService.Airports"/>
        <EntitySet Name="OrgHierarchyNodes" EntityType="AdminService.OrgHierarchyNodes"/>
        <EntitySet Name="Companies" EntityType="AdminService.Companies"/>
        <EntitySet Name="AccountingLedgers" EntityType="AdminService.AccountingLedgers"/>
        <EntitySet Name="GLCodeMappings" EntityType="AdminService.GLCodeMappings">
          <NavigationPropertyBinding Path="ledger" Target="AccountingLedgers"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="expenseType" Target="ExpenseTypes"/>
        </EntitySet>
        <EntitySet Name="Policies" EntityType="AdminService.Policies">
          <NavigationPropertyBinding Path="approvers" Target="RequestApproverLevel"/>
        </EntitySet>
        <EntitySet Name="TravelRequestEntries" EntityType="AdminService.TravelRequestEntries">
          <NavigationPropertyBinding Path="userId" Target="Users"/>
          <NavigationPropertyBinding Path="approverId" Target="Users"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
        </EntitySet>
        <EntitySet Name="ExpenseTypesExpense" EntityType="AdminService.ExpenseTypesExpense"/>
        <EntitySet Name="RequestGroupPolicyMapping" EntityType="AdminService.RequestGroupPolicyMapping">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="group" Target="Groups"/>
        </EntitySet>
        <EntitySet Name="ExpenseGroupPolicyMapping" EntityType="AdminService.ExpenseGroupPolicyMapping">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="group" Target="Groups"/>
        </EntitySet>
        <EntitySet Name="Groups" EntityType="AdminService.Groups"/>
        <EntitySet Name="RequestApproverLevel" EntityType="AdminService.RequestApproverLevel"/>
        <EntitySet Name="ExpenseApproverLevel" EntityType="AdminService.ExpenseApproverLevel"/>
        <EntitySet Name="ExpensePolicies" EntityType="AdminService.ExpensePolicies"/>
        <EntitySet Name="RequestExpenseTypes" EntityType="AdminService.RequestExpenseTypes"/>
        <EntitySet Name="ExpenseTypes" EntityType="AdminService.ExpenseTypes"/>
        <EntitySet Name="Currencies" EntityType="AdminService.Currencies"/>
        <EntitySet Name="Countries" EntityType="AdminService.Countries"/>
        <EntitySet Name="Cities" EntityType="AdminService.Cities">
          <NavigationPropertyBinding Path="country" Target="Countries"/>
        </EntitySet>
        <EntitySet Name="AllCities" EntityType="AdminService.AllCities"/>
        <EntitySet Name="Locations" EntityType="AdminService.Locations"/>
        <EntitySet Name="Company" EntityType="AdminService.Company"/>
        <EntitySet Name="RequestEmployeeApproverMappings" EntityType="AdminService.RequestEmployeeApproverMappings">
          <NavigationPropertyBinding Path="user" Target="Users"/>
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="approverLevel" Target="RequestApproverLevel"/>
          <NavigationPropertyBinding Path="approver" Target="Users"/>
        </EntitySet>
        <EntitySet Name="ExpenseEmployeeApproverMappings" EntityType="AdminService.ExpenseEmployeeApproverMappings">
          <NavigationPropertyBinding Path="user" Target="Users"/>
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
          <NavigationPropertyBinding Path="approverLevel" Target="ExpenseApproverLevel"/>
          <NavigationPropertyBinding Path="approver" Target="Users"/>
        </EntitySet>
        <EntitySet Name="RequestPolicyApproverLevel" EntityType="AdminService.RequestPolicyApproverLevel">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="approverLevel" Target="RequestApproverLevel"/>
        </EntitySet>
        <EntitySet Name="ExpensePolicyApproverLevel" EntityType="AdminService.ExpensePolicyApproverLevel">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="approverLevel" Target="ExpenseApproverLevel"/>
        </EntitySet>
        <EntitySet Name="RequestTravelAllowance" EntityType="AdminService.RequestTravelAllowance"/>
        <EntitySet Name="ExpenseTravelAllowance" EntityType="AdminService.ExpenseTravelAllowance"/>
        <EntitySet Name="PerDayAllowance" EntityType="AdminService.PerDayAllowance">
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
        </EntitySet>
        <EntitySet Name="FuelAllowance" EntityType="AdminService.FuelAllowance">
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
          <NavigationPropertyBinding Path="currency" Target="Currencies"/>
        </EntitySet>
        <EntitySet Name="SystemSettings" EntityType="AdminService.SystemSettings"/>
        <EntitySet Name="ValidationErrors" EntityType="AdminService.ValidationErrors"/>
        <EntitySet Name="UserDependents" EntityType="AdminService.UserDependents">
          <NavigationPropertyBinding Path="user" Target="Users"/>
        </EntitySet>
        <ActionImport Name="saveOrUpdateRequestApproverMapping" Action="AdminService.saveOrUpdateRequestApproverMapping" EntitySet="RequestEmployeeApproverMappings"/>
        <ActionImport Name="deleteRequestApproverMapping" Action="AdminService.deleteRequestApproverMapping"/>
        <ActionImport Name="saveOrUpdateExpenseApproverMapping" Action="AdminService.saveOrUpdateExpenseApproverMapping" EntitySet="ExpenseEmployeeApproverMappings"/>
        <ActionImport Name="deleteExpenseApproverMapping" Action="AdminService.deleteExpenseApproverMapping"/>
        <ActionImport Name="searchAirports" Action="AdminService.searchAirports"/>
        <ActionImport Name="initializeMasterData" Action="AdminService.initializeMasterData"/>
        <ActionImport Name="uploadOrgData" Action="AdminService.uploadOrgData"/>
        <ActionImport Name="uploadParsedExcel" Action="AdminService.uploadParsedExcel"/>
        <ActionImport Name="uploadParsedUserExcel" Action="AdminService.uploadParsedUserExcel"/>
        <ActionImport Name="getViolationsByMonth" Action="AdminService.getViolationsByMonth"/>
        <ActionImport Name="getTotalWarningPercentage" Action="AdminService.getTotalWarningPercentage"/>
        <ActionImport Name="getTravelRequestEntries" Action="AdminService.getTravelRequestEntries"/>
        <ActionImport Name="getActiveInactiveUsers" Action="AdminService.getActiveInactiveUsers"/>
        <ActionImport Name="getAmountByMonth" Action="AdminService.getAmountByMonth"/>
        <ActionImport Name="getUserDetails" Action="AdminService.getUserDetails"/>
        <ActionImport Name="updateGroupName" Action="AdminService.updateGroupName"/>
        <ActionImport Name="deleteGroup" Action="AdminService.deleteGroup"/>
        <ActionImport Name="getCityNameById" Action="AdminService.getCityNameById"/>
        <ActionImport Name="listOrgHierarchyChildren" Action="AdminService.listOrgHierarchyChildren" EntitySet="OrgHierarchyNodes"/>
        <ActionImport Name="syncDepartmentsFromSAP" Action="AdminService.syncDepartmentsFromSAP"/>
        <ActionImport Name="syncSBUsFromSAP" Action="AdminService.syncSBUsFromSAP"/>
        <ActionImport Name="syncCostCentersFromSAP" Action="AdminService.syncCostCentersFromSAP"/>
        <ActionImport Name="syncDivisionsFromSAP" Action="AdminService.syncDivisionsFromSAP"/>
        <ActionImport Name="syncLocationsFromSAP" Action="AdminService.syncLocationsFromSAP"/>
        <ActionImport Name="syncCompaniesFromSAP" Action="AdminService.syncCompaniesFromSAP"/>
        <ActionImport Name="syncGradesFromSAP" Action="AdminService.syncGradesFromSAP"/>
        <ActionImport Name="syncUsersFromSAP" Action="AdminService.syncUsersFromSAP"/>
      </EntityContainer>
      <EntityType Name="Roles">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="UserRoleMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="userId" Type="Edm.Guid"/>
        <Property Name="roleId" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Users">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="username" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="password" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="firstName" Type="Edm.String" MaxLength="32"/>
        <Property Name="middleName" Type="Edm.String" MaxLength="32"/>
        <Property Name="lastName" Type="Edm.String" MaxLength="32"/>
        <Property Name="employeeId" Type="Edm.String" MaxLength="48"/>
        <Property Name="position" Type="Edm.String" MaxLength="100"/>
        <Property Name="managerId" Type="Edm.String" MaxLength="100"/>
        <Property Name="managerName" Type="Edm.String" MaxLength="100"/>
        <Property Name="email" Type="Edm.String" MaxLength="255"/>
        <Property Name="passportNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="passportExpiryDate" Type="Edm.Date"/>
        <Property Name="aadharNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="is_active" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="isTestUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="expenseUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="expenseApprover" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="requestUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="requestApprover" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="autoApproval" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="oneLevelApproval" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="mustChangePassword" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="passwordResetToken" Type="Edm.String" MaxLength="255"/>
        <Property Name="passwordResetExpiry" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="cashAdvanceAccountCode" Type="Edm.String" MaxLength="20"/>
        <Property Name="vendorId" Type="Edm.String" MaxLength="20"/>
        <NavigationProperty Name="sbuId" Type="AdminService.SBUs">
          <ReferentialConstraint Property="sbuId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="sbuId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="costCenterId" Type="AdminService.CostCenters">
          <ReferentialConstraint Property="costCenterId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="costCenterId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="departmentId" Type="AdminService.Departments">
          <ReferentialConstraint Property="departmentId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="departmentId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="divisionId" Type="AdminService.Divisions">
          <ReferentialConstraint Property="divisionId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="divisionId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="designationId" Type="AdminService.Designations">
          <ReferentialConstraint Property="designationId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="designationId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="gradeId" Type="AdminService.Grades">
          <ReferentialConstraint Property="gradeId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="gradeId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="companyId" Type="AdminService.Company">
          <ReferentialConstraint Property="companyId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="companyId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel1" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel1_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel1_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel2" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel2_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel2_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel3" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel3_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel3_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel4" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel4_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel4_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel5" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel5_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel5_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="orgLevel6" Type="AdminService.OrgHierarchyNodes">
          <ReferentialConstraint Property="orgLevel6_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="orgLevel6_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="ledgerId" Type="AdminService.AccountingLedgers">
          <ReferentialConstraint Property="ledgerId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="ledgerId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="currencyId" Type="AdminService.Currencies">
          <ReferentialConstraint Property="currencyId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="currencyId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="countryId" Type="AdminService.Countries">
          <ReferentialConstraint Property="countryId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="countryId_ID" Type="Edm.Int32"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <NavigationProperty Name="dependents" Type="Collection(AdminService.UserDependents)" Partner="user">
          <OnDelete Action="Cascade"/>
        </NavigationProperty>
      </EntityType>
      <EntityType Name="Departments">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="SBUs">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="CostCenters">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="costcenterManager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="Divisions">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="Grades">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="Designations">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="Airports">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="iataCode" Type="Edm.String" MaxLength="3"/>
        <Property Name="airportName" Type="Edm.String" MaxLength="255"/>
        <Property Name="city" Type="Edm.String" MaxLength="255"/>
        <Property Name="country" Type="Edm.String" MaxLength="255"/>
        <Property Name="active" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="searchVector" Type="Edm.String"/>
      </EntityType>
      <EntityType Name="OrgHierarchyNodes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="level_id" Type="Edm.Int32"/>
        <Property Name="parent_id" Type="Edm.Guid"/>
        <Property Name="company_id" Type="Edm.Guid"/>
        <Property Name="is_active" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <EntityType Name="Companies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
      </EntityType>
      <EntityType Name="AccountingLedgers">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="GLCodeMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="gl_code" Type="Edm.String" MaxLength="50"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <NavigationProperty Name="ledger" Type="AdminService.AccountingLedgers">
          <ReferentialConstraint Property="ledger_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="ledger_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="expenseType" Type="AdminService.ExpenseTypes">
          <ReferentialConstraint Property="expenseType_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseType_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Policies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="isInternationalPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <NavigationProperty Name="approvers" Type="Collection(AdminService.RequestApproverLevel)"/>
        <Property Name="approvers_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="TravelRequestEntries">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="reply_comments" Type="Edm.String"/>
        <Property Name="reject_comments" Type="Edm.String"/>
        <Property Name="comments" Type="Edm.String"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="status" Type="Edm.String" MaxLength="50" DefaultValue="Pending"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <NavigationProperty Name="userId" Type="AdminService.Users">
          <ReferentialConstraint Property="userId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="userId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverId" Type="AdminService.Users">
          <ReferentialConstraint Property="approverId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="warnings" Type="Edm.String" MaxLength="1000"/>
        <Property Name="isEscalated" Type="Edm.Boolean"/>
        <Property Name="file_path" Type="Edm.String" MaxLength="2000"/>
        <Property Name="castatus" Type="Edm.String" MaxLength="50"/>
        <Property Name="sap_sent" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="sap_sent_date" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="sap_batch_id" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="ExpenseTypesExpense">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="category_ID" Type="Edm.Guid"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="RequestGroupPolicyMapping">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="ExpenseGroupPolicyMapping">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Groups">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="RequestApproverLevel">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="approverLevel" Type="Edm.String" MaxLength="100"/>
        <Property Name="approverRoleName" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="ExpenseApproverLevel">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="approverLevel" Type="Edm.String" MaxLength="100"/>
        <Property Name="approverRoleName" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="ExpensePolicies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="isInternationalPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="isNonTravelPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isIntracityPolicy" Type="Edm.Boolean" DefaultValue="false"/>
      </EntityType>
      <EntityType Name="RequestExpenseTypes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="category_ID" Type="Edm.Guid"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="ExpenseTypes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="isNonTravelPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isIntracityPolicy" Type="Edm.Boolean" DefaultValue="false"/>
      </EntityType>
      <EntityType Name="Currencies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="currency_code" Type="Edm.String" MaxLength="100"/>
        <Property Name="currency_name" Type="Edm.String" MaxLength="255"/>
      </EntityType>
      <EntityType Name="Countries">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="10"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="Cities">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="city" Type="Edm.String" MaxLength="255"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="10"/>
        <NavigationProperty Name="country" Type="AdminService.Countries">
          <ReferentialConstraint Property="country_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="country_ID" Type="Edm.Int32"/>
      </EntityType>
      <EntityType Name="AllCities">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="255"/>
        <Property Name="country" Type="Edm.String" MaxLength="255"/>
      </EntityType>
      <EntityType Name="Locations">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="Company">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="manager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="RequestEmployeeApproverMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="AdminService.Users">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverLevel" Type="AdminService.RequestApproverLevel">
          <ReferentialConstraint Property="approverLevel_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approver" Type="AdminService.Users">
          <ReferentialConstraint Property="approver_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approver_ID" Type="Edm.Guid"/>
        <Property Name="order" Type="Edm.Int32"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="ExpenseEmployeeApproverMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="AdminService.Users">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverLevel" Type="AdminService.ExpenseApproverLevel">
          <ReferentialConstraint Property="approverLevel_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approver" Type="AdminService.Users">
          <ReferentialConstraint Property="approver_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approver_ID" Type="Edm.Guid"/>
        <Property Name="order" Type="Edm.Int32"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="RequestPolicyApproverLevel">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverLevel" Type="AdminService.RequestApproverLevel">
          <ReferentialConstraint Property="approverLevel_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="ExpensePolicyApproverLevel">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="AdminService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverLevel" Type="AdminService.ExpenseApproverLevel">
          <ReferentialConstraint Property="approverLevel_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="RequestTravelAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="travelAllowanceName" Type="Edm.String"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="expenseTypes" Type="Edm.String"/>
      </EntityType>
      <EntityType Name="ExpenseTravelAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="travelAllowanceName" Type="Edm.String"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="expenseTypes" Type="Edm.String"/>
      </EntityType>
      <EntityType Name="PerDayAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="PerDayAllowanceName" Type="Edm.String"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="FuelAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="FuelAllowanceName" Type="Edm.String"/>
        <NavigationProperty Name="group" Type="AdminService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="AdminService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="currency" Type="AdminService.Currencies">
          <ReferentialConstraint Property="currency_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="currency_ID" Type="Edm.Guid"/>
        <Property Name="vehicleType" Type="Edm.String"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="SystemSettings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="setting_key" Type="Edm.String" MaxLength="50" Nullable="false"/>
        <Property Name="value" Type="Edm.String" MaxLength="255"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="ValidationErrors">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="errorType" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="errorCount" Type="Edm.Int32" Nullable="false"/>
        <Property Name="totalRecords" Type="Edm.Int32" Nullable="false"/>
        <Property Name="errorDetails" Type="Edm.String"/>
        <Property Name="errorSummary" Type="Edm.String" MaxLength="500"/>
        <Property Name="syncType" Type="Edm.String" MaxLength="20"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="resolved" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="promoted" Type="Edm.Int32"/>
      </EntityType>
      <EntityType Name="UserDependents">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="AdminService.Users" Partner="dependents">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="relation" Type="Edm.String" MaxLength="50"/>
        <Property Name="passportNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="passportExpiryDate" Type="Edm.Date"/>
        <Property Name="aadharNumber" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <ComplexType Name="return_AdminService_searchAirports">
        <Property Name="iatacode" Type="Edm.String" MaxLength="3"/>
        <Property Name="airportname" Type="Edm.String" MaxLength="255"/>
        <Property Name="city" Type="Edm.String" MaxLength="255"/>
        <Property Name="country" Type="Edm.String" MaxLength="255"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_uploadParsedUserExcel">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="duplicates" Type="Collection(AdminService.return_AdminService_uploadParsedUserExcel_duplicates)" Nullable="false"/>
        <Property Name="validationErrors" Type="Collection(AdminService.return_AdminService_uploadParsedUserExcel_validationErrors)" Nullable="false"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="managersPromoted" Type="Edm.Int32"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_uploadParsedUserExcel_duplicates">
        <Property Name="field" Type="Edm.String"/>
        <Property Name="value" Type="Edm.String"/>
        <Property Name="rows" Type="Collection(Edm.Int32)" Nullable="false"/>
        <Property Name="usernames" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_uploadParsedUserExcel_validationErrors">
        <Property Name="row" Type="Edm.Int32"/>
        <Property Name="username" Type="Edm.String"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getViolationsByMonth">
        <Property Name="month" Type="Edm.String" MaxLength="3"/>
        <Property Name="violations" Type="Edm.Int32"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getTotalWarningPercentage">
        <Property Name="totalWarningPercentage" Type="Edm.Decimal" Precision="5" Scale="2"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getTravelRequestEntries">
        <Property Name="totalRequests" Type="Edm.Int32"/>
        <Property Name="submittedRequests" Type="Edm.Int32"/>
        <Property Name="dateRange" Type="AdminService.return_AdminService_getTravelRequestEntries_dateRange"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getTravelRequestEntries_dateRange">
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveInactiveUsers">
        <Property Name="activeCount" Type="Edm.Int32"/>
        <Property Name="inactiveCount" Type="Edm.Int32"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getAmountByMonth">
        <Property Name="month" Type="Edm.String" MaxLength="3"/>
        <Property Name="amount" Type="Edm.Int32"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getUserDetails">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="username" Type="Edm.String"/>
        <Property Name="sbu" Type="Edm.String"/>
        <Property Name="costCenter" Type="Edm.String"/>
        <Property Name="department" Type="Edm.String"/>
        <Property Name="designation" Type="Edm.String"/>
        <Property Name="grade" Type="Edm.String"/>
        <Property Name="orgLevel1" Type="Edm.String"/>
        <Property Name="orgLevel2" Type="Edm.String"/>
        <Property Name="orgLevel3" Type="Edm.String"/>
        <Property Name="orgLevel4" Type="Edm.String"/>
        <Property Name="ledger" Type="Edm.String"/>
        <Property Name="group" Type="Edm.String"/>
        <Property Name="currency" Type="Edm.String"/>
        <Property Name="country" Type="Edm.String"/>
        <Property Name="email" Type="Edm.String"/>
        <Property Name="firstName" Type="Edm.String"/>
        <Property Name="lastName" Type="Edm.String"/>
        <Property Name="position" Type="Edm.String"/>
        <Property Name="managerName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getCityNameById">
        <Property Name="cityName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncDepartmentsFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncSBUsFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncCostCentersFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncDivisionsFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncLocationsFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncCompaniesFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncGradesFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncUsersFromSAP">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="syncType" Type="Edm.String"/>
        <Property Name="inserted" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="promotedToApprover" Type="Edm.Int32"/>
        <Property Name="groupsCreated" Type="Edm.Int32"/>
        <Property Name="groupsUpdated" Type="Edm.Int32"/>
        <Property Name="fixedMismatches" Type="Edm.Int32"/>
        <Property Name="deactivatedCount" Type="Edm.Int32"/>
        <Property Name="usersProcessed" Type="Edm.Int32"/>
        <Property Name="uniqueCountriesFound" Type="Edm.Int32"/>
        <Property Name="managerIdsFound" Type="Edm.Int32"/>
        <Property Name="emergencyFixes" Type="Edm.Int32"/>
        <Property Name="lastSyncTimestamp" Type="Edm.String"/>
        <Property Name="deltaDate" Type="Edm.String"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="false"/>
        <Property Name="countryDistribution" Type="Collection(AdminService.return_AdminService_syncUsersFromSAP_countryDistribution)" Nullable="false"/>
        <Property Name="roleDistribution" Type="Collection(AdminService.return_AdminService_syncUsersFromSAP_roleDistribution)" Nullable="false"/>
        <Property Name="usersWithChanges" Type="Edm.Int32"/>
        <Property Name="totalFieldChanges" Type="Edm.Int32"/>
        <Property Name="changeLog" Type="Collection(AdminService.return_AdminService_syncUsersFromSAP_changeLog)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncUsersFromSAP_countryDistribution">
        <Property Name="country" Type="Edm.String"/>
        <Property Name="userCount" Type="Edm.Int32"/>
        <Property Name="groupName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncUsersFromSAP_roleDistribution">
        <Property Name="roleId" Type="Edm.Guid"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncUsersFromSAP_changeLog">
        <Property Name="userId" Type="Edm.String"/>
        <Property Name="employeeId" Type="Edm.String"/>
        <Property Name="fullName" Type="Edm.String"/>
        <Property Name="changesCount" Type="Edm.Int32"/>
        <Property Name="changes" Type="Collection(AdminService.return_AdminService_syncUsersFromSAP_changeLog_changes)" Nullable="false"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_syncUsersFromSAP_changeLog_changes">
        <Property Name="field" Type="Edm.String"/>
        <Property Name="oldValue" Type="Edm.String"/>
        <Property Name="newValue" Type="Edm.String"/>
      </ComplexType>
      <Action Name="saveOrUpdateRequestApproverMapping" IsBound="false">
        <Parameter Name="data" Type="Collection(AdminService.RequestEmployeeApproverMappings)" Nullable="false"/>
        <ReturnType Type="Collection(AdminService.RequestEmployeeApproverMappings)"/>
      </Action>
      <Action Name="deleteRequestApproverMapping" IsBound="false">
        <Parameter Name="user_ID" Type="Edm.Guid"/>
        <Parameter Name="policy_ID" Type="Edm.Guid"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="saveOrUpdateExpenseApproverMapping" IsBound="false">
        <Parameter Name="data" Type="Collection(AdminService.ExpenseEmployeeApproverMappings)" Nullable="false"/>
        <ReturnType Type="Collection(AdminService.ExpenseEmployeeApproverMappings)"/>
      </Action>
      <Action Name="deleteExpenseApproverMapping" IsBound="false">
        <Parameter Name="user_ID" Type="Edm.Guid"/>
        <Parameter Name="policy_ID" Type="Edm.Guid"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="searchAirports" IsBound="false">
        <Parameter Name="query" Type="Edm.String"/>
        <ReturnType Type="Collection(AdminService.return_AdminService_searchAirports)" Nullable="false"/>
      </Action>
      <Action Name="initializeMasterData" IsBound="false">
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="uploadOrgData" IsBound="false">
        <Parameter Name="file" Type="Edm.Binary"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="uploadParsedExcel" IsBound="false">
        <Parameter Name="file" Type="Edm.String"/>
        <Parameter Name="uploadType" Type="Edm.String"/>
      </Action>
      <Action Name="uploadParsedUserExcel" IsBound="false">
        <Parameter Name="file" Type="Edm.String"/>
        <ReturnType Type="AdminService.return_AdminService_uploadParsedUserExcel"/>
      </Action>
      <Action Name="getViolationsByMonth" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getViolationsByMonth)" Nullable="false"/>
      </Action>
      <Action Name="getTotalWarningPercentage" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_getTotalWarningPercentage"/>
      </Action>
      <Action Name="getTravelRequestEntries" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_getTravelRequestEntries"/>
      </Action>
      <Action Name="getActiveInactiveUsers" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_getActiveInactiveUsers"/>
      </Action>
      <Action Name="getAmountByMonth" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getAmountByMonth)" Nullable="false"/>
      </Action>
      <Action Name="getUserDetails" IsBound="false">
        <Parameter Name="userId" Type="Edm.Guid"/>
        <ReturnType Type="AdminService.return_AdminService_getUserDetails"/>
      </Action>
      <Action Name="updateGroupName" IsBound="false">
        <Parameter Name="groupId" Type="Edm.Guid"/>
        <Parameter Name="newName" Type="Edm.String"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="deleteGroup" IsBound="false">
        <Parameter Name="groupId" Type="Edm.Guid"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="getCityNameById" IsBound="false">
        <Parameter Name="cityId" Type="Edm.Guid"/>
        <ReturnType Type="AdminService.return_AdminService_getCityNameById"/>
      </Action>
      <Action Name="listOrgHierarchyChildren" IsBound="false">
        <Parameter Name="parentId" Type="Edm.Guid"/>
        <Parameter Name="companyId" Type="Edm.Guid"/>
        <ReturnType Type="Collection(AdminService.OrgHierarchyNodes)"/>
      </Action>
      <Action Name="syncDepartmentsFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncDepartmentsFromSAP"/>
      </Action>
      <Action Name="syncSBUsFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncSBUsFromSAP"/>
      </Action>
      <Action Name="syncCostCentersFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncCostCentersFromSAP"/>
      </Action>
      <Action Name="syncDivisionsFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncDivisionsFromSAP"/>
      </Action>
      <Action Name="syncLocationsFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncLocationsFromSAP"/>
      </Action>
      <Action Name="syncCompaniesFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncCompaniesFromSAP"/>
      </Action>
      <Action Name="syncGradesFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncGradesFromSAP"/>
      </Action>
      <Action Name="syncUsersFromSAP" IsBound="false">
        <ReturnType Type="AdminService.return_AdminService_syncUsersFromSAP"/>
      </Action>
      <Annotations Target="AdminService.Roles/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Users/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Departments/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.SBUs/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.CostCenters/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Divisions/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Grades/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Designations/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Airports/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.OrgHierarchyNodes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Companies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.AccountingLedgers/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.GLCodeMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Policies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.TravelRequestEntries/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseTypesExpense/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestGroupPolicyMapping/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseGroupPolicyMapping/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Groups/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestApproverLevel/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseApproverLevel/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpensePolicies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestExpenseTypes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseTypes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Currencies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.AllCities/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Locations/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Company/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestEmployeeApproverMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseEmployeeApproverMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestPolicyApproverLevel/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpensePolicyApproverLevel/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.RequestTravelAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ExpenseTravelAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.PerDayAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.FuelAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.SystemSettings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.ValidationErrors/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.UserDependents/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>