--DROP TABLE ActStatus CASCADE; CREATE TABLE ActStatus ( ActStatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (1, 'normal', '2.16.840.1.113883.5.14', 'normal'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (2, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (3, 'active', '2.16.840.1.113883.5.14', 'active'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (4, 'cancelled', '2.16.840.1.113883.5.14', 'cancelled'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (5, 'completed', '2.16.840.1.113883.5.14', 'completed'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (6, 'held', '2.16.840.1.113883.5.14', 'held'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (7, 'new', '2.16.840.1.113883.5.14', 'new'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (8, 'suspended', '2.16.840.1.113883.5.14', 'suspended'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (9, 'nullified', '2.16.840.1.113883.5.14', 'nullified'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (10, 'obsolete', '2.16.840.1.113883.5.14', 'obsolete'); --DROP TABLE ActStatus CASCADE; CREATE TABLE ActStatus ( ActStatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (1, 'normal', '2.16.840.1.113883.5.14', 'normal'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (2, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (3, 'active', '2.16.840.1.113883.5.14', 'active'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (4, 'cancelled', '2.16.840.1.113883.5.14', 'cancelled'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (5, 'completed', '2.16.840.1.113883.5.14', 'completed'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (6, 'held', '2.16.840.1.113883.5.14', 'held'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (7, 'new', '2.16.840.1.113883.5.14', 'new'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (8, 'suspended', '2.16.840.1.113883.5.14', 'suspended'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (9, 'nullified', '2.16.840.1.113883.5.14', 'nullified'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (10, 'obsolete', '2.16.840.1.113883.5.14', 'obsolete'); --DROP TABLE ActStatus CASCADE; CREATE TABLE ActStatus ( ActStatus_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (1, 'normal', '2.16.840.1.113883.5.14', 'normal'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (2, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (3, 'active', '2.16.840.1.113883.5.14', 'active'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (4, 'cancelled', '2.16.840.1.113883.5.14', 'cancelled'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (5, 'completed', '2.16.840.1.113883.5.14', 'completed'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (6, 'held', '2.16.840.1.113883.5.14', 'held'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (7, 'new', '2.16.840.1.113883.5.14', 'new'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (8, 'suspended', '2.16.840.1.113883.5.14', 'suspended'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (9, 'nullified', '2.16.840.1.113883.5.14', 'nullified'); INSERT INTO ActStatus (ActStatus_id, code, codeSystem, displayName) VALUES (10, 'obsolete', '2.16.840.1.113883.5.14', 'obsolete');