<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="attendance-time" name="Attendance support and approved daily time">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Attendance support and approved daily time">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="Which stored keys connect a daily time record to its supporting evidence?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition" label="ShiftDefinition" tableName="ShiftDefinition" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition__grain" label="One shift template" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ShiftDefinition">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition__ShiftDefinitionID" label="ShiftDefinitionID (PK)" fieldName="ShiftDefinitionID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ShiftDefinition">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition__ShiftCode" label="ShiftCode" fieldName="ShiftCode">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ShiftDefinition">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition__Department" label="Department" fieldName="Department">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ShiftDefinition">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ShiftDefinition__WorkCenterID" label="WorkCenterID (FK)" fieldName="WorkCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ShiftDefinition">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment" label="EmployeeShiftAssignment" tableName="EmployeeShiftAssignment" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment__grain" label="One employee shift assignment over&#10;effective dates" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftAssignment">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment__EmployeeShiftAssignmentID" label="EmployeeShiftAssignmentID (PK)" fieldName="EmployeeShiftAssignmentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftAssignment">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment__ShiftDefinitionID" label="ShiftDefinitionID (FK)" fieldName="ShiftDefinitionID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftAssignment">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment__EmployeeID" label="EmployeeID (FK)" fieldName="EmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftAssignment">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftAssignment__WorkCenterID" label="WorkCenterID (FK)" fieldName="WorkCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftAssignment">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster" label="EmployeeShiftRoster" tableName="EmployeeShiftRoster" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="170" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster__grain" label="One employee planned shift on a&#10;roster date" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftRoster">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster__EmployeeShiftRosterID" label="EmployeeShiftRosterID (PK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftRoster">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster__ShiftDefinitionID" label="ShiftDefinitionID (FK)" fieldName="ShiftDefinitionID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftRoster">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster__EmployeeID" label="EmployeeID (FK)" fieldName="EmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftRoster">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeShiftRoster__RosterDate" label="RosterDate" fieldName="RosterDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeShiftRoster">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence" label="EmployeeAbsence" tableName="EmployeeAbsence" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="610" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence__grain" label="One absence record against a&#10;roster" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeAbsence">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence__EmployeeAbsenceID" label="EmployeeAbsenceID (PK)" fieldName="EmployeeAbsenceID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeAbsence">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence__EmployeeShiftRosterID" label="EmployeeShiftRosterID (FK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeAbsence">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence__AbsenceDate" label="AbsenceDate" fieldName="AbsenceDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeAbsence">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="EmployeeAbsence__AbsenceType" label="AbsenceType" fieldName="AbsenceType">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="EmployeeAbsence">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval" label="OvertimeApproval" tableName="OvertimeApproval" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="610" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval__grain" label="One recorded overtime approval" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="OvertimeApproval">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval__OvertimeApprovalID" label="OvertimeApprovalID (PK)" fieldName="OvertimeApprovalID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="OvertimeApproval">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval__EmployeeShiftRosterID" label="EmployeeShiftRosterID (FK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="OvertimeApproval">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval__WorkDate" label="WorkDate" fieldName="WorkDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="OvertimeApproval">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="OvertimeApproval__ApprovedHours" label="ApprovedHours" fieldName="ApprovedHours">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="OvertimeApproval">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch" label="TimeClockPunch" tableName="TimeClockPunch" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="610" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch__grain" label="One raw clock-punch event" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockPunch">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch__TimeClockPunchID" label="TimeClockPunchID (PK)" fieldName="TimeClockPunchID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockPunch">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch__TimeClockEntryID" label="TimeClockEntryID (FK)" fieldName="TimeClockEntryID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockPunch">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch__EmployeeShiftRosterID" label="EmployeeShiftRosterID (FK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockPunch">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockPunch__PunchTimestamp" label="PunchTimestamp" fieldName="PunchTimestamp">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockPunch">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry" label="TimeClockEntry" tableName="TimeClockEntry" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="1050" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry__grain" label="One approved-time record for an&#10;employee work date" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockEntry">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry__TimeClockEntryID" label="TimeClockEntryID (PK)" fieldName="TimeClockEntryID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockEntry">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry__EmployeeShiftRosterID" label="EmployeeShiftRosterID (FK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockEntry">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry__EmployeeID" label="EmployeeID (FK)" fieldName="EmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockEntry">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="TimeClockEntry__PayrollPeriodID" label="PayrollPeriodID (FK)" fieldName="PayrollPeriodID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="TimeClockEntry">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException" label="AttendanceException" tableName="AttendanceException" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="1050" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException__grain" label="One logged attendance-review&#10;exception" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="AttendanceException">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException__AttendanceExceptionID" label="AttendanceExceptionID (PK)" fieldName="AttendanceExceptionID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="AttendanceException">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException__TimeClockEntryID" label="TimeClockEntryID (FK)" fieldName="TimeClockEntryID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="AttendanceException">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException__EmployeeShiftRosterID" label="EmployeeShiftRosterID (FK)" fieldName="EmployeeShiftRosterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="AttendanceException">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="AttendanceException__ExceptionType" label="ExceptionType" fieldName="ExceptionType">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="AttendanceException">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="r1" label="r1" relationKind="reference" childTable="EmployeeShiftAssignment" childFields="ShiftDefinitionID" parentTable="ShiftDefinition" parentFields="ShiftDefinitionID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ShiftDefinition__ShiftDefinitionID" target="EmployeeShiftAssignment__ShiftDefinitionID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="279.0" />
                <mxPoint x="379.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r2" label="r2" relationKind="reference" childTable="EmployeeShiftRoster" childFields="ShiftDefinitionID" parentTable="ShiftDefinition" parentFields="ShiftDefinitionID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ShiftDefinition__ShiftDefinitionID" target="EmployeeShiftRoster__ShiftDefinitionID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1.0" y="279.0" />
                <mxPoint x="1.0" y="408.0" />
                <mxPoint x="771.0" y="408.0" />
                <mxPoint x="771.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r3" label="r3" relationKind="reference" childTable="EmployeeAbsence" childFields="EmployeeShiftRosterID" parentTable="EmployeeShiftRoster" parentFields="EmployeeShiftRosterID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="EmployeeShiftRoster__EmployeeShiftRosterID" target="EmployeeAbsence__EmployeeShiftRosterID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="771.0" y="279.0" />
                <mxPoint x="771.0" y="162.0" />
                <mxPoint x="-45.0" y="162.0" />
                <mxPoint x="-45.0" y="749.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r4" label="r4" relationKind="reference" childTable="OvertimeApproval" childFields="EmployeeShiftRosterID" parentTable="EmployeeShiftRoster" parentFields="EmployeeShiftRosterID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=1;entryY=0.5;" edge="1" parent="1" source="EmployeeShiftRoster__EmployeeShiftRosterID" target="OvertimeApproval__EmployeeShiftRosterID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1149.0" y="279.0" />
                <mxPoint x="1149.0" y="586.0" />
                <mxPoint x="764.0" y="586.0" />
                <mxPoint x="764.0" y="749.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r5" label="r5" relationKind="reference" childTable="TimeClockEntry" childFields="EmployeeShiftRosterID" parentTable="EmployeeShiftRoster" parentFields="EmployeeShiftRosterID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="EmployeeShiftRoster__EmployeeShiftRosterID" target="TimeClockEntry__EmployeeShiftRosterID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1195.0" y="279.0" />
                <mxPoint x="1195.0" y="1288.0" />
                <mxPoint x="1.0" y="1288.0" />
                <mxPoint x="1.0" y="1189.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r6" label="r6" relationKind="reference" childTable="TimeClockPunch" childFields="TimeClockEntryID" parentTable="TimeClockEntry" parentFields="TimeClockEntryID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="TimeClockEntry__TimeClockEntryID" target="TimeClockPunch__TimeClockEntryID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1.0" y="1159.0" />
                <mxPoint x="1.0" y="848.0" />
                <mxPoint x="771.0" y="848.0" />
                <mxPoint x="771.0" y="749.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r7" label="r7" relationKind="reference" childTable="AttendanceException" childFields="TimeClockEntryID" parentTable="TimeClockEntry" parentFields="TimeClockEntryID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="TimeClockEntry__TimeClockEntryID" target="AttendanceException__TimeClockEntryID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="1159.0" />
                <mxPoint x="379.0" y="1189.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="footer" label="(PK) = primary key. (FK) = foreign key.&#10;Solid crow’s-foot lines show foreign-key relationships; dashed labeled lines show conditional traces or analytical matches. See r1, r2… in the relationship table.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="1320.0" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
