HUMS Hospital

Backend Changes done

Release Details

Service Name : Backend_LabService

DB Script :

DataBase Name : Lab
Schemas Name : Master

1) Table Name : m_result_status

INSERT INTO master.m_result_status
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;
INSERT INTO master.m_result_status
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;

2) Table Name : m_staining_type

INSERT INTO master.m_staining_type
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;
INSERT INTO master.m_staining_type
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;
INSERT INTO master.m_staining_type
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;
INSERT INTO master.m_staining_type
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;
INSERT INTO master.m_staining_type
(id, active, created_by, created_date, updated_by, updated_date, code, created_by_id, description, updated_by_id, l1, l2, l3, l4, l5, l6, org_id)
VALUES;

Testing done in QA
1. Result can be captured (Pos/Neg) in the identification screen
2. But Performed By doesn't meet the intended requirement

User selection is manual instead of auto-captured.
Same “Performed By” data is shared across Media Observation and Identification screens; Changing one screen automatically updates the other.

Requirement expected for Performed By:

Auto-capture logged-in user details, MLT can change the details if needed
Separate tracking per module/screen/action
Multiple MLT handling support

Video is attached for reference.

ALTER TABLE transaction.t_micro_result
DROP COLUMN performed_by_id,
DROP COLUMN performed_date,
DROP COLUMN designation_id;

Tested "Performed by" capturing points automatically.