<?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:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Validation.V1.xml">
    <edmx:Include Alias="Validation" Namespace="Org.OData.Validation.V1"/>
  </edmx:Reference>
  <edmx:DataServices>
    <Schema Namespace="ODataService" 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="getETLTransformedData" EntityType="ODataService.getETLTransformedData"/>
        <EntitySet Name="getETLExpenseData" EntityType="ODataService.getETLExpenseData"/>
      </EntityContainer>
      <EntityType Name="getETLTransformedData">
        <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="sourceFile" Type="Edm.String"/>
        <Property Name="mappingProfile" Type="Edm.String"/>
        <Property Name="recordIndex" Type="Edm.Int32"/>
        <Property Name="employeeName" Type="Edm.String" MaxLength="1500"/>
        <Property Name="employeeId" Type="Edm.String"/>
        <Property Name="employeeNumber" Type="Edm.String" MaxLength="50"/>
        <Property Name="outdoorDutyIdName" Type="Edm.String"/>
        <Property Name="tripID" Type="Edm.String"/>
        <Property Name="department" Type="Edm.String"/>
        <Property Name="tripName" Type="Edm.String" MaxLength="1500"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="approvalStatus" Type="Edm.String"/>
        <Property Name="odDays" Type="Edm.Int32"/>
        <Property Name="approvedAmount" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="currency" Type="Edm.String"/>
        <Property Name="approver" Type="Edm.String"/>
        <Property Name="approvalDate" Type="Edm.Date"/>
        <Property Name="location" Type="Edm.String"/>
        <Property Name="purpose" Type="Edm.String" MaxLength="1500"/>
        <Property Name="project" Type="Edm.String" MaxLength="1500"/>
        <Property Name="company" Type="Edm.String" MaxLength="1500"/>
        <Property Name="requestPolicy" Type="Edm.String"/>
        <Property Name="branch" Type="Edm.String"/>
        <Property Name="travelType" Type="Edm.String" MaxLength="1500"/>
        <Property Name="travelRequestSegment" Type="Edm.String"/>
        <Property Name="segmentType" Type="Edm.String"/>
        <Property Name="segmentTypeCategory" Type="Edm.String"/>
        <Property Name="segmentTypeCode" Type="Edm.String"/>
        <Property Name="segmentTypeName" Type="Edm.String"/>
        <Property Name="requestedAmount" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="submissionDate" Type="Edm.Date"/>
        <Property Name="isOutdoorDuty" Type="Edm.Boolean"/>
        <Property Name="outdoorDutyValue" Type="Edm.String"/>
        <Property Name="travelRequestId" Type="Edm.String" MaxLength="50"/>
        <Property Name="expenseReportId" Type="Edm.String"/>
        <Property Name="dynamicFields" Type="Edm.String"/>
        <Property Name="metadata" Type="Edm.String"/>
        <Property Name="validationStatus" Type="Edm.String"/>
        <Property Name="extractedAt" Type="Edm.DateTimeOffset"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <EntityType Name="getETLExpenseData">
        <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="sourceFile" Type="Edm.String"/>
        <Property Name="mappingProfile" Type="Edm.String"/>
        <Property Name="recordIndex" Type="Edm.Int32"/>
        <Property Name="employeeName" Type="Edm.String"/>
        <Property Name="employeeId" Type="Edm.String"/>
        <Property Name="outdoorDutyIdName" Type="Edm.String"/>
        <Property Name="designation" Type="Edm.String"/>
        <Property Name="department" Type="Edm.String"/>
        <Property Name="branch" Type="Edm.String"/>
        <Property Name="role" Type="Edm.String"/>
        <Property Name="tourStart" Type="Edm.Date"/>
        <Property Name="tourEnd" Type="Edm.Date"/>
        <Property Name="tourLocal" Type="Edm.String"/>
        <Property Name="reportNo" Type="Edm.String"/>
        <Property Name="reportID" Type="Edm.String"/>
        <Property Name="reportingStep" Type="Edm.String"/>
        <Property Name="stepAction" Type="Edm.String"/>
        <Property Name="employeeApproved" Type="Edm.String"/>
        <Property Name="sentForApproval" Type="Edm.String"/>
        <Property Name="approvedAmount" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="adjustedAmount" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="requestedAmount" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="currency" Type="Edm.String"/>
        <Property Name="totalCash" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="totalCard" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="cashAdvance" Type="Edm.Decimal" Precision="12" Scale="2"/>
        <Property Name="employeeExpenseType" Type="Edm.String"/>
        <Property Name="paymentType" Type="Edm.String"/>
        <Property Name="transactionEntry" Type="Edm.String"/>
        <Property Name="reimbursementCurrency" Type="Edm.String"/>
        <Property Name="segmentType" Type="Edm.String"/>
        <Property Name="submitDate" Type="Edm.Date"/>
        <Property Name="paymentDate" Type="Edm.Date"/>
        <Property Name="comment" Type="Edm.String"/>
        <Property Name="commentsPayment" Type="Edm.String"/>
        <Property Name="requestID" Type="Edm.String"/>
        <Property Name="tripID" Type="Edm.String"/>
        <Property Name="isOutdoorDuty" Type="Edm.Boolean"/>
        <Property Name="outdoorDutyValue" Type="Edm.String"/>
        <Property Name="dynamicFields" Type="Edm.String"/>
        <Property Name="metadata" Type="Edm.String"/>
        <Property Name="validationStatus" Type="Edm.String"/>
        <Property Name="extractedAt" Type="Edm.DateTimeOffset"/>
        <Property Name="isActive" Type="Edm.Boolean" DefaultValue="true"/>
      </EntityType>
      <Annotations Target="ODataService.getETLTransformedData/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ODataService.getETLTransformedData/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="ODataService.getETLTransformedData/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="ODataService.getETLTransformedData/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="ODataService.getETLTransformedData/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="ODataService.getETLTransformedData/validationStatus">
        <Annotation Term="Validation.AllowedValues">
          <Collection>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="VALID"/>
              <PropertyValue Property="Value" String="VALID"/>
            </Record>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="WARNINGS"/>
              <PropertyValue Property="Value" String="WARNINGS"/>
            </Record>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="ERRORS"/>
              <PropertyValue Property="Value" String="ERRORS"/>
            </Record>
          </Collection>
        </Annotation>
      </Annotations>
      <Annotations Target="ODataService.getETLExpenseData/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ODataService.getETLExpenseData/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="ODataService.getETLExpenseData/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="ODataService.getETLExpenseData/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="ODataService.getETLExpenseData/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="ODataService.getETLExpenseData/validationStatus">
        <Annotation Term="Validation.AllowedValues">
          <Collection>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="VALID"/>
              <PropertyValue Property="Value" String="VALID"/>
            </Record>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="WARNINGS"/>
              <PropertyValue Property="Value" String="WARNINGS"/>
            </Record>
            <Record Type="Validation.AllowedValue">
              <Annotation Term="Core.SymbolicName" String="ERRORS"/>
              <PropertyValue Property="Value" String="ERRORS"/>
            </Record>
          </Collection>
        </Annotation>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>