--DROP TABLE IVR_VS_transReason CASCADE; CREATE TABLE IVR_VS_transReason ( IVR_VS_transReason_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (1, '1000110', '2.16.756.5.30.1.143.5.1', 'emergency mission'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (2, '1000111', '2.16.756.5.30.1.143.5.1', 'relocation'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (3, '1000112', '2.16.756.5.30.1.143.5.1', 'shuttle for emergency doctor'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (4, '1000113', '2.16.756.5.30.1.143.5.1', 'incubator transport'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (5, '1000114', '2.16.756.5.30.1.143.5.1', 'neonatology mission'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (6, '1000003', '2.16.756.5.30.1.143.5.1', 'stand-by mission'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (7, '1000115', '2.16.756.5.30.1.143.5.1', 'return transport'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (8, '1000116', '2.16.756.5.30.1.143.5.1', 'intervention mission police'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (9, '1000117', '2.16.756.5.30.1.143.5.1', 'self-referral'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (10, '1000118', '2.16.756.5.30.1.143.5.1', 'stretcher mission'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (11, '1000119', '2.16.756.5.30.1.143.5.1', 'mission fpr partner'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (12, '1000120', '2.16.756.5.30.1.143.5.1', 'involuntary committment'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (13, '1000121', '2.16.756.5.30.1.143.5.1', 'service on place'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (14, '1000122', '2.16.756.5.30.1.143.5.1', 'referral by doctor'); INSERT INTO IVR_VS_transReason (IVR_VS_transReason_id, code, codeSystem, displayName) VALUES (15, '1000123', '2.16.756.5.30.1.143.5.1', 'refuse of transport');