[Pansophy] Open Traveler Errors

[Mike Dickey]

Hi All,

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.


  *   I found a discrepancy in the query for Travelers By Age and made the correction.
  *   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.
     *   Modify the query for TRAVELERS BY AGE to check for Obsoleted travelers (in TRAV_CONFIG).
     *   Close the orphaned travelers (in TRAV_OWNERS).

Both of these should be done, the first to eliminate any futures issues, and the second to close travelers that have been orphaned.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Pansophy <pansophy-bounces at mailman.jlab.org> On Behalf Of Ashley Mitchell via Pansophy
Sent: Monday, April 1, 2024 3:03 PM
To: pansophy at jlab.org
Subject: [Pansophy] Open Traveler Errors

Hi,

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.

[cid:image001.png at 01DA84D4.FEA17BE0]

I also get a different number when I pull Travelers by Project Op/Cl Report.
C100R 39 total:
[cid:image002.png at 01DA84D4.FEA17BE0]

Ashley Mitchell (She/Her/Hers)
Quality Engineer
SNS-PPU Project Coordinator/CAM
Cell: 757-434-2905
[https://www.jlab.org/div_dept/dir_off/public_affairs/logo/JLabEmailSig.png]
600 Kelvin Dr.
Suite 8, MS 55H
Newport News, VA 23606
www.jlab.org<http://www.jlab.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240402/5b825470/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15460 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240402/5b825470/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 27730 bytes
Desc: image002.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240402/5b825470/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OC vs Age Descrepancies.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 11948 bytes
Desc: OC vs Age Descrepancies.xlsx
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240402/5b825470/attachment-0001.xlsx>