|
Questions
about OpenMETRIC's Calibration Workflow
2.
Calibration Workflow
|
2.1
|
How does your system support automatic
calibration interval adjustment? Will the system use the last
calibration data results to activate a new calibration interval to
be reflected in the printed out calibration label?
|
OpenMETRIC supports a wide
variety of interval adjustment methodologies.
In the Reference table, a client can indicate whether they prefer
to use “algorithmic” or “statistical” adjustment.
If the client specifies
“algorithmic,” OpenMETRIC permits the specification of pass-fail
patterns with adjustment percentages for each pattern.
The patterns can include up to three most recent calibrations.
For each pass-fail pattern a percentage can be specified by which
the previous interval will be multiplied to compute the new interval for
the item.
The new computed interval
is used to compute the new calibration Due Date for the item.
The format of the
computer-generated calibration sticker is extremely flexible, permitting
the inclusion of over 30 separate data elements, including the computed
Due Date.
OpenMETRIC also permits
the computed interval and computed Due Date to be overridden, by a user
with appropriate access authorization.
If the interval or Due Date is overridden, OpenMETRIC retains the
“computed” values and highlights the overridden values for quick
identification.
Even though OpenMETRIC
supports extremely flexible algorithmic interval adjustment methodologies,
and even though these methodologies are popular with many of our clients,
DDS recommends that statistical methodologies be used for interval
adjustment. This
recommendation is consistent with the findings of the NCSL Recommended
Practice No. 1. For clients
adopting these preferred methodologies, OpenMETRIC provides a seamless
interface with IntervalMAX from Integrated Sciences Group.
IntervalMAX is widely regarded as the premier product for interval
adjustment. IntervalMAX is
the only product currently available which incorporates the S2 methodology
from NCSL RP-1.
|
|
|
2.2
|
Does your system support multiple scheduled
maintenance services for each asset?
|
|
At the present
time, OpenMETRIC only maintains one “due date” for each item.
This “due date” could be a calibration due date or a PM
due date.
Some clients
create multiple entries in the Item Master table for each item,
where a recognizable suffix is used to identify the entry for
calibration, the entry for quarterly PM, the entry for semi-annual
PM, etc. The basic
portion of the Item number is identical for each of the multiple
items, but this mechanism permits an unlimited number of intervals
and due dates to be associated with a given item.
|
|
2.3
|
Does your system automatically update due
dates for preventative maintenance actions and other
non-calibration services?
|
|
At the present
time, OpenMETRIC only computes new due dates for calibration
services. However,
there is so much flexibility provided in this regard, that some
clients generate a calibration record for non-calibration
services, with appropriate “As Found” codes to avoid polluting
the end-of-period reliability data.
|
|
2.4
|
Does your system accommodate forward and
reverse traceability with error checking?
|
|
OpenMETRIC
provides two traceability reports.
The Pedigree report provides forward traceability and the
Impact report provides reverse traceability.
Both traceability
reports are multi-level, meaning that with a single report, you
can trace the impact of a primary standard down to each and every
item that it calibrated and to each item that any of them
calibrated, etc.
OpenMETRIC
identifies traceability to CALIBRATIONS, not just to items.
This is a subtle, yet critical, point for accurate and
effective traceability.
OpenMETRIC
performs error checking on standards at the point of data entry,
ensuring that standards have not expired before they are tied to
an item’s calibration. As
a result, there is not additional error checking required during
the generation of a traceability report.
|
|
2.5
|
Does your system accommodate individual
time accounting entries?
|
|
If “time
accounting” refers to the capture of labor, OpenMETRIC has a
powerful and flexible labor reporting system.
If “time
accounting” refers to billing and chargeback, OpenMETRIC has a
powerful and flexible charging system.
If “time
accounting” refers to tracking the “time at station” for
workflow analysis, OpenMETRIC has a powerful and flexible “track
status log” system.
|
|
2.6
|
How does your system handle on-line access
to calibration and maintenance procedures?
|
|
OpenMETRIC
provides direct invocation and access to calibration and
maintenance procedures, so long as they are electronically
accessible.
On the Procedure
subsystem, the location of the procedure and the program which
must be invoked to view the procedure are specified.
Then, during servicing, the procedure can be invoked and
displayed on the tech’s workstation.
The procedures can
be Word documents, Excel spreadsheets, Adobe Postscript files, or
URL’s on a web server.
|
|
2.7
|
What is the limit of your open-ended
history notes? Can history notes be searched?
|
|
OpenMETRIC
provides 30 different Comment tables.
Each table typically permits up to 1000 characters of
comments.
Comments can be
recorded for individual items, individual item classes, individual
item categories, individual servicing records, etc.
Each of these comments can be displayed, including comments
from historical records.
OpenMETRIC does
not directly provide a key word searching capability.
However, a comment, or any portion thereof, can be easily
copied and pasted into a Word document (or any other appropriate
format) where searching tools exist.
|
|
2.8
|
How does your system ensure that the
current revision calibration procedure is being used?
|
|
The “cover
page” in the Procedure subsystem provides effectivity control,
identifying the FROM and THRU dates for which a given revision is
effective. OpenMETRIC
automatically selects the current version of a procedure during
servicing.
If an obsolete
procedure is manually selected or referenced during servicing,
OpenMETRIC intercepts the attempt and displays an error.
|
|
2.9
|
How does your system handle
out-of-tolerance and non-conformance reporting and tracking?
|
|
OpenMETRIC
provides user-customizable tables for the entry of OOT data.
This data can be automatically incorporated into a User
Notification Report which can be automatically emailed to the
equipment user.
The User
Notification Report can also be “attached” to the calibration
record for the item. When
the user response is received, it can also be “attached” to
the calibration record. A
user-generated report can periodically monitor the attachment
table for responses that have not yet been received.
|
|
2.10
|
How does your system handle bar codes and
customized labels?
|
Bar
Codes:
OpenMETRIC incorporates
extensive support for bar codes to expedite data entry and to improve data
accuracy.
1.
Wedge Readers:
If wedge readers are
attached to workstations, then literally ANYTHING that would otherwise be
typed can be scanned into OpenMETRIC.
This includes item numbers, technician badge numbers, work order
numbers, etc. One of our
clients even went so far as to generate an annual calendar with bar codes
for each date during the year which he scanned rather than enter a date.
This approach requires no
software change, and merely requires some mechanism for generating the bar
codes that are required.
1.
Generating Bar Codes
For long-term scanning
accuracy, many clients purchase pre-printed bar code labels or stickers
which are generated by specialty suppliers on a durable material such as
aluminum. These labels can be
scanned almost indefinitely without degraded accuracy.
There are numerous bar
code printing packages available for Windows for nominal license fees.
These are useful for generating “boilerplate” material to be
scanned into the database, such as calibration cert language, etc.
These can also be used for printing item stickers which include bar
codes.
OpenMETRIC supports the
direct printing of bar codes for common and recurrent requirements in the
workflow of a calibration lab. Specifically,
OpenMETRIC will print bar codes on the following labels/documents/reports:
Template-driven Item Sticker (using embedded control codes for
Zebra printers)
Template-driven Cal Sticker (using embedded control codes for Zebra
printers)
Template-driven Traveler (using bar code font for Windows printers)
Some of our users have
realized that they can put anything that they want to in our templates,
thereby generating virtually anything that they want on bar codes.
2.
Off-line Data Collection using Handheld Scanners
OpenMETRIC supports the
collection and batch updating of useful data using handheld bar code
scanners. Specifically,
handheld scanners can be used to capture updated tracking status for
items. These tracking status
updates can then be added to OpenMETRIC using the batch scanner function.
OpenPROTRAK, a
tightly-coupled companion system for OpenMETRIC, supports the capture and
batch updating of item location information (physical inventory).
|
|
|
2.11
|
How does your system handle year 2000
compliance information?
|
|
OpenMETRIC is
fully Y2K compliant. All
dates include the full 4-digit year, even though some dates may be
displayed and may be entered using just the last two digits.
|
|
2.12
|
What method is used to track and maintain
equipment location?
|
|
OpenMETRIC
maintains both a “permanent” location and a “servicing”
location. The
permanent location typically refers to the location where the
equipment is normally located, while the servicing location tracks
the item during in-lab servicing.
Location changes
for an item are entered on the Item Master record.
Locations are validated against the Location Master to
ensure accuracy and consistency.
Each change to an Item record, including Location, triggers
the creation of an Item Master History record, retaining the
previous record contents. These
historical records can be searched, retrieved, and reported.
|
|
2.13
|
Can there be data fields available for
client access, read or write? How many?
|
|
OpenMETRIC
includes over 4000 data fields distributed over 176 tables
(files). All of these
fields are available for clients to access, read, and/or write,
depending on the security authorization of the user.
If, however, you
mean “user defined” data fields, OpenMETRIC includes 32
user-defined data fields for which the client can specify the
name. These data
fields can be accessed, read, and/or written, depending on the
security authorization of the user.
|
|
2.14
|
How does the system accommodate the
tracking of vendor services?
|
|
OpenMETRIC permits
you to specify and maintain a database of vendors.
For each vendor, you can specify what services the vendor
is approved to render. You
can also specify when the vendor was audited/assessed, who
performed the audit, what type of audit was performed, and when
the audit is scheduled to be performed again.
When an item is
serviced by a vendor, whether the item is sent to the vendor or
the vendor provides the services on-site, OpenMETRIC tracks the
custody transfer to the vendor, the return of custody from the
vendor, the vendor’s cal certificate (if applicable), the costs
of the service, etc.
OpenMETRIC
includes the tools necessary to plan, perform, record, and analyze
vendor services.
|
|
2.15
|
How does the
system accommodate repair actions?
|
|
OpenMETRIC
includes a Repair subsystem into which repair actions can be
recorded. Labor
required for repairs can be entered into the Labor subsystem.
Parts used during repair can be recorded in the Parts
subsystem. Repair
charges can be charged using the Charge subsystem.
|
|
2.16
|
How does the system accommodate
Preventative Maintenance management?
|
|
OpenMETRIC
includes a PM subsystem into which PM actions can be recorded.
Labor required for PM’s can be entered into the Labor
subsystem. Parts used
during PM can be recorded in the Parts subsystem.
PM charges can be charged using the Charge subsystem.
|
|
2.17
|
Is tracking of calibration standards
accommodated to include reverse traceability? Describe the
calibration standards management system?
|
Yes, OpenMETRIC provides
multi-level forward and reverse traceability.
OpenMETRIC’s traceability is to the CALIBRATION as opposed to
being merely to the item.
On the Item Master, for
each item, you can specify whether or not the item is a standard.
This simplifies the generation of reports and lists of standards.
On Reference, you can
specify whether or not you will allow ONLY items flagged as standards to
be specified as standards for a calibration.
During a calibration, you
enter standards by hitting the Standards button.
You will see a list of the standards that have already been
entered, if any, for this calibration.
You add a new standard to
the calibration by hitting the Add/Edit button.
This invokes a subwindow on which the standard is specified.
The date that the standard
is used is specified. This is
filled out, by default, as “today,” but may be changed, if necessary.
The Item number of the standard can be typed, scanned, or selected
from pull down lists. One of
the available lists includes all items that are flagged as standards.
Another list presents the standards defined as a “virtual
bench” from which one or all may be selected.
Once a standard has been
selected and its usage date has been specified, the current calibration
for the standard is checked to ensure that it has not expired (as of the
usage date). The calibrated
date and expiration date are displayed on the subwindow.
OpenMETRIC will not permit expired standards to be specified as
standards for a calibration. (If
this occurs, you will need to perform a calibration or an extension on the
standard before it can be used as a standard for calibration.)
When the calibration is
completed and the job is closed, the standards used are permanently
recorded for the calibration, based on the calibration from/thru date of
the traceable calibration of the standard.
In Reference, you can
specify certain item status values that do not require calibrations in
order to be used as standards (e.g., NCR for “no cal required”).
If a standard has one of these statuses, it is not mandatory to
have a valid calibration (not expired) in order to be used as a standard
for the calibration.
|
|
|
2.18
|
Can procedures, pictures, graphs, spec
sheets, schematics be attached to equipment records?
|
|
Yes, virtually
anything can be attached to equipment records.
In addition,
documents or files can be attached to numerous other objects
throughout OpenMETRIC.
|
|
2.19
|
How is “as found’ and “as left”
measurement data handled?
|
|
OpenMETRIC
provides several ways to capture and store measurement data.
OpenMETRIC
provides a Datasheet subsystem which permits datasheets to be
predefined for the entry of measurement data.
During Calibration, the Readings button will cause a copy
of the applicable datasheet to be copied into a holding area.
Data can be entered into the datasheet.
When the calibration is completed and the job is closed,
these readings are transferred to the permanent historical record
for the calibration.
OpenMETRIC also
provides a flexible user-definable grid into which OOT data can be
entered (In actuality, all data could be entered into an OOT grid,
but this could be confusing and misleading.)
Finally, data
collected and stored in a file (e.g., via MetCal) can be attached
to the calibration for permanent archive and management.
|
|
2.20
|
Can “Certificates of Calibration” be
printed out automatically upon completion of a calibration action?
|
|
OpenMETRIC
provides a cal cert which can be printed by merely “hitting a
button.”
Many clients have
evolved to the stage of maintaining the cal cert electronically so
it is not printed automatically at the completion of the cal but
can be retrieved at any time when required.
|
|
2.21
|
Can technicians be assigned to user-defined
groups for segregated work schedule, work flow, and work report
tracking? How many different work groups can be defined?
|
|
OpenMETRIC
provides several different mechanisms to plan, schedule, track,
and manage workflow.
For each item, you
can specify the Servicing Facility, Cal Lab, and/or Workbench that
typically services the item.
Planner, Recall,
Backlog, and Done By reports can all be generated by Cal Lab (as
well as by other selection criteria).
There are an
unlimited number (or at least the number is so large as to be
effectively unlimited) of Servicing Facilities, Cal Labs, and Work
Benches.
Most clients do
not maintain permanent associations between technicians and these
work-management organizational units.
The technician responsible for the calibration is assigned
prior to or during the calibration.
|
|
2.22
|
How are unique equipment numbers defined?
Can there be different categories of equipment numbers? How many
categories?
|
|
OpenMETRIC expects
every item to have a unique Item Number which can be up to 20
character long and may contain numbers, letters, and certain
special characters such as space, dash, slash, etc.
OpenMETRIC items
are assigned to SubCategories, Categories, and Classes in
ascending hierarchy.
Valid
Subcategories, Categories, and Classes are all specified on
corresponding subsystems from which data is validated and to which
default data can be automatically forwarded.
There is no limit
to the number of Subcategories, Categories, or Classes to which
items may belong.
|
|
2.23
|
Can calibration procedure cross-index be
defined that tracks equipment model numbers supported by a
specific calibration procedure number?
|
|
Yes.
On the Procedure tab, the Cals button will display a list
of all of the calibrations that used a given procedure.
This Paged List Box (PLB) can be filtered by Item,
Manufacturer, Model, Servicing Facility, Cal Lab, and/or
Technician.
|
|
2.24
|
How are calibration recall intervals
accommodated? Can they be modified?
|
|
OpenMETRIC
supports a wide variety of interval adjustment methodologies.
In the Reference table, a client can indicate whether they
prefer to use “algorithmic” or “statistical” adjustment.
If the client
specifies “algorithmic,” OpenMETRIC permits the specification
of pass-fail patterns with adjustment percentages for each
pattern. The patterns
can include up to three most recent calibrations.
For each pass-fail pattern a percentage can be specified by
which the previous interval will be multiplied to compute the new
interval for the item.
The new computed
interval is used to compute the new calibration Due Date for the
item.
The format of the
computer-generated calibration sticker is extremely flexible,
permitting the inclusion of over 30 separate data elements,
including the computed Due Date.
OpenMETRIC also
permits the computed interval and computed Due Date to be
overridden, by a user with appropriate access authorization.
If the interval or Due Date are overridden, OpenMETRIC
retains the “computed” values and highlights the overridden
values for quick identification.
Even though
OpenMETRIC supports extremely flexible algorithmic interval
adjustment methodologies, and even though these methodologies are
popular with many of our clients, DDS recommends that statistical
methodologies be used for interval adjustment.
This recommendation is consistent with the findings of the
NCSL Recommended Practice No. 1.
For clients adopting these preferred methodologies,
OpenMETRIC provides a seamless interface with IntervalMAX from
Integrated Sciences Group. IntervalMAX
is widely regarded as the premier product for interval adjustment.
IntervalMAX is the only product currently available which
incorporates the S2 methodology from NCSL RP-1.
|
|
|
|
2.25
|
How are “parent” and “child”
association of equipment supported?
|
|
Several different
types of “parent-child” relationships are supported by
OpenMETRIC.
TAGGED
COMPONENTS:
If both the parent
and the child are “tagged” (that is, they each have an item
identification tag and each are identified in the Item Master
table), then OpenMETRIC supports the relationship as follows.
On the Item Master
table, there is a radio button to indicate whether or not the item
is “a system.” A
“parent” would indicate “yes” to this choice.
Items which are “children” would indicate “no” to
this choice. For each
child, the parent is specified in the “Component of” field.
Parents can be
readily displayed using the field finder (yellow binoculars) to
the right of the “Component of” field.
This will display a paged list box (PLB) of “Items that
are Systems.”
The components of
a system (children of a parent) can be readily displayed by
hitting the button upon which the “Component of” label
resides. This will
display a paged list box (PLB) of “Items which are Components of
xxxxxx”.
UNTAGGED
ACCESSORIES:
If a child is not
tagged (that is, the child does NOT have an identification tag and
is NOT identified in the Item Master table), OpenMETRIC allows the
child to be specified as an Accessory.
On the Item Master
entry for the parent, the Accessory list is accessed by hitting
the “Acc” button in the “More…” box at the bottom of the
screen. This brings
up a grid into which accessories can be entered.
For each accessory, OpenMETRIC accommodates the
Nomenclature, Model/Part number, Serial number, and Quantity.
|
|
2.26
|
How are special flags and alerts
accommodated, i.e. Lockout / Tagout notice?
|
|
On the Item
Master, there is a field which can be entered called “Spcl
Hand” (Special Handling). The
values which can entered into this field are defined by the client
on the Reference table.
Any special
handling value that is entered on the Item Master table for an
item is automatically displayed on both the Tracking and the
Calibration screen when a servicing job is opened for the item.
|
|
2.27
|
Can more than one technician document work
against an open item?
|
|
Yes.
OpenMETRIC requires that a single specific technician be
identified as the “Assigned technician” (responsible
technician) for the job, but any number of technicians can record
labor hours and enter data and information for the job.
The “assigned Tech” is a mandatory entry for a
calibration.
In addition to the
“Assigned Tech,” a “Cal Tech” may be specified.
If the “Assigned Tech” is basically a supervisor, the
“Cal Tech” might be the intermediate-level tech who actually
performs the calibration under the supervision of the “Assigned
Tech.”
Regardless of
which tech is specified as the “Assigned” or “Cal” tech,
any number of techs may log labor hours against the service.
|
|
2.28
|
How does the system validate calibration
status of standards used?
|
|
Once a standard
has been selected and its usage date has been specified, the
current calibration for the standard is checked to ensure that it
has not expired (as of the usage date).
The calibrated date and expiration date are displayed on
the subwindow. OpenMETRIC
will not permit expired standards to be specified as standards for
a calibration. (If
this occurs, you will need to perform a calibration or an
extension on the standard before it can be used as a standard for
calibration.)
|
|
2.29
|
How does the system manage the logging of
environmental conditions during calibration actions, i.e.
Humidity, Temperature, etc? Does this information automatically
transfer into a certification report?
|
|
On the Calibration
screen, there are data fields in the “Environmental
Conditions” box. These
can be entered manually by the technician or they can be
automatically extracted from an RS-232 interface to a
temperature/humidity sensor.
OpenMETRIC
accommodates “As Used” and “As Tested” conditions.
The “As Used” conditions are defaulted from the
Customer record for the Using Customer for the item.
The “As Tested” conditions include temperature, a radio
button for “Degrees C” or “Degrees F”, and humidity.
The environmental
conditions are displayed on the canned Certificate included in
OpenMETRIC. They can
also be displayed on WonderWriter and other user-generated
reports.
|
|
2.30
|
Can the system provide for the assignment
of default calibration intervals to unique types of instruments
(same models)?
|
|
Yes.
When a Class is
defined, default intervals as well as other default information
may be specified.
When a Category
(Manufacturer + Model) is defined, the user selects the Class to
which the Category belongs from the Field Finder to the right of
the Class field. The
user is asked if he wants to bring down the Class defaults (Yes or
No). The user can
also hit the button upon which the “class” label resides.
This will cause the user to be asked if he wants to bring
down the Class defaults (Yes or No).
Finally, the user can check or uncheck the box to “Enable
Class Updates.” If
checked, any future changes to the Class defaults on the Class
record to which this Category record belongs, will automatically
update the default information on this Category record.
This same logic
and mechanism occurs between Category and Subcategory and finally
between Subcategory and Item.
In this way,
individual item intervals can be easily managed by Class,
Category, or Subcategory.
|
|