<?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="PerDayAllowanceService" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="EntityContainer">
        <EntitySet Name="UserUIAccess" EntityType="PerDayAllowanceService.UserUIAccess"/>
        <EntitySet Name="Users" EntityType="PerDayAllowanceService.Users">
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="dependents" Target="UserDependents"/>
        </EntitySet>
        <EntitySet Name="PerDayAllowance" EntityType="PerDayAllowanceService.PerDayAllowance">
          <NavigationPropertyBinding Path="group" Target="Groups"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
        </EntitySet>
        <EntitySet Name="Groups" EntityType="PerDayAllowanceService.Groups"/>
        <EntitySet Name="ExpensePolicies" EntityType="PerDayAllowanceService.ExpensePolicies"/>
        <EntitySet Name="Cities" EntityType="PerDayAllowanceService.Cities"/>
        <EntitySet Name="AllCities" EntityType="PerDayAllowanceService.AllCities"/>
        <EntitySet Name="UserDependents" EntityType="PerDayAllowanceService.UserDependents">
          <NavigationPropertyBinding Path="user" Target="Users"/>
        </EntitySet>
        <ActionImport Name="saveorupdatePerDayAllowance" Action="PerDayAllowanceService.saveorupdatePerDayAllowance"/>
        <ActionImport Name="getPerDayAllowanceRate" Action="PerDayAllowanceService.getPerDayAllowanceRate"/>
      </EntityContainer>
      <EntityType Name="UserUIAccess">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="feature_name" Type="Edm.String" MaxLength="50"/>
        <Property Name="is_visible" Type="Edm.Boolean" DefaultValue="true"/>
      </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"/>
        <Property Name="sbuId_ID" Type="Edm.Guid"/>
        <Property Name="costCenterId_ID" Type="Edm.Guid"/>
        <Property Name="departmentId_ID" Type="Edm.Guid"/>
        <Property Name="divisionId_ID" Type="Edm.Guid"/>
        <Property Name="designationId_ID" Type="Edm.Guid"/>
        <Property Name="gradeId_ID" Type="Edm.Guid"/>
        <Property Name="companyId_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel1_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel2_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel3_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel4_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel5_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel6_ID" Type="Edm.Guid"/>
        <Property Name="ledgerId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="group" Type="PerDayAllowanceService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <Property Name="currencyId_ID" Type="Edm.Guid"/>
        <Property Name="countryId_ID" Type="Edm.Int32"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <NavigationProperty Name="dependents" Type="Collection(PerDayAllowanceService.UserDependents)" Partner="user">
          <OnDelete Action="Cascade"/>
        </NavigationProperty>
      </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="PerDayAllowanceService.Groups">
          <ReferentialConstraint Property="group_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="PerDayAllowanceService.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="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="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="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"/>
        <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="UserDependents">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="PerDayAllowanceService.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_PerDayAllowanceService_getPerDayAllowanceRate">
        <Property Name="included_days" Type="Edm.Int32"/>
        <Property Name="total_amount" Type="Edm.Decimal" Precision="10" Scale="2"/>
        <Property Name="currency_ID" Type="Edm.Guid"/>
        <Property Name="message" Type="Edm.String"/>
      </ComplexType>
      <Action Name="saveorupdatePerDayAllowance" IsBound="false">
        <Parameter Name="ID" Type="Edm.Guid"/>
        <Parameter Name="PerDayAllowanceName" Type="Edm.String"/>
        <Parameter Name="group" Type="Edm.Guid"/>
        <Parameter Name="policy" Type="Edm.Guid"/>
        <Parameter Name="details" Type="Edm.String"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Action Name="getPerDayAllowanceRate" IsBound="false">
        <Parameter Name="policy_ID" Type="Edm.Guid"/>
        <Parameter Name="group_ID" Type="Edm.Guid"/>
        <Parameter Name="location_ID" Type="Edm.String"/>
        <Parameter Name="arrival_datetime" Type="Edm.DateTimeOffset" Precision="7"/>
        <Parameter Name="departure_datetime" Type="Edm.DateTimeOffset" Precision="7"/>
        <ReturnType Type="PerDayAllowanceService.return_PerDayAllowanceService_getPerDayAllowanceRate"/>
      </Action>
      <Annotations Target="PerDayAllowanceService.UserUIAccess/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.Users/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.PerDayAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.Groups/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.ExpensePolicies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.AllCities/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="PerDayAllowanceService.UserDependents/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>