--DROP TABLE ActStatusCodeActiveCompletedAbortedSuspended CASCADE;
CREATE TABLE ActStatusCodeActiveCompletedAbortedSuspended (
ActStatusCodeActiveCompletedAbortedSuspended_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL
);
INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
VALUES (1, 'completed', '2.16.840.1.113883.5.14', 'Completed');
INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
VALUES (2, 'aborted', '2.16.840.1.113883.5.14', 'Aborted');
INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
VALUES (3, 'active', '2.16.840.1.113883.5.14', 'Active');
INSERT INTO ActStatusCodeActiveCompletedAbortedSuspended (ActStatusCodeActiveCompletedAbortedSuspended_id, code, codeSystem, displayName)
VALUES (4, 'suspended', '2.16.840.1.113883.5.14', 'Suspended');