Main Page

The main index page for the system shows the tube names in a tabbed format and clicking on the tabs will show options and information available for that tube. If the tube's tab color is pink, that is an indicator that its spare count (spare, conditioning and stand by tubes) is lower than the configured minumum. More information about the main page is available.

Authorization

The editing and updating features of this system require authorization which is done through the WWW server and requires a certificate in the browser. For Windows, all machines should now have the Network ID Manager which creates the certificate when logging into to the machine. This is automatically available to Internet Explorer but a plugin needs installed for Firefox (Mozilla). The plugin will already be on the machine, as it comes with the Network ID Manager, and instructions for installing it are available from the Network ID Manager at:

Help->Kerberos Certificates->Installing the PKCS11

Edit->Preferences->Privacy & Security->Certificates

Edit->Preferences->Advanced->Encryption Tab-> View Certificates

Authorization for the system is done in levels and different parts of the system have different authorization requirements. People with full authorization can make changes to these level requirements.

Data

Source

The data in the system originally came from Fernanda from a file "7835TubesInventory.xls" on October 19, 2009. She then researched more information and gave me "7835Michel.xls". Information from this second spreadsheet was used for the tube data and the first one was used to populate the station data for the tubes.

Since then, some updates have been made based on the monthly reports received using the interface.

Tube Status

The initial data did not include any tube status information so some assumptions have been made to get some initial data. The following is the order which this assignments were done.

Spare

update
    mccusker.tube_history set status_id=1
where
    received_date != null
    and tube_history_id not in
        (select tube_history_id from mccusker.tube_station_history)

Active

update tube_history set status_id=0
where
    tube_history_id in
        (select tube_history_id from tube_station_history where outservice_date = null)

Archived

1. Select all the tubes into a file, getting their tube history id
2. Remove the lastest rebuild of each tube (just be editing the file)
3. Create the update command for each line setting the status to archived

Failed

update tube_history set status_id=2 where tube_history_id in (select h.tube_history_id from
    tube_type_info i,
    tube_history h,
    tube_station_history s
where
    i.type_info_id=h.type_info_id
    and h.tube_history_id = s.tube_history_id
    and s.outservice_date != null
    and h.status_id=null)

Note When a rebuild is entered in, the system will mark its predecessor as archived.

The data is put into mulitple tables.

Reports

On most reports, clicking on the serial number will show a new report for that specific tube. From there, moving over its rebuild (which is really only different for the 7835 tubes) will display a menu of other options for that tube. Also, if a report has a PO number shown, it will be a link to information within Business Services about the PO.

Tube List

The "Tube List" link provides a list of tubes listed by default in order of the date they were received. The sorting of this list can be changed using the links in the table column headers. The data can also be exported into a separated file.

Tube History

This link provides a report sorted by the tube's serial followed by all of its rebuilds. From this list, one particular tube can be searched for and viewed and information on the tube and its station history can be edited from here. Clicking on the drawing icon will display a page listing the history for that rebuild and information can be updated. Right clicking on the rebuild number will show a context menu with options to edit the tube information or edit/view the build history.

Station Report

This report list the history of tubes in the stations sorted by the station and then the date inservice.

Status Report

This report uses the status of the tubes and provides a status report of all non-archived tubes.

Estimate Number of Years of Operation with Current Inventory

This report shows a table with the available inventory and for rebuilt tubes, shows how that inventory can be used and how long doing the rebuilds will prolong the life of the current inventory. Under the table, is a plot that shows the curve of a few columns. Notes on some of the columns:

Potential Inventory	This column is the current Rebuild's inventory minus those that have failed plus the previous rebuild's failed count - assuming that those will eventually be rebuilt, but not after rebuild 5 since vendor rarely rebuild that many times.
Capitol Investment	Shows the current cost of the tubes but does not accumulate rebuilding costs.

And then there is a link to view a "play" table where some of the values can be changed

Interface

The user interface consists of several screens with form for data entry. There are also links to viewing the data using the reports

Add New Tube

To add a new tube to the system, a person has to be an administrator of the system. With a Kerberos ticket in the browser, the authorization list can be viewed.

The form will be slightly different depending on what tube is being entered. For all tubes, the serial number, rebuild number (which could be zero for new), cost, PO, supplier, date received, status and notes can be entered along with flaging a tube for a particular station and uploading files for the tube. If the tube is a 7835, a indication of an ion pump, getterless and borrrowed are also available. For the 7835 and the 4616, at task associated with its rebuilt status can be selected. And tubes 7835, 7651, ML-6544, 4616, VKP-7955 and L-5859 can have Special Operating Spare (SPS) values.

