[Pansophy] Serial Numbers from Cryomodules (A starting point)

[Mike Dickey]

Hi Matt,

There is a system table where you can look for serial number fields in tables (Travelers).  The ALL_TAB_COLUMNS table has a lot of information about the tables and columns, but we are only interested in a few, Owner, Table_Name, and Column_Name.  I put together a sample query to, hopefully, get things started.  Depending on the Traveler area, CAV, CST, or CM, you will be ably to get some of the serial numbers for a specific Cryomodule.

Again this is a starting point, and will take more work to link cavities to the cryomodule that they went into or get the feedthrus on those cavities.  I did some of that work for the PRIMeS/InspectionStatus.cfm report page.

For the query below, copy/paste into SQL Developer, Traveler DB, and RUN it.  Under the current conditions, it will get a few non-serial number fields like, Waveguide...

// ALL Tables and Columns with "SN' or 'ID' in them from the C100 project

select  table_name AS "Tables", column_name "VarName"
FROM    all_tab_columns
where   owner = upper('ADAPPS')
and     (column_name LIKE '%SN%' or column_name LIKE '%ID%')
and     table_name LIKE 'C100%ASSY%'
and     table_name NOT LIKE 'C100R%'
order by table_name, column_name;

Let me know if you have any questions,

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20241016/9bf5cb91/attachment.html>