[Pansophy] FW: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request

[Megan McDonald]

Hi Ashley!
Sorry for the delayed response. Since it is new fields being added to track, it would just be easier to create a new revision. We can move any currently open travelers to the newest revision once it is released, if need be.

Megan

From: Matthew Menia <menia at jlab.org>
Sent: Tuesday, March 21, 2023 2:53 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>
Subject: RE: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request

Hey Megan,

Can I add the RAM code without the need for a new revision?

Matt

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Tuesday, March 21, 2023 2:48 PM
To: Matthew Menia <menia at jlab.org<mailto:menia at jlab.org>>
Cc: Megan McDonald <megan at jlab.org<mailto:megan at jlab.org>>
Subject: Re: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request

The RAM code should be able to add without a new revision.  Check with Megan

Get Outlook for Android<https://aka.ms/ghei36>
________________________________
From: Matthew Menia <menia at jlab.org<mailto:menia at jlab.org>>
Sent: Tuesday, March 21, 2023 2:00:01 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Subject: FW: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request


Hey Valerie,



A R3 is necessary to add the RAM info since it is not a field in the R2? Or this there a way to display the information?



Matt



From: Ashley Mitchell <ashleya at jlab.org<mailto:ashleya at jlab.org>>
Sent: Tuesday, March 21, 2023 9:35 AM
To: Matthew Menia <menia at jlab.org<mailto:menia at jlab.org>>
Cc: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Subject: Re: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request



Matt,

See below.  The inspection comment could be linked with Inspection notes.



I need the RAM info in the new one, should I make a R3?



- Ashley





________________________________

From: Matthew Menia <menia at jlab.org<mailto:menia at jlab.org>>
Sent: Wednesday, March 1, 2023 9:37 AM
To: Ashley Mitchell <ashleya at jlab.org<mailto:ashleya at jlab.org>>
Cc: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Subject: C100R-CAV-CHEM-COMP/C100R-CHEM-COMP-DEGR Request



Good morning Ashley,



I have been working on completing your request and had a question on merging the data.



I pulled the data fields from C100R-CAV-CHEM-COMP-R1 and C100R-CHEM-COMP-DEGR-R2 then compared them to find the best match. Before I move forward I wanted to make sure the fields are properly matched if you could double check the data fields when you have time?



C100R-CAV-CHEM-COMP-R1

C100R-CHEM-COMP-DEGR-R2

ITEMNAME

C100PairComponent

CEBRZSN

DSRFSN

VTATHSN

HMFTSN

HMFTSN

FPFTSN

FPFTSN

WBASN

WINWGDSN

WINSN

WINSN

WGDSN

WGDSN

DropSN

ITEMNAMEOTHER

OTHERSERIALNUMBER

NOTES

CavActivated

RamTagNoCavity

RamCouponNoCavity

DoseAt30cmCav

RADComment

CleaningTimestamp

TimeAndDateDegr

ClnComment

DegreaseComment

BeginCleaningTechnician1

DegreaseTech

BeginCleaningTechnician2

BeginCleaningTechnician3

Inspected

DamageNote

InspectionNotes

Final_Inspection_Comment

AllCompClean

AllCompClnComment

AcidEtchNeeded

BCP (Yes?)

AcidEtchComment

BCPEtchTime

EndCleaningTechnician1

BCPTech

EndCleaningTechnician2

EndCleaningTechnician3

ProcessComment

Final_Inspection_Comment





Thank you,

Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20230323/eb233c32/attachment-0001.html>