Client is a contractor that provides calibration and maintenance services to a number of industrial customers. In this case the service is to ambient gas quality sensing for monitoring and alarm. This is a personal safety function that requires periodic testing, typically every 3 or 6 months. Complete and accurate records of testing and maintenance are required. Clear and concise customer reports are also required.
The Admin Application is the repository for all collected data. As part of the dispatch process, relevant data is extracted (copied) from the Admin Application and transmitted to the Leader Application where new data is input. On completion of work the new data generated is uploaded to the Admin Application where it is audited before being added to the existing data.
The Leader Application that is used under field conditions, makes extensive use of pull-down selections for data entry in order to: minimize errors, reduce data entry time and provide consistent data to simplify analysis.
Some are modules like:
Equipment control, last bullet. We will need to address two situations:
1) during a calibration test we identify that the sensor has failed, it is replaced and the new sensor calibrated
2) during normal day to day operation the sensor fails and we are called in to replace and calibrate this sensor only. In both cases we want to maintain a history of the measurement point (Tag Number).
Future use of this information will be to identify repeat offenders (so proactive corrective action can be initiated), adjust inventory levels- the life of a sensor is highly dependent on environment. We may occasionally need to print a Tag Number history (Marsh Letterhead, company header, instrument header, chronology: sort by date, event (calibration, repair/replace including new serial number and comments).
Regarding Gas Record
Data Bases- all information input by Operator except as noted. Should be a separate screen for each data base
Customer data base
- Used to supply information for service report and test report
- Customer Company Name; Contact, address, city, Contact telephone #
- Test Gas data base
- Used to control test gases
- Each recipe of test gas has an EQC # (EQC123) and each bottle of that gas has a unique identifier (EQC123.22)
- For each recipe, we require a supplier order number.
- For each unique bottle of gas we require: purchase date, date of first use, date of last use, gas concentration, balance gas,
- Tag number (principal unique identifier)
- Access restrictions (ladder, man-lift, safety person, security support)
- upstream equipment
- downstream equipment (one selection is “sensor”)
- Error allowed
- Installation date (may be unknown)
- Purchase date, Supplier, price (may be unknown)
- Last calibration date (automatically updated)
- In service (yes/no) we expect that there will be multiple copies of the same tag but only one will be in service at any time, the others have been removed due to failure