LIS system medical center on the line in Shijiazhuang, Hebei Province!
Medical Center is located in Shijiazhuang city most prosperous areas, Ziqiang Road near the Hebei Hall. It is not only the city's largest medical center, and the most advanced equipment, but it bears the city's 30,000 civil servants medical tasks.It not only has a large number of high value advanced testing equipment, but there are a large number of high-quality medical technology staff, enjoyed a high reputation in Shijiazhuang city.With the increase in the amount of medical examination, the Center found that the LIS system of limited functions and complicated operation, and wanted to switch to a set of outstanding LIS system.After the center's leadership multifaceted study, the final choice of the firm Gaohua LIS system.In 2007 after the Spring Festival, our engineers spent only two weeks to complete the entire LIS implementation. Facts have proven that our customers will never live up to our expectations. LIS system of each site to realize bar code management. Samples were sent to the laboratory, the examiner barcode scanning, the patient's basic information can be automatically extracted, eliminating the need for manual input.Abbott automatic analyzer full use of the Abbott automatic identification bar code functions.Biochemical items from the medical system to the LIS system and then send instructions to guide Abbott biochemical analyzer.Abbott work has been completed, further data acquisition and analysis. The entire process of bringing the entire process automation does not require manual operation.After all, after examining the results, will automatically return to the medical center-the medical systems.
[Hebei Medical Center]
The entire medical center uses wireless network interconnection.
[Hebei Branch medical testing center]
The laboratory achieved 12 analyzer and many other work sites of all network automation.
Below Biochemical station as an example, tell us about our system of LIS:
Below are the Abbott analyzer.
Abbott analyzer uses open bar code. Below we print the bar code, Abbott recognition rate is almost 100%:
We use the bar code is the year, month, day, plus four ID, a total of 12. Code128 format.
Below are the barcode stuck to the test-tube and the shelves:
As long as the operator tube hangers Abbott put on the conveyor belt, and the rest will be done automatically:
The process is as follows:
1>Donets first register basic information and to detect biochemical and then print bar codes and put them on the tube, finally, the health examination for blood to the nurses station.
2>Medical examinations will be equipped with bar code samples sent to the laboratory test tube.
3>Staff put in vitro biochemical analyzer Add the conveyor belt. Automatic barcode scanning equipment, with the LIS automatically send orders to allow equipment to start work, waiting for the completion of work.
4>Analysis has been completed, we automatically collect the LIS results. Examiner examination, the results will be automatically sent to the medical center.
Below introduced from deeper levels to achieve the principle:
1>Donets systems in the medical register their basic information, and the need to detect biochemical projects. Registration at the same time, relevant information will be sent to the LIS system. LIS system open to the medical system of two forms:
TABLE T90_JC (
F1_ID INTEGER NOT NULL,Automatic Number
F1_XM NAME,NAME
F2_XB VARCHAR(6),Gender
F3_NL VARCHAR(6),Age
F4_TMH VARCHAR(18),Barcode No.
F5_RQ DATE DEFAULT current_date,Date, the current default, no matter how general
F6_SJ TIME DEFAULT current_time,Time, the current default, no matter how general
F7_BRLX VARCHAR(20),Patients types
F8_JLZ VARCHAR(10),Records. Medical software operators. If there's a problem the operator can be found who is Operating.
);
TABLE
T91_XMJC (
F1_ID INTEGER NOT
NULL, Automatic Number
F2_TMH
VARCHAR(18), Barcode No.
F3_XMDH VARCHAR(10) The codenamed of project
)
Medical examination at the time of registration, the basic information, testing and project information such as bar code, was also written to 2 table of the LIS system, a form to record basic information, a second form to record test data.
Medical examination at the time of registration, the basic information, testing and project information such as bar code, was also written to 2 table of the LIS system, a form to record basic information, a second form to record test data.The tube was Abbott barcode scanning analyzer, to the LIS system sends a request what is testing the project list (Order Request). List request containing bar codes, test tube rack, test tube location, and other information.After the LIS system receiver to the list after the request, barcode extracted, and then according to bar code, the interface from the two forms of access to basic medical information and testing project list.
The final system will detect the project list into analyzer can identify text (order text) to upload Abbott Analyzer.The instruments will know that this examination should do what items. After the completion of testing, the systems will automatically LIS Acquisition Results.
In addition, we have to open the medical system storage process : P_JC1 and physical systems can use this process easier access to test results:
select * from P_JC1(‘200702140001’)
Above this line of code,
200702140001 for the bar code. After implementation can access these fields:
BZ SMALLINT,Tagged
BZMC
VARCHAR(14), Project categories
ZDBH
INTEGER, Major categories in the order in which
LSH
VARCHAR(11),The largest category of serial numbers
XM
VARCHAR(10),Item
XMMC
VARCHAR(28), Project Title
JG
VARCHAR(30),Results
DW
VARCHAR(10),Units
PD
VARCHAR(2),Judge
CKZ1
VARCHAR(10),Reference values lower
CKZ2
VARCHAR(10), The reference value ceiling
JYZ
VARCHAR(10), Reports
SHZ
VARCHAR(10), Audits
JYRQ DATE) Test Date
SH SMALLINT Audit signs : 1/no audit, 0 audited
If we only need to extract the audited records, add a word "where".
select * from P_JC1(‘200702140001’)
where sh=0
These are the LIS system and the medical system collaborative work process. If HIS system and collaboration, the patient monitoring programs from the list of doctors workstations out, and then crossed LIS, LIS testing has been completed, the final test results came back to the doctor workstation.
Throughout the trial versions of their systems are being compiled and will soon be released to the Internet, please concerns.
Below this there are a large number of pages on the LIS system introduced:
http://www.ghrj.net/jyxt/index.htm
|