﻿<?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="Model.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="Applications">
          <Key>
            <PropertyRef Name="ApplicationID" />
          </Key>
          <Property Name="ApplicationID" Type="bigint" Nullable="false" />
          <Property Name="Name" Type="varchar" MaxLength="1000" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="PasswordQuestions">
          <Key>
            <PropertyRef Name="PasswordQuestionID" />
          </Key>
          <Property Name="PasswordQuestionID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="255" Nullable="false" />
        </EntityType>
        <EntityType Name="Roles">
          <Key>
            <PropertyRef Name="RoleID" />
          </Key>
          <Property Name="RoleID" Type="smallint" Nullable="false" />
          <Property Name="ApplicationID" Type="bigint" Nullable="false" />
          <Property Name="Name" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
          <Property Name="ConflictingRoleIDs" Type="varchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="RoleSecurables">
          <Key>
            <PropertyRef Name="RoleID" />
            <PropertyRef Name="SecurableID" />
          </Key>
          <Property Name="RoleID" Type="smallint" Nullable="false" />
          <Property Name="SecurableID" Type="smallint" Nullable="false" />
          <Property Name="CanRead" Type="bit" Nullable="false" />
          <Property Name="CanEdit" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="Securables">
          <Key>
            <PropertyRef Name="SecurableID" />
          </Key>
          <Property Name="SecurableID" Type="smallint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="varchar(max)" Nullable="false" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
          <Property Name="IsSystem" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="UserRoles">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="RoleID" />
          </Key>
          <Property Name="UserID" Type="bigint" Nullable="false" />
          <Property Name="RoleID" Type="smallint" Nullable="false" />
        </EntityType>
        <EntityType Name="Users">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="UserStatusID" Type="smallint" Nullable="false" />
          <Property Name="EntityID" Type="int" />
          <Property Name="ItemID" Type="varchar" MaxLength="20" />
          <Property Name="LastName" Type="varchar" MaxLength="50" />
          <Property Name="FirstName" Type="varchar" MaxLength="50" />
          <Property Name="FullName" Type="varchar" MaxLength="101" StoreGeneratedPattern="Computed" Nullable="false" />
          <Property Name="KnownAs" Type="varchar" MaxLength="101" />
          <Property Name="Email" Type="varchar" MaxLength="255" Nullable="false" />
          <Property Name="NTAccount" Type="varchar" MaxLength="255" />
          <Property Name="Cell" Type="varchar" MaxLength="10" />
          <Property Name="IsPasswordExpired" Type="bit" />
          <Property Name="PasswordDate" Type="datetime" />
          <Property Name="PasswordHash" Type="varchar" MaxLength="255" />
          <Property Name="PasswordSalt" Type="varchar" MaxLength="20" />
          <Property Name="PasswordChallenge" Type="varchar" MaxLength="20" />
          <Property Name="PasswordQuestion" Type="varchar" MaxLength="255" />
          <Property Name="PasswordAnswerHash" Type="varchar" MaxLength="255" />
          <Property Name="PasswordAnswerSalt" Type="varchar" MaxLength="20" />
          <Property Name="PasswordAnswerChallenge" Type="varchar" MaxLength="20" />
          <Property Name="FingerprintTemplate" Type="varbinary(max)" />
          <Property Name="CreatedByID" Type="bigint" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="UpdatedByID" Type="bigint" Nullable="false" />
          <Property Name="UpdatedDate" Type="datetime" Nullable="false" />
          <Property Name="FingerprintRequestToken" Type="varchar" MaxLength="255" />
          <Property Name="FingerprintRequestExpiryDate" Type="datetime" />
          <Property Name="UserProfileDocID" Type="bigint" />
          <Property Name="OfficeLocationID" Type="bigint" />
        </EntityType>
        <EntityType Name="UserSettings">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="SettingName" />
          </Key>
          <Property Name="UserID" Type="bigint" Nullable="false" />
          <Property Name="SettingName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="SettingValue" Type="varchar(max)" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="UserStatus">
          <Key>
            <PropertyRef Name="UserStatusID" />
          </Key>
          <Property Name="UserStatusID" Type="smallint" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="UserStatusHistory">
          <Key>
            <PropertyRef Name="UserStatusHistoryID" />
          </Key>
          <Property Name="UserStatusHistoryID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="UserID" Type="bigint" Nullable="false" />
          <Property Name="UserStatusID" Type="smallint" Nullable="false" />
          <Property Name="UpdatedByID" Type="bigint" Nullable="false" />
          <Property Name="UpdatedDate" Type="datetime" Nullable="false" />
        </EntityType>
        <EntityType Name="WorkflowBuddies">
          <Key>
            <PropertyRef Name="WorkflowBuddyID" />
          </Key>
          <Property Name="WorkflowBuddyID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="WorkflowID" Type="bigint" Nullable="false" />
          <Property Name="UserID" Type="bigint" Nullable="false" />
          <Property Name="BuddyUserID" Type="bigint" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view 'EPWP.Security.Vw_Users' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Vw_Users">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="UserStatusID" />
            <PropertyRef Name="FullName" />
            <PropertyRef Name="Email" />
          </Key>
          <Property Name="UserID" Type="bigint" Nullable="false" />
          <Property Name="UserStatusID" Type="smallint" Nullable="false" />
          <Property Name="LastName" Type="varchar" MaxLength="50" />
          <Property Name="FirstName" Type="varchar" MaxLength="50" />
          <Property Name="FullName" Type="varchar" MaxLength="101" Nullable="false" />
          <Property Name="KnownAs" Type="varchar" MaxLength="101" />
          <Property Name="Email" Type="varchar" MaxLength="255" Nullable="false" />
          <Property Name="UserProfileDocID" Type="bigint" />
          <Property Name="OfficeLocationID" Type="bigint" />
        </EntityType>
        <Association Name="FK_Applications_Roles">
          <End Role="Applications" Type="Self.Applications" Multiplicity="1" />
          <End Role="Roles" Type="Self.Roles" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Applications">
              <PropertyRef Name="ApplicationID" />
            </Principal>
            <Dependent Role="Roles">
              <PropertyRef Name="ApplicationID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Roles_RoleSecurables">
          <End Role="Roles" Type="Self.Roles" Multiplicity="1" />
          <End Role="RoleSecurables" Type="Self.RoleSecurables" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Roles">
              <PropertyRef Name="RoleID" />
            </Principal>
            <Dependent Role="RoleSecurables">
              <PropertyRef Name="RoleID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Roles_UserRoles">
          <End Role="Roles" Type="Self.Roles" Multiplicity="1" />
          <End Role="UserRoles" Type="Self.UserRoles" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Roles">
              <PropertyRef Name="RoleID" />
            </Principal>
            <Dependent Role="UserRoles">
              <PropertyRef Name="RoleID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Securables_RoleSecurables">
          <End Role="Securables" Type="Self.Securables" Multiplicity="1" />
          <End Role="RoleSecurables" Type="Self.RoleSecurables" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Securables">
              <PropertyRef Name="SecurableID" />
            </Principal>
            <Dependent Role="RoleSecurables">
              <PropertyRef Name="SecurableID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_UserRoles">
          <End Role="Users" Type="Self.Users" Multiplicity="1" />
          <End Role="UserRoles" Type="Self.UserRoles" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserRoles">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_UserStatusHistory">
          <End Role="Users" Type="Self.Users" Multiplicity="1" />
          <End Role="UserStatusHistory" Type="Self.UserStatusHistory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserStatusHistory">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserSettings_Users">
          <End Role="Users" Type="Self.Users" Multiplicity="1" />
          <End Role="UserSettings" Type="Self.UserSettings" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserSettings">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserStatus_Users">
          <End Role="UserStatus" Type="Self.UserStatus" Multiplicity="1" />
          <End Role="Users" Type="Self.Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserStatus">
              <PropertyRef Name="UserStatusID" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="UserStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserStatus_UserStatusHistory">
          <End Role="UserStatus" Type="Self.UserStatus" Multiplicity="1" />
          <End Role="UserStatusHistory" Type="Self.UserStatusHistory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserStatus">
              <PropertyRef Name="UserStatusID" />
            </Principal>
            <Dependent Role="UserStatusHistory">
              <PropertyRef Name="UserStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="Pr_ClearUserSettings" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_DeleteUserWorkflowBuddy" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="WorkflowID" Type="bigint" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="BuddyUserID" Type="bigint" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_GetActiveUsers" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_GetRoleSecurables" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="RoleID" Type="smallint" Mode="In" />
        </Function>
        <Function Name="Pr_GetUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="ReturnUserID" Type="bigint" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_GetUserByFingerPrintRequestToken" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="FingerprintRequestToken" Type="varchar" Mode="In" />
        </Function>
        <Function Name="Pr_GetUsersInRole" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="AppName" Type="varchar" Mode="In" />
          <Parameter Name="RoleName" Type="varchar" Mode="In" />
          <Parameter Name="AuthMode" Type="varchar" Mode="In" />
        </Function>
        <Function Name="Pr_GetUsersInRoles" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="RoleIds" Type="varchar" Mode="In" />
        </Function>
        <Function Name="Pr_GetUserWorkflowBuddies" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveRoleSecurables" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="RoleID" Type="smallint" Mode="In" />
          <Parameter Name="SecurablesCsv" Type="varchar" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="KnownAs" Type="varchar" Mode="In" />
          <Parameter Name="LastName" Type="varchar" Mode="In" />
          <Parameter Name="FirstName" Type="varchar" Mode="In" />
          <Parameter Name="Email" Type="varchar" Mode="In" />
          <Parameter Name="NTAccount" Type="varchar" Mode="In" />
          <Parameter Name="Cell" Type="varchar" Mode="In" />
          <Parameter Name="OfficeLocationID" Type="bigint" Mode="In" />
          <Parameter Name="UserProfileDocID" Type="bigint" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserFingerprint" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="Fingerprint" Type="varbinary(max)" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserFingerPrintRequestToken" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="CreateToken" Type="bit" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserPassword" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="UserName" Type="varchar" Mode="In" />
          <Parameter Name="AuthMode" Type="varchar" Mode="In" />
          <Parameter Name="NewPassword" Type="varchar" Mode="In" />
          <Parameter Name="IsPasswordReset" Type="bit" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserRoles" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="RolesCsv" Type="varchar" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserSettings" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UpdateUserID" Type="bigint" Mode="In" />
          <Parameter Name="SettingName" Type="varchar" Mode="In" />
          <Parameter Name="SettingValue" Type="varchar" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_SaveUserWorkflowBuddy" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="WorkflowID" Type="bigint" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="BuddyUserID" Type="bigint" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <Function Name="Pr_UserStatusUpdate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
          <Parameter Name="Comments" Type="varchar" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
          <Parameter Name="UserStatusID" Type="smallint" Mode="In" />
        </Function>
        <Function Name="Pr_ValidateFingerPrintRequestToken" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Security">
          <Parameter Name="FingerprintRequestToken" Type="varchar" Mode="In" />
        </Function>
        <Function Name="Pr_UpdateRelatedTable" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="System">
          <Parameter Name="PrimaryID" Type="varchar" Mode="In" />
          <Parameter Name="PrimaryColumnName" Type="varchar" Mode="In" />
          <Parameter Name="RelatedIds" Type="varchar(max)" Mode="In" />
          <Parameter Name="RelatedSchema" Type="varchar" Mode="In" />
          <Parameter Name="RelatedTableName" Type="varchar" Mode="In" />
          <Parameter Name="RelatedPrimaryColumnName" Type="varchar" Mode="In" />
        </Function>
        <EntityContainer Name="ModelStoreContainer">
          <EntitySet Name="Applications" EntityType="Self.Applications" Schema="Security" store:Type="Tables" />
          <EntitySet Name="PasswordQuestions" EntityType="Self.PasswordQuestions" Schema="Security" store:Type="Tables" />
          <EntitySet Name="Roles" EntityType="Self.Roles" Schema="Security" store:Type="Tables" />
          <EntitySet Name="RoleSecurables" EntityType="Self.RoleSecurables" Schema="Security" store:Type="Tables" />
          <EntitySet Name="Securables" EntityType="Self.Securables" Schema="Security" store:Type="Tables" />
          <EntitySet Name="UserRoles" EntityType="Self.UserRoles" Schema="Security" store:Type="Tables" />
          <EntitySet Name="Users" EntityType="Self.Users" Schema="Security" store:Type="Tables" />
          <EntitySet Name="UserSettings" EntityType="Self.UserSettings" Schema="Security" store:Type="Tables" />
          <EntitySet Name="UserStatus" EntityType="Self.UserStatus" Schema="Security" store:Type="Tables" />
          <EntitySet Name="UserStatusHistory" EntityType="Self.UserStatusHistory" Schema="Security" store:Type="Tables" />
          <EntitySet Name="WorkflowBuddies" EntityType="Self.WorkflowBuddies" Schema="Security" store:Type="Tables" />
          <EntitySet Name="Vw_Users" EntityType="Self.Vw_Users" store:Type="Views" store:Schema="Security">
            <DefiningQuery>SELECT 
    [Vw_Users].[UserID] AS [UserID], 
    [Vw_Users].[UserStatusID] AS [UserStatusID], 
    [Vw_Users].[LastName] AS [LastName], 
    [Vw_Users].[FirstName] AS [FirstName], 
    [Vw_Users].[FullName] AS [FullName], 
    [Vw_Users].[KnownAs] AS [KnownAs], 
    [Vw_Users].[Email] AS [Email], 
    [Vw_Users].[UserProfileDocID] AS [UserProfileDocID], 
    [Vw_Users].[OfficeLocationID] AS [OfficeLocationID]
    FROM [Security].[Vw_Users] AS [Vw_Users]</DefiningQuery>
          </EntitySet>
          <AssociationSet Name="FK_Applications_Roles" Association="Self.FK_Applications_Roles">
            <End Role="Applications" EntitySet="Applications" />
            <End Role="Roles" EntitySet="Roles" />
          </AssociationSet>
          <AssociationSet Name="FK_Roles_RoleSecurables" Association="Self.FK_Roles_RoleSecurables">
            <End Role="Roles" EntitySet="Roles" />
            <End Role="RoleSecurables" EntitySet="RoleSecurables" />
          </AssociationSet>
          <AssociationSet Name="FK_Roles_UserRoles" Association="Self.FK_Roles_UserRoles">
            <End Role="Roles" EntitySet="Roles" />
            <End Role="UserRoles" EntitySet="UserRoles" />
          </AssociationSet>
          <AssociationSet Name="FK_Securables_RoleSecurables" Association="Self.FK_Securables_RoleSecurables">
            <End Role="Securables" EntitySet="Securables" />
            <End Role="RoleSecurables" EntitySet="RoleSecurables" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_UserRoles" Association="Self.FK_Users_UserRoles">
            <End Role="Users" EntitySet="Users" />
            <End Role="UserRoles" EntitySet="UserRoles" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_UserStatusHistory" Association="Self.FK_Users_UserStatusHistory">
            <End Role="Users" EntitySet="Users" />
            <End Role="UserStatusHistory" EntitySet="UserStatusHistory" />
          </AssociationSet>
          <AssociationSet Name="FK_UserSettings_Users" Association="Self.FK_UserSettings_Users">
            <End Role="Users" EntitySet="Users" />
            <End Role="UserSettings" EntitySet="UserSettings" />
          </AssociationSet>
          <AssociationSet Name="FK_UserStatus_Users" Association="Self.FK_UserStatus_Users">
            <End Role="UserStatus" EntitySet="UserStatus" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_UserStatus_UserStatusHistory" Association="Self.FK_UserStatus_UserStatusHistory">
            <End Role="UserStatus" EntitySet="UserStatus" />
            <End Role="UserStatusHistory" EntitySet="UserStatusHistory" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Model" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="AfxAdminSecurityContext" annotation:LazyLoadingEnabled="false">
          <EntitySet Name="Applications" EntityType="Model.Application" />
          <EntitySet Name="PasswordQuestions" EntityType="Model.PasswordQuestion" />
          <EntitySet Name="Roles" EntityType="Model.Role" />
          <EntitySet Name="Securables" EntityType="Model.Securable" />
          <EntitySet Name="Users" EntityType="Model.User" />
          <EntitySet Name="UserSettings" EntityType="Model.UserSetting" />
          <EntitySet Name="UserStatus" EntityType="Model.UserStatus" />
          <EntitySet Name="UserStatusHistories" EntityType="Model.UserStatusHistory" />
          <AssociationSet Name="FK_Applications_Roles" Association="Model.FK_Applications_Roles">
            <End Role="Applications" EntitySet="Applications" />
            <End Role="Roles" EntitySet="Roles" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_UserStatusHistory" Association="Model.FK_Users_UserStatusHistory">
            <End Role="Users" EntitySet="Users" />
            <End Role="UserStatusHistory" EntitySet="UserStatusHistories" />
          </AssociationSet>
          <AssociationSet Name="FK_UserStatus_Users" Association="Model.FK_UserStatus_Users">
            <End Role="UserStatus" EntitySet="UserStatus" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_UserStatus_UserStatusHistory" Association="Model.FK_UserStatus_UserStatusHistory">
            <End Role="UserStatus" EntitySet="UserStatus" />
            <End Role="UserStatusHistory" EntitySet="UserStatusHistories" />
          </AssociationSet>
          <AssociationSet Name="UserRoles" Association="Model.UserRoles">
            <End Role="Roles" EntitySet="Roles" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <FunctionImport Name="Pr_SaveUserPassword">
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="UserName" Mode="In" Type="String" />
            <Parameter Name="AuthMode" Mode="In" Type="String" />
            <Parameter Name="NewPassword" Mode="In" Type="String" />
            <Parameter Name="IsPasswordReset" Mode="In" Type="Boolean" />
          </FunctionImport>
          <EntitySet Name="WorkflowBuddies" EntityType="Model.WorkflowBuddy" />
          <FunctionImport Name="Pr_UpdateRelatedTable">
            <Parameter Name="PrimaryID" Mode="In" Type="String" />
            <Parameter Name="PrimaryColumnName" Mode="In" Type="String" />
            <Parameter Name="RelatedIds" Mode="In" Type="String" />
            <Parameter Name="RelatedSchema" Mode="In" Type="String" />
            <Parameter Name="RelatedTableName" Mode="In" Type="String" />
            <Parameter Name="RelatedPrimaryColumnName" Mode="In" Type="String" />
          </FunctionImport>
          <AssociationSet Name="FK_UserSettings_Users" Association="Model.FK_UserSettings_Users">
            <End Role="User" EntitySet="Users" />
            <End Role="UserSetting" EntitySet="UserSettings" />
          </AssociationSet>
          <EntitySet Name="RoleSecurables" EntityType="Model.RoleSecurable" />
          <AssociationSet Name="FK_Roles_RoleSecurables" Association="Model.FK_Roles_RoleSecurables">
            <End Role="Role" EntitySet="Roles" />
            <End Role="RoleSecurable" EntitySet="RoleSecurables" />
          </AssociationSet>
          <AssociationSet Name="FK_Securables_RoleSecurables" Association="Model.FK_Securables_RoleSecurables">
            <End Role="Securable" EntitySet="Securables" />
            <End Role="RoleSecurable" EntitySet="RoleSecurables" />
          </AssociationSet>
          <FunctionImport Name="Pr_ClearUserSettings">
          <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <EntitySet Name="Vw_Users" EntityType="Model.Vw_User" />
          <FunctionImport Name="Pr_GetActiveUsers" EntitySet="Vw_Users" ReturnType="Collection(Model.Vw_User)">
          <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetUser" EntitySet="Users" ReturnType="Collection(Model.User)">
            <Parameter Name="ReturnUserID" Mode="In" Type="Int64" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUser">
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="KnownAs" Mode="In" Type="String" />
            <Parameter Name="LastName" Mode="In" Type="String" />
            <Parameter Name="FirstName" Mode="In" Type="String" />
            <Parameter Name="Email" Mode="In" Type="String" />
            <Parameter Name="NTAccount" Mode="In" Type="String" />
            <Parameter Name="Cell" Mode="In" Type="String" />
            <Parameter Name="OfficeLocationID" Mode="In" Type="Int64" />
            <Parameter Name="UserProfileDocID" Mode="In" Type="Int64" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_UserStatusUpdate">
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="UserStatusID" Mode="In" Type="Int16" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUserRoles">
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="RolesCsv" Mode="In" Type="String" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUserSettings">
            <Parameter Name="UpdateUserID" Mode="In" Type="Int64" />
            <Parameter Name="SettingName" Mode="In" Type="String" />
            <Parameter Name="SettingValue" Mode="In" Type="String" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUserFingerprint">
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="Fingerprint" Mode="In" Type="Binary" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_DeleteUserWorkflowBuddy">
            <Parameter Name="WorkflowID" Mode="In" Type="Int64" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="BuddyUserID" Mode="In" Type="Int64" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetUserWorkflowBuddies" ReturnType="Collection(Model.Pr_GetUserWorkflowBuddies_Result)">
          <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUserWorkflowBuddy">
            <Parameter Name="WorkflowID" Mode="In" Type="Int64" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="BuddyUserID" Mode="In" Type="Int64" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetUsersInRole" ReturnType="Collection(String)">
            <Parameter Name="AppName" Mode="In" Type="String" />
            <Parameter Name="RoleName" Mode="In" Type="String" />
            <Parameter Name="AuthMode" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetUsersInRoles" EntitySet="Vw_Users" ReturnType="Collection(Model.Vw_User)">
          <Parameter Name="RoleIds" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetRoleSecurables" EntitySet="RoleSecurables" ReturnType="Collection(Model.RoleSecurable)">
          <Parameter Name="RoleID" Mode="In" Type="Int16" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveRoleSecurables">
            <Parameter Name="RoleID" Mode="In" Type="Int16" />
            <Parameter Name="SecurablesCsv" Mode="In" Type="String" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_SaveUserFingerPrintRequestToken">
            <Parameter Name="UserID" Mode="In" Type="Int64" />
            <Parameter Name="CreateToken" Mode="In" Type="Boolean" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <FunctionImport Name="Pr_ValidateFingerPrintRequestToken" ReturnType="Collection(String)">
          <Parameter Name="FingerprintRequestToken" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="Pr_GetUserByFingerPrintRequestToken" EntitySet="Users" ReturnType="Collection(Model.User)">
          <Parameter Name="FingerprintRequestToken" Mode="In" Type="String" />
          </FunctionImport>
        </EntityContainer>
        <EntityType Name="Application">
          <Key>
            <PropertyRef Name="ApplicationID" />
          </Key>
          <Property Name="ApplicationID" Type="Int64" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="1000" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="Roles" Relationship="Model.FK_Applications_Roles" FromRole="Applications" ToRole="Roles" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <EntityType Name="PasswordQuestion">
          <Key>
            <PropertyRef Name="PasswordQuestionID" />
          </Key>
          <Property Name="Title" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Type="Int64" Name="PasswordQuestionID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
        </EntityType>
        <EntityType Name="Role">
          <Key>
            <PropertyRef Name="RoleID" />
          </Key>
          <Property Name="RoleID" Type="Int16" Nullable="false" />
          <Property Name="ApplicationID" Type="Int64" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="Application" Relationship="Model.FK_Applications_Roles" FromRole="Roles" ToRole="Applications" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
          <NavigationProperty Name="Users" Relationship="Model.UserRoles" FromRole="Roles" ToRole="Users" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="RoleSecurables" Relationship="Model.FK_Roles_RoleSecurables" FromRole="Role" ToRole="RoleSecurable" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <Property Name="ConflictingRoleIDs" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
        </EntityType>
        <EntityType Name="Securable">
          <Key>
            <PropertyRef Name="SecurableID" />
          </Key>
          <Property Name="SecurableID" Type="Int16" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="Description" Type="String" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="IsSystem" Type="Boolean" Nullable="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="RoleSecurables" Relationship="Model.FK_Securables_RoleSecurables" FromRole="Securable" ToRole="RoleSecurable" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <EntityType Name="User">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="UserStatusID" Type="Int16" Nullable="false" />
          <Property Name="EntityID" Type="Int32" />
          <Property Name="ItemID" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
          <Property Name="LastName" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" Unicode="false" FixedLength="false" />
          <Property Name="FullName" Type="String" Nullable="false" MaxLength="101" Unicode="false" FixedLength="false" annotation:StoreGeneratedPattern="Computed" />
          <Property Name="KnownAs" Type="String" MaxLength="101" Unicode="false" FixedLength="false" />
          <Property Name="Email" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="NTAccount" Type="String" MaxLength="255" Unicode="false" FixedLength="false" >
          </Property>
          <Property Name="Cell" Type="String" MaxLength="10" Unicode="false" FixedLength="false" />
          <Property Name="IsPasswordExpired" Type="Boolean" />
          <Property Name="PasswordDate" Type="DateTime" Precision="3" />
          <Property Name="PasswordHash" Type="String" MaxLength="255" Unicode="false" FixedLength="false" >
          </Property>
          <Property Name="PasswordSalt" Type="String" MaxLength="20" Unicode="false" FixedLength="false" >
          </Property>
          <Property Name="PasswordChallenge" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
          <Property Name="PasswordQuestion" Type="String" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="PasswordAnswerHash" Type="String" MaxLength="255" Unicode="false" FixedLength="false" >
          </Property>
          <Property Name="PasswordAnswerSalt" Type="String" MaxLength="20" Unicode="false" FixedLength="false" >
          </Property>
          <Property Name="PasswordAnswerChallenge" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
          <Property Name="FingerprintTemplate" Type="Binary" MaxLength="Max" FixedLength="false" a:GetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </Property>
          <Property Name="CreatedByID" Type="Int64" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="UpdatedByID" Type="Int64" Nullable="false" />
          <Property Name="UpdatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <NavigationProperty Name="UserStatusHistories" Relationship="Model.FK_Users_UserStatusHistory" FromRole="Users" ToRole="UserStatusHistory" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="UserStatus" Relationship="Model.FK_UserStatus_Users" FromRole="Users" ToRole="UserStatus" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="Roles" Relationship="Model.UserRoles" FromRole="Users" ToRole="Roles" >
          </NavigationProperty>
          <NavigationProperty Name="UserSettings" Relationship="Model.FK_UserSettings_Users" FromRole="User" ToRole="UserSetting" a:GetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Public" >
          </NavigationProperty>
          <Property Name="FingerprintRequestToken" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Name="FingerprintRequestExpiryDate" Type="DateTime" Precision="3" />
          <Property Name="UserProfileDocID" Type="Int64" />
          <Property Name="OfficeLocationID" Type="Int64" />
        </EntityType>
        <EntityType Name="UserSetting">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="SettingName" />
          </Key>
          <Property Name="UserID" Type="Int64" Nullable="false" />
          <Property Name="SettingName" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
          <Property Name="SettingValue" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="User" Relationship="Model.FK_UserSettings_Users" FromRole="UserSetting" ToRole="User" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <EntityType Name="UserStatus">
          <Key>
            <PropertyRef Name="UserStatusID" />
          </Key>
          <Property Name="UserStatusID" Type="Int16" Nullable="false" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
          <NavigationProperty Name="Users" Relationship="Model.FK_UserStatus_Users" FromRole="UserStatus" ToRole="Users" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="UserStatusHistories" Relationship="Model.FK_UserStatus_UserStatusHistory" FromRole="UserStatus" ToRole="UserStatusHistory" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <EntityType Name="UserStatusHistory">
          <Key>
            <PropertyRef Name="UserStatusHistoryID" />
          </Key>
          <Property Name="UserStatusHistoryID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="UserID" Type="Int64" Nullable="false" />
          <Property Name="UserStatusID" Type="Int16" Nullable="false" />
          <Property Name="UpdatedByID" Type="Int64" Nullable="false" />
          <Property Name="UpdatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <NavigationProperty Name="User" Relationship="Model.FK_Users_UserStatusHistory" FromRole="UserStatusHistory" ToRole="Users" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="UserStatus" Relationship="Model.FK_UserStatus_UserStatusHistory" FromRole="UserStatusHistory" ToRole="UserStatus" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <Association Name="FK_Applications_Roles">
          <End Role="Applications" Type="Model.Application" Multiplicity="1" />
          <End Role="Roles" Type="Model.Role" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Applications">
              <PropertyRef Name="ApplicationID" />
            </Principal>
            <Dependent Role="Roles">
              <PropertyRef Name="ApplicationID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_UserStatusHistory">
          <End Role="Users" Type="Model.User" Multiplicity="1" />
          <End Role="UserStatusHistory" Type="Model.UserStatusHistory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserStatusHistory">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserStatus_Users">
          <End Role="UserStatus" Type="Model.UserStatus" Multiplicity="1" />
          <End Role="Users" Type="Model.User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserStatus">
              <PropertyRef Name="UserStatusID" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="UserStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserStatus_UserStatusHistory">
          <End Role="UserStatus" Type="Model.UserStatus" Multiplicity="1" />
          <End Role="UserStatusHistory" Type="Model.UserStatusHistory" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserStatus">
              <PropertyRef Name="UserStatusID" />
            </Principal>
            <Dependent Role="UserStatusHistory">
              <PropertyRef Name="UserStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="UserRoles">
          <End Role="Roles" Type="Model.Role" Multiplicity="*" />
          <End Role="Users" Type="Model.User" Multiplicity="*" />
        </Association>
        <EntityType Name="WorkflowBuddy">
          <Key>
            <PropertyRef Name="WorkflowBuddyID" />
          </Key>
          <Property Type="Int64" Name="WorkflowBuddyID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="Int64" Name="WorkflowID" Nullable="false" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
          <Property Type="Int64" Name="UserID" Nullable="false" />
          <Property Type="Int64" Name="BuddyUserID" Nullable="false" />
        </EntityType>
        <Association Name="FK_UserSettings_Users">
          <End Type="Model.User" Role="User" Multiplicity="1" />
          <End Type="Model.UserSetting" Role="UserSetting" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="User">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="UserSetting">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="RoleSecurable">
          <Key>
            <PropertyRef Name="RoleID" />
            <PropertyRef Name="SecurableID" />
          </Key>
          <Property Type="Int16" Name="RoleID" Nullable="false" />
          <Property Type="Int16" Name="SecurableID" Nullable="false" />
          <Property Type="Boolean" Name="CanRead" Nullable="false" />
          <Property Type="Boolean" Name="CanEdit" Nullable="false" />
          <NavigationProperty Name="Role" Relationship="Model.FK_Roles_RoleSecurables" FromRole="RoleSecurable" ToRole="Role" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="Securable" Relationship="Model.FK_Securables_RoleSecurables" FromRole="RoleSecurable" ToRole="Securable" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <Association Name="FK_Roles_RoleSecurables">
          <End Type="Model.Role" Role="Role" Multiplicity="1" />
          <End Type="Model.RoleSecurable" Role="RoleSecurable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="RoleID" />
            </Principal>
            <Dependent Role="RoleSecurable">
              <PropertyRef Name="RoleID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Securables_RoleSecurables">
          <End Type="Model.Securable" Role="Securable" Multiplicity="1" />
          <End Type="Model.RoleSecurable" Role="RoleSecurable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Securable">
              <PropertyRef Name="SecurableID" />
            </Principal>
            <Dependent Role="RoleSecurable">
              <PropertyRef Name="SecurableID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="Vw_User">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="UserStatusID" />
            <PropertyRef Name="FullName" />
            <PropertyRef Name="Email" />
          </Key>
          <Property Name="UserID" Type="Int64" Nullable="false" />
          <Property Name="UserStatusID" Type="Int16" Nullable="false" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="FullName" Type="String" Nullable="false" MaxLength="101" FixedLength="false" Unicode="false" />
          <Property Name="KnownAs" Type="String" MaxLength="101" FixedLength="false" Unicode="false" />
          <Property Name="Email" Type="String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Name="UserProfileDocID" Type="Int64" />
          <Property Name="OfficeLocationID" Type="Int64" />
        </EntityType>
        <ComplexType Name="Pr_GetActiveUsers_Result">
          <Property Type="Int64" Name="UserID" Nullable="false" />
          <Property Type="Int16" Name="UserStatusID" Nullable="false" />
          <Property Type="String" Name="LastName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FirstName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FullName" Nullable="false" MaxLength="101" />
          <Property Type="String" Name="KnownAs" Nullable="true" MaxLength="101" />
          <Property Type="String" Name="Email" Nullable="false" MaxLength="255" />
        </ComplexType>
        <ComplexType Name="Pr_GetUser_Result">
          <Property Type="Int64" Name="UserID" Nullable="false" />
          <Property Type="Int16" Name="UserStatusID" Nullable="false" />
          <Property Type="Int32" Name="EntityID" Nullable="true" />
          <Property Type="String" Name="ItemID" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="LastName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FirstName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FullName" Nullable="false" MaxLength="101" />
          <Property Type="String" Name="KnownAs" Nullable="true" MaxLength="101" />
          <Property Type="String" Name="Email" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="NTAccount" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="Cell" Nullable="true" MaxLength="10" />
          <Property Type="Boolean" Name="IsPasswordExpired" Nullable="false" />
          <Property Type="DateTime" Name="PasswordDate" Nullable="false" Precision="23" />
          <Property Type="String" Name="PasswordHash" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="PasswordSalt" Nullable="false" MaxLength="20" />
          <Property Type="String" Name="PasswordChallenge" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="PasswordQuestion" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="PasswordAnswerHash" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="PasswordAnswerSalt" Nullable="false" MaxLength="20" />
          <Property Type="String" Name="PasswordAnswerChallenge" Nullable="true" MaxLength="20" />
          <Property Type="Binary" Name="FingerprintTemplate" Nullable="true" />
          <Property Type="Int64" Name="CreatedByID" Nullable="false" />
          <Property Type="DateTime" Name="CreatedDate" Nullable="false" Precision="23" />
          <Property Type="Int64" Name="UpdatedByID" Nullable="false" />
          <Property Type="DateTime" Name="UpdatedDate" Nullable="false" Precision="23" />
        </ComplexType>
        <ComplexType Name="Pr_GetUserWorkflowBuddies_Result">
          <Property Type="String" Name="WorkflowFriendlyName" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="KnownAs" Nullable="true" MaxLength="101" />
          <Property Type="Int64" Name="WorkflowID" Nullable="false" />
          <Property Type="Int64" Name="BuddyUserID" Nullable="false" />
        </ComplexType>
        <ComplexType Name="Pr_GetUsersInRoles_Result">
          <Property Type="Int64" Name="UserID" Nullable="false" />
          <Property Type="Int16" Name="UserStatusID" Nullable="false" />
          <Property Type="String" Name="LastName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FirstName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FullName" Nullable="false" MaxLength="101" />
          <Property Type="String" Name="KnownAs" Nullable="true" MaxLength="101" />
          <Property Type="String" Name="Email" Nullable="false" MaxLength="255" />
        </ComplexType>
        <ComplexType Name="Pr_GetRoleSecurables_Result">
          <Property Type="Int16" Name="RoleID" Nullable="false" />
          <Property Type="Int16" Name="SecurableID" Nullable="false" />
          <Property Type="Boolean" Name="CanRead" Nullable="false" />
          <Property Type="Boolean" Name="CanEdit" Nullable="false" />
        </ComplexType>
        <ComplexType Name="Pr_GetUserByFingerPrintRequestToken_Result">
          <Property Type="Int64" Name="UserID" Nullable="false" />
          <Property Type="Int16" Name="UserStatusID" Nullable="false" />
          <Property Type="Int32" Name="EntityID" Nullable="true" />
          <Property Type="String" Name="ItemID" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="LastName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FirstName" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="FullName" Nullable="false" MaxLength="101" />
          <Property Type="String" Name="KnownAs" Nullable="true" MaxLength="101" />
          <Property Type="String" Name="Email" Nullable="false" MaxLength="255" />
          <Property Type="String" Name="NTAccount" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="Cell" Nullable="true" MaxLength="10" />
          <Property Type="Boolean" Name="IsPasswordExpired" Nullable="true" />
          <Property Type="DateTime" Name="PasswordDate" Nullable="true" Precision="23" />
          <Property Type="String" Name="PasswordHash" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="PasswordSalt" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="PasswordChallenge" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="PasswordQuestion" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="PasswordAnswerHash" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="PasswordAnswerSalt" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="PasswordAnswerChallenge" Nullable="true" MaxLength="20" />
          <Property Type="Binary" Name="FingerprintTemplate" Nullable="true" />
          <Property Type="Int64" Name="CreatedByID" Nullable="false" />
          <Property Type="DateTime" Name="CreatedDate" Nullable="false" Precision="23" />
          <Property Type="Int64" Name="UpdatedByID" Nullable="false" />
          <Property Type="DateTime" Name="UpdatedDate" Nullable="false" Precision="23" />
          <Property Type="String" Name="FingerprintRequestToken" Nullable="true" MaxLength="255" />
          <Property Type="DateTime" Name="FingerprintRequestExpiryDate" Nullable="true" Precision="23" />
        </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="ModelStoreContainer" CdmEntityContainer="AfxAdminSecurityContext">
          <EntitySetMapping Name="Applications">
            <EntityTypeMapping TypeName="Model.Application">
              <MappingFragment StoreEntitySet="Applications">
                <ScalarProperty Name="ApplicationID" ColumnName="ApplicationID" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PasswordQuestions">
            <EntityTypeMapping TypeName="Model.PasswordQuestion">
              <MappingFragment StoreEntitySet="PasswordQuestions">
                <ScalarProperty Name="PasswordQuestionID" ColumnName="PasswordQuestionID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Roles">
            <EntityTypeMapping TypeName="Model.Role">
              <MappingFragment StoreEntitySet="Roles">
                <ScalarProperty Name="ConflictingRoleIDs" ColumnName="ConflictingRoleIDs" />
                <ScalarProperty Name="RoleID" ColumnName="RoleID" />
                <ScalarProperty Name="ApplicationID" ColumnName="ApplicationID" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Securables">
            <EntityTypeMapping TypeName="Model.Securable">
              <MappingFragment StoreEntitySet="Securables">
                <ScalarProperty Name="SecurableID" ColumnName="SecurableID" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="IsSystem" ColumnName="IsSystem" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Users">
            <EntityTypeMapping TypeName="Model.User">
              <MappingFragment StoreEntitySet="Users">
                <ScalarProperty Name="OfficeLocationID" ColumnName="OfficeLocationID" />
                <ScalarProperty Name="UserProfileDocID" ColumnName="UserProfileDocID" />
                <ScalarProperty Name="FingerprintRequestExpiryDate" ColumnName="FingerprintRequestExpiryDate" />
                <ScalarProperty Name="FingerprintRequestToken" ColumnName="FingerprintRequestToken" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
                <ScalarProperty Name="UserStatusID" ColumnName="UserStatusID" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="FullName" ColumnName="FullName" />
                <ScalarProperty Name="KnownAs" ColumnName="KnownAs" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="NTAccount" ColumnName="NTAccount" />
                <ScalarProperty Name="Cell" ColumnName="Cell" />
                <ScalarProperty Name="IsPasswordExpired" ColumnName="IsPasswordExpired" />
                <ScalarProperty Name="PasswordDate" ColumnName="PasswordDate" />
                <ScalarProperty Name="PasswordHash" ColumnName="PasswordHash" />
                <ScalarProperty Name="PasswordSalt" ColumnName="PasswordSalt" />
                <ScalarProperty Name="PasswordChallenge" ColumnName="PasswordChallenge" />
                <ScalarProperty Name="PasswordQuestion" ColumnName="PasswordQuestion" />
                <ScalarProperty Name="PasswordAnswerHash" ColumnName="PasswordAnswerHash" />
                <ScalarProperty Name="PasswordAnswerSalt" ColumnName="PasswordAnswerSalt" />
                <ScalarProperty Name="PasswordAnswerChallenge" ColumnName="PasswordAnswerChallenge" />
                <ScalarProperty Name="FingerprintTemplate" ColumnName="FingerprintTemplate" />
                <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
                <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserSettings">
            <EntityTypeMapping TypeName="Model.UserSetting">
              <MappingFragment StoreEntitySet="UserSettings">
                <ScalarProperty Name="UserID" ColumnName="UserID" />
                <ScalarProperty Name="SettingName" ColumnName="SettingName" />
                <ScalarProperty Name="SettingValue" ColumnName="SettingValue" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserStatus">
            <EntityTypeMapping TypeName="Model.UserStatus">
              <MappingFragment StoreEntitySet="UserStatus">
                <ScalarProperty Name="UserStatusID" ColumnName="UserStatusID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserStatusHistories">
            <EntityTypeMapping TypeName="Model.UserStatusHistory">
              <MappingFragment StoreEntitySet="UserStatusHistory">
                <ScalarProperty Name="UserStatusHistoryID" ColumnName="UserStatusHistoryID" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
                <ScalarProperty Name="UserStatusID" ColumnName="UserStatusID" />
                <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
                <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <AssociationSetMapping Name="UserRoles" TypeName="Model.UserRoles" StoreEntitySet="UserRoles">
            <EndProperty Name="Roles">
              <ScalarProperty Name="RoleID" ColumnName="RoleID" />
            </EndProperty>
            <EndProperty Name="Users">
              <ScalarProperty Name="UserID" ColumnName="UserID" />
            </EndProperty>
          </AssociationSetMapping>
          <FunctionImportMapping FunctionImportName="Pr_SaveUserPassword" FunctionName="Model.Store.Pr_SaveUserPassword" />
          <EntitySetMapping Name="WorkflowBuddies">
            <EntityTypeMapping TypeName="Model.WorkflowBuddy">
              <MappingFragment StoreEntitySet="WorkflowBuddies">
                <ScalarProperty Name="BuddyUserID" ColumnName="BuddyUserID" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
                <ScalarProperty Name="WorkflowID" ColumnName="WorkflowID" />
                <ScalarProperty Name="WorkflowBuddyID" ColumnName="WorkflowBuddyID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RoleSecurables">
            <EntityTypeMapping TypeName="Model.RoleSecurable">
              <MappingFragment StoreEntitySet="RoleSecurables">
                <ScalarProperty Name="CanEdit" ColumnName="CanEdit" />
                <ScalarProperty Name="CanRead" ColumnName="CanRead" />
                <ScalarProperty Name="SecurableID" ColumnName="SecurableID" />
                <ScalarProperty Name="RoleID" ColumnName="RoleID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="Pr_ClearUserSettings" FunctionName="Model.Store.Pr_ClearUserSettings" />
          <FunctionImportMapping FunctionImportName="Pr_UpdateRelatedTable" FunctionName="Model.Store.Pr_UpdateRelatedTable" />
          <EntitySetMapping Name="Vw_Users">
            <EntityTypeMapping TypeName="Model.Vw_User">
              <MappingFragment StoreEntitySet="Vw_Users">
                <ScalarProperty Name="OfficeLocationID" ColumnName="OfficeLocationID" />
                <ScalarProperty Name="UserProfileDocID" ColumnName="UserProfileDocID" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="KnownAs" ColumnName="KnownAs" />
                <ScalarProperty Name="FullName" ColumnName="FullName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="UserStatusID" ColumnName="UserStatusID" />
                <ScalarProperty Name="UserID" ColumnName="UserID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="Pr_GetActiveUsers" FunctionName="Model.Store.Pr_GetActiveUsers">
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_GetUser" FunctionName="Model.Store.Pr_GetUser">
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_SaveUser" FunctionName="Model.Store.Pr_SaveUser" />
          <FunctionImportMapping FunctionImportName="Pr_UserStatusUpdate" FunctionName="Model.Store.Pr_UserStatusUpdate" />
          <FunctionImportMapping FunctionImportName="Pr_SaveUserRoles" FunctionName="Model.Store.Pr_SaveUserRoles" />
          <FunctionImportMapping FunctionImportName="Pr_SaveUserSettings" FunctionName="Model.Store.Pr_SaveUserSettings" />
          <FunctionImportMapping FunctionImportName="Pr_SaveUserFingerprint" FunctionName="Model.Store.Pr_SaveUserFingerprint" />
          <FunctionImportMapping FunctionImportName="Pr_DeleteUserWorkflowBuddy" FunctionName="Model.Store.Pr_DeleteUserWorkflowBuddy" />
          <FunctionImportMapping FunctionImportName="Pr_GetUserWorkflowBuddies" FunctionName="Model.Store.Pr_GetUserWorkflowBuddies">
            <ResultMapping>
              <ComplexTypeMapping TypeName="Model.Pr_GetUserWorkflowBuddies_Result">
                <ScalarProperty Name="WorkflowFriendlyName" ColumnName="WorkflowFriendlyName" />
                <ScalarProperty Name="KnownAs" ColumnName="KnownAs" />
                <ScalarProperty Name="WorkflowID" ColumnName="WorkflowID" />
                <ScalarProperty Name="BuddyUserID" ColumnName="BuddyUserID" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_SaveUserWorkflowBuddy" FunctionName="Model.Store.Pr_SaveUserWorkflowBuddy" />
          <FunctionImportMapping FunctionImportName="Pr_GetUsersInRole" FunctionName="Model.Store.Pr_GetUsersInRole" />
          <FunctionImportMapping FunctionImportName="Pr_GetUsersInRoles" FunctionName="Model.Store.Pr_GetUsersInRoles">
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_GetRoleSecurables" FunctionName="Model.Store.Pr_GetRoleSecurables">
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="Pr_SaveRoleSecurables" FunctionName="Model.Store.Pr_SaveRoleSecurables" />
          <FunctionImportMapping FunctionImportName="Pr_SaveUserFingerPrintRequestToken" FunctionName="Model.Store.Pr_SaveUserFingerPrintRequestToken" />
          <FunctionImportMapping FunctionImportName="Pr_ValidateFingerPrintRequestToken" FunctionName="Model.Store.Pr_ValidateFingerPrintRequestToken" />
          <FunctionImportMapping FunctionImportName="Pr_GetUserByFingerPrintRequestToken" FunctionName="Model.Store.Pr_GetUserByFingerPrintRequestToken">
          </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="False" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams>
      <Diagram Name="SecurityModel">
        <EntityTypeShape EntityType="Model.Application" Width="1.875" PointX="0.5" PointY="0.5" Height="1.7879850260416674" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.PasswordQuestion" Width="2" PointX="6.875" PointY="0.75" Height="1.4033821614583331" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.Role" Width="1.875" PointX="0.5" PointY="2.75" Height="2.3648893229166656" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.Securable" Width="1.875" PointX="0.5" PointY="7.875" Height="2.1725878906249996" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.User" Width="2.125" PointX="3.375" PointY="0.5" Height="6.4032194010416656" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.UserSetting" Width="1.875" PointX="9.375" PointY="1" Height="1.7879850260416674" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.UserStatus" Width="2" PointX="6.875" PointY="2.75" Height="1.7879850260416674" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.UserStatusHistory" Width="2" PointX="6.875" PointY="5" Height="2.3648893229166674" IsExpanded="true" />
        <AssociationConnector Association="Model.FK_Applications_Roles" ManuallyRouted="false">
          <ConnectorPoint PointX="1.4375" PointY="2.2879850260416674" />
          <ConnectorPoint PointX="1.4375" PointY="2.75" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_Users_UserStatusHistory" ManuallyRouted="false">
          <ConnectorPoint PointX="5.5" PointY="6.0477604166666659" />
          <ConnectorPoint PointX="6.875" PointY="6.0477604166666659" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_UserStatus_Users" ManuallyRouted="false">
          <ConnectorPoint PointX="6.875" PointY="3.6439925130208337" />
          <ConnectorPoint PointX="5.5" PointY="3.6439925130208337" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_UserStatus_UserStatusHistory" ManuallyRouted="false">
          <ConnectorPoint PointX="7.875" PointY="4.5379850260416674" />
          <ConnectorPoint PointX="7.875" PointY="5" />
        </AssociationConnector>
        <AssociationConnector Association="Model.UserRoles" ManuallyRouted="false">
          <ConnectorPoint PointX="2.375" PointY="3.9324446614583328" />
          <ConnectorPoint PointX="3.375" PointY="3.9324446614583328" />
        </AssociationConnector>
        <EntityTypeShape EntityType="Model.WorkflowBuddy" Width="1.875" PointX="9.375" PointY="3.125" Height="1.7879850260416674" />
        <AssociationConnector Association="Model.FK_UserSettings_Users" >
          <ConnectorPoint PointX="5.5" PointY="2.4516910807291667" />
          <ConnectorPoint PointX="9.375" PointY="2.4516910807291667" />
        </AssociationConnector>
        <EntityTypeShape EntityType="Model.RoleSecurable" Width="1.875" PointX="0.5" PointY="5.375" />
        <AssociationConnector Association="Model.FK_Roles_RoleSecurables" />
        <AssociationConnector Association="Model.FK_Securables_RoleSecurables" />
        <EntityTypeShape EntityType="Model.Vw_User" Width="1.5" PointX="3.375" PointY="8.75" />
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>