ESdat Forums
»
Forums
»
ESdat
»
ESdat Online Chemistry Profile
 Rank: Newbie
Groups: Registered
Posts: 2
Thanks: 1 times
|
A few lab reports were imported with combined PFAS data (i.e. sum of compounds), and it appears that the chemcode might have been automatically changed to an incorrect chemcode during import. The original chem code is not visible in the chem profile, and we cant seem to add a new chemcode in ESdat online.
But - if i search for the chem name in the chem profile, it shows that its associated with a different (incorrect) chemcode. If i search for the chem name in the chemistry results table, it shows that the results have been imported for the chem name (So i assume that the chemcode has ether been changed, or there's a secret chemcode table that isnt visible in Online?). The original ChemName is: "Sum of PFHxS and PFOS", and ChemCode: "355-46-4/1763-23-1". The chem profile shows an entry for the same ChemName, but with the ChemCode: "375-85-9/1963-23-1", which relates to a different combination of PFAS results.
Does anyone know how to add a new ChemCode/ChemName to a chemisty profile in Online?
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hello Andrew, The ChemCode that was being used in ESdat Online for "Sum of PFHxS and PFOS" was "375-85-9/1763-23-1". As you say the ChemCode for PFHxS is "355-46-4" not "375-85-9" so the correct ChemCode for "Sum of PFHxS and PFOS" results should be "355-46-4/1763-23-1"
System Admins can view a summary of all OriginalChemName values across the system for a particular ChemCode, which shows that all results using the ChemCode of "375-85-9/1763-23-1" had an OriginalChemName of "Sum of PFHxS and PFOS" or "Sum (PFHxS + PFOS)" (and conversley in a seperate summary that all results with those OriginalChemNames were consistently assigned that ChemCode). The output name for that ChemCode was "Sum of PFHxS and PFOS" for all ChemProfiles in the system, so was consistent with the OriginalChemNames and no outputs from the system will have been affected. There are no environmental standards for this in the system, so there were no issues with exceedances not being identified if they had been loaded with a different ChemCode.
The ChemCode has now been edited to reflect the OriginalChemName and ChemName values Admins have the capacity in the system to ensure that all results with an OriginalChemName of "Sum of PFHxS and PFOS" or "Sum (PFHxS + PFOS)" are assigned the correct ChemCode of "355-46-4/1763-23-1" during future imports. That has been implemented in case future "Sum of PFHxS and PFOS" results are being imported with the previous "375-85-9/1763-23-1". (Note for onsite users they manage this themselves). As regards other questions, or just as an FYI: Users can search all the ChemCodes and ChemNames in ESdat Online, including at https://online.ESdat.net/ChemistryLookup. Users can't add ChemCodes to the SaaS/Cloud ESdat Online. Only support and laboratories can add ChemCodes. If you have a lab report where the data from the lab was automatically changed from "355-46-4/1763-23-1" to "375-85-9/1763-23-1" then please send us the report number as there was no rule in place to make that change so we'd need to look at that further. Edited by user Sunday, July 9, 2017 2:26:35 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 79
|
We had the issue with the PFAS - that we noticed that Names like 'SUM' was tripping the importer into picking the wrong chemcode. In the end we just changed the wording of the Chem Name slightly in the database and it was back to correctly picking the chem name when it saw the Original_Chem_Name as one of the Alternative_Name matches .
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
ESdat Online Chemistry Profile
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.