Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "CMD_BOX33_REFERENCE"
- ( "ACCESSION_NUMBER_STARTS_WITH" VARCHAR(10),
- "SALES_GROUP" VARCHAR(12),
- "TEST_TYPE" VARCHAR(26),
- "INSURANCE_TYPE" VARCHAR(26),
- "SENDOUT_LAB" VARCHAR(128),
- "BOX_33_LAB_NAME" VARCHAR(128),
- "BOX_33_LAB_NPI" VARCHAR(26),
- "BOX_33_PREFIX" VARCHAR(26),
- "BOX_33_LAB_TAX_ID" VARCHAR(26),
- "BOX_33_LAB_ADDRESS" VARCHAR(26),
- "BOX_33_LAB_ADDRESS_2" VARCHAR(26),
- "BOX_33_STATE" VARCHAR(26),
- "BOX_33_CITY" VARCHAR(26),
- "BOX_33_CLIA" VARCHAR(26),
- "BOX_33_PHONE_NUMBER" VARCHAR(26),
- "BOX_33_ZIP_CODE" VARCHAR(26),
- "START_DATE" DATETIME,
- "END_DATE" DATETIME
- );
- CREATE INDEX "CMD_BOX33_REFERENCE_INDEX6" ON "CMD_BOX33_REFERENCE" ("ACCESSION_NUMBER_STARTS_WITH", "SENDOUT_LAB", "SALES_GROUP", "TEST_TYPE", "INSURANCE_TYPE");
Advertisement
Add Comment
Please, Sign In to add comment