Lab Resources: STARLiMS

Index

My Contact Information
Latest STARLiMS version Information
HL7 Interfaces Project - HL7 Messaging project details and HL7 Generator application.
Sample Sonar Project - Graphical interface for locating a sample in STARLiMS.
Patient Update Project - Graphical interface for reconciling Patient information between Central Receiving and Patients tables.
STARLiMS Desktop Application Launcher Project - STARLiMS desktop application run on shared network drive.
SQL Repository - Various SQL statements created over the years for STARLiMS backed updates, queries etc.
Test Configuration Documentation - Word Documents containing configuration information for tests in STARLiMS.
Other Projects - Documentation on other STARLiMS projects.

My Contact Information

Name: James Yoder
Email: jtycom2020@ArtCentrics.com
Current State Residence: Arizona
Current Status: Retired as of 03/04/2022, open to short-term, part-time projects as a consultant/project leader, but very particular :)

Latest STARLiMS version information

Clinical Instance: Product Version = PH12.0.18 | XFDRuntime = 11.7.3 x64
Chemistry Instance: Project Version = PH12.0.18 | XFDRuntime = 12.1.4 x64
myLIMS

Updated: 2022-01-19

The HL7 Interfaces project was a multi organizational collaborative effort between Abbott Informatics (now STARLiMS) Arizona State Health Department (APHL), Association of Public Health Laboratories (APHL), Center for Disease Control (CDC), Various reporting programs including PHLIP, LRN-B, LRN-C, Rabies, AIMS. Its primary goals were:

Configuration Based - Transform HL7 messaging from a strictly code based application to a configuration based application.
Program Templates - Develop and provide baseline templates for each of the reporting programs so that labs implementing this framework can quickly get certification.
Messages on Demand - Addition of the HL7 Generator application developed at ADHS to generate HL7 messages on demand for samples in the system.

HL7 Interfaces Project Download Documents Included in this download include:

01 - HL7 Interfaces Poster_2021-04-08.pdf - One page overview of this project
02 - HL7Interfaces_Connect 2021 Presentation_2021-04-22.pdf - Presented at STARLiMS Connect 2021 conference a broad overview of this project (19 pages).
03 - HL7 Interfaces Docket_Abbott_2021-04-23.pdf - Project development documentation with details of project development. (67 pages)
HL7 Generator Application (Sub-Directory)

HL7 Generator.pdf - Application documentation includes project details including Application usage, installation and configuration. (24 pages)
2021-05-28_HL7Generator_Demo.mp4 - Video Demonstration on how to use the HL7 Generator Application (35 minutes)
2021-05-28_HL7Generator_Install.mp4 - Video Demonstration on how to install the HL7 Generator Application (25 minutes)
HL7 Generator_V2.1_XFDRuntime 11~7~3_2021-05-27.sdp - Installation package created for Clinical instance developed on XFDRuntime 11.7.3 x64 technology layer.
HL7 Generator_V2.2_XFDRuntime 12~1~4_2021-09-13.sdp - Installation package created for Chemistry instance developed on XFDRuntime 12.1.4 x64 technology layer.

Sample Sonar Project

Updated: 2022-01-19

An application developed at Arizona Department of Health Services (ADHS) used to identify the location in the STARLiMS application that the specified sample can be located. Additional functionality includes identifying possible issues that might be associated with the sample, view latest report functionality, and Audit Log report. The concept of this project is quite simple, to allow the user to enter the sample ID and provide a graphical interface showing where in the lifecycle in the STARLiMs application the sample is currently located. This is application does not require any table modifications or additions to the STARLiMS application and should be compatible with XFDRuntime versions of 10.7 and later. Modifications to the provided Audit Log report (Crystal Reports) will be required to utilize the Audit Log feature.

Sample Sonar Documents Included in this download include:

01 - Sample Sonar Docket_2021-11-24.pdf - Project development documentation including Users Guide, Admin Guide Installation and configuration instructions (42 pages).
02 - Sample Sonar User Training_2021-07-09.mp4 - Video Demonstration on how to use the Sample Sonar application (12 minutes).
03 - Sample Sonar Admin~Installation and Configuration_2021-07-09.mp4 - Video demonstrating how to install and configure the Sample Sonar application (41 minutes). NOTE: the last version of this application, we updated the data sources see Sample Sonar Docket for details, concept is the same, but the datasources were streamlined.
04 - Sample Sonar Developer_Adding Issues and Locations_2021-07-12.mp4 - Video how to modify datasource for locationa and issues (55 minutes). NOTE: the last version of this application, we updated the data sources see Sample Sonar Docket for details, concept is the same, but the datasources were streamlined, we have separated the data sources and redesign. Review the Docket for details.
05 - Sample Sonar Package_V2021-11-12a.sdp - Installation package; developed on XFDRuntime 11.7.3, but should be compatible with 10.7 and later.

Patient Update Project

Updated: 2022-01-20

An application developed at Arizona Department of Health Services (ADHS) used help identify and reconcile patient information including Sex, Birth Date, First Name, Middle Name, Last Name between the Patient and the Central Receiving tables.

Patient Update Documents Included in this download include:

01 - Patient Update Docket_2021-06-04.pdf - Project development documentation including Users Guide, Admin Guide Installation and configuration instructions (20 pages).
02 - Patient Update Demonstration_2021-06-07.mp4 - Video Demonstration on how to use the Patient Update application (18 minutes).
03 - Patient Update_V0.0.1_2021-07-26.sdp - Installation package. Developed on XFDRuntime 10.4, but validated upward compatible with XFDRuntime 11.7.3

STARLiMS Desktop Application Launcher Project

Updated: 2022-01-20

Basic setup as the Desktop application for clients, but we add a twist by running the application off of a file share so there is minimal change required to the client computer. This also provides one interface to launch various instances of the the STARLiMS application. The idea here is instead of placing the runtime folders on the client computer, we will put them on a shared drive, then create a shortcut on the client computer to a bat file on the shared drive that will launch the instance of STARLiMS selected.

STARLiMS Desktop Application Documents Included in this download include:

Abbott_How to run the Native Application from a ShortCut_2020-02-28.pdf - Instructions provided by Abbott on how to run the Native Application from a shortcut.
ADHS-STARLiMS.ico - Icon setup to launch the STARLiMS selection bat file.
CrystalReports.exe - Crystal Reports viewer.
STARLiMS Desktop App Install Instructions.pdf - Instructions for the end user hot to setup the launch icon once the shared folder containing the STARLiMS core files has been setup.
STARLiMS Launcher - Shortuct for desktop.
STARLiMSDestop.bat - BAT file that should reside on the shared drive that is the target of the shortcut.

Oracle SQL Queries Library

Updated: 2022-01-21

Assortment of SQL queries created for trouble shooting, updating, data extraction and many other operations performed through SQL statements. Developed with the Oracle database, You may need to make changes for them to work in SQL Server. Files all have the .sql extension but can be viewed in a regular text editor.

Oracle SQL Repository_2022-01-20.zip

Test Configurations Documentation

Updated: 2022-01-21

Word documents containing test configurations for various tests residing in STARLiMS. These are good templates if you plan on creating a new test in STARLiMS

Test Specifications_2022-01-20.zip