<?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:Reference Uri="https://sap.github.io/odata-vocabularies/vocabularies/UI.xml">
    <edmx:Include Alias="UI" Namespace="com.sap.vocabularies.UI.v1"/>
  </edmx:Reference>
  <edmx:DataServices>
    <Schema Namespace="AdminService" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <Annotation Term="Core.Links">
        <Collection>
          <Record>
            <PropertyValue Property="rel" String="author"/>
            <PropertyValue Property="href" String="https://cap.cloud.sap"/>
          </Record>
        </Collection>
      </Annotation>
      <EntityContainer Name="EntityContainer">
        <EntitySet Name="Users" EntityType="AdminService.Users">
          <NavigationPropertyBinding Path="roleMapping" Target="UserRoleMapping"/>
        </EntitySet>
        <EntitySet Name="UserRoleMapping" EntityType="AdminService.UserRoleMapping">
          <NavigationPropertyBinding Path="user" Target="Users"/>
          <NavigationPropertyBinding Path="role" Target="Roles"/>
        </EntitySet>
        <EntitySet Name="Roles" EntityType="AdminService.Roles">
          <NavigationPropertyBinding Path="userMappings" Target="UserRoleMapping"/>
        </EntitySet>
        <EntitySet Name="Agencies" EntityType="AdminService.Agencies">
          <NavigationPropertyBinding Path="country" Target="Countries"/>
        </EntitySet>
        <EntitySet Name="Countries" EntityType="AdminService.Countries"/>
        <EntitySet Name="Professions" EntityType="AdminService.Professions"/>
        <EntitySet Name="SceCodes" EntityType="AdminService.SceCodes"/>
        <EntitySet Name="DriverProfessions" EntityType="AdminService.DriverProfessions"/>
        <EntitySet Name="VisaQuotaMaster" EntityType="AdminService.VisaQuotaMaster">
          <NavigationPropertyBinding Path="AgencyID" Target="Agencies"/>
        </EntitySet>
        <EntitySet Name="VisaQuotaTransaction" EntityType="AdminService.VisaQuotaTransaction">
          <NavigationPropertyBinding Path="quota" Target="VisaQuotaMaster"/>
        </EntitySet>
        <ActionImport Name="getActiveRoles" Action="AdminService.getActiveRoles"/>
        <ActionImport Name="createUser" Action="AdminService.createUser"/>
        <ActionImport Name="toggleAgencyStatus" Action="AdminService.toggleAgencyStatus"/>
        <ActionImport Name="importAgencies" Action="AdminService.importAgencies"/>
        <ActionImport Name="getActiveAgencies" Action="AdminService.getActiveAgencies"/>
        <ActionImport Name="getActiveCountries" Action="AdminService.getActiveCountries"/>
        <ActionImport Name="importCountries" Action="AdminService.importCountries"/>
        <ActionImport Name="getActiveProfessions" Action="AdminService.getActiveProfessions"/>
        <ActionImport Name="importProfessions" Action="AdminService.importProfessions"/>
        <ActionImport Name="getActiveSceCodes" Action="AdminService.getActiveSceCodes"/>
        <ActionImport Name="importSceCodes" Action="AdminService.importSceCodes"/>
        <ActionImport Name="getActiveDriverProfessions" Action="AdminService.getActiveDriverProfessions"/>
        <ActionImport Name="importDriverProfessions" Action="AdminService.importDriverProfessions"/>
        <ActionImport Name="upsertQuota" Action="AdminService.upsertQuota"/>
        <ActionImport Name="adjustQuota" Action="AdminService.adjustQuota"/>
      </EntityContainer>
      <EntityType Name="Users">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="username" Type="Edm.String" MaxLength="200"/>
        <Property Name="email" Type="Edm.String" MaxLength="200"/>
        <Property Name="password" Type="Edm.String" MaxLength="255"/>
        <Property Name="firstName" Type="Edm.String" MaxLength="100"/>
        <Property Name="lastName" Type="Edm.String" MaxLength="100"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="mustChangePassword" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="language" Type="Edm.String" MaxLength="10" DefaultValue="en"/>
        <Property Name="lastLoginAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <NavigationProperty Name="roleMapping" Type="AdminService.UserRoleMapping" Partner="user">
          <ReferentialConstraint Property="ID" ReferencedProperty="user_ID"/>
        </NavigationProperty>
        <Property Name="roleName" Type="Edm.String" MaxLength="100"/>
        <Property Name="role_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="UserRoleMapping">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <NavigationProperty Name="user" Type="AdminService.Users" Nullable="false" Partner="roleMapping">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="role" Type="AdminService.Roles" Nullable="false" Partner="userMappings">
          <ReferentialConstraint Property="role_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="role_ID" Type="Edm.Guid" Nullable="false"/>
      </EntityType>
      <EntityType Name="Roles">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="roleCode" Type="Edm.String" MaxLength="50"/>
        <Property Name="roleName" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="type" Type="Edm.String" MaxLength="50"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
        <NavigationProperty Name="userMappings" Type="Collection(AdminService.UserRoleMapping)" Partner="role">
          <OnDelete Action="Cascade"/>
        </NavigationProperty>
      </EntityType>
      <EntityType Name="Agencies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="agencyId" Type="Edm.String" MaxLength="20"/>
        <Property Name="agencyName" Type="Edm.String" MaxLength="200"/>
        <NavigationProperty Name="country" Type="AdminService.Countries">
          <ReferentialConstraint Property="country_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="country_ID" Type="Edm.Guid"/>
        <Property Name="email" Type="Edm.String" MaxLength="200"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="countryName" Type="Edm.String" MaxLength="200"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="3"/>
      </EntityType>
      <EntityType Name="Countries">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="3"/>
        <Property Name="countryName" Type="Edm.String" MaxLength="200"/>
      </EntityType>
      <EntityType Name="Professions">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="professionCode" Type="Edm.String" MaxLength="20"/>
        <Property Name="professionName" Type="Edm.String" MaxLength="200"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <EntityType Name="SceCodes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="sceCode" Type="Edm.String" MaxLength="20"/>
        <Property Name="sceNameEn" Type="Edm.String" MaxLength="200"/>
        <Property Name="sceNameAr" Type="Edm.String" MaxLength="200"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <EntityType Name="DriverProfessions">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="professionCode" Type="Edm.String" MaxLength="20"/>
        <Property Name="professionName" Type="Edm.String" MaxLength="200"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <EntityType Name="VisaQuotaMaster">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="VisaType" Type="Edm.String" MaxLength="100"/>
        <Property Name="ProfessionCode" Type="Edm.String" MaxLength="50"/>
        <Property Name="ProfessionName" Type="Edm.String" MaxLength="200"/>
        <Property Name="City" Type="Edm.String" MaxLength="100"/>
        <Property Name="Country" Type="Edm.String" MaxLength="100"/>
        <Property Name="CompanyCode" Type="Edm.String" MaxLength="50"/>
        <Property Name="Department" Type="Edm.String" MaxLength="200"/>
        <Property Name="GradeType" Type="Edm.String" MaxLength="50"/>
        <Property Name="SponsorID" Type="Edm.String" MaxLength="100"/>
        <NavigationProperty Name="AgencyID" Type="AdminService.Agencies">
          <ReferentialConstraint Property="AgencyID_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="AgencyID_ID" Type="Edm.Guid"/>
        <Property Name="PurchasedQty" Type="Edm.Int32" DefaultValue="0"/>
        <Property Name="AvailableQty" Type="Edm.Int32" DefaultValue="0"/>
        <Property Name="FirstPurchaseDate" Type="Edm.Date"/>
        <Property Name="LastPurchaseDate" Type="Edm.Date"/>
        <Property Name="TransactionDate" Type="Edm.Date"/>
        <Property Name="PaymentAmount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="Comments" Type="Edm.String" MaxLength="1000"/>
        <Property Name="Status" Type="Edm.String" MaxLength="20" DefaultValue="Active"/>
        <Property Name="agencyName" Type="Edm.String" MaxLength="200"/>
      </EntityType>
      <EntityType Name="VisaQuotaTransaction">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="createdAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="createdBy" Type="Edm.String" MaxLength="255"/>
        <Property Name="modifiedAt" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="modifiedBy" Type="Edm.String" MaxLength="255"/>
        <NavigationProperty Name="quota" Type="AdminService.VisaQuotaMaster">
          <ReferentialConstraint Property="quota_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="quota_ID" Type="Edm.Guid"/>
        <Property Name="ActionType" Type="Edm.String" MaxLength="30"/>
        <Property Name="Source" Type="Edm.String" MaxLength="30" DefaultValue="MANUAL"/>
        <Property Name="VisaType" Type="Edm.String" MaxLength="100"/>
        <Property Name="ProfessionCode" Type="Edm.String" MaxLength="50"/>
        <Property Name="ProfessionName" Type="Edm.String" MaxLength="200"/>
        <Property Name="City" Type="Edm.String" MaxLength="100"/>
        <Property Name="Country" Type="Edm.String" MaxLength="100"/>
        <Property Name="CompanyCode" Type="Edm.String" MaxLength="50"/>
        <Property Name="Department" Type="Edm.String" MaxLength="200"/>
        <Property Name="GradeType" Type="Edm.String" MaxLength="50"/>
        <Property Name="AgencyName" Type="Edm.String" MaxLength="200"/>
        <Property Name="Quantity" Type="Edm.Int32"/>
        <Property Name="BalanceAfterTxn" Type="Edm.Int32"/>
        <Property Name="CandidateName" Type="Edm.String" MaxLength="200"/>
        <Property Name="CandidateNationality" Type="Edm.String" MaxLength="100"/>
        <Property Name="CaseNo" Type="Edm.String" MaxLength="100"/>
        <Property Name="Remarks" Type="Edm.String" MaxLength="500"/>
      </EntityType>
      <ComplexType Name="return_AdminService_getActiveRoles">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="roleName" Type="Edm.String"/>
        <Property Name="type" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_createUser">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="userID" Type="Edm.Guid"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_toggleAgencyStatus">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_importAgencies">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="created" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(Edm.String)" Nullable="true"/>
      </ComplexType>
      <ComplexType Name="ap_AdminService_importAgencies_agencies">
        <Property Name="agencyName" Type="Edm.String"/>
        <Property Name="countryId" Type="Edm.Guid"/>
        <Property Name="email" Type="Edm.String"/>
        <Property Name="isActive" Type="Edm.Boolean"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveAgencies">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="agencyId" Type="Edm.String"/>
        <Property Name="agencyName" Type="Edm.String"/>
        <Property Name="country_ID" Type="Edm.Guid"/>
        <Property Name="countryName" Type="Edm.String"/>
        <Property Name="countryCode" Type="Edm.String"/>
        <Property Name="email" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveCountries">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="countryCode" Type="Edm.String"/>
        <Property Name="countryName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ImportResult">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="total" Type="Edm.Int32"/>
        <Property Name="created" Type="Edm.Int32"/>
        <Property Name="updated" Type="Edm.Int32"/>
        <Property Name="skipped" Type="Edm.Int32"/>
        <Property Name="errors" Type="Collection(AdminService.ImportResult_errors)" Nullable="true"/>
      </ComplexType>
      <ComplexType Name="ImportResult_errors">
        <Property Name="row" Type="Edm.Int32"/>
        <Property Name="code" Type="Edm.String"/>
        <Property Name="message" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ap_AdminService_importCountries_rows">
        <Property Name="countryCode" Type="Edm.String"/>
        <Property Name="countryName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveProfessions">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="professionCode" Type="Edm.String"/>
        <Property Name="professionName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ap_AdminService_importProfessions_rows">
        <Property Name="professionCode" Type="Edm.String"/>
        <Property Name="professionName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveSceCodes">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="sceCode" Type="Edm.String"/>
        <Property Name="sceNameEn" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ap_AdminService_importSceCodes_rows">
        <Property Name="sceCode" Type="Edm.String"/>
        <Property Name="sceNameEn" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_getActiveDriverProfessions">
        <Property Name="ID" Type="Edm.Guid"/>
        <Property Name="professionCode" Type="Edm.String"/>
        <Property Name="professionName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ap_AdminService_importDriverProfessions_rows">
        <Property Name="professionCode" Type="Edm.String"/>
        <Property Name="professionName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_upsertQuota">
        <Property Name="wasUpsert" Type="Edm.Boolean"/>
        <Property Name="quotaId" Type="Edm.Guid"/>
        <Property Name="message" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_AdminService_adjustQuota">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="newAvailableQty" Type="Edm.Int32"/>
      </ComplexType>
      <Action Name="getActiveRoles" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveRoles)" Nullable="true"/>
      </Action>
      <Action Name="createUser" IsBound="false">
        <Parameter Name="firstName" Type="Edm.String"/>
        <Parameter Name="lastName" Type="Edm.String"/>
        <Parameter Name="email" Type="Edm.String"/>
        <Parameter Name="role_ID" Type="Edm.Guid"/>
        <Parameter Name="isActive" Type="Edm.Boolean"/>
        <ReturnType Type="AdminService.return_AdminService_createUser"/>
      </Action>
      <Action Name="toggleAgencyStatus" IsBound="false">
        <Parameter Name="agencyId" Type="Edm.Guid"/>
        <Parameter Name="isActive" Type="Edm.Boolean"/>
        <ReturnType Type="AdminService.return_AdminService_toggleAgencyStatus"/>
      </Action>
      <Action Name="importAgencies" IsBound="false">
        <Parameter Name="agencies" Type="Collection(AdminService.ap_AdminService_importAgencies_agencies)" Nullable="true"/>
        <ReturnType Type="AdminService.return_AdminService_importAgencies"/>
      </Action>
      <Action Name="getActiveAgencies" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveAgencies)" Nullable="true"/>
      </Action>
      <Action Name="getActiveCountries" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveCountries)" Nullable="true"/>
      </Action>
      <Action Name="importCountries" IsBound="false">
        <Parameter Name="rows" Type="Collection(AdminService.ap_AdminService_importCountries_rows)" Nullable="true"/>
        <ReturnType Type="AdminService.ImportResult"/>
      </Action>
      <Action Name="getActiveProfessions" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveProfessions)" Nullable="true"/>
      </Action>
      <Action Name="importProfessions" IsBound="false">
        <Parameter Name="rows" Type="Collection(AdminService.ap_AdminService_importProfessions_rows)" Nullable="true"/>
        <ReturnType Type="AdminService.ImportResult"/>
      </Action>
      <Action Name="getActiveSceCodes" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveSceCodes)" Nullable="true"/>
      </Action>
      <Action Name="importSceCodes" IsBound="false">
        <Parameter Name="rows" Type="Collection(AdminService.ap_AdminService_importSceCodes_rows)" Nullable="true"/>
        <ReturnType Type="AdminService.ImportResult"/>
      </Action>
      <Action Name="getActiveDriverProfessions" IsBound="false">
        <ReturnType Type="Collection(AdminService.return_AdminService_getActiveDriverProfessions)" Nullable="true"/>
      </Action>
      <Action Name="importDriverProfessions" IsBound="false">
        <Parameter Name="rows" Type="Collection(AdminService.ap_AdminService_importDriverProfessions_rows)" Nullable="true"/>
        <ReturnType Type="AdminService.ImportResult"/>
      </Action>
      <Action Name="upsertQuota" IsBound="false">
        <Parameter Name="VisaType" Type="Edm.String"/>
        <Parameter Name="ProfessionCode" Type="Edm.String"/>
        <Parameter Name="ProfessionName" Type="Edm.String"/>
        <Parameter Name="City" Type="Edm.String"/>
        <Parameter Name="Country" Type="Edm.String"/>
        <Parameter Name="CompanyCode" Type="Edm.String"/>
        <Parameter Name="Department" Type="Edm.String"/>
        <Parameter Name="GradeType" Type="Edm.String"/>
        <Parameter Name="SponsorID" Type="Edm.String"/>
        <Parameter Name="AgencyID" Type="Edm.Guid"/>
        <Parameter Name="AddQty" Type="Edm.Int32"/>
        <Parameter Name="PurchaseDate" Type="Edm.Date"/>
        <Parameter Name="PaymentAmount" Type="Edm.Decimal" Scale="variable"/>
        <Parameter Name="Comments" Type="Edm.String"/>
        <ReturnType Type="AdminService.return_AdminService_upsertQuota"/>
      </Action>
      <Action Name="adjustQuota" IsBound="false">
        <Parameter Name="quotaId" Type="Edm.Guid"/>
        <Parameter Name="quantity" Type="Edm.Int32"/>
        <Parameter Name="action" Type="Edm.String"/>
        <Parameter Name="remarks" Type="Edm.String"/>
        <ReturnType Type="AdminService.return_AdminService_adjustQuota"/>
      </Action>
      <Annotations Target="AdminService.Users/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Users/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.Users/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.Users/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.Users/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMapping/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMapping/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMapping/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMapping/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.UserRoleMapping/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.Roles/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Roles/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.Roles/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.Roles/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.Roles/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/countryName">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.Agencies/countryCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/countryCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.Countries/countryName">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/professionCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.Professions/professionName">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/sceCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.SceCodes/sceNameEn">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/professionCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.DriverProfessions/professionName">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/VisaType">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/ProfessionCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/ProfessionName">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/City">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/Country">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/CompanyCode">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaMaster/Department">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/createdAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Created On"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/createdBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Immutable" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Created By"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/modifiedAt">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Common.Label" String="Changed On"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/modifiedBy">
        <Annotation Term="UI.HiddenFilter" Bool="true"/>
        <Annotation Term="UI.ExcludeFromNavigationContext" Bool="true"/>
        <Annotation Term="Core.Computed" Bool="true"/>
        <Annotation Term="Core.Description" String="User's unique ID"/>
        <Annotation Term="Common.Label" String="Changed By"/>
      </Annotations>
      <Annotations Target="AdminService.VisaQuotaTransaction/ActionType">
        <Annotation Term="Common.FieldControl" EnumMember="Common.FieldControlType/Mandatory"/>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>