HUMS Hospital

not yet update by developer

Script to be run on other databases.

INSERT INTO system_master (id, description, identifier_code, name_en, active, created_at, created_by, last_updated_at, last_updated_by, type_id, type_identifier)
SELECT
(SELECT COALESCE,0) + 1 FROM system_master),
'Transferred to other facility /Unit',
'transferred-to-other--unit',
'Transferred to other facility /Unit',
true,
NOW,
'Sagar Pokale',
NOW,
'Sagar Pokale',
id,
identifier_code
FROM system_master_type
WHERE identifier_code = 'DIS-TYP';

INSERT INTO system_master (id, description, identifier_code, name_en, active, created_at, created_by, last_updated_at, last_updated_by, type_id, type_identifier)
SELECT (SELECT COALESCE,0) + 1 FROM system_master),
'Transferred to another Hospital',
'transferred-to-another--hospital',
'Transferred to another Hospital',
true,
NOW,
'Sagar Pokale',
NOW,
'Sagar Pokale',
id,
identifier_code
FROM system_master_type
WHERE identifier_code = 'DIS-TYP';

Please find the observation below:

Tested in QA

In Patient > Discharge type and discharge disposition is the same. To inactivate discharge disposition - PASS in QA, Disposition Type dropdown is no longer available

WORKING ON SANDBOX.