hv_labgen_accession_costs ddl

  CREATE TABLE "HV_LABGEN_ACCESSION_COSTS"
   (    "RECNUM" FLOAT NOT NULL,
    "ACCESSION" VARCHAR(20) NOT NULL,
    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
    "SG_COST" FLOAT NOT NULL,
    "NUMBER_OF_TESTS" FLOAT NOT NULL,
    "COGS" FLOAT NOT NULL,
    "INSURANCE_COST" FLOAT NOT NULL,
    "AVG_TEST_COMPL" FLOAT NOT NULL,
    "NUMBER_OF_TNP" FLOAT NOT NULL,
    "NUMBER_OF_CPTS" FLOAT
   );

  CREATE UNIQUE INDEX "HV_LABGEN_ACCESSION_COSTS_U1" ON "HV_LABGEN_ACCESSION_COSTS" ("RECNUM", "SOURCE_CLINIC");

  CREATE UNIQUE INDEX "HV_LABGEN_ACCESSION_COSTS_U2" ON "HV_LABGEN_ACCESSION_COSTS" ("ACCESSION", "SOURCE_CLINIC");