INSERT INTO I2B2DEMODATA.RESEARCH_TYPE (RESEARCH_TYPE_CD, RESEARCH_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('C','Clinical','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.RESEARCH_TYPE (RESEARCH_TYPE_CD, RESEARCH_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('O','Observational','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.RESEARCH_TYPE (RESEARCH_TYPE_CD, RESEARCH_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('A','Animal','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.RESEARCH_TYPE (RESEARCH_TYPE_CD, RESEARCH_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('I','In vitro','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.IRB_APPROVAL_TYPE (IRB_APPROVAL_TYPE_CD, IRB_APPROVAL_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('F','Full review','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.IRB_APPROVAL_TYPE (IRB_APPROVAL_TYPE_CD, IRB_APPROVAL_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('E','Expedited review','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.IRB_APPROVAL_TYPE (IRB_APPROVAL_TYPE_CD, IRB_APPROVAL_TYPE_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('X','Exempt','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.REQUEST_STATUS (REQUEST_STATUS_CD, REQUEST_STATUS_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('P','Pending','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.REQUEST_STATUS (REQUEST_STATUS_CD, REQUEST_STATUS_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('I','In Process','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.REQUEST_STATUS (REQUEST_STATUS_CD, REQUEST_STATUS_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('C','Completed','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.REQUEST_STATUS (REQUEST_STATUS_CD, REQUEST_STATUS_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('O','On Hold','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.REQUEST_STATUS (REQUEST_STATUS_CD, REQUEST_STATUS_DESC, CREATE_USER, CREATE_DATE) 
VALUES ('X','Cancelled','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.MAP_TYPE (MAP_TYPE_CD, MAP_TYPE_DESC, CREATE_USER, CREATE_DATE) values ('ON','OnetoOne','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.MAP_TYPE (MAP_TYPE_CD, MAP_TYPE_DESC, CREATE_USER, CREATE_DATE) values ('AG','Aggregate','DEFAULT','2010-01-01');

INSERT INTO I2B2DEMODATA.MAP_TYPE (MAP_TYPE_CD, MAP_TYPE_DESC, CREATE_USER, CREATE_DATE) values ('AR','Archetype','DEFAULT','2010-01-01');

COMMIT;