hv_labgen_report_dates ddl

  CREATE TABLE "HV_LABGEN_REPORT_DATES"
   (    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
    "RECNUM" BIGINT,
    "ACCESSION" VARCHAR(10),
    "FIRSTTIME" VARCHAR(8),
    "FINALTIME" VARCHAR(8),
    "TESTTYPE" VARCHAR(3),
    "FIRSTDATE" DATETIME,
    "FINALDATE" DATETIME,
    "FINAL_DATE_TIME" DATETIME,
    "DSYS_INSTANCE_ID" BIGINT,
    "DSYS_PROCESS_ID" BIGINT,
    "DSYS_BATCH_ID" DECIMAL(30,0)
   );

  CREATE UNIQUE INDEX "HV_LABGEN_REPORT_DATES_AU1" ON "HV_LABGEN_REPORT_DATES" ("ACCESSION", "RECNUM", "SOURCE_CLINIC");

  CREATE INDEX "HV_LABGEN_REPORT_DATES_SYS" ON "HV_LABGEN_REPORT_DATES" ("DSYS_INSTANCE_ID", "DSYS_PROCESS_ID", "DSYS_BATCH_ID");