hv_labgen_ordered_tests ddl

  CREATE TABLE "HV_LABGEN_ORDERED_TESTS"
   (    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
    "INDTESTS" VARCHAR(4),
    "TESTFLAGS" VARCHAR(1),
    "RESULTS" VARCHAR(8),
    "ORDER_RECNUM" BIGINT,
    "SEQ" INT,
    "RECNUM" BIGINT,
    "DSYS_INSTANCE_ID" BIGINT,
    "DSYS_PROCESS_ID" BIGINT,
    "DSYS_BATCH_ID" DECIMAL(30,0),
    "TEST_COMPLETION_DATE" DATETIME,
    "TEST_STARTED_DATE" DATETIME,
    "TEST_STARTED_TECH" VARCHAR(10),
    "TEST_COMPLETION_TECH" VARCHAR(10),
    "MESSAGE" VARCHAR(4000),
    "IN_HOUSE_SEND_OUT" VARCHAR(10),
    "REFERENCE_LABNAME" VARCHAR(30),
    "REFLAB_RECNUM" FLOAT,
    "LOW_TEST_RANGE" VARCHAR(4000),
    "HIGH_TEST_RANGE" VARCHAR(4000),
    "REFERENCE_RANGE" VARCHAR(20),
    "ABNORMAL" VARCHAR(3),
    "TRANSLATION" VARCHAR(50)
   ) ;

  CREATE UNIQUE INDEX "HV_LABGEN_ORDERED_TESTS_AU1" ON "HV_LABGEN_ORDERED_TESTS" ("ORDER_RECNUM", "SOURCE_CLINIC", "INDTESTS");

  CREATE INDEX "HV_LABGEN_ORDERED_TESTS_N1" ON "HV_LABGEN_ORDERED_TESTS" ("INDTESTS", "SOURCE_CLINIC");

  CREATE INDEX "HV_LABGEN_ORDERED_TESTS_SYS" ON "HV_LABGEN_ORDERED_TESTS" ("DSYS_INSTANCE_ID", "DSYS_PROCESS_ID", "DSYS_BATCH_ID");

  CREATE OR REPLACE TRIGGER "BU_HV_LABGEN_ORDERED_TESTS" ON hv_labgen_ordered_tests
INSTEAD OF UPDATE
  AS
BEGIN

   IF ISNULL(:NEW.results,'::') =  '::' BEGIN

      SET @:NEW.results = :OLD.results;

   END

END
END;
GO
ALTER TRIGGER "BU_HV_LABGEN_ORDERED_TESTS" ENABLE;