SET ColumnMode;
CLEAR FROM LabEventMap WHERE objectId != NULL;
SELECT objectId INTO OID FROM CISCareUnitCfg WHERE name="060_IOP";

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2019-8",
    mappedPtEvent  = "PaCO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "1994-3",
    mappedPtEvent  = "Calcium__mmol_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2746-6",
    mappedPtEvent  = "ven__ph_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2744-1",
    mappedPtEvent  = "Art__pH_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9987-9",
    mappedPtEvent  = "O2GE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2947-0",
    mappedPtEvent  = "Natrium__mmol_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "718-7",
    mappedPtEvent  = "t_Hb_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "6298-4",
    mappedPtEvent  = "Kalium__mmol__CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2021-4",
    mappedPtEvent  = "PvCO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "1960-4",
    mappedPtEvent  = "HCO3_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2711-0",
    mappedPtEvent  = "ven__SAET_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2708-6",
    mappedPtEvent  = "SAET___CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "1925-7",
    mappedPtEvent  = "Art__ABE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "1927-3",
    mappedPtEvent  = "ven__ABE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2026-3",
    mappedPtEvent  = "TCO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2703-7",
    mappedPtEvent  = "PaO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2705-2",
    mappedPtEvent  = "PvO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2617-9",
    mappedPtEvent  = "ven__METHB_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9985-3",
    mappedPtEvent  = "ven__O2GE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2615-3",
    mappedPtEvent  = "art__METHB_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2027-1",
    mappedPtEvent  = "ven__TCO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9994-5",
    mappedPtEvent  = "ven__SBE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "1959-6",
    mappedPtEvent  = "ven__HCO3_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9996-0",
    mappedPtEvent  = "SBE_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2030-5",
    mappedPtEvent  = "art__HBCO_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2032-1",
    mappedPtEvent  = "ven__HBCO_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9993-7",
    mappedPtEvent  = "SBIC_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "9991-1",
    mappedPtEvent  = "ven__SBIC_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2716-9",
    mappedPtEvent  = "ven__HBO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);

INSERT INTO LabEventMap
  WITH VALUES
    testId         = "2714-4",
    mappedPtEvent  = "art__HBO2_CFG",
    mappedPropName = "value1",
    careunitName   = ("CISCareUnitCfg",$OID);