hv_labgen_clients ddl

  CREATE TABLE "HV_LABGEN_CLIENTS"
   (    "SOURCE_CLINIC" VARCHAR(15) NOT NULL,
    "NUM" BIGINT,
    "COPIES" BIGINT,
    "DRCOPY" BIGINT,
    "BILLDR" BIGINT,
    "BILLPAT" BIGINT,
    "DISCOUNT" BIGINT,
    "SALESGROUP" BIGINT,
    "SALESGRP2" BIGINT,
    "SALESGRP3" BIGINT,
    "SALESGRP4" BIGINT,
    "ROUTE" BIGINT,
    "BILLTOCLT" BIGINT,
    "RECNUM" BIGINT,
    "NAME" VARCHAR(25),
    "TITLE" VARCHAR(4),
    "ADDRS" VARCHAR(25),
    "CITY" VARCHAR(25),
    "STATE" VARCHAR(2),
    "ZIP" VARCHAR(9),
    "COMPANY" VARCHAR(1),
    "REMREP" VARCHAR(1),
    "PRIVILEGE" VARCHAR(1),
    "PROVIDER" VARCHAR(10),
    "DRTYPE" VARCHAR(2),
    "TEL" VARCHAR(13),
    "CONTACT" VARCHAR(25),
    "BILLPROF" VARCHAR(1),
    "ADDR2" VARCHAR(25),
    "CITYSTATE" VARCHAR(25),
    "BILLZIP" VARCHAR(9),
    "PROVIDER2" VARCHAR(10),
    "ASSIGN" VARCHAR(1),
    "SPECPRICE" VARCHAR(1),
    "COMPTEST" VARCHAR(1),
    "INACTIVE_" VARCHAR(1),
    "OKTOBILL" VARCHAR(1),
    "DIALYSIS" VARCHAR(1),
    "ALLBILLTYPES" VARCHAR(1),
    "LSTPAYDT" DATETIME,
    "DSYS_INSTANCE_ID" BIGINT,
    "DSYS_PROCESS_ID" BIGINT,
    "DSYS_BATCH_ID" DECIMAL(30,0),
    "NPI" VARCHAR(12)
   )
  ON "HV_DATA" ;

  CREATE UNIQUE INDEX "HV_LABGEN_CLIENTS_AU1" ON "HV_LABGEN_CLIENTS" ("RECNUM", "SOURCE_CLINIC")
  ON "HV_DATA" ;

  CREATE INDEX "HV_LABGEN_CLIENTS_N1" ON "HV_LABGEN_CLIENTS" ("NAME")
  ON "HV_DATA" ;

  CREATE INDEX "HV_LABGEN_CLIENTS_SYS" ON "HV_LABGEN_CLIENTS" ("DSYS_INSTANCE_ID", "DSYS_PROCESS_ID", "DSYS_BATCH_ID")
  ON "HV_DATA" ;