﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="Workflows.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2005" Alias="Self" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <Function Name="Pr_VerificationTasksGet" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="App">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SystemTriggerDequeue" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="System" />
        <Function Name="Pr_SystemTriggerEnqueue" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="System">
          <Parameter Name="SystemTriggerTypeID" Type="smallint" Mode="In" />
          <Parameter Name="RelatedItemID" Type="bigint" Mode="In" />
          <Parameter Name="RelatedData" Type="nvarchar(max)" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SystemTriggerStatusUpdate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="System">
          <Parameter Name="SystemTriggerID" Type="bigint" Mode="In" />
          <Parameter Name="SystemTriggerStatusID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_WorkflowInstanceTaskAction" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Wf">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="WorkflowInstanceTaskStatusID" Type="smallint" Mode="In" />
          <Parameter Name="CompletedByUserName" Type="varchar" Mode="In" />
          <Parameter Name="RequestCorrectionWorkflowTemplateStepID" Type="smallint" Mode="In" />
          <Parameter Name="Comments" Type="varchar" Mode="In" />
          <Parameter Name="ErrorMessage" Type="varchar" Mode="InOut" />
        </Function>
        <Function Name="Pr_WorkflowInstanceTaskActionFailover" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Wf">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="ErrorMessage" Type="varchar(max)" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <EntityContainer Name="WorkflowsStoreContainer" />
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="SystemTriggers" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="SystemTriggerContext" annotation:LazyLoadingEnabled="true">
          <FunctionImport Name="Pr_WorkflowInstanceTaskAction">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="WorkflowInstanceTaskStatusID" Mode="In" Type="Int16" />
            <Parameter Name="CompletedByUserName" Mode="In" Type="String" />
            <Parameter Name="RequestCorrectionWorkflowTemplateStepID" Mode="In" Type="Int16" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="ErrorMessage" Mode="InOut" Type="String" />
          </FunctionImport>
          <FunctionImport Name="Pr_WorkflowInstanceTaskActionFailover">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="ErrorMessage" Mode="In" Type="String" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SystemTriggerDequeue" ReturnType="Collection(SystemTriggers.Pr_SystemTriggerDequeue_Result)" />
          <FunctionImport Name="Pr_SystemTriggerEnqueue">
            <Parameter Name="SystemTriggerTypeID" Mode="In" Type="Int16" />
            <Parameter Name="RelatedItemID" Mode="In" Type="Int64" />
            <Parameter Name="RelatedData" Mode="In" Type="String" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SystemTriggerStatusUpdate">
            <Parameter Name="SystemTriggerID" Mode="In" Type="Int64" />
            <Parameter Name="SystemTriggerStatusID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_VerificationTasksGet" ReturnType="Collection(SystemTriggers.Pr_VerificationTasksGet_Result)">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
        </EntityContainer>
        <ComplexType Name="Pr_SystemTriggerDequeue_Result">
          <Property Type="Int64" Name="SystemTriggerID" Nullable="false" />
          <Property Type="Int16" Name="SystemTriggerStatusID" Nullable="false" />
          <Property Type="Int16" Name="SystemTriggerTypeID" Nullable="false" />
          <Property Type="Int64" Name="RelatedItemID" Nullable="false" />
          <Property Type="String" Name="RelatedData" Nullable="true" />
          <Property Type="Int64" Name="UserID" Nullable="false" />
        </ComplexType>
        <ComplexType Name="Pr_VerificationTasksGet_Result">
          <Property Type="Int64" Name="ApplicationRequestDetailID" Nullable="false" />
          <Property Type="Int64" Name="WorkflowInstanceID" Nullable="false" />
          <Property Type="String" Name="ReferenceNumber" Nullable="false" MaxLength="20" />
          <Property Type="Int16" Name="ApplicationRequestTypeID" Nullable="false" />
          <Property Type="String" Name="Description" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="Member" Nullable="true" MaxLength="255" />
          <Property Type="Int64" Name="AssignedToID" Nullable="true" />
          <Property Type="Double" Name="Step" Nullable="false" />
          <Property Type="String" Name="StepDescription" Nullable="false" MaxLength="255" />
          <Property Type="Int64" Name="WorkflowInstanceTaskID" Nullable="true" />
          <Property Type="DateTime" Name="CreatedDate" Nullable="false" Precision="23" />
          <Property Type="DateTime" Name="FirstVerificationTaskDate" Nullable="true" Precision="23" />
          <Property Type="DateTime" Name="WarningDate" Nullable="true" Precision="23" />
          <Property Type="DateTime" Name="DueDate" Nullable="true" Precision="23" />
          <Property Type="String" Name="AssignedTo" Nullable="true" MaxLength="255" />
          <Property Type="Int64" Name="LicenceIssueDetailID" Nullable="true" />
          <Property Type="Boolean" Name="IsBulkVehicleApplication" Nullable="true" />
          <Property Type="Int64" Name="VehicleCount" Nullable="true" />
          <Property Type="String" Name="AppOrLir" Nullable="true" MaxLength="3" />
        </ComplexType>
        </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="WorkflowsStoreContainer" CdmEntityContainer="SystemTriggerContext">
          <FunctionImportMapping FunctionImportName="Pr_WorkflowInstanceTaskAction" FunctionName="Workflows.Store.Pr_WorkflowInstanceTaskAction" />
          <FunctionImportMapping FunctionImportName="Pr_WorkflowInstanceTaskActionFailover" FunctionName="Workflows.Store.Pr_WorkflowInstanceTaskActionFailover" />
          <FunctionImportMapping FunctionImportName="Pr_SystemTriggerDequeue" FunctionName="Workflows.Store.Pr_SystemTriggerDequeue">
            <ResultMapping>
              <ComplexTypeMapping TypeName="SystemTriggers.Pr_SystemTriggerDequeue_Result">
                <ScalarProperty Name="SystemTriggerID" ColumnName="SystemTriggerID" />
                <ScalarProperty Name="SystemTriggerStatusID" ColumnName="SystemTriggerStatusID" />
                <ScalarProperty Name="SystemTriggerTypeID" ColumnName="SystemTriggerTypeID" />
                <ScalarProperty Name="RelatedItemID" ColumnName="RelatedItemID" />
                <ScalarProperty Name="RelatedData" ColumnName="RelatedData" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_SystemTriggerEnqueue" FunctionName="Workflows.Store.Pr_SystemTriggerEnqueue" />
          <FunctionImportMapping FunctionImportName="Pr_SystemTriggerStatusUpdate" FunctionName="Workflows.Store.Pr_SystemTriggerStatusUpdate" />
          <FunctionImportMapping FunctionImportName="Pr_VerificationTasksGet" FunctionName="Workflows.Store.Pr_VerificationTasksGet">
            <ResultMapping>
              <ComplexTypeMapping TypeName="SystemTriggers.Pr_VerificationTasksGet_Result">
                <ScalarProperty Name="ApplicationRequestDetailID" ColumnName="ApplicationRequestDetailID" />
                <ScalarProperty Name="WorkflowInstanceID" ColumnName="WorkflowInstanceID" />
                <ScalarProperty Name="ReferenceNumber" ColumnName="ReferenceNumber" />
                <ScalarProperty Name="ApplicationRequestTypeID" ColumnName="ApplicationRequestTypeID" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Member" ColumnName="Member" />
                <ScalarProperty Name="AssignedToID" ColumnName="AssignedToID" />
                <ScalarProperty Name="Step" ColumnName="Step" />
                <ScalarProperty Name="StepDescription" ColumnName="StepDescription" />
                <ScalarProperty Name="WorkflowInstanceTaskID" ColumnName="WorkflowInstanceTaskID" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="FirstVerificationTaskDate" ColumnName="FirstVerificationTaskDate" />
                <ScalarProperty Name="WarningDate" ColumnName="WarningDate" />
                <ScalarProperty Name="DueDate" ColumnName="DueDate" />
                <ScalarProperty Name="AssignedTo" ColumnName="AssignedTo" />
                <ScalarProperty Name="LicenceIssueDetailID" ColumnName="LicenceIssueDetailID" />
                <ScalarProperty Name="IsBulkVehicleApplication" ColumnName="IsBulkVehicleApplication" />
                <ScalarProperty Name="VehicleCount" ColumnName="VehicleCount" />
                <ScalarProperty Name="AppOrLir" ColumnName="AppOrLir" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="True" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
        <DesignerProperty Name="UseLegacyProvider" Value="True" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams>
      <Diagram Name="SystemTriggerModel">
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>