--DROP TABLE PregnancyObservationCodes CASCADE; CREATE TABLE PregnancyObservationCodes ( PregnancyObservationCodes_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (1, '11636-8', '2.16.840.1.113883.6.1', 'BIRTHS LIVE (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (2, '11637-6', '2.16.840.1.113883.6.1', 'BIRTHS PRETERM (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (3, '11638-4', '2.16.840.1.113883.6.1', 'BIRTHS STILL LIVING (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (4, '11639-2', '2.16.840.1.113883.6.1', 'BIRTHS TERM (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (5, '11640-0', '2.16.840.1.113883.6.1', 'BIRTHS TOTAL (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (6, '11612-9', '2.16.840.1.113883.6.1', 'ABORTIONS(REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (7, '11613-7', '2.16.840.1.113883.6.1', 'ABORTIONSINDUCED (REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (8, '11614-5', '2.16.840.1.113883.6.1', 'ABORTIONSSPONTANEOUS(REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (9, '33065-4', '2.16.840.1.113883.6.1', 'ECTOPIC PREGNANCY(REPORTED)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (10, '57062-2', '2.16.840.1.113883.6.1', 'Births.stillborn'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (11, '11996-6', '2.16.840.1.113883.6.1', 'Pregnancies'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (12, '11639-2', '2.16.840.1.113883.6.1', 'Births.Term'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (13, '11637-6', '2.16.840.1.113883.6.1', 'Births.Preterm'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (14, '45371-2', '2.16.840.1.113883.6.1', 'Multiple pregnancy'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (15, '49051-6', '2.16.840.1.113883.6.1', 'Gestational age'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (16, '11887-7', '2.16.840.1.113883.6.1', 'FETUS, GESTATIONAL AGE (ESTIMATED FROM SELECTED DELIVERY DATE)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (17, '32396-4', '2.16.840.1.113883.6.1', 'Labor duration'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (18, '8339-4', '2.16.840.1.113883.6.1', 'Body weight at birth'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (19, '29300-1', '2.16.840.1.113883.6.1', 'Procedure9'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (20, '8722-1', '2.16.840.1.113883.6.1', 'Surgical operation note anesthesia'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (21, '52829-9', '2.16.840.1.113883.6.1', 'Place of service'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (22, '42839-1', '2.16.840.1.113883.6.1', 'Labor risk'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (23, '42840-9', '2.16.840.1.113883.6.1', 'Delivery risk'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (24, '11449-6', '2.16.840.1.113883.6.1', 'PREGNANCYSTATUS'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (25, '8678-5', '2.16.840.1.113883.6.1', 'MENSTRUAL STATUS'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (26, '8665-2', '2.16.840.1.113883.6.1', 'DATE LAST MENSTRUAL PERIOD'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (27, '11778-8', '2.16.840.1.113883.6.1', 'DELIVERY DATE (CLINICAL ESTIMATE)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (28, '11779-6', '2.16.840.1.113883.6.1', 'DELIVERY DATE (ESTIMATED FROM LAST MENSTRUAL PERIOD)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (29, '11780-4', '2.16.840.1.113883.6.1', 'DELIVERY DATE (ESTIMATED FROM OVULATION DATE)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (30, '11884-4', '2.16.840.1.113883.6.1', 'FETUS, GESTATIONAL AGE (CLINICAL ESTIMATE)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (31, '11885-1', '2.16.840.1.113883.6.1', 'FETUS, GESTATIONAL AGE (ESTIMATED FROM LAST MENSTRUAL PERIOD)'); INSERT INTO PregnancyObservationCodes (PregnancyObservationCodes_id, code, codeSystem, displayName) VALUES (32, '11886-9', '2.16.840.1.113883.6.1', 'FETUS, GESTATIONAL AGE (ESTIMATED FROM OVULATION DATE)');