<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Mike,</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks for looking into this. I also realized it might be when the reports are pulled - if it's on the 1<sup>st</sup> of the month or end of the month or month to date, so we might just always have a bit of a discrepancy between reports. </div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
- Ashley</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Mike Dickey <mdickey@jlab.org><br>
<b>Sent:</b> Tuesday, April 2, 2024 8:31 AM<br>
<b>To:</b> Ashley Mitchell <ashleya@jlab.org><br>
<b>Cc:</b> pansophy@jlab.org <pansophy@jlab.org><br>
<b>Subject:</b> RE: Open Traveler Errors</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Consolas}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
p.x_MsoListParagraph, li.x_MsoListParagraph, div.x_MsoListParagraph
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle19
{font-family:Consolas;
color:#1F497D;
font-weight:normal;
font-style:normal}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
ol
{margin-bottom:0in}
ul
{margin-bottom:0in}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D">Hi All,</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D">Having written these pages awhile ago, I thought I should take a look to see what was going on. I looked at C100R, the others will need additional time.</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D"> </span></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="color:#1F497D; margin-left:0in"><span style="font-size:14.0pt; font-family:Consolas">I found a discrepancy in the query for Travelers By Age and made the correction.</span></li><li class="x_MsoListParagraph" style="color:#1F497D; margin-left:0in"><span style="font-size:14.0pt; font-family:Consolas">In the spreadsheet above, I had to do a more in-depth analysis of the data to figure out what else was happening. In the comments you
can see that the Traveler acronyms have changed, to include the WCA. There are 2 solutions to deal with this problem.</span></li><ul type="circle" style="margin-top:0in">
<li class="x_MsoListParagraph" style="color:#1F497D; margin-left:0in"><span style="font-size:14.0pt; font-family:Consolas">Modify the query for TRAVELERS BY AGE to check for Obsoleted travelers (in TRAV_CONFIG).</span></li><li class="x_MsoListParagraph" style="color:#1F497D; margin-left:0in"><span style="font-size:14.0pt; font-family:Consolas">Close the orphaned travelers (in TRAV_OWNERS).</span></li></ul>
</ul>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D">Both of these should be done, the first to eliminate any futures issues, and the second to close travelers that have been orphaned.</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D"> </span></p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:Consolas; color:black">Mike Dickey</span></p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:Consolas; color:black">SRF Inventory Technician</span></p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:Consolas; color:black">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-size:12.0pt; font-family:Consolas; color:#1F497D"></span></p>
</div>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:Consolas; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> Pansophy <pansophy-bounces@mailman.jlab.org> <b>
On Behalf Of </b>Ashley Mitchell via Pansophy<br>
<b>Sent:</b> Monday, April 1, 2024 3:03 PM<br>
<b>To:</b> pansophy@jlab.org<br>
<b>Subject:</b> [Pansophy] Open Traveler Errors</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Hi,</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">When I add up the open travelers from the Travelers open by age report (Total Open below), I get a different number than when I pull the Projects Metrics Report (Traveler Open below) on 4 of
the 7 projects.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><img width="603" height="170" id="x_Picture_x0020_1" style="width:6.2812in; height:1.7708in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01DA84D4.FEA17BE0"></span><span style="font-size:12.0pt; color:black"></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">I also get a different number when I pull Travelers by Project Op/Cl Report.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">C100R 39 total:</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><img width="519" height="403" id="x_Picture_x0020_2" style="width:5.4062in; height:4.1979in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01DA84D4.FEA17BE0"></span><span style="font-size:12.0pt; color:black"></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div id="x_Signature">
<div>
<p class="x_MsoNormal"><b><span style="font-size:13.0pt; color:black">Ashley Mitchell</span></b><b><span style="font-size:9.0pt; color:black">
</span></b><span style="font-size:9.0pt; color:black">(She/Her/Hers)</span><span style="color:black"></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Quality Engineer</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">SNS-PPU Project Coordinator/CAM</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Cell: 757-434-2905<br>
</span><span style="font-size:12.0pt; color:black"><img width="144" height="36" id="x__x0000_i1025" style="width:1.5in; height:.375in" src="https://www.jlab.org/div_dept/dir_off/public_affairs/logo/JLabEmailSig.png"></span><span style="font-size:12.0pt; color:black"><br>
600 Kelvin Dr.<br>
Suite 8, MS 55H<br>
Newport News, VA 23606</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><a href="http://www.jlab.org" target="_blank">www.jlab.org</a></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
</div>
</div>
</div>
</body>
</html>