Difference between revisions of "User:Shawndouglas/sandbox"
Shawndouglas (talk | contribs) (→1.4 General functional requirements: Updated, moved, conglomerated, etc. various items. Not completely finished.) |
Shawndouglas (talk | contribs) (→1.4 General system functions: Updated reporting section.) |
||
Line 490: | Line 490: | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ac.''' Does your system allow authorized users to print chain of custody for items, cases, projects, and batches? | | style="padding:5px; width:500px;" |'''ac.''' Does your system allow authorized users to query and print chain of custody for items, cases, projects, and batches? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
Line 624: | Line 624: | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''k.''' Does your system | | style="padding:5px; width:500px;" |'''k.''' Does your system prevent a sample from being placed in a report queue until approved? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''l.''' Does your system | | style="padding:5px; width:500px;" |'''l.''' Does your system include comprehensive sample scheduling, tracking, and sample flow management? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''m.''' Does your system | | style="padding:5px; width:500px;" |'''m.''' Does your system allow authorized users to schedule routine samples on an hourly, daily, weekly, or monthly basis, allowing them to be enabled and disabled as a group? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''n.''' Does your system | | style="padding:5px; width:500px;" |'''n.''' Does your system generate an hourly, daily, weekly, or monthly sampling schedule from a schedule database? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''o.''' | | style="padding:5px; width:500px;" |'''o.''' Does your system support automatic assignment and scheduling of analysis requests? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''p.''' Can your system | | style="padding:5px; width:500px;" |'''p.''' Can your system receive accession/analysis request information from web-enabled forms? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''q.''' | | style="padding:5px; width:500px;" |'''q.''' Can your system process automated uploading of field-derived sample collection data? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''r.''' Does your system support tracking of shipping and receiving? | | style="padding:5px; width:500px;" |'''r.''' Does your system allows users to handle billable and non-billable tests on the same accession? | ||
| style="background-color:white; padding:5px;" | | |||
| style="background-color:white;" | | |||
|- | |||
| style="padding:5px; width:500px;" |'''s.''' Does your system support tracking of shipping and receiving? | |||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
Line 765: | Line 769: | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''z.''' | | style="padding:5px; width:500px;" |'''z.''' Can your system clearly differentiate released preliminary data from fully validated results? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''aa.''' Does your system | | style="padding:5px; width:500px;" |'''aa.''' Does your system validate/approve data prior to being moved to the main database? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ab.''' Does your system | | style="padding:5px; width:500px;" |'''ab.''' Does your system fully manage all aspects of laboratory quality control, including the reporting and charting of all quality control data captured in the lab? Please explain how. | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ac.''' Does your system | | style="padding:5px; width:500px;" |'''ac.''' Does your system provide a base for a quality assurance program, including proficiency testing, scheduled maintenance of equipment, etc.? Please explain how. | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ad.''' Does your system | | style="padding:5px; width:500px;" |'''ad.''' Does your system distinguishe between QA/QC duplicates and normal samples? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ae.''' Does your system | | style="padding:5px; width:500px;" |'''ae.''' Does your system allow QA/QC tests to be easily created and associated with the primary analytical test? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''af.''' Does your system | | style="padding:5px; width:500px;" |'''af.''' Does your system calculate monthly QA/QC percentages for testing? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ag.''' Does your system | | style="padding:5px; width:500px;" |'''ag.''' Does your system automatically flag out-of-range quality control limits? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ah.''' Does your system | | style="padding:5px; width:500px;" |'''ah.''' Does your system check data files for specification and corrects them for specific reporting and analyte limits and qualifiers like dilution factor, automatically assigning qualifiers based on project analyte limiting? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ai.''' Does your system | | style="padding:5px; width:500px;" |'''ai.''' Does your system allow file transfer of data from instrument or user-generated files, with full on-screen review prior to database commitment? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''aj.''' Does your system | | style="padding:5px; width:500px;" |'''aj.''' Does your system permit manual data entry into an electronic worksheet of test measurements and results? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ak.''' Does your system | | style="padding:5px; width:500px;" |'''ak.''' Does your system allow incorrectly inputted data to be manually corrected? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''al.''' Does your system | | style="padding:5px; width:500px;" |'''al.''' Does your system provide colored visual indication of previously entered data as well as new data associated with a single sample when a result is entered, with the indicator changing color if the value is out of specification? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''am.''' Does your system | | style="padding:5px; width:500px;" |'''am.''' Does your system permit result entry via intelligent instrument interfaces or multi-sample/multi-test ASCII files? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''an.''' Does your system | | style="padding:5px; width:500px;" |'''an.''' Does your system allow automated or semi-automated data insertion? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''ao.''' Does your system store non-narrative textual results in searchable fields? | | style="padding:5px; width:500px;" |'''ao.''' Does your system provide auto-commenting for common laboratory result comments? | ||
| style="background-color:white; padding:5px;" | | |||
| style="background-color:white;" | | |||
|- | |||
| style="padding:5px; width:500px;" |'''ap.''' Does your system store non-narrative textual results in searchable fields? | |||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
Line 912: | Line 920: | ||
! style="color:brown; background-color:#ffffee; width:700px;"| Vendor response | ! style="color:brown; background-color:#ffffee; width:700px;"| Vendor response | ||
|- | |- | ||
| style="padding:5px; width:500px;" |'''a.''' | | style="padding:5px; width:500px;" |'''a.''' Does your system include a versatile report writer and forms generator? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''b.''' Does your system include a custom graphic generator for forms? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''c.''' Does your system allow development of specific templates for different types of reports? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''d.''' Does your system maintain template versions and renditions, allowing management and tracking of the template over time? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''e.''' Can your system generate template letters for semi-annual reports? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''f.''' Can your system generate reports from any data in tables? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''g.''' Does your system support report queries by fields/keys, status, completion, or other variables? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''h.''' Does your system use Microsoft Office tools for formatting reports? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''i.''' Does your system support multiple web browsers for viewing online reports? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''j.''' Does your system permit sample progress reports to be viewed locally or remotely based on security application limits and/or sample ownership? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''k.''' Can your system generate, store, reproduce, and display laboratory, statistical, and inventory reports on demand, including narrative? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''l.''' Does your system include several standard reports and query routines to access all samples with the pending status through a backlog report that includes the following criteria: all laboratory, department, analysis, submittal date, collection date, prep test complete, location, project, sample delivery group, and other user-selectable options? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''m.''' Can your system generate management and turn-around time reports and graphs? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''n.''' Can your system generate customized final reports? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''o.''' Can your system automatically generate laboratory reports of findings and other written documents? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''p.''' Can your system automatically generate individual and aggregate workload and productivity reports on all operational and administrative activities? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''q.''' Can your system automatically generate and transmit exception trails and exception reports for all entered and/or stored out-of-specification data? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''r.''' Can your system generate a read-only progress report that allows for printed reports of sample status and data collected to date? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''s.''' Does your system provide an ad-hoc web reporting interface to report on user-selected criteria? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''t.''' Can your system automatically generate and update control charts? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''u.''' Can your system generate QA/QC charts for all recovery, precision, and lab control samples via a full statistics package? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''v.''' Does your system display history of previous results for an analyte's sample point in a tabular report, graphic trend chart, and statistical summary? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''w.''' Can your system automatically generate and post periodic static summary reports on an internal web server? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''x.''' Does your system transmit results in a variety of ways including fax, e-mail, print, and website in formats like RTF, PDF, HTML, XML, DOC, XLS, and TXT? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''y.''' Does your system prohibit issuing reports outside of qualified areas? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''z.''' Does your system electronically transmit results via final report only when all case reviews have been completed by the case coordinator? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''aa.''' Can your system send on-screen output to a printer or file? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | | ||
|- | |- | ||
| style="padding:5px; width:500px;" |''' | | style="padding:5px; width:500px;" |'''ab.''' Does your system allow database access using user-friendly report writing and inquiry tools? | ||
| style="background-color:white; padding:5px;" | | | style="background-color:white; padding:5px;" | | ||
| style="background-color:white;" | | | style="background-color:white;" | |
Revision as of 00:47, 19 September 2013
This is my sandbox, where I play with features and test MediaWiki code. If you wish to leave a comment for me, please see my discussion page instead. |
Sandbox begins below
System questionnaire
This questionnaire lists the extensive requirements of a laboratory informatics system, primarily of a LIMS, though these requirements could easily apply to other informatics systems. The intention of this document is 1. to assist labs with identifying their system needs and 2. to help labs better determine if a specific vendor/product meets their requirements in the form of a request for information (RFI).
This questionnaire is comprehensive and includes many items that do not apply to every lab. Additionally, some laboratories' requirements include a functionality item not common to other labs. Section 1.5 "Industry-specific questionnaire" contains a selection of those industry-specific requirements and will continue to be amended over time. The last section, 1.6 "Custom system functions questionnaire," is designed for the vendor to insert any additional functionality that doesn't fall under the categories provided.
When referencing a particular item for someone else, use the section number followed by the requirement letter, e.g. 1.4.2.f for "Does the system allow the system admin to create custom screens, apps, and reports?"
Requirement code and notes
In responding to each requirement, the vendor must select a requirement code from the following:
- Y: Meets requirement in commercial off-the-shelf solution as delivered/configured (or vendor provides service)
- YC: Meets requirement only with customization (additional code, using a third-party application, etc.)
- N: Does not meet requirement
- I: Informational response only, N/A
The vendor should ideally enter a requirement code and a response for each functionality question.
To add the requirement code and vendor notes to a functionality item, look for this kind of code in the appropriate section: | style="padding:5px; width:500px;" |'''a.''' Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor
|
1.0 Vendor information
|
1.1 Vendor services
|
1.2 Information technology
|
1.3 Regulatory compliance and security
|
1.4 General system functions
|
1.5 Industry-specific requirements
|
1.6 Custom functional requirements
|