<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:DataServices>
    <Schema Namespace="Arcoro.One.Data.DataWarehouse.Entities" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityType Name="DwCompany">
        <Key>
          <PropertyRef Name="ArcoroTenantId" />
        </Key>
        <Property Name="ArcoroTenantId" Type="Edm.Guid" Nullable="false" />
        <Property Name="Name" Type="Edm.String" Nullable="false" />
        <Property Name="ExistsInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInAts" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInAts" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInExakTime" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExakTimeStatus" Type="Edm.String" Nullable="false" />
        <Property Name="ActiveInExakTime" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInChurnZero" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInChurnZero" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CoreStatus" Type="Edm.String" Nullable="false" />
        <Property Name="ActiveInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInAdvancedAnalytics" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInAdvancedAnalytics" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInOnboarding" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInOnboarding" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExistsInHub" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CustomerSubscriptionStartDate" Type="Edm.Date" />
        <Property Name="CustomerSubscriptionEndDate" Type="Edm.Date" />
        <Property Name="EnterpriseName" Type="Edm.String" Nullable="false" />
        <Property Name="IsInternal" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Ein" Type="Edm.String" Nullable="false" />
        <NavigationProperty Name="Users" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUser)" />
        <NavigationProperty Name="TimeOffPlans" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlan)" />
        <NavigationProperty Name="Equipments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEquipment)" />
        <NavigationProperty Name="Jobs" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJob)" />
        <NavigationProperty Name="Candidates" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCandidate)" />
        <NavigationProperty Name="PayPeriods" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPayPeriod)" />
        <NavigationProperty Name="PayPeriodApprovals" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPayPeriodApproval)" />
        <NavigationProperty Name="WorkDateTimeApprovals" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwWorkDateTimeApproval)" />
        <NavigationProperty Name="UserCustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserCustomField)" />
        <NavigationProperty Name="UserFieldNotes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserFieldNote)" />
        <NavigationProperty Name="Courses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCourse)" />
        <NavigationProperty Name="CourseTranscripts" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCourseTranscript)" />
        <NavigationProperty Name="LearningPlans" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLearningPlan)" />
        <NavigationProperty Name="Transcripts" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTranscript)" />
        <NavigationProperty Name="TranscriptLastCompeleteds" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTranscriptLastCompeleted)" />
        <NavigationProperty Name="Licenses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLicense)" />
        <NavigationProperty Name="EvaluationForms" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationForm)" />
        <NavigationProperty Name="PerformanceEvaluations" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluation)" />
        <NavigationProperty Name="SurveyQuestions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwSurveyQuestion)" />
        <NavigationProperty Name="SurveyResponses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwSurveyResponse)" />
        <NavigationProperty Name="SurveyResponseAggregates" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwSurveyResponseAggregate)" />
        <NavigationProperty Name="BenefitPackages" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwBenefitPackage)" />
        <NavigationProperty Name="MobileForms" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMobileForm)" />
        <NavigationProperty Name="Expenses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwExpense)" />
        <NavigationProperty Name="ExpenseCustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwExpenseCustomField)" />
        <NavigationProperty Name="CostCodes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCostCode)" />
        <NavigationProperty Name="CostCodeCustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCostCodeCustomField)" />
        <NavigationProperty Name="CostCodeFieldNotes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCostCodeFieldNote)" />
        <NavigationProperty Name="Locations" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLocation)" />
        <NavigationProperty Name="LocationCustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLocationCustomField)" />
        <NavigationProperty Name="LocationFieldNotes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLocationFieldNote)" />
        <NavigationProperty Name="EquipmentCustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEquipmentCustomField)" />
        <NavigationProperty Name="SmsMessages" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwSmsMessage)" />
        <NavigationProperty Name="Accounts" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwAccount)" />
        <NavigationProperty Name="DataExports" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwDataExport)" />
        <NavigationProperty Name="Employers" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEmployer)" />
        <NavigationProperty Name="HrMetricByMonths" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwHrMetricByMonth)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An Arcoro customer company, including which modules are active and the overall status of each subscription." />
      </EntityType>
      <EntityType Name="DwUser">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInAdvancedAnalytics" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInAdvancedAnalytics" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInAdvancedAnalytics" Type="Edm.Boolean" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="MiddleName" Type="Edm.String" Nullable="false" />
        <Property Name="MiddleInitial" Type="Edm.String" Nullable="false" />
        <Property Name="Suffix" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayName" Type="Edm.String" Nullable="false" />
        <Property Name="Username" Type="Edm.String" Nullable="false" />
        <Property Name="Language" Type="Edm.String" Nullable="false" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="JobCode" Type="Edm.String" Nullable="false" />
        <Property Name="JobCodeDescription" Type="Edm.String" Nullable="false" />
        <Property Name="JobCodesDoNotMatch" Type="Edm.Boolean" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="Department" Type="Edm.String" Nullable="false" />
        <Property Name="DepartmentCode" Type="Edm.String" Nullable="false" />
        <Property Name="UserGroups" Type="Edm.String" Nullable="false" />
        <Property Name="WorkPhone" Type="Edm.String" Nullable="false" />
        <Property Name="HomePhone" Type="Edm.String" Nullable="false" />
        <Property Name="MobilePhone" Type="Edm.String" Nullable="false" />
        <Property Name="EmailAddress" Type="Edm.String" Nullable="false" />
        <Property Name="EmailIsConfirmed" Type="Edm.Boolean" Nullable="false" />
        <Property Name="LastLoginDate" Type="Edm.Date" />
        <NavigationProperty Name="TimeRecords" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecord)" />
        <NavigationProperty Name="TimePunches" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimePunch)" />
        <NavigationProperty Name="TimeOffBalances" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffBalance)" />
        <NavigationProperty Name="TimeOffRequests" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffRequest)" />
        <NavigationProperty Name="JobUsers" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobUser)" />
        <NavigationProperty Name="CompensationHistories" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCompensationHistory)" />
        <NavigationProperty Name="CompensationTransactions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCompensationTransaction)" />
        <NavigationProperty Name="CoreCostCodes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserCoreCostCode)" />
        <NavigationProperty Name="EmploymentStatusHistories" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEmploymentStatusHistory)" />
        <NavigationProperty Name="PositionHistories" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPositionHistory)" />
        <NavigationProperty Name="UserAssociatedPeople" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserAssociatedPerson)" />
        <NavigationProperty Name="UserCertifications" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserCertification)" />
        <NavigationProperty Name="UserChangeLogs" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserChangeLog)" />
        <NavigationProperty Name="UserGoals" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserGoal)" />
        <NavigationProperty Name="UserTranscripts" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserTranscript)" />
        <NavigationProperty Name="UsersWithoutCertifications" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUsersWithoutCertification)" />
        <NavigationProperty Name="UsersWithoutCourses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUsersWithoutCourse)" />
        <NavigationProperty Name="FederalTaxes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwFederalTax)" />
        <NavigationProperty Name="StateProvinceTaxes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwStateProvinceTax)" />
        <NavigationProperty Name="Shifts" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwShift)" />
        <NavigationProperty Name="ShiftTimeRecordDifferences" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwShiftTimeRecordDifference)" />
        <NavigationProperty Name="TimeRecordByHourGroups" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordByHourGroup)" />
        <NavigationProperty Name="TimeOffPlanEmployees" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlanEmployee)" />
        <NavigationProperty Name="CourseAssignments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCourseAssignment)" />
        <NavigationProperty Name="UserLearningPlans" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserLearningPlan)" />
        <NavigationProperty Name="UserLearningPlanTasks" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwUserLearningPlanTask)" />
        <NavigationProperty Name="PerformanceEvaluationWorkflows" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationWorkflow)" />
        <NavigationProperty Name="BenefitElections" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElection)" />
        <NavigationProperty Name="Expenses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwExpense)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A user account in Arcoro. May be linked to an employee, candidate, or learner record across the platform's modules." />
      </EntityType>
      <EntityType Name="DwUserDetailsCore">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ManagerInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInCore" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="MaritalStatus" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="EmployeeType" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeStatus" Type="Edm.String" Nullable="false" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="OriginalHireDate" Type="Edm.Date" />
        <Property Name="AlternateServiceDate1" Type="Edm.Date" />
        <Property Name="AlternateServiceDate2" Type="Edm.Date" />
        <Property Name="Salary" Type="Edm.Decimal" Scale="variable" />
        <Property Name="HourlyRate" Type="Edm.Decimal" Scale="variable" />
        <Property Name="PayrollPayGroupName" Type="Edm.String" Nullable="false" />
        <Property Name="PayrollPayGroupCode" Type="Edm.String" Nullable="false" />
        <Property Name="PaySchedule" Type="Edm.String" Nullable="false" />
        <Property Name="CompRateName" Type="Edm.String" Nullable="false" />
        <Property Name="CompRateCode" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="PersonIdTimeOffManager" Type="Edm.Int32" />
        <Property Name="TimeOffManagerUserName" Type="Edm.String" />
        <Property Name="TimeOffManagerFullName" Type="Edm.String" />
        <Property Name="PersonIdPerformanceManager" Type="Edm.Int32" />
        <Property Name="PerformanceManagerUserName" Type="Edm.String" />
        <Property Name="PerformanceManagerFullName" Type="Edm.String" />
        <Property Name="IsWorkflowResource" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvinceCode" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="LocationIdFacility1" Type="Edm.Int32" />
        <Property Name="Facility1Name" Type="Edm.String" />
        <Property Name="LocationIdFacility2" Type="Edm.Int32" />
        <Property Name="Facility2Name" Type="Edm.String" />
        <Property Name="BenefitStatus" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitEligibilityDate" Type="Edm.Date" />
        <Property Name="EmployerName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployerCode" Type="Edm.String" Nullable="false" />
        <Property Name="EmployerTaxIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Property Name="TerminationReason" Type="Edm.String" Nullable="false" />
        <Property Name="TerminationReasonCode" Type="Edm.String" Nullable="false" />
        <Property Name="WorkersCompName" Type="Edm.String" Nullable="false" />
        <Property Name="WorkersCompCode" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodes" Type="Edm.String" Nullable="false" />
        <Property Name="LaborClassCode" Type="Edm.String" Nullable="false" />
        <Property Name="LaborClassName" Type="Edm.String" Nullable="false" />
        <Property Name="VisaType" Type="Edm.String" Nullable="false" />
        <Property Name="VisaExpirationDate" Type="Edm.Date" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Core HR details for a user — payroll, compensation, demographics, address, manager hierarchy, and employment lifecycle dates. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwUserDetailsApplicantTracking">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInAts" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInAts" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInAts" Type="Edm.Boolean" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Applicant Tracking module presence and role flags for a user. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwUserDetailsLearning">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ManagerInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInPerformance" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="LastPromotionDate" Type="Edm.Date" />
        <Property Name="NextEvaluationDate" Type="Edm.Date" />
        <Property Name="Potential" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LockRecordDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Learning Management module details for a user — LMS role flags, manager, evaluation dates, and select demographics. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwUserDetailsOnboarding">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInOnboarding" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OnboardingRole" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Onboarding module presence and role for a user. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwUserDetailsPerformance">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ManagerInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInLms" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInPerformance" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="LastPromotionDate" Type="Edm.Date" />
        <Property Name="NextEvaluationDate" Type="Edm.Date" />
        <Property Name="Potential" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="PersonIdPerformanceManager" Type="Edm.Int32" />
        <Property Name="PerformanceManagerUserName" Type="Edm.String" />
        <Property Name="PerformanceManagerFullName" Type="Edm.String" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" Nullable="false" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Property Name="LockRecordDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Performance module details for a user — role flags, manager hierarchy, evaluation dates, and select demographics. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwUserDetailsTime">
        <Key>
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExistsInEt" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ActiveInEt" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AdminInEt" Type="Edm.Boolean" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="EtConnectSecurityRole" Type="Edm.String" Nullable="false" />
        <Property Name="EtMobileSecurityRole" Type="Edm.String" Nullable="false" />
        <Property Name="Category" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="FieldNotes" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="ExakTime (Time &amp; Attendance) details for a user — role flags, security roles, address, category, and field notes. Joined to by PersonId." />
      </EntityType>
      <EntityType Name="DwTimeRecord">
        <Key>
          <PropertyRef Name="TimeRecordId" />
        </Key>
        <Property Name="TimeRecordId" Type="Edm.Guid" Nullable="false" />
        <Property Name="EltModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="EmployeeFullName" Type="Edm.String" />
        <Property Name="EmployeeId" Type="Edm.String" />
        <Property Name="TimeRecordType" Type="Edm.String" Nullable="false" />
        <Property Name="WorkDate" Type="Edm.Date" Nullable="false" />
        <Property Name="StartDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="CostCodeIdentifier" Type="Edm.String" />
        <Property Name="CostCodeDescription" Type="Edm.String" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="LocationIdentifier" Type="Edm.String" />
        <Property Name="LocationName" Type="Edm.String" />
        <Property Name="StopDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="Comments" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="TimeSpanMinutes" Type="Edm.Int32" Nullable="false" />
        <Property Name="RegularTimeHours" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="OverTime1Hours" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="OverTime2Hours" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="TotalHours" Type="Edm.Decimal" Scale="variable" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="ModifiedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="ModifiedByFullName" Type="Edm.String" />
        <Property Name="ModifiedByEmployeeId" Type="Edm.String" />
        <Property Name="TimePunchIdStart" Type="Edm.Guid" />
        <Property Name="TimePunchIdStop" Type="Edm.Guid" />
        <Property Name="PayPeriodId" Type="Edm.Int32" />
        <Property Name="PayPeriodStartDate" Type="Edm.Date" />
        <Property Name="PayPeriodEndDate" Type="Edm.Date" />
        <Property Name="StartPunchLatitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="StartPunchLongitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="StartPunchLocationDistanceMeters" Type="Edm.Int32" />
        <Property Name="IsStartPunchOutsideLocationGeoFence" Type="Edm.Boolean" Nullable="false" />
        <Property Name="LocationIdStopPunch" Type="Edm.Int32" />
        <Property Name="StopPunchLatitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="StopPunchLongitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="StopPunchLocationDistanceMeters" Type="Edm.Int32" />
        <Property Name="IsStopPunchOutsideLocationGeoFence" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ShiftName" Type="Edm.String" Nullable="false" />
        <Property Name="PaycodeName" Type="Edm.String" Nullable="false" />
        <Property Name="PaycodeIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="IsExported" Type="Edm.Boolean" Nullable="false" />
        <NavigationProperty Name="MealBreakViolations" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMealBreakViolation)" />
        <NavigationProperty Name="TimeRecordByHourGroups" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordByHourGroup)" />
        <NavigationProperty Name="TimeRecordEquipments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordEquipment)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A daily time record summarizing an employee's hours worked, broken down by job, cost code, and pay type." />
      </EntityType>
      <EntityType Name="DwTimePunch">
        <Key>
          <PropertyRef Name="TimePunchId" />
        </Key>
        <Property Name="TimePunchId" Type="Edm.Guid" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="PunchDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="OriginalPunchDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="CreatedDatetimeOffset" Type="Edm.DateTimeOffset" />
        <Property Name="PunchCreatedDeviceType" Type="Edm.String" Nullable="false" />
        <Property Name="PunchModifiedDeviceType" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedDatetimeOffset" Type="Edm.DateTimeOffset" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="DeviceTimezoneOffsetHours" Type="Edm.Int16" />
        <Property Name="DeviceNetworkDatetimeUtc" Type="Edm.DateTimeOffset" />
        <Property Name="PunchNetworkMinutesDiff" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A single clock-in or clock-out event captured by an employee." />
      </EntityType>
      <EntityType Name="DwTimeOffPlan">
        <Key>
          <PropertyRef Name="TimeOffPlanId" />
        </Key>
        <Property Name="TimeOffPlanId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Module" Type="Edm.String" Nullable="false" />
        <Property Name="PlanType" Type="Edm.String" />
        <Property Name="Name" Type="Edm.String" Nullable="false" />
        <Property Name="Description" Type="Edm.String" Nullable="false" />
        <Property Name="Status" Type="Edm.String" Nullable="false" />
        <Property Name="Method" Type="Edm.String" Nullable="false" />
        <Property Name="RequestMinimumInMinutes" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="ModifiedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="RequestsAllowNegativeBalance" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CostCodeId" Type="Edm.Guid" Nullable="false" />
        <Property Name="OvertimeInclusion" Type="Edm.Int32" />
        <NavigationProperty Name="TimeOffPlanEmployees" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlanEmployee)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A time-off policy (e.g., vacation, sick, PTO) configured for a company." />
      </EntityType>
      <EntityType Name="DwTimeOffBalance">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="PlanName" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PlanName" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmailAddress" Type="Edm.String" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="CostCodes" Type="Edm.String" />
        <Property Name="PaySchedule" Type="Edm.String" />
        <Property Name="ManagerFirstName" Type="Edm.String" />
        <Property Name="ManagerLastName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="PlanSystem" Type="Edm.String" Nullable="false" />
        <Property Name="Balance" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="MaximumBalance" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's current available and used time-off balance, summarized per plan." />
      </EntityType>
      <EntityType Name="DwTimeOffRequest">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="PlanName" />
          <PropertyRef Name="StartDate" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PlanName" Type="Edm.String" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmailAddress" Type="Edm.String" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="CostCodes" Type="Edm.String" />
        <Property Name="PaySchedule" Type="Edm.String" />
        <Property Name="ManagerFirstName" Type="Edm.String" />
        <Property Name="ManagerLastName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="PlanSystem" Type="Edm.String" Nullable="false" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="Hours" Type="Edm.Decimal" Scale="variable" />
        <Property Name="Status" Type="Edm.String" Nullable="false" />
        <Property Name="Comments" Type="Edm.String" Nullable="false" />
        <Property Name="ApproverComments" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A time-off request submitted by an employee - dates, hours, status, and approver." />
      </EntityType>
      <EntityType Name="DwEquipment">
        <Key>
          <PropertyRef Name="EquipmentId" />
        </Key>
        <Property Name="EquipmentId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EltModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="EquipmentName" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentNumber" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentIsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AlternateEquipmentNumber" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="Rate" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="EquipmentType" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentCategory" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentGroups" Type="Edm.String" Nullable="false" />
        <Property Name="Comments" Type="Edm.String" Nullable="false" />
        <Property Name="FieldNotes" Type="Edm.String" />
        <NavigationProperty Name="EquipmentFieldNotes" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEquipmentFieldNote)" />
        <NavigationProperty Name="TimeRecordEquipments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordEquipment)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A piece of equipment tracked by the company (vehicles, tools, machines)." />
      </EntityType>
      <EntityType Name="DwEquipmentFieldNote">
        <Key>
          <PropertyRef Name="CreatedDate" />
          <PropertyRef Name="PersonIdCreatedBy" />
        </Key>
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="EquipmentId" Type="Edm.Int32" />
        <Property Name="EquipmentName" Type="Edm.String" />
        <Property Name="Note" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByFullName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A free-text note attached to a piece of equipment by a user." />
      </EntityType>
      <EntityType Name="DwCandidate">
        <Key>
          <PropertyRef Name="CandidateId" />
        </Key>
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AccountId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmailAddress" Type="Edm.String" Nullable="false" />
        <Property Name="SummaryStatement" Type="Edm.String" />
        <Property Name="Tags" Type="Edm.String" />
        <Property Name="AddressLine1" Type="Edm.String" />
        <Property Name="AddressLine2" Type="Edm.String" />
        <Property Name="City" Type="Edm.String" />
        <Property Name="StateAbbrev" Type="Edm.String" />
        <Property Name="PostalCode" Type="Edm.String" />
        <Property Name="MainPhone" Type="Edm.String" />
        <Property Name="AltPhone" Type="Edm.String" />
        <Property Name="AltPhone2" Type="Edm.String" />
        <Property Name="FacebookLink" Type="Edm.String" />
        <Property Name="LinkedInLink" Type="Edm.String" />
        <Property Name="TwitterLink" Type="Edm.String" />
        <Property Name="SkypeLink" Type="Edm.String" />
        <Property Name="CreatedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <NavigationProperty Name="AddtlInfos" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCandidateAddtlInfo)" />
        <NavigationProperty Name="Educations" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCandidateEducation)" />
        <NavigationProperty Name="EeocSurveyResponses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCandidateEeocSurveyResponse)" />
        <NavigationProperty Name="WorkExperiences" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCandidateWorkExperience)" />
        <NavigationProperty Name="JobCandidates" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidate)" />
        <NavigationProperty Name="OfferLetters" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingOfferLetter)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A job candidate - a person who has applied to or is being considered for one or more positions." />
      </EntityType>
      <EntityType Name="DwCandidateAddtlInfo">
        <Key>
          <PropertyRef Name="CandidateAdditionalInfoId" />
        </Key>
        <Property Name="CandidateAdditionalInfoId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Heading" Type="Edm.String" />
        <Property Name="DateInfo" Type="Edm.String" />
        <Property Name="Comments" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Additional self-reported information collected from a candidate during the application process." />
      </EntityType>
      <EntityType Name="DwCandidateEducation">
        <Key>
          <PropertyRef Name="CandidateEducationId" />
        </Key>
        <Property Name="CandidateEducationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="InstitutionName" Type="Edm.String" />
        <Property Name="StartDate" Type="Edm.String" />
        <Property Name="EndDate" Type="Edm.String" />
        <Property Name="Major" Type="Edm.String" />
        <Property Name="Comments" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An educational achievement reported by a candidate (school, degree, dates)." />
      </EntityType>
      <EntityType Name="DwCandidateEeocSurveyResponse">
        <Key>
          <PropertyRef Name="CandidateEeocSurveyResponseId" />
        </Key>
        <Property Name="CandidateEeocSurveyResponseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="EthnicOrigin" Type="Edm.String" Nullable="false" />
        <Property Name="VeteranStatus" Type="Edm.String" Nullable="false" />
        <Property Name="DisabilityStatus" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A candidate's response to the EEOC voluntary self-identification survey." />
      </EntityType>
      <EntityType Name="DwCandidateWorkExperience">
        <Key>
          <PropertyRef Name="CandidateWorkExperienceId" />
        </Key>
        <Property Name="CandidateWorkExperienceId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="CompanyName" Type="Edm.String" />
        <Property Name="StartDate" Type="Edm.String" />
        <Property Name="EndDate" Type="Edm.String" />
        <Property Name="JobDescription" Type="Edm.String" />
        <Property Name="Salary" Type="Edm.String" />
        <Property Name="ImmediateSupervisor" Type="Edm.String" />
        <Property Name="SupervisorsPhone" Type="Edm.String" />
        <Property Name="ReasonForLeaving" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A previous job or work experience reported by a candidate." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJob">
        <Key>
          <PropertyRef Name="JobId" />
        </Key>
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AccountId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateAbbrev" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="Country" Type="Edm.String" Nullable="false" />
        <Property Name="SkillTags" Type="Edm.String" Nullable="false" />
        <Property Name="Status" Type="Edm.String" Nullable="false" />
        <Property Name="OwnerFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="OwnerLastName" Type="Edm.String" Nullable="false" />
        <Property Name="OwnerFullName" Type="Edm.String" Nullable="false" />
        <Property Name="EeoCategory" Type="Edm.String" Nullable="false" />
        <Property Name="IsConfidential" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OpenedDate" Type="Edm.Date" />
        <Property Name="RequestedCloseDate" Type="Edm.Date" />
        <Property Name="WonderlicJobId" Type="Edm.String" Nullable="false" />
        <Property Name="WonderlicJobName" Type="Edm.String" Nullable="false" />
        <Property Name="IsJobPurchase" Type="Edm.Boolean" />
        <Property Name="Group" Type="Edm.String" Nullable="false" />
        <Property Name="RequisitionCode" Type="Edm.String" Nullable="false" />
        <Property Name="RequisitionStatus" Type="Edm.String" Nullable="false" />
        <Property Name="IsInternal" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CandidateBatchSize" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApplicationTemplateId" Type="Edm.Int32" />
        <Property Name="ApplicationTemplateName" Type="Edm.String" Nullable="false" />
        <Property Name="IsTelecommute" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsNational" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OpeningsCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="LeftToFillCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="NumberOfApplicants" Type="Edm.Int32" Nullable="false" />
        <Property Name="NumberOfViews" Type="Edm.Int32" Nullable="false" />
        <Property Name="NumberOfClicks" Type="Edm.Int32" Nullable="false" />
        <Property Name="NumberOfEmailClicks" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsAssessRequiredForAll" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OriginalBatchSize" Type="Edm.Int32" Nullable="false" />
        <Property Name="HasBatchingEnabled" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AssignedUsers" Type="Edm.String" />
        <Property Name="IsPostedToZipRecruiter" Type="Edm.Boolean" Nullable="false" />
        <Property Name="SalaryMin" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="SalaryMax" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="SalaryCurrency" Type="Edm.String" Nullable="false" />
        <Property Name="SalaryPeriod" Type="Edm.String" Nullable="false" />
        <NavigationProperty Name="JobCandidates" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidate)" />
        <NavigationProperty Name="JobAccountFeeds" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobAccountFeed)" />
        <NavigationProperty Name="JobAssessments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobAssessment)" />
        <NavigationProperty Name="CustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCustomField)" />
        <NavigationProperty Name="OgDistributions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobOgDistribution)" />
        <NavigationProperty Name="PostingFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobPostingField)" />
        <NavigationProperty Name="Socials" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobSocial)" />
        <NavigationProperty Name="JobUsers" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobUser)" />
        <NavigationProperty Name="OfferLetters" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingOfferLetter)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A job posting in the ATS — what candidates apply against." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobAccountFeed">
        <Key>
          <PropertyRef Name="JobAccountFeedId" />
        </Key>
        <Property Name="JobAccountFeedId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AccountJobFeedId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AccountJobFeedName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A paid job-board account feed (e.g. Indeed Sponsored) a job posting is syndicated to." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobAssessment">
        <Key>
          <PropertyRef Name="JobAssessmentId" />
        </Key>
        <Property Name="JobAssessmentId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AssessmentName" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A pre-employment assessment that candidates are required to complete for a specific job." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidate">
        <Key>
          <PropertyRef Name="JobCandidateId" />
        </Key>
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Score" Type="Edm.Int32" />
        <Property Name="Source" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="FinalDisposition" Type="Edm.String" Nullable="false" />
        <Property Name="HiredDate" Type="Edm.Date" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="OnboardingStartDate" Type="Edm.Date" />
        <Property Name="ApplyFromLocation" Type="Edm.String" Nullable="false" />
        <Property Name="ApplyFromRefreshId" Type="Edm.String" Nullable="false" />
        <Property Name="JobSeekerSource" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmailAddress" Type="Edm.String" />
        <Property Name="SummaryStatement" Type="Edm.String" />
        <Property Name="CandidateTags" Type="Edm.String" />
        <Property Name="AddressLine1" Type="Edm.String" />
        <Property Name="AddressLine2" Type="Edm.String" />
        <Property Name="City" Type="Edm.String" />
        <Property Name="StateAbbrev" Type="Edm.String" />
        <Property Name="PostalCode" Type="Edm.String" />
        <Property Name="MainPhone" Type="Edm.String" />
        <Property Name="AltPhone" Type="Edm.String" />
        <Property Name="AltPhone2" Type="Edm.String" />
        <Property Name="CandidateFacebookLink" Type="Edm.String" />
        <Property Name="CandidateLinkedInLink" Type="Edm.String" />
        <Property Name="CandidateTwitterLink" Type="Edm.String" />
        <Property Name="CandidateSkypeLink" Type="Edm.String" />
        <Property Name="WasBatchProcessed" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CurrentStatus" Type="Edm.String" Nullable="false" />
        <Property Name="DisabilityStatus" Type="Edm.String" Nullable="false" />
        <NavigationProperty Name="CandidateAssessments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateAssessment)" />
        <NavigationProperty Name="CustomData" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateCustomDatum)" />
        <NavigationProperty Name="CustomFields" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateCustomField)" />
        <NavigationProperty Name="DispositionTrackings" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateDispositionTracking)" />
        <NavigationProperty Name="StatusTrackings" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateStatusTracking)" />
        <NavigationProperty Name="TimeInDispositions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateTimeInDisposition)" />
        <NavigationProperty Name="TimeInStages" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateTimeInStage)" />
        <NavigationProperty Name="Interviews" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwInterview)" />
        <NavigationProperty Name="OutsideScreenings" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwOutsideScreening)" />
        <NavigationProperty Name="OfferLetters" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingOfferLetter)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A candidate's application to a specific job in the ATS — the join between Candidate and Job." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateAssessment">
        <Key>
          <PropertyRef Name="JobCandidateAssessmentId" />
        </Key>
        <Property Name="JobCandidateAssessmentId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobAssessmentName" Type="Edm.String" Nullable="false" />
        <Property Name="WorkflowCode" Type="Edm.String" />
        <Property Name="WorkflowStatus" Type="Edm.String" />
        <Property Name="WorkflowUrl" Type="Edm.String" />
        <Property Name="CreatedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A candidate's progress against a job's required assessment, including the assessment workflow status and link." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateCustomDatum">
        <Key>
          <PropertyRef Name="JobCandidateCustomDataId" />
        </Key>
        <Property Name="JobCandidateCustomDataId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Heading" Type="Edm.String" Nullable="false" />
        <Property Name="Comments" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A free-form note (heading and comments) recorded against a candidate's application to a specific job." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateCustomField">
        <Key>
          <PropertyRef Name="JobCandidateCustomFieldId" />
        </Key>
        <Property Name="JobCandidateCustomFieldId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CurrentStatus" Type="Edm.String" />
        <Property Name="FinalDisposition" Type="Edm.String" />
        <Property Name="CandidateId" Type="Edm.Int32" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="FullSortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="Section" Type="Edm.String" Nullable="false" />
        <Property Name="IsCustomSection" Type="Edm.Boolean" Nullable="false" />
        <Property Name="SectionSortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="QuestionId" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionLabel" Type="Edm.String" Nullable="false" />
        <Property Name="AnswerGroup" Type="Edm.Int32" Nullable="false" />
        <Property Name="AnswerSortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="Answer" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A candidate's answer to a single custom application question on a job - one row per question per candidate." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateDispositionTracking">
        <Key>
          <PropertyRef Name="JobCandidateDispositionTrackingId" />
        </Key>
        <Property Name="JobCandidateDispositionTrackingId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PreviousDisposition" Type="Edm.String" Nullable="false" />
        <Property Name="NewDisposition" Type="Edm.String" Nullable="false" />
        <Property Name="LastUpdateDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A change in a candidate's disposition on a job (e.g. Hired, Rejected) - records the previous and new disposition and when it changed." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateStatusTracking">
        <Key>
          <PropertyRef Name="JobCandidateId" />
          <PropertyRef Name="UpdateSequence" />
        </Key>
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="UpdateSequence" Type="Edm.Int32" Nullable="false" />
        <Property Name="LastUpdateDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PreviousStatus" Type="Edm.String" Nullable="false" />
        <Property Name="NewStatus" Type="Edm.String" Nullable="false" />
        <Property Name="DaysInStatus" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A change in a candidate's pipeline status on a job - records the previous and new status, when it changed, and days spent in the previous status." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateTimeInDisposition">
        <Key>
          <PropertyRef Name="ApplicationDate" />
          <PropertyRef Name="JobCandidateId" />
        </Key>
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApplicationDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="Company" Type="Edm.String" />
        <Property Name="Account" Type="Edm.String" />
        <Property Name="JobName" Type="Edm.String" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="PostingDate" Type="Edm.Date" />
        <Property Name="CandidateId" Type="Edm.Int32" />
        <Property Name="CandidateFullName" Type="Edm.String" Nullable="false" />
        <Property Name="Disposition" Type="Edm.String" />
        <Property Name="DispositionDate" Type="Edm.DateTimeOffset" />
        <Property Name="TimeInDisposition" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Reporting view of how long a candidate has spent in their current disposition on a job." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCandidateTimeInStage">
        <Key>
          <PropertyRef Name="ApplicationDate" />
          <PropertyRef Name="JobCandidateId" />
        </Key>
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApplicationDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="Company" Type="Edm.String" />
        <Property Name="Account" Type="Edm.String" />
        <Property Name="JobName" Type="Edm.String" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="PostingDate" Type="Edm.Date" />
        <Property Name="CandidateId" Type="Edm.Int32" />
        <Property Name="CandidateFullName" Type="Edm.String" Nullable="false" />
        <Property Name="Stage" Type="Edm.String" />
        <Property Name="StageDate" Type="Edm.DateTimeOffset" />
        <Property Name="DaysInStage" Type="Edm.Int32" />
        <Property Name="FinalDisposition" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Reporting view of how long a candidate spent in a particular pipeline stage on a job, with their final disposition." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobCustomField">
        <Key>
          <PropertyRef Name="JobCustomFieldId" />
        </Key>
        <Property Name="JobCustomFieldId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CustomText" Type="Edm.String" />
        <Property Name="ResponseType" Type="Edm.String" />
        <Property Name="ResponseChoices" Type="Edm.String" />
        <Property Name="ViewOrder" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Definition of a custom question on a job's application form, including its response type and the available choices." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobLocalizedAttribute">
        <Key>
          <PropertyRef Name="JobLocalizedAttributeId" />
        </Key>
        <Property Name="JobLocalizedAttributeId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="LanguageCode" Type="Edm.String" Nullable="false" />
        <Property Name="Title" Type="Edm.String" />
        <Property Name="Description" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Localized title and description for a job posting in a specific language." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobLocation">
        <Key>
          <PropertyRef Name="JobLocationId" />
        </Key>
        <Property Name="JobLocationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="City" Type="Edm.String" />
        <Property Name="StateAbbreviation" Type="Edm.String" />
        <Property Name="PostalCode" Type="Edm.String" />
        <Property Name="CountryAbbreviation" Type="Edm.String" />
        <Property Name="Primary" Type="Edm.Boolean" />
        <Property Name="DisplayOption" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A physical work location (city, state, postal code, country) advertised on a job posting." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobOgDistribution">
        <Key>
          <PropertyRef Name="JobOgDistributionId" />
        </Key>
        <Property Name="JobOgDistributionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="OutreachGroupId" Type="Edm.Int32" Nullable="false" />
        <Property Name="OutreachGroupName" Type="Edm.String" />
        <Property Name="RequestDate" Type="Edm.Date" />
        <Property Name="FulfillmentDate" Type="Edm.Date" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A request to distribute a job posting to a particular outreach group (e.g. a diversity job board), including request and fulfillment dates." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobPostingField">
        <Key>
          <PropertyRef Name="JobPostingFieldId" />
        </Key>
        <Property Name="JobPostingFieldId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FieldLabel" Type="Edm.String" Nullable="false" />
        <Property Name="FieldValue" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A label/value pair captured on a job posting form (e.g. &quot;Salary Range&quot; / &quot;$60k-$80k&quot;)." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobSocial">
        <Key>
          <PropertyRef Name="JobSocialId" />
        </Key>
        <Property Name="JobSocialId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SocialMediaName" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A social media channel a job posting has been shared to (e.g. LinkedIn, Facebook)." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingJobUser">
        <Key>
          <PropertyRef Name="JobUserId" />
        </Key>
        <Property Name="JobUserId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="UserFullName" Type="Edm.String" Nullable="false" />
        <Property Name="UserRole" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A recruiter or hiring team member assigned to a job, with their role on the hiring team." />
      </EntityType>
      <EntityType Name="DwInterview">
        <Key>
          <PropertyRef Name="InterviewId" />
        </Key>
        <Property Name="InterviewId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="InterviewType" Type="Edm.String" Nullable="false" />
        <Property Name="InterviewStartDateTimezone" Type="Edm.DateTimeOffset" />
        <Property Name="InterviewEndDateTimezone" Type="Edm.DateTimeOffset" />
        <Property Name="InterviewerId" Type="Edm.Int32" Nullable="false" />
        <Property Name="InterviewerName" Type="Edm.String" />
        <Property Name="InterviewLocation" Type="Edm.String" />
        <Property Name="InterviewPhone" Type="Edm.String" />
        <Property Name="CandidateComments" Type="Edm.String" />
        <Property Name="HiringManagerComments" Type="Edm.String" />
        <Property Name="HasCandidateConfirmed" Type="Edm.Boolean" />
        <Property Name="HasHiringManagerConfirmed" Type="Edm.Boolean" />
        <Property Name="DidYouInterview" Type="Edm.Boolean" />
        <Property Name="IsMovingForward" Type="Edm.Boolean" />
        <Property Name="MovingForwardComment" Type="Edm.String" />
        <Property Name="Status" Type="Edm.String" Nullable="false" />
        <Property Name="LastEmailsSent" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An interview scheduled with a candidate - time, attendees, and outcome." />
      </EntityType>
      <EntityType Name="DwOutsideScreening">
        <Key>
          <PropertyRef Name="OutsideScreeningId" />
        </Key>
        <Property Name="OutsideScreeningId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ScreeningType" Type="Edm.String" Nullable="false" />
        <Property Name="OrderId" Type="Edm.String" />
        <Property Name="TrackingId" Type="Edm.String" />
        <Property Name="ScreeningProduct" Type="Edm.String" Nullable="false" />
        <Property Name="RequestDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="Status" Type="Edm.String" />
        <Property Name="ScreeningResults" Type="Edm.String" />
        <Property Name="Notes" Type="Edm.String" />
        <Property Name="PartnerName" Type="Edm.String" />
        <Property Name="ReferenceId" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An external background, drug, or reference screening ordered for a candidate." />
      </EntityType>
      <EntityType Name="DwApplicantTrackingOfferLetter">
        <Key>
          <PropertyRef Name="OfferLetterId" />
        </Key>
        <Property Name="OfferLetterId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobCandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobId" Type="Edm.Int32" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" />
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="OfferLetterStatus" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="CandidateResponseDate" Type="Edm.Date" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="ExpirationDate" Type="Edm.Date" />
        <Property Name="CustomDate" Type="Edm.Date" />
        <Property Name="Department" Type="Edm.String" Nullable="false" />
        <Property Name="ReportingManager" Type="Edm.String" Nullable="false" />
        <Property Name="WorkingLocation" Type="Edm.String" Nullable="false" />
        <Property Name="OnboardingJobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="CurrentUserOnboardingTitle" Type="Edm.String" Nullable="false" />
        <Property Name="EmploymentType" Type="Edm.String" Nullable="false" />
        <Property Name="PayRateType" Type="Edm.String" Nullable="false" />
        <Property Name="SalaryPay" Type="Edm.String" Nullable="false" />
        <Property Name="HourlyPay" Type="Edm.String" Nullable="false" />
        <Property Name="PayByPayPeriod" Type="Edm.String" Nullable="false" />
        <Property Name="SignOnBonus" Type="Edm.String" Nullable="false" />
        <Property Name="RelocationAllowance" Type="Edm.String" Nullable="false" />
        <Property Name="CellPhoneAllowance" Type="Edm.String" Nullable="false" />
        <Property Name="VehicleAllowance" Type="Edm.String" Nullable="false" />
        <Property Name="Pto" Type="Edm.String" Nullable="false" />
        <Property Name="Vacation" Type="Edm.String" Nullable="false" />
        <Property Name="SickTime" Type="Edm.String" Nullable="false" />
        <Property Name="CandidateComments" Type="Edm.String" Nullable="false" />
        <Property Name="AttachmentCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApprovalName" Type="Edm.String" />
        <Property Name="ApprovalStepCount" Type="Edm.Int32" />
        <Property Name="ApprovedStepCount" Type="Edm.Int32" />
        <Property Name="RejectedStepCount" Type="Edm.Int32" />
        <Property Name="OpenStepCount" Type="Edm.Int32" />
        <Property Name="LastApprovalResponseDate" Type="Edm.Date" />
        <Property Name="UserIdCreatedBy" Type="Edm.Guid" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An Applicant Tracking offer letter sent to a job candidate, with its status, dates, structured pay and allowance terms, and approval chain counts. One row per offer letter." />
      </EntityType>
      <EntityType Name="DwCompensationHistory">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="StartDate" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmployeeId" Type="Edm.String" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="RateType" Type="Edm.String" Nullable="false" />
        <Property Name="RateCode" Type="Edm.String" Nullable="false" />
        <Property Name="Rate" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="WorkedHours" Type="Edm.Int32" Nullable="false" />
        <Property Name="OverTimeRate" Type="Edm.Decimal" Scale="variable" />
        <Property Name="OtherRate" Type="Edm.Decimal" Scale="variable" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Property Name="IsAutoPay" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AutoPayHours" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A change to an employee's pay rate or compensation arrangement over time. One row per compensation period." />
      </EntityType>
      <EntityType Name="DwCompensationTransaction">
        <Key>
          <PropertyRef Name="CompensationCategory" />
          <PropertyRef Name="CreatedDatetime" />
          <PropertyRef Name="EffectiveDate" />
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="TransactionType" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EffectiveDate" Type="Edm.Date" Nullable="false" />
        <Property Name="TransactionType" Type="Edm.String" Nullable="false" />
        <Property Name="CompensationCategory" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmployeeId" Type="Edm.String" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" />
        <Property Name="ExpirationDate" Type="Edm.Date" />
        <Property Name="Amount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayCode" Type="Edm.String" Nullable="false" />
        <Property Name="RateCode" Type="Edm.String" Nullable="false" />
        <Property Name="PayrollEmployerCode" Type="Edm.String" Nullable="false" />
        <Property Name="IsSyncedToPayroll" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="ModifiedByFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedByLastName" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedByFullName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A Core HR compensation transaction: one pay change, one-time payment, or recurring amount for an employee, with its effective window, category, pay and rate codes, and who last modified it." />
      </EntityType>
      <EntityType Name="DwEmploymentStatusHistory">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="StartDate" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="EmploymentStatus" Type="Edm.String" Nullable="false" />
        <Property Name="AcaStatus" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitStatus" Type="Edm.String" Nullable="false" />
        <Property Name="EmployerName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployerCode" Type="Edm.String" Nullable="false" />
        <Property Name="IsCompressed" Type="Edm.Boolean" Nullable="false" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="OriginalHireDate" Type="Edm.Date" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A change to an employee's employment status (active, on leave, terminated, etc.) over time. One row per status period." />
      </EntityType>
      <EntityType Name="DwPositionHistory">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="StartDate" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A change to an employee's job, title, department, or supervisor over time. One row per position period." />
      </EntityType>
      <EntityType Name="DwUserAssociatedPerson">
        <Key>
          <PropertyRef Name="UserAssociatedPersonId" />
        </Key>
        <Property Name="UserAssociatedPersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdEmployee" Type="Edm.Int32" />
        <Property Name="EmployeeFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeLastName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeFullName" Type="Edm.String" Nullable="false" />
        <Property Name="Relationship" Type="Edm.String" Nullable="false" />
        <Property Name="RelationshipCategory" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="MiddleName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="Suffix" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="IsEligibleDependent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsEligibleBeneficiary" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsDependent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsBeneficiary" Type="Edm.Boolean" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="CommitmentDate" Type="Edm.Date" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="IsFullTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsPartTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="StudentHours" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsTobaccoUser" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsDisabled" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsHouseholdMember" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsQmcso" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsEmergencyContact" Type="Edm.Boolean" Nullable="false" />
        <Property Name="PrimaryPhone" Type="Edm.String" Nullable="false" />
        <Property Name="SecondaryPhone" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A person associated with an employee - such as a dependent, beneficiary, emergency contact, or other relation." />
      </EntityType>
      <EntityType Name="DwUserCertification">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="Username" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Username" Type="Edm.String" Nullable="false" />
        <Property Name="UserCertificationId" Type="Edm.Int32" />
        <Property Name="UserActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayName" Type="Edm.String" Nullable="false" />
        <Property Name="JobCode" Type="Edm.String" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Property Name="Department" Type="Edm.String" Nullable="false" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LastPromotionDate" Type="Edm.Date" />
        <Property Name="NextEvaluationDate" Type="Edm.Date" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerName" Type="Edm.String" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="WorkPhone" Type="Edm.String" Nullable="false" />
        <Property Name="MobilePhone" Type="Edm.String" Nullable="false" />
        <Property Name="EmailAddress" Type="Edm.String" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="CertificationId" Type="Edm.Int32" />
        <Property Name="CertificationName" Type="Edm.String" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="Status" Type="Edm.String" />
        <Property Name="IsRejected" Type="Edm.Boolean" />
        <Property Name="MaxStartDate" Type="Edm.Date" />
        <Property Name="MaxEndDate" Type="Edm.Date" />
        <Property Name="DocumentNames" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A professional license or certification held by an employee." />
      </EntityType>
      <EntityType Name="DwUserChangeLog">
        <Key>
          <PropertyRef Name="ChangeDate" />
          <PropertyRef Name="FieldName" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ChangeDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="ChangeSource" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="FieldCategory" Type="Edm.String" Nullable="false" />
        <Property Name="OldValue" Type="Edm.String" Nullable="false" />
        <Property Name="NewValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An audited change to a user's profile data, capturing the field name, old value, and new value." />
      </EntityType>
      <EntityType Name="DwUserCustomField">
        <Key>
          <PropertyRef Name="FieldNumber" />
          <PropertyRef Name="FieldSource" />
        </Key>
        <Property Name="FieldSource" Type="Edm.String" Nullable="false" />
        <Property Name="FieldNumber" Type="Edm.Byte" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="FieldValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom (company-defined) data field on a user record." />
      </EntityType>
      <EntityType Name="DwUserFieldNote">
        <Key>
          <PropertyRef Name="CreatedDate" />
          <PropertyRef Name="PersonIdCreatedBy" />
        </Key>
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="UserFullName" Type="Edm.String" />
        <Property Name="Note" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByFullName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A free-text note attached to a user, written by a manager or HR partner." />
      </EntityType>
      <EntityType Name="DwUserGoal">
        <Key>
          <PropertyRef Name="GoalName" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="GoalName" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="GoalStatus" Type="Edm.String" Nullable="false" />
        <Property Name="GoalDescription" Type="Edm.String" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="EndDate" Type="Edm.Date" />
        <Property Name="DueDate" Type="Edm.Date" />
        <Property Name="CompleteDate" Type="Edm.Date" />
        <Property Name="ApprovedDate" Type="Edm.Date" />
        <Property Name="PerformanceEvaluationId" Type="Edm.Int32" />
        <Property Name="PersonIdApprover" Type="Edm.Int32" />
        <Property Name="ApproverFirstName" Type="Edm.String" />
        <Property Name="ApproverLastName" Type="Edm.String" />
        <Property Name="ApproverFullName" Type="Edm.String" />
        <Property Name="ApproverEmployeeId" Type="Edm.String" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="CreatedByFirstName" Type="Edm.String" />
        <Property Name="CreatedByLastName" Type="Edm.String" />
        <Property Name="CreatedByFullName" Type="Edm.String" />
        <Property Name="CreatedByEmployeeId" Type="Edm.String" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PerformanceEvalEmails" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A performance goal assigned to or owned by an employee." />
      </EntityType>
      <EntityType Name="DwUserTranscript">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="Username" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Username" Type="Edm.String" Nullable="false" />
        <Property Name="UserActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="JobCode" Type="Edm.String" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Property Name="Department" Type="Edm.String" Nullable="false" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LastPromotionDate" Type="Edm.Date" />
        <Property Name="NextEvaluationDate" Type="Edm.Date" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerName" Type="Edm.String" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="WorkPhone" Type="Edm.String" Nullable="false" />
        <Property Name="MobilePhone" Type="Edm.String" Nullable="false" />
        <Property Name="EmailAddress" Type="Edm.String" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="CourseId" Type="Edm.Int32" />
        <Property Name="CourseTitle" Type="Edm.String" />
        <Property Name="CourseDescription" Type="Edm.String" />
        <Property Name="CourseReferenceNumber" Type="Edm.String" />
        <Property Name="CourseVersionNumber" Type="Edm.String" />
        <Property Name="CourseTrainingType" Type="Edm.String" />
        <Property Name="CourseCeu" Type="Edm.Int32" />
        <Property Name="CourseMasteryScore" Type="Edm.Int32" />
        <Property Name="CourseApprovalType" Type="Edm.String" />
        <Property Name="CourseReviewFrequency" Type="Edm.String" />
        <Property Name="CourseAuthor" Type="Edm.String" />
        <Property Name="CourseNotes" Type="Edm.String" />
        <Property Name="CourseCategories" Type="Edm.String" />
        <Property Name="CoursePrerequisites" Type="Edm.String" />
        <Property Name="CourseCompetencies" Type="Edm.String" />
        <Property Name="CourseInstructors" Type="Edm.String" />
        <Property Name="ClassNumber" Type="Edm.String" />
        <Property Name="ClassStartDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassEndDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassStartTime" Type="Edm.DateTimeOffset" />
        <Property Name="ClassEndTime" Type="Edm.DateTimeOffset" />
        <Property Name="Classroom" Type="Edm.String" />
        <Property Name="ClassCost" Type="Edm.Decimal" Scale="variable" />
        <Property Name="Duration" Type="Edm.String" />
        <Property Name="ReferenceMaterialsLink" Type="Edm.String" />
        <Property Name="ExternalEnrollmentLink" Type="Edm.String" />
        <Property Name="CbtLink" Type="Edm.String" />
        <Property Name="CompletionStatus" Type="Edm.String" />
        <Property Name="CompletionDate" Type="Edm.DateTimeOffset" />
        <Property Name="Grade" Type="Edm.String" />
        <Property Name="AcknowledgeDate" Type="Edm.DateTimeOffset" />
        <Property Name="MaxCompletionDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's completed training and learning history." />
      </EntityType>
      <EntityType Name="DwUsersWithoutCertification">
        <Key>
          <PropertyRef Name="CertificationId" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CertificationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CertificationName" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A view of employees who do not currently hold a particular required certification." />
      </EntityType>
      <EntityType Name="DwUsersWithoutCourse">
        <Key>
          <PropertyRef Name="CourseTitle" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CourseTitle" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A view of employees who have not yet completed a particular training course." />
      </EntityType>
      <EntityType Name="DwWorkDateTimeApproval">
        <Key>
          <PropertyRef Name="WorkDateTimeApprovalId" />
        </Key>
        <Property Name="WorkDateTimeApprovalId" Type="Edm.Int32" Nullable="false" />
        <Property Name="WorkDate" Type="Edm.Date" Nullable="false" />
        <Property Name="ApprovalType" Type="Edm.String" Nullable="false" />
        <Property Name="ApprovalDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="HasSignature" Type="Edm.Boolean" Nullable="false" />
        <Property Name="PersonIdApprover" Type="Edm.Int32" />
        <Property Name="ApproverFullName" Type="Edm.String" />
        <Property Name="PersonIdTimeRecord" Type="Edm.Int32" />
        <Property Name="EmployeeFullName" Type="Edm.String" />
        <Property Name="ApprovalSequence" Type="Edm.Int32" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An approval record indicating that a manager has signed off on an employee's worked time for a date." />
      </EntityType>
      <EntityType Name="DwFederalTax">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="TaxYear" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="TaxYear" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="StopDate" Type="Edm.Date" />
        <Property Name="FilingStatus" Type="Edm.String" Nullable="false" />
        <Property Name="Allowances" Type="Edm.Int32" Nullable="false" />
        <Property Name="AdditionalWithholding" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="HasTwoJobs" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Dependents" Type="Edm.Int32" Nullable="false" />
        <Property Name="OtherIncome" Type="Edm.Int32" Nullable="false" />
        <Property Name="Deductions" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="IsExempt" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OverrideAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="OverridePercent" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="IsNonResidentAlien" Type="Edm.Boolean" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's federal tax withholding setup for a tax year (filing status, allowances, additional withholding)." />
      </EntityType>
      <EntityType Name="DwStateProvinceTax">
        <Key>
          <PropertyRef Name="FilingStateCode" />
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="TaxYear" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="TaxYear" Type="Edm.Int32" Nullable="false" />
        <Property Name="FilingStateCode" Type="Edm.String" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="StopDate" Type="Edm.Date" />
        <Property Name="FilingStatus" Type="Edm.String" Nullable="false" />
        <Property Name="FilingState" Type="Edm.String" Nullable="false" />
        <Property Name="UnemploymentState" Type="Edm.String" Nullable="false" />
        <Property Name="UnemploymentStateCode" Type="Edm.String" Nullable="false" />
        <Property Name="Allowances" Type="Edm.Int32" Nullable="false" />
        <Property Name="PercentWithholding" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PercentWithholdingSelection" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AdditionalWithholding" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="IsExempt" Type="Edm.Boolean" Nullable="false" />
        <Property Name="OverrideAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="OverridePercent" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's state- or province-level tax withholding setup for a tax year and filing state." />
      </EntityType>
      <EntityType Name="DwMealBreakViolation">
        <Key>
          <PropertyRef Name="MealBreakViolationId" />
        </Key>
        <Property Name="MealBreakViolationId" Type="Edm.Guid" Nullable="false" />
        <Property Name="TimeRecordId" Type="Edm.Guid" Nullable="false" />
        <Property Name="ViolationType" Type="Edm.String" Nullable="false" />
        <Property Name="ViolationDate" Type="Edm.Date" Nullable="false" />
        <Property Name="ExpectedValue" Type="Edm.Int32" />
        <Property Name="ActualValue" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A flagged meal- or rest-break compliance issue on an employee's work day." />
      </EntityType>
      <EntityType Name="DwPayPeriod">
        <Key>
          <PropertyRef Name="PayPeriodId" />
        </Key>
        <Property Name="PayPeriodId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PayPeriodStartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PayPeriodEndDate" Type="Edm.Date" Nullable="false" />
        <Property Name="IsClosed" Type="Edm.Boolean" Nullable="false" />
        <Property Name="PayPeriodType" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A defined pay period in the company's payroll cycle." />
      </EntityType>
      <EntityType Name="DwPayPeriodApproval">
        <Key>
          <PropertyRef Name="PayPeriodApprovalId" />
        </Key>
        <Property Name="PayPeriodApprovalId" Type="Edm.Guid" Nullable="false" />
        <Property Name="PayPeriodId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApprovalType" Type="Edm.String" Nullable="false" />
        <Property Name="ApprovalDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="HasSignature" Type="Edm.Boolean" Nullable="false" />
        <Property Name="PersonIdApprover" Type="Edm.Int32" />
        <Property Name="ApproverFullName" Type="Edm.String" />
        <Property Name="PersonIdTimeRecord" Type="Edm.Int32" />
        <Property Name="EmployeeFullName" Type="Edm.String" />
        <Property Name="Comment" Type="Edm.String" Nullable="false" />
        <Property Name="ApprovalSequence" Type="Edm.Int32" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A manager's approval of an employee's time for a pay period." />
      </EntityType>
      <EntityType Name="DwShift">
        <Key>
          <PropertyRef Name="ShiftId" />
        </Key>
        <Property Name="ShiftId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="ShiftUserFullName" Type="Edm.String" />
        <Property Name="StartDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="StartDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="EndDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="EndDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="IsRecurrenceException" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsRecurring" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="CostCodeDescription" Type="Edm.String" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="LocationName" Type="Edm.String" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayColor" Type="Edm.String" Nullable="false" />
        <Property Name="RecurrenceEndDate" Type="Edm.Date" />
        <Property Name="TimeZone" Type="Edm.String" Nullable="false" />
        <Property Name="AttachmentNames" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="CreatedByName" Type="Edm.String" />
        <Property Name="ModifiedDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="ModifiedByName" Type="Edm.String" />
        <NavigationProperty Name="ShiftTasks" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwShiftTask)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A scheduled or worked shift for an employee." />
      </EntityType>
      <EntityType Name="DwShiftTask">
        <Key>
          <PropertyRef Name="ShiftTaskId" />
        </Key>
        <Property Name="ShiftTaskId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ShiftId" Type="Edm.Int32" Nullable="false" />
        <Property Name="TaskName" Type="Edm.String" Nullable="false" />
        <Property Name="ShiftTitle" Type="Edm.String" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="CostCodeDescription" Type="Edm.String" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="LocationName" Type="Edm.String" />
        <Property Name="CreatedDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="CreatedByName" Type="Edm.String" />
        <Property Name="ModifiedDatetimeOffset" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="ModifiedByName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A task or step performed during a shift, often tied to a cost code or job." />
      </EntityType>
      <EntityType Name="DwShiftTimeRecordDifference">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="WorkDate" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="WorkDate" Type="Edm.Date" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="MinShiftStart" Type="Edm.DateTimeOffset" />
        <Property Name="MinTrStart" Type="Edm.DateTimeOffset" />
        <Property Name="ShiftStartDiffMinutes" Type="Edm.Int32" />
        <Property Name="MaxShiftEnd" Type="Edm.DateTimeOffset" />
        <Property Name="MaxTrEnd" Type="Edm.DateTimeOffset" />
        <Property Name="ShiftEndDiffMinutes" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Analytics view comparing scheduled shifts to actual time records to highlight variances." />
      </EntityType>
      <EntityType Name="DwTimeRecordByHourGroup">
        <Key>
          <PropertyRef Name="HourGroup" />
          <PropertyRef Name="TimeRecordId" />
        </Key>
        <Property Name="TimeRecordId" Type="Edm.Guid" Nullable="false" />
        <Property Name="HourGroup" Type="Edm.String" Nullable="false" />
        <Property Name="EltModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="TimeRecordType" Type="Edm.String" Nullable="false" />
        <Property Name="WorkDate" Type="Edm.Date" Nullable="false" />
        <Property Name="StartDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="StopDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="HourValue" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="ModifiedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PayPeriodId" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A breakdown of a time record into hour groups (regular, overtime, double time, etc.)." />
      </EntityType>
      <EntityType Name="DwTimeRecordEquipment">
        <Key>
          <PropertyRef Name="EquipmentId" />
          <PropertyRef Name="TimeRecordId" />
        </Key>
        <Property Name="TimeRecordId" Type="Edm.Guid" Nullable="false" />
        <Property Name="EquipmentId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EltModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="EquipmentName" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentNumber" Type="Edm.String" Nullable="false" />
        <Property Name="AlternateEquipmentNumber" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="Rate" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="EquipmentType" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Equipment usage recorded against a time record." />
      </EntityType>
      <EntityType Name="DwTimeOffPlanEmployee">
        <Key>
          <PropertyRef Name="TimeOffPlanEmployeeId" />
        </Key>
        <Property Name="TimeOffPlanEmployeeId" Type="Edm.Int32" Nullable="false" />
        <Property Name="TimeOffPlanId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="PlanStartDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PlanEndDate" Type="Edm.Date" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="ModifiedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="BalanceInHours" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="Tier" Type="Edm.Int32" />
        <NavigationProperty Name="TimeOffPlanEmployeeRequests" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlanEmployeeRequest)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's enrollment in a particular time-off plan, including accrual and balance settings." />
      </EntityType>
      <EntityType Name="DwTimeOffPlanEmployeeRequest">
        <Key>
          <PropertyRef Name="TimeOffPlanEmployeeRequestId" />
        </Key>
        <Property Name="TimeOffPlanEmployeeRequestId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="Status" Type="Edm.String" Nullable="false" />
        <Property Name="IncludeWeekends" Type="Edm.Boolean" Nullable="false" />
        <Property Name="TotalDurationInHours" Type="Edm.Decimal" Scale="variable" />
        <Property Name="Comments" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdApprovedBy" Type="Edm.Int32" />
        <Property Name="ApprovalDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="PersonIdCancelledBy" Type="Edm.Int32" />
        <Property Name="CancelDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="TimeOffPlanEmployeeId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="ModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="ApproverComments" Type="Edm.String" />
        <Property Name="MinRequestDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="MinRequestWorkDate" Type="Edm.Date" Nullable="false" />
        <Property Name="MaxRequestDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="MaxRequestWorkDate" Type="Edm.Date" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A specific time-off request submitted under an employee's time-off plan enrollment." />
      </EntityType>
      <EntityType Name="DwCourse">
        <Key>
          <PropertyRef Name="CourseId" />
        </Key>
        <Property Name="CourseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ReferenceNumber" Type="Edm.String" Nullable="false" />
        <Property Name="VersionNumber" Type="Edm.String" Nullable="false" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="TrainingType" Type="Edm.String" Nullable="false" />
        <Property Name="Description" Type="Edm.String" Nullable="false" />
        <Property Name="Duration" Type="Edm.String" Nullable="false" />
        <Property Name="Cost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="Ceu" Type="Edm.Int32" Nullable="false" />
        <Property Name="MasteryScore" Type="Edm.Int32" />
        <Property Name="ApprovalType" Type="Edm.String" Nullable="false" />
        <Property Name="ReviewFrequency" Type="Edm.String" Nullable="false" />
        <Property Name="ReferenceMaterialsLink" Type="Edm.String" Nullable="false" />
        <Property Name="ExternalEnrollmentLink" Type="Edm.String" Nullable="false" />
        <Property Name="CbtLink" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" />
        <Property Name="UpdatedDate" Type="Edm.Date" />
        <Property Name="LastReviewDate" Type="Edm.Date" />
        <Property Name="SmeName" Type="Edm.String" Nullable="false" />
        <Property Name="Author" Type="Edm.String" Nullable="false" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Property Name="Review" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RestrictAccessByPermissions" Type="Edm.Boolean" Nullable="false" />
        <Property Name="AcknowledgementDocumentName" Type="Edm.String" Nullable="false" />
        <Property Name="RequireAcknowledgement" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RequireAcknowledgementFailedCourseClass" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CustomAcknowledgement" Type="Edm.String" Nullable="false" />
        <Property Name="Categories" Type="Edm.String" Nullable="false" />
        <Property Name="Prerequisites" Type="Edm.String" Nullable="false" />
        <Property Name="Competencies" Type="Edm.String" Nullable="false" />
        <Property Name="TrainingProviderTypes" Type="Edm.String" Nullable="false" />
        <Property Name="Instructors" Type="Edm.String" Nullable="false" />
        <Property Name="IsAutoComplete" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsVisibleInDashboard" Type="Edm.Boolean" Nullable="false" />
        <NavigationProperty Name="CourseAssignments" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwCourseAssignment)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A training course offered through the learning management system." />
      </EntityType>
      <EntityType Name="DwCourseAssignment">
        <Key>
          <PropertyRef Name="CourseId" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="CourseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" />
        <Property Name="LastName" Type="Edm.String" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="EmployeeId" Type="Edm.String" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" />
        <Property Name="Department" Type="Edm.String" />
        <Property Name="JobCode" Type="Edm.String" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerFirstName" Type="Edm.String" />
        <Property Name="ManagerLastName" Type="Edm.String" />
        <Property Name="ManagerFullName" Type="Edm.String" />
        <Property Name="ManagerEmployeeId" Type="Edm.String" />
        <Property Name="IsAutoComplete" Type="Edm.Boolean" />
        <Property Name="CourseTitle" Type="Edm.String" />
        <Property Name="AssignedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="DueDate" Type="Edm.Date" />
        <Property Name="IsRequired" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsRecommended" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsCompleted" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CompletedDate" Type="Edm.Date" />
        <Property Name="RecurrenceType" Type="Edm.String" Nullable="false" />
        <Property Name="AssignmentType" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="ModifiedByFirstName" Type="Edm.String" />
        <Property Name="ModifiedByLastName" Type="Edm.String" />
        <Property Name="ModifiedByFullName" Type="Edm.String" />
        <Property Name="ModifiedByEmployeeId" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A course assigned to an employee, including due date and completion status." />
      </EntityType>
      <EntityType Name="DwCourseTranscript">
        <Key>
          <PropertyRef Name="PersonIdStudent" />
          <PropertyRef Name="Title" />
        </Key>
        <Property Name="PersonIdStudent" Type="Edm.Int32" Nullable="false" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="StudentName" Type="Edm.String" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ApprovalType" Type="Edm.String" Nullable="false" />
        <Property Name="Author" Type="Edm.String" Nullable="false" />
        <Property Name="Categories" Type="Edm.String" Nullable="false" />
        <Property Name="CbtLink" Type="Edm.String" Nullable="false" />
        <Property Name="Ceu" Type="Edm.Int32" Nullable="false" />
        <Property Name="ClassEndDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassEndTime" Type="Edm.DateTimeOffset" />
        <Property Name="ClassNumber" Type="Edm.String" />
        <Property Name="ClassStartDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassStartTime" Type="Edm.DateTimeOffset" />
        <Property Name="Competencies" Type="Edm.String" Nullable="false" />
        <Property Name="CompletionDate" Type="Edm.DateTimeOffset" />
        <Property Name="CompletionStatus" Type="Edm.String" />
        <Property Name="Cost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="CreatedDate" Type="Edm.Date" />
        <Property Name="UpdatedDate" Type="Edm.Date" />
        <Property Name="Description" Type="Edm.String" Nullable="false" />
        <Property Name="Duration" Type="Edm.String" Nullable="false" />
        <Property Name="Grade" Type="Edm.String" />
        <Property Name="Instructors" Type="Edm.String" Nullable="false" />
        <Property Name="LastReviewDate" Type="Edm.Date" />
        <Property Name="MasteryScore" Type="Edm.Int32" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Property Name="Prerequisites" Type="Edm.String" Nullable="false" />
        <Property Name="Review" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ReviewFrequency" Type="Edm.String" Nullable="false" />
        <Property Name="TrainingProviderTypes" Type="Edm.String" Nullable="false" />
        <Property Name="TrainingType" Type="Edm.String" Nullable="false" />
        <Property Name="VersionNumber" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A rollup view of an employee's completed courses across all assignments." />
      </EntityType>
      <EntityType Name="DwLearningPlan">
        <Key>
          <PropertyRef Name="LearningPlanId" />
        </Key>
        <Property Name="LearningPlanId" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="Title" Type="Edm.String" Nullable="false" />
        <Property Name="Description" Type="Edm.String" Nullable="false" />
        <Property Name="IsShowInSuccessionPlanOnly" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CreatedDateTime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="ModifiedDateTime" Type="Edm.DateTimeOffset" Nullable="false" />
        <NavigationProperty Name="LearningPlanTasks" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwLearningPlanTask)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A curated set of courses that employees are expected to complete (e.g., a curriculum or path)." />
      </EntityType>
      <EntityType Name="DwLearningPlanTask">
        <Key>
          <PropertyRef Name="LearningPlanTaskId" />
        </Key>
        <Property Name="LearningPlanTaskId" Type="Edm.Int32" Nullable="false" />
        <Property Name="LearningPlanId" Type="Edm.Int32" Nullable="false" />
        <Property Name="Title" Type="Edm.String" />
        <Property Name="Type" Type="Edm.String" Nullable="false" />
        <Property Name="Description" Type="Edm.String" />
        <Property Name="DaysToComplete" Type="Edm.Int32" />
        <Property Name="RequireManagerSignOff" Type="Edm.Boolean" />
        <Property Name="SortOrder" Type="Edm.Int32" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A single course or task within a learning plan." />
      </EntityType>
      <EntityType Name="DwTranscript">
        <Key>
          <PropertyRef Name="TranscriptId" />
        </Key>
        <Property Name="TranscriptId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdStudent" Type="Edm.Int32" />
        <Property Name="CourseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CourseTitle" Type="Edm.String" />
        <Property Name="CourseDescription" Type="Edm.String" />
        <Property Name="CourseReferenceNumber" Type="Edm.String" />
        <Property Name="CourseVersionNumber" Type="Edm.String" />
        <Property Name="CourseTrainingType" Type="Edm.String" />
        <Property Name="CourseCeu" Type="Edm.Int32" />
        <Property Name="CourseMasteryScore" Type="Edm.Int32" />
        <Property Name="CourseApprovalType" Type="Edm.String" />
        <Property Name="CourseReviewFrequency" Type="Edm.String" />
        <Property Name="CourseAuthor" Type="Edm.String" />
        <Property Name="CourseNotes" Type="Edm.String" />
        <Property Name="CourseCategories" Type="Edm.String" />
        <Property Name="CoursePrerequisites" Type="Edm.String" />
        <Property Name="CourseCompetencies" Type="Edm.String" />
        <Property Name="CourseInstructors" Type="Edm.String" />
        <Property Name="ClassNumber" Type="Edm.String" />
        <Property Name="ClassStartDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassEndDate" Type="Edm.DateTimeOffset" />
        <Property Name="ClassStartTime" Type="Edm.DateTimeOffset" />
        <Property Name="ClassEndTime" Type="Edm.DateTimeOffset" />
        <Property Name="Classroom" Type="Edm.String" />
        <Property Name="ClassCost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="Duration" Type="Edm.String" />
        <Property Name="ReferenceMaterialsLink" Type="Edm.String" />
        <Property Name="ExternalEnrollmentLink" Type="Edm.String" />
        <Property Name="CbtLink" Type="Edm.String" />
        <Property Name="CompletionStatus" Type="Edm.String" />
        <Property Name="CompletionDate" Type="Edm.DateTimeOffset" />
        <Property Name="Grade" Type="Edm.String" />
        <Property Name="Cost" Type="Edm.Decimal" Scale="variable" />
        <Property Name="AcknowledgeDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A historical training record for an employee." />
      </EntityType>
      <EntityType Name="DwTranscriptLastCompeleted">
        <Key>
          <PropertyRef Name="CourseId" />
          <PropertyRef Name="PersonIdStudent" />
        </Key>
        <Property Name="PersonIdStudent" Type="Edm.Int32" Nullable="false" />
        <Property Name="CourseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="StudentFullName" Type="Edm.String" Nullable="false" />
        <Property Name="CourseTitle" Type="Edm.String" />
        <Property Name="LastCompletionDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Latest completion record per employee per course. (Column name preserved from the source view.)" />
      </EntityType>
      <EntityType Name="DwUserLearningPlan">
        <Key>
          <PropertyRef Name="PersonId" />
          <PropertyRef Name="UserLearningPlanTaskId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="UserLearningPlanTaskId" Type="Edm.Int32" Nullable="false" />
        <Property Name="UserActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayName" Type="Edm.String" Nullable="false" />
        <Property Name="Username" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="JobCode" Type="Edm.String" Nullable="false" />
        <Property Name="JobTitle" Type="Edm.String" Nullable="false" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="TerminationDate" Type="Edm.Date" />
        <Property Name="Department" Type="Edm.String" Nullable="false" />
        <Property Name="CompanyLocationDescription" Type="Edm.String" Nullable="false" />
        <Property Name="LastPromotionDate" Type="Edm.Date" />
        <Property Name="NextEvaluationDate" Type="Edm.Date" />
        <Property Name="PersonIdManager" Type="Edm.Int32" />
        <Property Name="ManagerName" Type="Edm.String" />
        <Property Name="ManagerUserName" Type="Edm.String" />
        <Property Name="WorkPhone" Type="Edm.String" Nullable="false" />
        <Property Name="MobilePhone" Type="Edm.String" Nullable="false" />
        <Property Name="EmailAddress" Type="Edm.String" Nullable="false" />
        <Property Name="Ethnicity" Type="Edm.String" Nullable="false" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="LearningPlanId" Type="Edm.Int32" />
        <Property Name="LearningPlanActive" Type="Edm.Boolean" />
        <Property Name="LearningPlanTitle" Type="Edm.String" />
        <Property Name="LearningPlanDescription" Type="Edm.String" />
        <Property Name="LearningPlanCreatedDate" Type="Edm.DateTimeOffset" />
        <Property Name="LearningPlanModifiedDate" Type="Edm.DateTimeOffset" />
        <Property Name="CompletedDate" Type="Edm.DateTimeOffset" />
        <Property Name="LearningPlanTaskId" Type="Edm.Int32" />
        <Property Name="LearningPlanTaskTitle" Type="Edm.String" />
        <Property Name="LearningPlanTaskType" Type="Edm.String" />
        <Property Name="LearningPlanTaskDescription" Type="Edm.String" />
        <Property Name="DaysToComplete" Type="Edm.Int32" />
        <Property Name="RequireManagerSignOff" Type="Edm.Boolean" />
        <Property Name="SortOrder" Type="Edm.Int32" />
        <Property Name="AssignedDate" Type="Edm.DateTimeOffset" />
        <Property Name="LearningPlanTaskCompletedDate" Type="Edm.DateTimeOffset" />
        <Property Name="LearningPlanStatus" Type="Edm.String" />
        <Property Name="TaskStatus" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's enrollment in a learning plan, including overall progress." />
      </EntityType>
      <EntityType Name="DwUserLearningPlanTask">
        <Key>
          <PropertyRef Name="UserLearningPlanTaskId" />
        </Key>
        <Property Name="UserLearningPlanTaskId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="LearningPlanTaskId" Type="Edm.Int32" Nullable="false" />
        <Property Name="LearningPlanId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AssignedDate" Type="Edm.DateTimeOffset" />
        <Property Name="TaskStatus" Type="Edm.String" Nullable="false" />
        <Property Name="LearningPlanStatus" Type="Edm.String" />
        <Property Name="CompletedDate" Type="Edm.DateTimeOffset" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's completion status of a specific task within a learning plan." />
      </EntityType>
      <EntityType Name="DwLicense">
        <Key>
          <PropertyRef Name="LicenseName" />
        </Key>
        <Property Name="LicenseName" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="LicenseCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.DateTimeOffset" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A professional license type tracked by the company (name, requirements, expiration rules)." />
      </EntityType>
      <EntityType Name="DwEvaluationForm">
        <Key>
          <PropertyRef Name="EvaluationFormId" />
        </Key>
        <Property Name="EvaluationFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FormName" Type="Edm.String" Nullable="false" />
        <Property Name="FormType" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RequireSignOff" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RequireLocationManagerSignoff" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RequireManagerPostApproval" Type="Edm.Boolean" Nullable="false" />
        <Property Name="RequireEmployeeSignoffOnManagerEvaluation" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <NavigationProperty Name="EvaluationFormSections" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationFormSection)" />
        <NavigationProperty Name="EvaluationFormQuestions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationFormQuestion)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A performance evaluation form template - the structure of sections and questions used to evaluate employees." />
      </EntityType>
      <EntityType Name="DwEvaluationFormQuestion">
        <Key>
          <PropertyRef Name="EvaluationFormQuestionId" />
        </Key>
        <Property Name="EvaluationFormQuestionId" Type="Edm.Int64" Nullable="false" />
        <Property Name="EvaluationFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FormName" Type="Edm.String" />
        <Property Name="FormType" Type="Edm.String" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsRequired" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsForCurrentGoals" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsForFutureGoals" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="SortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormSectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SectionName" Type="Edm.String" />
        <Property Name="ScoringWeightPercent" Type="Edm.Double" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionTextShort" Type="Edm.String" />
        <Property Name="QuestionTextHtml" Type="Edm.String" Nullable="false" />
        <Property Name="Choices" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A single question that appears on a performance evaluation form." />
      </EntityType>
      <EntityType Name="DwEvaluationFormSection">
        <Key>
          <PropertyRef Name="EvaluationFormSectionId" />
        </Key>
        <Property Name="EvaluationFormSectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FormName" Type="Edm.String" />
        <Property Name="SortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsForCurrentGoals" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsForFutureGoals" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ScoringWeightPercent" Type="Edm.Double" Nullable="false" />
        <Property Name="SectionName" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A section grouping related questions on a performance evaluation form." />
      </EntityType>
      <EntityType Name="DwPerformanceEvaluation">
        <Key>
          <PropertyRef Name="PerformanceEvaluationId" />
        </Key>
        <Property Name="PerformanceEvaluationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FormName" Type="Edm.String" Nullable="false" />
        <Property Name="IsFormActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="FormType" Type="Edm.String" Nullable="false" />
        <Property Name="AssignmentType" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdRatee" Type="Edm.Int32" />
        <Property Name="RateeFullName" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdRater" Type="Edm.Int32" />
        <Property Name="RaterFullName" Type="Edm.String" Nullable="false" />
        <Property Name="AssignedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="MustCompleteByDays" Type="Edm.Int32" />
        <Property Name="IsComplete" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CompletionDate" Type="Edm.Date" />
        <Property Name="EvaluationScore" Type="Edm.Decimal" Scale="variable" />
        <Property Name="WorkflowDescription" Type="Edm.String" Nullable="false" />
        <Property Name="PersonIdNextWorkflow" Type="Edm.Int32" />
        <Property Name="NextWorkflowUserFullName" Type="Edm.String" />
        <Property Name="PerformanceEvaluationIdLinkedManager" Type="Edm.Int32" />
        <NavigationProperty Name="PerformanceEvaluationAnswers" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationAnswer)" />
        <NavigationProperty Name="PerformanceEvaluationSections" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationSection)" />
        <NavigationProperty Name="PerformanceEvaluationWorkflows" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationWorkflow)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A performance evaluation conducted on an employee - combining the form, the participants, and the responses." />
      </EntityType>
      <EntityType Name="DwPerformanceEvaluationAnswer">
        <Key>
          <PropertyRef Name="PerformanceEvaluationId" />
          <PropertyRef Name="PersonIdRatee" />
          <PropertyRef Name="PersonIdRater" />
        </Key>
        <Property Name="PerformanceEvaluationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdRatee" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdRater" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormId" Type="Edm.Int32" />
        <Property Name="FormName" Type="Edm.String" />
        <Property Name="RateeFullName" Type="Edm.String" />
        <Property Name="RaterFullName" Type="Edm.String" />
        <Property Name="EvaluationFormSectionId" Type="Edm.Int32" />
        <Property Name="SectionName" Type="Edm.String" />
        <Property Name="SortOrder" Type="Edm.Int32" />
        <Property Name="EvaluationFormQuestionId" Type="Edm.Int64" />
        <Property Name="QuestionTextShort" Type="Edm.String" />
        <Property Name="Choices" Type="Edm.String" />
        <Property Name="AnswerDisplay" Type="Edm.String" />
        <Property Name="AnswerValue" Type="Edm.String" />
        <Property Name="AnswerDate" Type="Edm.Date" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A single answer given on a performance evaluation, capturing the rater, ratee, and response." />
      </EntityType>
      <EntityType Name="DwPerformanceEvaluationSection">
        <Key>
          <PropertyRef Name="EvaluationFormSectionId" />
          <PropertyRef Name="PerformanceEvaluationId" />
        </Key>
        <Property Name="PerformanceEvaluationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormSectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="EvaluationFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="FormName" Type="Edm.String" />
        <Property Name="EvaluationScore" Type="Edm.Decimal" Scale="variable" />
        <Property Name="SortOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="SectionName" Type="Edm.String" Nullable="false" />
        <Property Name="ScoringWeightPercent" Type="Edm.Double" Nullable="false" />
        <Property Name="SectionScore" Type="Edm.Decimal" Scale="variable" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A section of a specific performance evaluation, including its score and weighting." />
      </EntityType>
      <EntityType Name="DwPerformanceEvaluationWorkflow">
        <Key>
          <PropertyRef Name="PerformanceEvaluationId" />
          <PropertyRef Name="WorkflowSequence" />
        </Key>
        <Property Name="PerformanceEvaluationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="WorkflowSequence" Type="Edm.Int32" Nullable="false" />
        <Property Name="ApproverSequence" Type="Edm.Int32" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="UserFullName" Type="Edm.String" />
        <Property Name="RoleDescription" Type="Edm.String" Nullable="false" />
        <Property Name="IsComplete" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CompletionDate" Type="Edm.Date" />
        <Property Name="Notes" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A workflow step in a performance evaluation (manager review, employee acknowledgment, etc.)." />
      </EntityType>
      <EntityType Name="DwSurveyQuestion">
        <Key>
          <PropertyRef Name="SurveyQuestionId" />
        </Key>
        <Property Name="SurveyQuestionId" Type="Edm.String" Nullable="false" />
        <Property Name="SurveyId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SurveyName" Type="Edm.String" Nullable="false" />
        <Property Name="SurveyIsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="SurveyIsAnonymous" Type="Edm.Boolean" Nullable="false" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="QuestionIsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ReplyType" Type="Edm.String" Nullable="false" />
        <Property Name="ReplyOptions" Type="Edm.String" Nullable="false" />
        <Property Name="CorrectReplyOptions" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A question that appears on a company survey." />
      </EntityType>
      <EntityType Name="DwSurveyResponse">
        <Key>
          <PropertyRef Name="SurveyResponseId" />
        </Key>
        <Property Name="SurveyResponseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SurveyId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SurveyName" Type="Edm.String" Nullable="false" />
        <Property Name="SurveyQuestionId" Type="Edm.String" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="FullName" Type="Edm.String" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="Response" Type="Edm.String" Nullable="false" />
        <Property Name="ResponseDate" Type="Edm.Date" Nullable="false" />
        <Property Name="IsCorrectResponse" Type="Edm.Boolean" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's response to a survey." />
      </EntityType>
      <EntityType Name="DwSurveyResponseAggregate">
        <Key>
          <PropertyRef Name="SurveyId" />
          <PropertyRef Name="SurveyQuestionId" />
        </Key>
        <Property Name="SurveyId" Type="Edm.Int32" Nullable="false" />
        <Property Name="SurveyQuestionId" Type="Edm.String" Nullable="false" />
        <Property Name="SurveyName" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="Response" Type="Edm.String" Nullable="false" />
        <Property Name="IsCorrectResponse" Type="Edm.Boolean" />
        <Property Name="ResponseCount" Type="Edm.Int32" />
        <Property Name="DistinctUserResponseCount" Type="Edm.Int32" />
        <Property Name="FirstResponseDate" Type="Edm.Date" />
        <Property Name="LastResponseDate" Type="Edm.Date" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Aggregated survey response counts per question per survey, suitable for reporting." />
      </EntityType>
      <EntityType Name="DwBenefitElection">
        <Key>
          <PropertyRef Name="BenefitElectionId" />
        </Key>
        <Property Name="BenefitElectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonId" Type="Edm.Int32" />
        <Property Name="FirstName" Type="Edm.String" Nullable="false" />
        <Property Name="LastName" Type="Edm.String" Nullable="false" />
        <Property Name="FullName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeId" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitName" Type="Edm.String" Nullable="false" />
        <Property Name="PlanName" Type="Edm.String" Nullable="false" />
        <Property Name="OptionName" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitPackageId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PackageName" Type="Edm.String" Nullable="false" />
        <Property Name="PackageEffectiveDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PackageExpirationDate" Type="Edm.Date" Nullable="false" />
        <Property Name="ElectionEffectiveDate" Type="Edm.Date" Nullable="false" />
        <Property Name="ElectionExpirationDate" Type="Edm.Date" Nullable="false" />
        <Property Name="CoverageAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualPremiumAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualEmployeeCost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualEmployerCost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualCreditAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualPreTaxDeduction" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="AnnualPostTaxDeduction" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodPremiumAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodEmployeeCost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodEmployerCost" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodCreditAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodPreTaxDeduction" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PayPeriodPostTaxDeduction" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="PrimaryCareProvider1" Type="Edm.String" Nullable="false" />
        <Property Name="PrimaryCareProvider2" Type="Edm.String" Nullable="false" />
        <Property Name="PayPeriodCount" Type="Edm.Int16" />
        <Property Name="EoiCoverageAmount" Type="Edm.Decimal" Scale="variable" />
        <NavigationProperty Name="BenefitElectionBeneficiaries" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElectionBeneficiary)" />
        <NavigationProperty Name="BenefitElectionDependents" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElectionDependent)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employee's election in a benefits enrollment - the plan they chose, the cost, and the coverage." />
      </EntityType>
      <EntityType Name="DwBenefitElectionBeneficiary">
        <Key>
          <PropertyRef Name="BenefitElectionId" />
          <PropertyRef Name="UserAssociatedPersonId" />
        </Key>
        <Property Name="BenefitElectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="UserAssociatedPersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdEmployee" Type="Edm.Int32" />
        <Property Name="EmployeeFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeLastName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeFullName" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitName" Type="Edm.String" Nullable="false" />
        <Property Name="PlanName" Type="Edm.String" Nullable="false" />
        <Property Name="OptionName" Type="Edm.String" Nullable="false" />
        <Property Name="PackageName" Type="Edm.String" Nullable="false" />
        <Property Name="Relationship" Type="Edm.String" Nullable="false" />
        <Property Name="RelationshipCategory" Type="Edm.String" Nullable="false" />
        <Property Name="IsPrimaryBeneficiary" Type="Edm.Boolean" Nullable="false" />
        <Property Name="BeneficiaryPercentage" Type="Edm.Int32" Nullable="false" />
        <Property Name="BeneficiaryEffectiveDate" Type="Edm.Date" Nullable="false" />
        <Property Name="BeneficiaryExpirationDate" Type="Edm.Date" Nullable="false" />
        <Property Name="BeneficiaryFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="BeneficiaryMiddleName" Type="Edm.String" Nullable="false" />
        <Property Name="BeneficiaryLastName" Type="Edm.String" Nullable="false" />
        <Property Name="BeneficiarySuffix" Type="Edm.String" Nullable="false" />
        <Property Name="BeneficiaryFullName" Type="Edm.String" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="CommitmentDate" Type="Edm.Date" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="IsFullTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsPartTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="StudentHours" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsTobaccoUser" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsDisabled" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsHouseholdMember" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsQmcso" Type="Edm.Boolean" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A beneficiary designated by an employee on a benefit election (life insurance, retirement, etc.)." />
      </EntityType>
      <EntityType Name="DwBenefitElectionDependent">
        <Key>
          <PropertyRef Name="BenefitElectionId" />
          <PropertyRef Name="UserAssociatedPersonId" />
        </Key>
        <Property Name="BenefitElectionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="UserAssociatedPersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PersonIdEmployee" Type="Edm.Int32" />
        <Property Name="EmployeeFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeLastName" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeFullName" Type="Edm.String" Nullable="false" />
        <Property Name="BenefitName" Type="Edm.String" Nullable="false" />
        <Property Name="PlanName" Type="Edm.String" Nullable="false" />
        <Property Name="OptionName" Type="Edm.String" Nullable="false" />
        <Property Name="PackageName" Type="Edm.String" Nullable="false" />
        <Property Name="Relationship" Type="Edm.String" Nullable="false" />
        <Property Name="RelationshipCategory" Type="Edm.String" Nullable="false" />
        <Property Name="DependentFirstName" Type="Edm.String" Nullable="false" />
        <Property Name="DependentMiddleName" Type="Edm.String" Nullable="false" />
        <Property Name="DependentLastName" Type="Edm.String" Nullable="false" />
        <Property Name="DependentSuffix" Type="Edm.String" Nullable="false" />
        <Property Name="DependentFullName" Type="Edm.String" Nullable="false" />
        <Property Name="DateOfBirth" Type="Edm.Date" />
        <Property Name="CommitmentDate" Type="Edm.Date" />
        <Property Name="Gender" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="MaskedTaxIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="IsFullTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsPartTimeStudent" Type="Edm.Boolean" Nullable="false" />
        <Property Name="StudentHours" Type="Edm.Int32" Nullable="false" />
        <Property Name="IsTobaccoUser" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsDisabled" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsHouseholdMember" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsQmcso" Type="Edm.Boolean" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A dependent enrolled on an employee's benefit election (health, dental, etc.)." />
      </EntityType>
      <EntityType Name="DwBenefitPackage">
        <Key>
          <PropertyRef Name="BenefitPackageId" />
        </Key>
        <Property Name="BenefitPackageId" Type="Edm.Int32" Nullable="false" />
        <Property Name="PackageName" Type="Edm.String" Nullable="false" />
        <Property Name="PackageEffectiveDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PackageExpirationDate" Type="Edm.Date" Nullable="false" />
        <Property Name="BenefitNames" Type="Edm.String" Nullable="false" />
        <Property Name="OpenEnrollmentStartDate" Type="Edm.Date" />
        <Property Name="OpenEnrollmentEndDate" Type="Edm.Date" />
        <Property Name="OpenEnrollmentNotStartedCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="OpenEnrollmentStartedCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="OpenEnrollmentCompletedCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="ElectionCount" Type="Edm.Int32" Nullable="false" />
        <NavigationProperty Name="BenefitElections" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElection)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A benefits package offered to employees - groups the plans eligible during a given enrollment window." />
      </EntityType>
      <EntityType Name="DwMobileForm">
        <Key>
          <PropertyRef Name="MobileFormId" />
        </Key>
        <Property Name="MobileFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormName" Type="Edm.String" Nullable="false" />
        <Property Name="MobileFormType" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsCustomForm" Type="Edm.Boolean" Nullable="false" />
        <Property Name="MobileFormQuestionId" Type="Edm.Guid" />
        <Property Name="QuestionName" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="ResponseType" Type="Edm.String" Nullable="false" />
        <Property Name="ResponseBaseType" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayOrder" Type="Edm.Int32" Nullable="false" />
        <NavigationProperty Name="MobileFormVersions" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormVersion)" />
        <NavigationProperty Name="MobileFormResponses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormResponse)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom form configured for use in the Arcoro mobile app (safety checklists, daily reports, etc.)." />
      </EntityType>
      <EntityType Name="DwMobileFormResponse">
        <Key>
          <PropertyRef Name="MobileFormResponseId" />
        </Key>
        <Property Name="MobileFormResponseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormVersionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormName" Type="Edm.String" Nullable="false" />
        <Property Name="MobileFormQuestionId" Type="Edm.Guid" />
        <Property Name="MobileFormVersionQuestionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="QuestionName" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="ModifiedDate" Type="Edm.Date" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="TimeRecordId" Type="Edm.Guid" />
        <Property Name="TimePunchId" Type="Edm.Guid" />
        <Property Name="ResponseValueId" Type="Edm.Guid" />
        <Property Name="ResponseValueText" Type="Edm.String" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="EquipmentId" Type="Edm.Int32" />
        <Property Name="ChoiceEnglishDisplay" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A submitted response to a mobile form by an employee." />
      </EntityType>
      <EntityType Name="DwMobileFormVersion">
        <Key>
          <PropertyRef Name="MobileFormVersionId" />
        </Key>
        <Property Name="MobileFormVersionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormName" Type="Edm.String" Nullable="false" />
        <Property Name="MobileFormType" Type="Edm.String" Nullable="false" />
        <Property Name="IsLatestVersion" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsCustomForm" Type="Edm.Boolean" Nullable="false" />
        <Property Name="VersionNumber" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormQuestionId" Type="Edm.Guid" />
        <Property Name="MobileFormVersionQuestionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="QuestionName" Type="Edm.String" Nullable="false" />
        <Property Name="QuestionText" Type="Edm.String" Nullable="false" />
        <Property Name="ResponseType" Type="Edm.String" Nullable="false" />
        <Property Name="ResponseBaseType" Type="Edm.String" Nullable="false" />
        <Property Name="DisplayOrder" Type="Edm.Int32" Nullable="false" />
        <NavigationProperty Name="MobileFormVersionQuestionChoices" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormVersionQuestionChoice)" />
        <NavigationProperty Name="MobileFormResponses" Type="Collection(Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormResponse)" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A specific version of a mobile form. Forms are versioned so historical responses remain interpretable." />
      </EntityType>
      <EntityType Name="DwMobileFormVersionQuestionChoice">
        <Key>
          <PropertyRef Name="DisplayOrder" />
          <PropertyRef Name="MobileFormVersionId" />
          <PropertyRef Name="MobileFormVersionQuestionId" />
        </Key>
        <Property Name="MobileFormVersionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MobileFormVersionQuestionId" Type="Edm.Int32" Nullable="false" />
        <Property Name="DisplayOrder" Type="Edm.Int32" Nullable="false" />
        <Property Name="EnglishDisplay" Type="Edm.String" Nullable="false" />
        <Property Name="ChoiceValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A multiple-choice option offered for a question on a mobile form." />
      </EntityType>
      <EntityType Name="DwExpense">
        <Key>
          <PropertyRef Name="ExpenseId" />
        </Key>
        <Property Name="ExpenseId" Type="Edm.Int32" Nullable="false" />
        <Property Name="ExpenseDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PersonIdEmployee" Type="Edm.Int32" />
        <Property Name="Note" Type="Edm.String" Nullable="false" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="ExpenseAmount" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" />
        <Property Name="ModifiedDate" Type="Edm.Date" />
        <Property Name="PersonIdModifiedBy" Type="Edm.Int32" />
        <Property Name="IsExported" Type="Edm.Boolean" Nullable="false" />
        <Property Name="ExpenseTypeName" Type="Edm.String" Nullable="false" />
        <Property Name="ExpenseTypeIdentifier" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An expense submitted by an employee for reimbursement (mileage, materials, per diem, etc.)." />
      </EntityType>
      <EntityType Name="DwExpenseCustomField">
        <Key>
          <PropertyRef Name="FieldName" />
          <PropertyRef Name="FieldNumber" />
        </Key>
        <Property Name="FieldNumber" Type="Edm.Byte" Nullable="false" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="ExpenseId" Type="Edm.Int32" />
        <Property Name="FieldValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom (company-defined) field captured on expense entries." />
      </EntityType>
      <EntityType Name="DwCostCode">
        <Key>
          <PropertyRef Name="CostCodeId" />
        </Key>
        <Property Name="CostCodeId" Type="Edm.Guid" Nullable="false" />
        <Property Name="CostCodeIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeDescription" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeType" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeCategory" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeIsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="CostCodeGroups" Type="Edm.String" Nullable="false" />
        <Property Name="FieldNotes" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A cost code used to allocate labor, equipment, or expenses to jobs and accounts." />
      </EntityType>
      <EntityType Name="DwCostCodeCustomField">
        <Key>
          <PropertyRef Name="FieldName" />
          <PropertyRef Name="FieldNumber" />
        </Key>
        <Property Name="FieldNumber" Type="Edm.Byte" Nullable="false" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="FieldValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom (company-defined) field captured on cost codes." />
      </EntityType>
      <EntityType Name="DwCostCodeFieldNote">
        <Key>
          <PropertyRef Name="CreatedDate" />
          <PropertyRef Name="PersonIdCreatedBy" />
        </Key>
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="CostCodeId" Type="Edm.Guid" />
        <Property Name="CostCodeIdentifier" Type="Edm.String" />
        <Property Name="CostCodeDescription" Type="Edm.String" />
        <Property Name="Note" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByFullName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A free-text note attached to a cost code by a user." />
      </EntityType>
      <EntityType Name="DwUserCoreCostCode">
        <Key>
          <PropertyRef Name="CostCodeLevel" />
          <PropertyRef Name="PersonId" />
        </Key>
        <Property Name="PersonId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CostCodeLevel" Type="Edm.Int32" Nullable="false" />
        <Property Name="CostCodeId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CostCodeIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeName" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeLevelName" Type="Edm.String" Nullable="false" />
        <Property Name="CostCodeIsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="SourceSystem" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A Core HR cost code assigned to a user (0-5 per user, one per cost code level); expandable from DwUser via CoreCostCodes. Distinct from the Arcoro Time cost codes in DwCostCode — see SourceSystem." />
      </EntityType>
      <EntityType Name="DwLocation">
        <Key>
          <PropertyRef Name="LocationId" />
        </Key>
        <Property Name="LocationId" Type="Edm.Int32" Nullable="false" />
        <Property Name="LocationName" Type="Edm.String" Nullable="false" />
        <Property Name="LocationIdentifier" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine1" Type="Edm.String" Nullable="false" />
        <Property Name="AddressLine2" Type="Edm.String" Nullable="false" />
        <Property Name="City" Type="Edm.String" Nullable="false" />
        <Property Name="StateProvince" Type="Edm.String" Nullable="false" />
        <Property Name="PostalCode" Type="Edm.String" Nullable="false" />
        <Property Name="CountryCode" Type="Edm.String" Nullable="false" />
        <Property Name="Latitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="Longitude" Type="Edm.Decimal" Scale="variable" />
        <Property Name="GeoFenceRadiusMeters" Type="Edm.Int32" />
        <Property Name="HomePhone" Type="Edm.String" Nullable="false" />
        <Property Name="MobilePhone" Type="Edm.String" Nullable="false" />
        <Property Name="Email" Type="Edm.String" Nullable="false" />
        <Property Name="LocationGroups" Type="Edm.String" Nullable="false" />
        <Property Name="ContactName" Type="Edm.String" Nullable="false" />
        <Property Name="TimeZone" Type="Edm.String" Nullable="false" />
        <Property Name="DefaultStartTime" Type="Edm.String" Nullable="false" />
        <Property Name="DefaultEndTime" Type="Edm.String" Nullable="false" />
        <Property Name="Category" Type="Edm.String" Nullable="false" />
        <Property Name="JobType" Type="Edm.String" Nullable="false" />
        <Property Name="IsActive" Type="Edm.Boolean" Nullable="false" />
        <Property Name="FieldNotes" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A physical location (jobsite, office, etc.) used by the company." />
      </EntityType>
      <EntityType Name="DwLocationCustomField">
        <Key>
          <PropertyRef Name="FieldName" />
          <PropertyRef Name="FieldNumber" />
        </Key>
        <Property Name="FieldNumber" Type="Edm.Byte" Nullable="false" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="FieldValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom (company-defined) field captured on locations." />
      </EntityType>
      <EntityType Name="DwLocationFieldNote">
        <Key>
          <PropertyRef Name="CreatedDate" />
          <PropertyRef Name="PersonIdCreatedBy" />
        </Key>
        <Property Name="PersonIdCreatedBy" Type="Edm.Int32" Nullable="false" />
        <Property Name="CreatedDate" Type="Edm.Date" Nullable="false" />
        <Property Name="LocationId" Type="Edm.Int32" />
        <Property Name="LocationName" Type="Edm.String" />
        <Property Name="Note" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByFullName" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A free-text note attached to a location by a user." />
      </EntityType>
      <EntityType Name="DwEquipmentCustomField">
        <Key>
          <PropertyRef Name="FieldName" />
          <PropertyRef Name="FieldNumber" />
        </Key>
        <Property Name="FieldNumber" Type="Edm.Byte" Nullable="false" />
        <Property Name="FieldName" Type="Edm.String" Nullable="false" />
        <Property Name="EquipmentId" Type="Edm.Int32" />
        <Property Name="FieldValue" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A custom (company-defined) field captured on equipment records." />
      </EntityType>
      <EntityType Name="DwSmsMessage">
        <Key>
          <PropertyRef Name="CandidateId" />
          <PropertyRef Name="MessageDatetime" />
        </Key>
        <Property Name="CandidateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="MessageDatetime" Type="Edm.DateTimeOffset" Nullable="false" />
        <Property Name="AccountName" Type="Edm.String" Nullable="false" />
        <Property Name="RecruiterName" Type="Edm.String" Nullable="false" />
        <Property Name="SmsSeatPhoneNumber" Type="Edm.String" Nullable="false" />
        <Property Name="CandidateName" Type="Edm.String" />
        <Property Name="CandidatePhoneNumber" Type="Edm.String" />
        <Property Name="CandidateOptInOut" Type="Edm.String" Nullable="false" />
        <Property Name="ActivityType" Type="Edm.String" Nullable="false" />
        <Property Name="MessageText" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An SMS message exchanged with a candidate during the recruiting process." />
      </EntityType>
      <EntityType Name="DwAccount">
        <Key>
          <PropertyRef Name="AccountId" />
        </Key>
        <Property Name="AccountId" Type="Edm.Int32" Nullable="false" />
        <Property Name="AccountName" Type="Edm.String" Nullable="false" />
        <Property Name="AccountAbbrev" Type="Edm.String" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A customer account - the top-level commercial entity that one or more Arcoro companies roll up to." />
      </EntityType>
      <EntityType Name="DwDataExport">
        <Key>
          <PropertyRef Name="DataExportId" />
        </Key>
        <Property Name="DataExportId" Type="Edm.Int32" Nullable="false" />
        <Property Name="CompanyName" Type="Edm.String" Nullable="false" />
        <Property Name="EnterpriseName" Type="Edm.String" Nullable="false" />
        <Property Name="ExportName" Type="Edm.String" Nullable="false" />
        <Property Name="DataType" Type="Edm.String" Nullable="false" />
        <Property Name="ExportType" Type="Edm.String" Nullable="false" />
        <Property Name="TransferType" Type="Edm.String" Nullable="false" />
        <Property Name="ExportFormat" Type="Edm.String" Nullable="false" />
        <Property Name="Carrier" Type="Edm.String" Nullable="false" />
        <Property Name="ExportList" Type="Edm.String" Nullable="false" />
        <Property Name="NotificationList" Type="Edm.String" Nullable="false" />
        <Property Name="OutputFileName" Type="Edm.String" Nullable="false" />
        <Property Name="DataExportCategory" Type="Edm.String" Nullable="false" />
        <Property Name="Packages" Type="Edm.String" Nullable="false" />
        <Property Name="Benefits" Type="Edm.String" Nullable="false" />
        <Property Name="LastExportSucceeded" Type="Edm.Boolean" />
        <Property Name="StartDate" Type="Edm.Date" />
        <Property Name="StopDate" Type="Edm.Date" />
        <Property Name="LastSuccessfulExportDate" Type="Edm.Date" />
        <Property Name="NextScheduleExportDate" Type="Edm.Date" />
        <Property Name="LastFailedExportDate" Type="Edm.Date" />
        <Property Name="LastFailedExportErrorMessage" Type="Edm.String" Nullable="false" />
        <Property Name="FtpuserName" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A scheduled or one-time data export configured by the company." />
      </EntityType>
      <EntityType Name="DwDate">
        <Key>
          <PropertyRef Name="DateId" />
        </Key>
        <Property Name="DateId" Type="Edm.Int32" Nullable="false" />
        <Property Name="DateValue" Type="Edm.Date" Nullable="false" />
        <Property Name="DateString" Type="Edm.String" Nullable="false" />
        <Property Name="DayOfWeek" Type="Edm.Byte" Nullable="false" />
        <Property Name="DayOfWeekName" Type="Edm.String" Nullable="false" />
        <Property Name="DayOfMonth" Type="Edm.Byte" Nullable="false" />
        <Property Name="DayOfYear" Type="Edm.Int16" Nullable="false" />
        <Property Name="WeekOfYear" Type="Edm.Byte" Nullable="false" />
        <Property Name="MonthName" Type="Edm.String" Nullable="false" />
        <Property Name="MonthOfYear" Type="Edm.Byte" Nullable="false" />
        <Property Name="CalendarQuarter" Type="Edm.Byte" Nullable="false" />
        <Property Name="CalendarYear" Type="Edm.Int16" Nullable="false" />
        <Property Name="IsWeekend" Type="Edm.Boolean" Nullable="false" />
        <Property Name="IsLeapYear" Type="Edm.Boolean" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A row in the calendar dimension - one per date - used to group and filter analytics by day, week, month, quarter, or year." />
      </EntityType>
      <EntityType Name="DwEmployer">
        <Key>
          <PropertyRef Name="EmployerId" />
        </Key>
        <Property Name="EmployerId" Type="Edm.String" Nullable="false" />
        <Property Name="EmployerName" Type="Edm.String" Nullable="false" />
        <Property Name="Ein" Type="Edm.String" Nullable="false" />
        <Property Name="EmployeeCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="ActiveCount" Type="Edm.Int32" Nullable="false" />
        <Property Name="InactiveCount" Type="Edm.Int32" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An employer entity used by tax and payroll calculations. A single company may have multiple employers for different tax jurisdictions." />
      </EntityType>
      <EntityType Name="DwHrMetricByMonth">
        <Key>
          <PropertyRef Name="MonthStart" />
        </Key>
        <Property Name="MonthStart" Type="Edm.Date" Nullable="false" />
        <Property Name="CompanyName" Type="Edm.String" Nullable="false" />
        <Property Name="MonthEnd" Type="Edm.Date" Nullable="false" />
        <Property Name="MonthOfYear" Type="Edm.Byte" Nullable="false" />
        <Property Name="MonthName" Type="Edm.String" Nullable="false" />
        <Property Name="CalendarYear" Type="Edm.Int16" Nullable="false" />
        <Property Name="StartingActive" Type="Edm.Int32" Nullable="false" />
        <Property Name="EndingActive" Type="Edm.Int32" Nullable="false" />
        <Property Name="HiredDuringMonth" Type="Edm.Int32" Nullable="false" />
        <Property Name="TerminatedDuringMonth" Type="Edm.Int32" Nullable="false" />
        <Property Name="ChurnPercent" Type="Edm.Decimal" Nullable="false" Scale="variable" />
        <Annotation Term="Org.OData.Core.V1.Description" String="Aggregated monthly HR metrics per company (headcount, hires, terminations, etc.) for trending and analytics." />
      </EntityType>
      <EntityType Name="DwAdvancedAnalyticsReport">
        <Key>
          <PropertyRef Name="AdvancedAnalyticsReportId" />
        </Key>
        <Property Name="AdvancedAnalyticsReportId" Type="Edm.Guid" Nullable="false" />
        <Property Name="CompanyName" Type="Edm.String" />
        <Property Name="ReportName" Type="Edm.String" Nullable="false" />
        <Property Name="ReportType" Type="Edm.String" Nullable="false" />
        <Property Name="IsDeleted" Type="Edm.Boolean" />
        <Property Name="CreatedDate" Type="Edm.Date" />
        <Property Name="CreatedByName" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByEmail" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedDate" Type="Edm.Date" />
        <Property Name="ModifiedByName" Type="Edm.String" />
        <Property Name="ModifiedByEmail" Type="Edm.String" Nullable="false" />
        <Property Name="LastViewedDatetime" Type="Edm.DateTimeOffset" />
        <Property Name="ViewCount" Type="Edm.Int64" />
        <Property Name="LastRenderDuration" Type="Edm.TimeOfDay" />
        <Annotation Term="Org.OData.Core.V1.Description" String="An Advanced Analytics report available to your subscription, including who created it and when it was last viewed." />
      </EntityType>
      <EntityType Name="DwAdvancedAnalyticsScheduled">
        <Key>
          <PropertyRef Name="CreatedByEmail" />
          <PropertyRef Name="ReportType" />
        </Key>
        <Property Name="ReportType" Type="Edm.String" Nullable="false" />
        <Property Name="CreatedByEmail" Type="Edm.String" Nullable="false" />
        <Property Name="CompanyName" Type="Edm.String" />
        <Property Name="SubscriptionName" Type="Edm.String" />
        <Property Name="AdvancedAnalyticsReportId" Type="Edm.Guid" />
        <Property Name="ReportName" Type="Edm.String" />
        <Property Name="Schedule" Type="Edm.String" />
        <Property Name="Filters" Type="Edm.String" />
        <Property Name="TimeZoneValue" Type="Edm.String" />
        <Property Name="ScheduleStartDate" Type="Edm.Date" />
        <Property Name="ScheduleEndDate" Type="Edm.Date" />
        <Property Name="ScheduleTime" Type="Edm.String" />
        <Property Name="LastSuccessfulRunDate" Type="Edm.Date" />
        <Property Name="NextScheduledRunDate" Type="Edm.Date" />
        <Property Name="DeliveryType" Type="Edm.String" />
        <Property Name="Recipients" Type="Edm.String" />
        <Property Name="IsDeleted" Type="Edm.Boolean" />
        <Property Name="CreatedDate" Type="Edm.Date" />
        <Property Name="CreatedByName" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedDate" Type="Edm.Date" />
        <Property Name="ModifiedByName" Type="Edm.String" Nullable="false" />
        <Property Name="ModifiedByEmail" Type="Edm.String" Nullable="false" />
        <Annotation Term="Org.OData.Core.V1.Description" String="A scheduled run of an Advanced Analytics report, including its recurrence, delivery configuration, and last/next run dates." />
      </EntityType>
    </Schema>
    <Schema Namespace="Default" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="Container">
        <EntitySet Name="DwCompanies" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCompany">
          <NavigationPropertyBinding Path="Accounts" Target="DwAccounts" />
          <NavigationPropertyBinding Path="BenefitPackages" Target="DwBenefitPackages" />
          <NavigationPropertyBinding Path="Candidates" Target="DwCandidates" />
          <NavigationPropertyBinding Path="CostCodeCustomFields" Target="DwCostCodeCustomFields" />
          <NavigationPropertyBinding Path="CostCodeFieldNotes" Target="DwCostCodeFieldNotes" />
          <NavigationPropertyBinding Path="CostCodes" Target="DwCostCodes" />
          <NavigationPropertyBinding Path="Courses" Target="DwCourses" />
          <NavigationPropertyBinding Path="CourseTranscripts" Target="DwCourseTranscripts" />
          <NavigationPropertyBinding Path="DataExports" Target="DwDataExports" />
          <NavigationPropertyBinding Path="Employers" Target="DwEmployers" />
          <NavigationPropertyBinding Path="EquipmentCustomFields" Target="DwEquipmentCustomFields" />
          <NavigationPropertyBinding Path="Equipments" Target="DwEquipments" />
          <NavigationPropertyBinding Path="EvaluationForms" Target="DwEvaluationForms" />
          <NavigationPropertyBinding Path="ExpenseCustomFields" Target="DwExpenseCustomFields" />
          <NavigationPropertyBinding Path="Expenses" Target="DwExpenses" />
          <NavigationPropertyBinding Path="HrMetricByMonths" Target="DwHrMetricByMonths" />
          <NavigationPropertyBinding Path="Jobs" Target="DwApplicantTrackingJobs" />
          <NavigationPropertyBinding Path="LearningPlans" Target="DwLearningPlans" />
          <NavigationPropertyBinding Path="Licenses" Target="DwLicenses" />
          <NavigationPropertyBinding Path="LocationCustomFields" Target="DwLocationCustomFields" />
          <NavigationPropertyBinding Path="LocationFieldNotes" Target="DwLocationFieldNotes" />
          <NavigationPropertyBinding Path="Locations" Target="DwLocations" />
          <NavigationPropertyBinding Path="MobileForms" Target="DwMobileForms" />
          <NavigationPropertyBinding Path="PayPeriodApprovals" Target="DwPayPeriodApprovals" />
          <NavigationPropertyBinding Path="PayPeriods" Target="DwPayPeriods" />
          <NavigationPropertyBinding Path="PerformanceEvaluations" Target="DwPerformanceEvaluations" />
          <NavigationPropertyBinding Path="SmsMessages" Target="DwSmsMessages" />
          <NavigationPropertyBinding Path="SurveyQuestions" Target="DwSurveyQuestions" />
          <NavigationPropertyBinding Path="SurveyResponseAggregates" Target="DwSurveyResponseAggregates" />
          <NavigationPropertyBinding Path="SurveyResponses" Target="DwSurveyResponses" />
          <NavigationPropertyBinding Path="TimeOffPlans" Target="DwTimeOffPlans" />
          <NavigationPropertyBinding Path="TranscriptLastCompeleteds" Target="DwTranscriptLastCompeleteds" />
          <NavigationPropertyBinding Path="Transcripts" Target="DwTranscripts" />
          <NavigationPropertyBinding Path="UserCustomFields" Target="DwUserCustomFields" />
          <NavigationPropertyBinding Path="UserFieldNotes" Target="DwUserFieldNotes" />
          <NavigationPropertyBinding Path="Users" Target="DwUsers" />
          <NavigationPropertyBinding Path="WorkDateTimeApprovals" Target="DwWorkDateTimeApprovals" />
        </EntitySet>
        <EntitySet Name="DwUsers" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUser">
          <NavigationPropertyBinding Path="BenefitElections" Target="DwBenefitElections" />
          <NavigationPropertyBinding Path="CompensationHistories" Target="DwCompensationHistories" />
          <NavigationPropertyBinding Path="CompensationTransactions" Target="DwCompensationTransactions" />
          <NavigationPropertyBinding Path="CoreCostCodes" Target="DwUserCoreCostCodes" />
          <NavigationPropertyBinding Path="CourseAssignments" Target="DwCourseAssignments" />
          <NavigationPropertyBinding Path="EmploymentStatusHistories" Target="DwEmploymentStatusHistories" />
          <NavigationPropertyBinding Path="Expenses" Target="DwExpenses" />
          <NavigationPropertyBinding Path="FederalTaxes" Target="DwFederalTaxes" />
          <NavigationPropertyBinding Path="JobUsers" Target="DwApplicantTrackingJobUsers" />
          <NavigationPropertyBinding Path="PerformanceEvaluationWorkflows" Target="DwPerformanceEvaluationWorkflows" />
          <NavigationPropertyBinding Path="PositionHistories" Target="DwPositionHistories" />
          <NavigationPropertyBinding Path="Shifts" Target="DwShifts" />
          <NavigationPropertyBinding Path="ShiftTimeRecordDifferences" Target="DwShiftTimeRecordDifferences" />
          <NavigationPropertyBinding Path="StateProvinceTaxes" Target="DwStateProvinceTaxes" />
          <NavigationPropertyBinding Path="TimeOffBalances" Target="DwTimeOffBalances" />
          <NavigationPropertyBinding Path="TimeOffPlanEmployees" Target="DwTimeOffPlanEmployees" />
          <NavigationPropertyBinding Path="TimeOffRequests" Target="DwTimeOffRequests" />
          <NavigationPropertyBinding Path="TimePunches" Target="DwTimePunches" />
          <NavigationPropertyBinding Path="TimeRecordByHourGroups" Target="DwTimeRecordByHourGroups" />
          <NavigationPropertyBinding Path="TimeRecords" Target="DwTimeRecords" />
          <NavigationPropertyBinding Path="UserAssociatedPeople" Target="DwUserAssociatedPeople" />
          <NavigationPropertyBinding Path="UserCertifications" Target="DwUserCertifications" />
          <NavigationPropertyBinding Path="UserChangeLogs" Target="DwUserChangeLogs" />
          <NavigationPropertyBinding Path="UserGoals" Target="DwUserGoals" />
          <NavigationPropertyBinding Path="UserLearningPlans" Target="DwUserLearningPlans" />
          <NavigationPropertyBinding Path="UserLearningPlanTasks" Target="DwUserLearningPlanTasks" />
          <NavigationPropertyBinding Path="UsersWithoutCertifications" Target="DwUsersWithoutCertifications" />
          <NavigationPropertyBinding Path="UsersWithoutCourses" Target="DwUsersWithoutCourses" />
          <NavigationPropertyBinding Path="UserTranscripts" Target="DwUserTranscripts" />
        </EntitySet>
        <EntitySet Name="DwUserDetailsCores" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsCore" />
        <EntitySet Name="DwUserDetailsApplicantTrackings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsApplicantTracking" />
        <EntitySet Name="DwUserDetailsLearnings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsLearning" />
        <EntitySet Name="DwUserDetailsOnboardings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsOnboarding" />
        <EntitySet Name="DwUserDetailsPerformances" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsPerformance" />
        <EntitySet Name="DwUserDetailsTimes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserDetailsTime" />
        <EntitySet Name="DwTimeRecords" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecord">
          <NavigationPropertyBinding Path="MealBreakViolations" Target="DwMealBreakViolations" />
          <NavigationPropertyBinding Path="TimeRecordByHourGroups" Target="DwTimeRecordByHourGroups" />
          <NavigationPropertyBinding Path="TimeRecordEquipments" Target="DwTimeRecordEquipments" />
        </EntitySet>
        <EntitySet Name="DwTimePunches" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimePunch" />
        <EntitySet Name="DwTimeOffPlans" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlan">
          <NavigationPropertyBinding Path="TimeOffPlanEmployees" Target="DwTimeOffPlanEmployees" />
        </EntitySet>
        <EntitySet Name="DwTimeOffBalances" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffBalance" />
        <EntitySet Name="DwTimeOffRequests" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffRequest" />
        <EntitySet Name="DwEquipments" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEquipment">
          <NavigationPropertyBinding Path="EquipmentFieldNotes" Target="DwEquipmentFieldNotes" />
          <NavigationPropertyBinding Path="TimeRecordEquipments" Target="DwTimeRecordEquipments" />
        </EntitySet>
        <EntitySet Name="DwEquipmentFieldNotes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEquipmentFieldNote" />
        <EntitySet Name="DwCandidates" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCandidate">
          <NavigationPropertyBinding Path="AddtlInfos" Target="DwCandidateAddtlInfos" />
          <NavigationPropertyBinding Path="Educations" Target="DwCandidateEducations" />
          <NavigationPropertyBinding Path="EeocSurveyResponses" Target="DwCandidateEeocSurveyResponses" />
          <NavigationPropertyBinding Path="JobCandidates" Target="DwApplicantTrackingJobCandidates" />
          <NavigationPropertyBinding Path="OfferLetters" Target="DwApplicantTrackingOfferLetters" />
          <NavigationPropertyBinding Path="WorkExperiences" Target="DwCandidateWorkExperiences" />
        </EntitySet>
        <EntitySet Name="DwCandidateAddtlInfos" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCandidateAddtlInfo" />
        <EntitySet Name="DwCandidateEducations" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCandidateEducation" />
        <EntitySet Name="DwCandidateEeocSurveyResponses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCandidateEeocSurveyResponse" />
        <EntitySet Name="DwCandidateWorkExperiences" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCandidateWorkExperience" />
        <EntitySet Name="DwApplicantTrackingJobs" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJob">
          <NavigationPropertyBinding Path="CustomFields" Target="DwApplicantTrackingJobCustomFields" />
          <NavigationPropertyBinding Path="JobAccountFeeds" Target="DwApplicantTrackingJobAccountFeeds" />
          <NavigationPropertyBinding Path="JobAssessments" Target="DwApplicantTrackingJobAssessments" />
          <NavigationPropertyBinding Path="JobCandidates" Target="DwApplicantTrackingJobCandidates" />
          <NavigationPropertyBinding Path="JobUsers" Target="DwApplicantTrackingJobUsers" />
          <NavigationPropertyBinding Path="OfferLetters" Target="DwApplicantTrackingOfferLetters" />
          <NavigationPropertyBinding Path="OgDistributions" Target="DwApplicantTrackingJobOgDistributions" />
          <NavigationPropertyBinding Path="PostingFields" Target="DwApplicantTrackingJobPostingFields" />
          <NavigationPropertyBinding Path="Socials" Target="DwApplicantTrackingJobSocials" />
        </EntitySet>
        <EntitySet Name="DwApplicantTrackingJobAccountFeeds" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobAccountFeed" />
        <EntitySet Name="DwApplicantTrackingJobAssessments" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobAssessment" />
        <EntitySet Name="DwApplicantTrackingJobCandidates" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidate">
          <NavigationPropertyBinding Path="CandidateAssessments" Target="DwApplicantTrackingJobCandidateAssessments" />
          <NavigationPropertyBinding Path="CustomData" Target="DwApplicantTrackingJobCandidateCustomData" />
          <NavigationPropertyBinding Path="CustomFields" Target="DwApplicantTrackingJobCandidateCustomFields" />
          <NavigationPropertyBinding Path="DispositionTrackings" Target="DwApplicantTrackingJobCandidateDispositionTrackings" />
          <NavigationPropertyBinding Path="Interviews" Target="DwInterviews" />
          <NavigationPropertyBinding Path="OfferLetters" Target="DwApplicantTrackingOfferLetters" />
          <NavigationPropertyBinding Path="OutsideScreenings" Target="DwOutsideScreenings" />
          <NavigationPropertyBinding Path="StatusTrackings" Target="DwApplicantTrackingJobCandidateStatusTrackings" />
          <NavigationPropertyBinding Path="TimeInDispositions" Target="DwApplicantTrackingJobCandidateTimeInDispositions" />
          <NavigationPropertyBinding Path="TimeInStages" Target="DwApplicantTrackingJobCandidateTimeInStages" />
        </EntitySet>
        <EntitySet Name="DwApplicantTrackingJobCandidateAssessments" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateAssessment" />
        <EntitySet Name="DwApplicantTrackingJobCandidateCustomData" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateCustomDatum" />
        <EntitySet Name="DwApplicantTrackingJobCandidateCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateCustomField" />
        <EntitySet Name="DwApplicantTrackingJobCandidateDispositionTrackings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateDispositionTracking" />
        <EntitySet Name="DwApplicantTrackingJobCandidateStatusTrackings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateStatusTracking" />
        <EntitySet Name="DwApplicantTrackingJobCandidateTimeInDispositions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateTimeInDisposition" />
        <EntitySet Name="DwApplicantTrackingJobCandidateTimeInStages" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCandidateTimeInStage" />
        <EntitySet Name="DwApplicantTrackingJobCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobCustomField" />
        <EntitySet Name="DwApplicantTrackingJobLocalizedAttributes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobLocalizedAttribute" />
        <EntitySet Name="DwApplicantTrackingJobLocations" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobLocation" />
        <EntitySet Name="DwApplicantTrackingJobOgDistributions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobOgDistribution" />
        <EntitySet Name="DwApplicantTrackingJobPostingFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobPostingField" />
        <EntitySet Name="DwApplicantTrackingJobSocials" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobSocial" />
        <EntitySet Name="DwApplicantTrackingJobUsers" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingJobUser" />
        <EntitySet Name="DwInterviews" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwInterview" />
        <EntitySet Name="DwOutsideScreenings" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwOutsideScreening" />
        <EntitySet Name="DwApplicantTrackingOfferLetters" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwApplicantTrackingOfferLetter" />
        <EntitySet Name="DwCompensationHistories" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCompensationHistory" />
        <EntitySet Name="DwCompensationTransactions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCompensationTransaction" />
        <EntitySet Name="DwEmploymentStatusHistories" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEmploymentStatusHistory" />
        <EntitySet Name="DwPositionHistories" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPositionHistory" />
        <EntitySet Name="DwUserAssociatedPeople" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserAssociatedPerson" />
        <EntitySet Name="DwUserCertifications" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserCertification" />
        <EntitySet Name="DwUserChangeLogs" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserChangeLog" />
        <EntitySet Name="DwUserCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserCustomField" />
        <EntitySet Name="DwUserFieldNotes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserFieldNote" />
        <EntitySet Name="DwUserGoals" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserGoal" />
        <EntitySet Name="DwUserTranscripts" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserTranscript" />
        <EntitySet Name="DwUsersWithoutCertifications" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUsersWithoutCertification" />
        <EntitySet Name="DwUsersWithoutCourses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUsersWithoutCourse" />
        <EntitySet Name="DwWorkDateTimeApprovals" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwWorkDateTimeApproval" />
        <EntitySet Name="DwFederalTaxes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwFederalTax" />
        <EntitySet Name="DwStateProvinceTaxes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwStateProvinceTax" />
        <EntitySet Name="DwMealBreakViolations" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwMealBreakViolation" />
        <EntitySet Name="DwPayPeriods" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPayPeriod" />
        <EntitySet Name="DwPayPeriodApprovals" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPayPeriodApproval" />
        <EntitySet Name="DwShifts" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwShift">
          <NavigationPropertyBinding Path="ShiftTasks" Target="DwShiftTasks" />
        </EntitySet>
        <EntitySet Name="DwShiftTasks" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwShiftTask" />
        <EntitySet Name="DwShiftTimeRecordDifferences" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwShiftTimeRecordDifference" />
        <EntitySet Name="DwTimeRecordByHourGroups" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordByHourGroup" />
        <EntitySet Name="DwTimeRecordEquipments" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeRecordEquipment" />
        <EntitySet Name="DwTimeOffPlanEmployees" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlanEmployee">
          <NavigationPropertyBinding Path="TimeOffPlanEmployeeRequests" Target="DwTimeOffPlanEmployeeRequests" />
        </EntitySet>
        <EntitySet Name="DwTimeOffPlanEmployeeRequests" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTimeOffPlanEmployeeRequest" />
        <EntitySet Name="DwCourses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCourse">
          <NavigationPropertyBinding Path="CourseAssignments" Target="DwCourseAssignments" />
        </EntitySet>
        <EntitySet Name="DwCourseAssignments" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCourseAssignment" />
        <EntitySet Name="DwCourseTranscripts" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCourseTranscript" />
        <EntitySet Name="DwLearningPlans" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLearningPlan">
          <NavigationPropertyBinding Path="LearningPlanTasks" Target="DwLearningPlanTasks" />
        </EntitySet>
        <EntitySet Name="DwLearningPlanTasks" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLearningPlanTask" />
        <EntitySet Name="DwTranscripts" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTranscript" />
        <EntitySet Name="DwTranscriptLastCompeleteds" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwTranscriptLastCompeleted" />
        <EntitySet Name="DwUserLearningPlans" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserLearningPlan" />
        <EntitySet Name="DwUserLearningPlanTasks" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserLearningPlanTask" />
        <EntitySet Name="DwLicenses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLicense" />
        <EntitySet Name="DwEvaluationForms" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationForm">
          <NavigationPropertyBinding Path="EvaluationFormQuestions" Target="DwEvaluationFormQuestions" />
          <NavigationPropertyBinding Path="EvaluationFormSections" Target="DwEvaluationFormSections" />
        </EntitySet>
        <EntitySet Name="DwEvaluationFormQuestions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationFormQuestion" />
        <EntitySet Name="DwEvaluationFormSections" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEvaluationFormSection" />
        <EntitySet Name="DwPerformanceEvaluations" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluation">
          <NavigationPropertyBinding Path="PerformanceEvaluationAnswers" Target="DwPerformanceEvaluationAnswers" />
          <NavigationPropertyBinding Path="PerformanceEvaluationSections" Target="DwPerformanceEvaluationSections" />
          <NavigationPropertyBinding Path="PerformanceEvaluationWorkflows" Target="DwPerformanceEvaluationWorkflows" />
        </EntitySet>
        <EntitySet Name="DwPerformanceEvaluationAnswers" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationAnswer" />
        <EntitySet Name="DwPerformanceEvaluationSections" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationSection" />
        <EntitySet Name="DwPerformanceEvaluationWorkflows" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwPerformanceEvaluationWorkflow" />
        <EntitySet Name="DwSurveyQuestions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwSurveyQuestion" />
        <EntitySet Name="DwSurveyResponses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwSurveyResponse" />
        <EntitySet Name="DwSurveyResponseAggregates" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwSurveyResponseAggregate" />
        <EntitySet Name="DwBenefitElections" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElection">
          <NavigationPropertyBinding Path="BenefitElectionBeneficiaries" Target="DwBenefitElectionBeneficiaries" />
          <NavigationPropertyBinding Path="BenefitElectionDependents" Target="DwBenefitElectionDependents" />
        </EntitySet>
        <EntitySet Name="DwBenefitElectionBeneficiaries" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElectionBeneficiary" />
        <EntitySet Name="DwBenefitElectionDependents" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwBenefitElectionDependent" />
        <EntitySet Name="DwBenefitPackages" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwBenefitPackage">
          <NavigationPropertyBinding Path="BenefitElections" Target="DwBenefitElections" />
        </EntitySet>
        <EntitySet Name="DwMobileForms" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwMobileForm">
          <NavigationPropertyBinding Path="MobileFormResponses" Target="DwMobileFormResponses" />
          <NavigationPropertyBinding Path="MobileFormVersions" Target="DwMobileFormVersions" />
        </EntitySet>
        <EntitySet Name="DwMobileFormResponses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormResponse" />
        <EntitySet Name="DwMobileFormVersions" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormVersion">
          <NavigationPropertyBinding Path="MobileFormResponses" Target="DwMobileFormResponses" />
          <NavigationPropertyBinding Path="MobileFormVersionQuestionChoices" Target="DwMobileFormVersionQuestionChoices" />
        </EntitySet>
        <EntitySet Name="DwMobileFormVersionQuestionChoices" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwMobileFormVersionQuestionChoice" />
        <EntitySet Name="DwExpenses" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwExpense" />
        <EntitySet Name="DwExpenseCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwExpenseCustomField" />
        <EntitySet Name="DwCostCodes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCostCode" />
        <EntitySet Name="DwCostCodeCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCostCodeCustomField" />
        <EntitySet Name="DwCostCodeFieldNotes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwCostCodeFieldNote" />
        <EntitySet Name="DwUserCoreCostCodes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwUserCoreCostCode" />
        <EntitySet Name="DwLocations" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLocation" />
        <EntitySet Name="DwLocationCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLocationCustomField" />
        <EntitySet Name="DwLocationFieldNotes" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwLocationFieldNote" />
        <EntitySet Name="DwEquipmentCustomFields" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEquipmentCustomField" />
        <EntitySet Name="DwSmsMessages" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwSmsMessage" />
        <EntitySet Name="DwAccounts" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwAccount" />
        <EntitySet Name="DwDataExports" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwDataExport" />
        <EntitySet Name="DwDates" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwDate" />
        <EntitySet Name="DwEmployers" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwEmployer" />
        <EntitySet Name="DwHrMetricByMonths" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwHrMetricByMonth" />
        <EntitySet Name="DwAdvancedAnalyticsReports" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwAdvancedAnalyticsReport" />
        <EntitySet Name="DwAdvancedAnalyticsScheduleds" EntityType="Arcoro.One.Data.DataWarehouse.Entities.DwAdvancedAnalyticsScheduled" />
      </EntityContainer>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>