cmd_sendout_reference ddl

  CREATE TABLE "CMD_SENDOUT_REFERENCE"
   (    "ACCESSION_NUMBER_STARTS_WITH" VARCHAR(26),
    "SENDOUT_LAB" VARCHAR(128),
    "SENDOUT_LAB_NAME" VARCHAR(128),
    "NPI" VARCHAR(26),
    "CLIA_ID" VARCHAR(26),
    "ZIP" VARCHAR(26),
    "STATE" VARCHAR(26),
    "SENDOUT_LAB_ADDRESS" VARCHAR(128),
    "SENDOUT_LAB_PREFIX" VARCHAR(26),
    "CITY" VARCHAR(26),
    "START_DATE" DATETIME,
    "END_DATE" DATETIME
   );

  CREATE INDEX "CMD_SENDOUT_REFERENCE_INDEX1" ON "CMD_SENDOUT_REFERENCE" ("ACCESSION_NUMBER_STARTS_WITH", "SENDOUT_LAB");

  CREATE INDEX "CMD_SENDOUT_REFERENCE_INDEX2" ON "CMD_SENDOUT_REFERENCE" ("SENDOUT_LAB");