Hitting the "Review Entry" button will display another screen showing what inserts are going to be made. It will also upload any files asked to be up loaded into a temporary space. If any errors or omitions are found, those will be indicated. Once the "Save Entry" button is used, the tube information is saved.

Update Tube

Updating tube information will use the same form as the add tube. One difference is how the uploaded files are handled. They are uploaded as soon as the "Review Update" button is selected. And any files already on the system with the same name will be overwritten.

One thing to note here is the update does not allow changing the serial number. This could have unintended consequences especially for the 7835 tubes. Serial numbers are only stored once and for the 7835, this means that each rebuild of that tube, before and after the one being viewed, would be changed to the new name as well. If this is what is intended, that change can be done now manually in the database table but there is no interface for it.

Also, the rebuild value can only be changed by those with full administrative access.

Insert Tube Into Station

The form to insert a tube in to a station will show those tubes that are marked "Spare", "Stand By", or "Conditioning" which are the ones deemed ready to be inserted. Then the form will allowing picking where the chosen tube should be inserted - which station. Some tubes are actually in the station more than once and the list to pick from will include the location in the station for that tube as well. Meter reading information at the time of insertion can be recorded here as well. Upon insertion, the tube is marked "Active".

Rebuild Tube

The form to rebuild a tube is available as soon as the status for a tube is changed to "Being Rebuilt". This form has the elements to track the rebuilding. First is setting the date the tube is being marked to be rebuilt which is initially set on the tube entry form, along with the status for the rebuild process which is initially set to "Waiting to be shipped".

Once the tube is shipped, that status can be updated to reflect that here and the date and where it is sent can be provided. Any notes on sending the tube can also be entered.

If it is known when the vendor receives the tube to be rebuilt, the status can be updated to reflect that.

There is a place to record the Test Cut and Analysis (TC&A) PO, cost and date which is only available for the 7835 and 4616 tubes. Any documents that go along with this rebuild can also be uploaded.

Once the vendor reports back as to what was done and the PO, cost and estimated days to delivery (EDD) are known those can also be recorded. Then when the rebuilt tube is returned, the new serial number or rebuild indicator is entered and with this last update, a new tube entry will be made to the system. If a new serial number is not given, we have chosen to use a-z at the end of the serial to indicate that it is a new one for that tube. The a-z should be provided on the form for you and will show up on the reports with an underscore (_) in front of it.

After each of these steps, the information can be saved so the reports will reflect the current status of the tube being rebuilt. The What happens when ... help provides a bit more information on what happens here also.

Delete Tube Information

There are a couple options for deleting a tube. One is the option available in the popup menu when viewing the tube history called "Delete Tube" and the other is the "Delete this entry" link when viewing the tube in station data page.

Using the "Delete Tube" menu for the tube will delete that tube's history entry. If this tube only has one entry in its history - i.e. not a rebuilt tube or not rebuilt if it can be, the entire tube information will be deleted.

Using the "Delete this entry" link on the tube in station data page will just delete the information about that tube being in a particular station at the time in question. It does not udpate any status information on the tube as the entry being deleted may not be the current or must recent station insert and may not even be in a station anymore.

On Order

The form at the top of this page is for adding or updating information about tubes being orderd. It can also be used to provide search criteria to search the order history when the "Search History" button is used.

The table that shows the history will include tubes being rebuilt if a search is done. This table includes a cost column that for tubes on order, is the actuall cost entered for the tube received. That information is not known (or kept) for tubes just ordered. This column for the rebuilt tubes is the cost entered for the rebuilt information so this does not indicate that the tube has been received.

The bottom table on the On Order report shows information about the purchase plan for the tube for the current year.

Column	Explanation
Tube	Name of the tube
On Order	This is the number of tubes currently on order and have an expected delivery date during this fiscal year.
Being Rebuilt	This column gives some details on what is currently being rebuilt for a tube with a count and the serial of the tube being rebuilt. This column will be greyed out for those tubes that aren't rebuilt. There may be tubes being rebuilt that will not show up in the list. This only shows those tubes that are expected to be received this FY.
Number Received	This is the number of tubes with a date received of this fiscal year
Plan	This number (or numbers) are the values entered as those bugeted to be purchased this fiscal year. This is done on the page for editing tube information. There is a 'N'ew and a 'R'ebuilt count number for each quarter's plan.

The rows will be colored coded also:

Row color	Meaning
	Rows will be pink as a warning for two reasons. One is when, for that tube, nothing is on order and nothing has been received for a fiscal year where there are numbers planned to purchase Or if the total received and on order is less than the plan and the current date is within a defined number of months which is initially set to 4 months.
	Rows will be light green if the number received and on order for the fiscal year matches the number planned to purchase. On order tubes that have an estimated delivery date outside the current fiscal year are not included.