--DROP TABLE IVR.VS.pulseMethod CASCADE; CREATE TABLE IVR.VS.pulseMethod ( IVR.VS.pulseMethod_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.pulseMethod (IVR.VS.pulseMethod_id, code, codeSystem, displayName) VALUES (1, '1000141', '2.16.756.5.30.1.143.5.1', '12pol EKG'); INSERT INTO IVR.VS.pulseMethod (IVR.VS.pulseMethod_id, code, codeSystem, displayName) VALUES (2, '1000140', '2.16.756.5.30.1.143.5.1', '4pol EKG'); INSERT INTO IVR.VS.pulseMethod (IVR.VS.pulseMethod_id, code, codeSystem, displayName) VALUES (3, '1000139', '2.16.756.5.30.1.143.5.1', '3pol EKG'); INSERT INTO IVR.VS.pulseMethod (IVR.VS.pulseMethod_id, code, codeSystem, displayName) VALUES (4, '113011001', '2.16.840.1.113883.6.96', 'Palpation ');