[Pansophy] L2HE VTRF - Report and Fieldnames

[Tiffany Ganey]

Row 5: In R1 it was MP_Present.  For current versions, I think you want to map Final_MP_Present instead of initial.
Rows 20-21: CavityPerformance and MultipactingComment were comment boxes in R1.  The intent in R2/R3 was that this information should all be consolidated into the PerformanceLimitAt2K_0K_Other comment box.
Question in Row 23: Yes - final_EaccFEOnset in R1 is the same as final_FEOnsetMVm in R2/R3.

When the L2HE VTRF traveler was updated for R2, the intent was to move the traveler towards standardization with other projects.  Hopefully we will eventually get all projects to use the same variable names for the same data entry.

Tiffany Ganey

From: Megan McDonald <megan at jlab.org>
Sent: Wednesday, January 19, 2022 10:21 AM
To: John Vennekate <hannesv at jlab.org>; Tiffany Ganey <ganey at jlab.org>; John Hogan <hogan at jlab.org>; Kirk Davis <kdavis at jlab.org>
Cc: pansophy <pansophy at jlab.org>; Katherine Wilson <kwilson at jlab.org>; Jacob Harris <jharris at jlab.org>
Subject: L2HE VTRF - Report and Fieldnames

All,

Attached is an excel sheet with the variable fieldnames that have changed between R1, R2 and R3. Fieldnames in travelers and consistency between revisions is very important for datamining, specifically on travelers that are heavily reported on like the VTRF. The reports that we build for travelers key off of the fieldnames so if a fieldname is changed in the slightest, such as adding or removing characters, the report doesn't break, it just doesn't show the data for the new revisions. In this case, the Cavity Performance Grid in the Projects area was generated using fieldnames from R1. Fieldnames were changed for R2 and R3, therefore, the data didn't appear.

I have copied the data over in the database and changed the fields that are used in the report to the best of my ability. Please review the attached sheet to see how I matched the fields and to note the two fields that are in the report and have been removed from the traveler in R2 and R3. If you notice something that still isn't appearing correctly in the report, please let us know.

Megan McDonald
Office - (757) 269-7641
Cell - (757) 234-1604

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220119/471e76be/attachment.html>