 	"EVALUATION" CLOB, 
 	"EVALUATION_J" CLOB, 
 	"CO_SUSPECT_COUNT" NUMBER(3,0), 
-	"EVENT_SYNOPSIS" VARCHAR2(5 CHAR), 
-	"EVENT_PRIMARY" VARCHAR2(400 CHAR), 
-	"DIAGNOSIS_REPTD" VARCHAR2(255 CHAR), 
-	"DIAGNOSIS_CODED" VARCHAR2(255 CHAR), 
+	"EVENT_SYNOPSIS" varchar(5), 
+	"EVENT_PRIMARY" varchar(400), 
+	"DIAGNOSIS_REPTD" varchar(255), 
+	"DIAGNOSIS_CODED" varchar(255), 
 	"DIAGNOSIS_SYN_CODE" NUMBER, 
 	"DIAGNOSIS_CODE_STATUS" NUMBER(3,0), 
-	"EVENT_PRIMARY_J" VARCHAR2(400 CHAR), 
-	"AGENT_NOTES_J" VARCHAR2(1000 CHAR), 
-	"COMPANY_DIAGNOSIS_J" VARCHAR2(250 CHAR), 
-	"COMPANY_DIAGNOSIS_NOTES_J" VARCHAR2(1000 CHAR), 
-	"DIAGNOSIS_BODY_SYS_J" VARCHAR2(250 CHAR), 
-	"DIAGNOSIS_CODED_J" VARCHAR2(255 CHAR), 
+	"EVENT_PRIMARY_J" varchar(400), 
+	"AGENT_NOTES_J" varchar(1000), 
+	"COMPANY_DIAGNOSIS_J" varchar(250), 
+	"COMPANY_DIAGNOSIS_NOTES_J" varchar(1000), 
+	"DIAGNOSIS_BODY_SYS_J" varchar(250), 
+	"DIAGNOSIS_CODED_J" varchar(255), 
 	"DIAGNOSIS_CODE_STATUS_J" NUMBER, 
-	"DIAGNOSIS_HLGT_J" VARCHAR2(250 CHAR), 
-	"DIAGNOSIS_HLT_J" VARCHAR2(250 CHAR), 
-	"DIAGNOSIS_INC_CODE_J" VARCHAR2(30 CHAR), 
-	"DIAGNOSIS_INC_TERM_J" VARCHAR2(250 CHAR), 
-	"DIAGNOSIS_REPTD_J" VARCHAR2(255 CHAR), 
-	"LISTEDNESS_NOTES_J" VARCHAR2(1000 CHAR), 
-	"SERIOUS_NOTES_J" VARCHAR2(1000 CHAR), 
-	"UD_TEXT_1_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_2_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_3_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_4_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_5_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_6_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_7_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_8_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_9_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_10_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_11_J" VARCHAR2(100 CHAR), 
-	"UD_TEXT_12_J" VARCHAR2(100 CHAR), 
+	"DIAGNOSIS_HLGT_J" varchar(250), 
+	"DIAGNOSIS_HLT_J" varchar(250), 
+	"DIAGNOSIS_INC_CODE_J" varchar(30), 
+	"DIAGNOSIS_INC_TERM_J" varchar(250), 
+	"DIAGNOSIS_REPTD_J" varchar(255), 
+	"LISTEDNESS_NOTES_J" varchar(1000), 
+	"SERIOUS_NOTES_J" varchar(1000), 
+	"UD_TEXT_1_J" varchar(100), 
+	"UD_TEXT_2_J" varchar(100), 
+	"UD_TEXT_3_J" varchar(100), 
+	"UD_TEXT_4_J" varchar(100), 
+	"UD_TEXT_5_J" varchar(100), 
+	"UD_TEXT_6_J" varchar(100), 
+	"UD_TEXT_7_J" varchar(100), 
+	"UD_TEXT_8_J" varchar(100), 
+	"UD_TEXT_9_J" varchar(100), 
+	"UD_TEXT_10_J" varchar(100), 
+	"UD_TEXT_11_J" varchar(100), 
+	"UD_TEXT_12_J" varchar(100), 
 	"DIAGNOSIS_SYN_CODE_J" NUMBER, 
 	"DELETED" DATE, 
 	"DLP_REVISION_NUMBER" NUMBER, 

  CREATE TABLE "MART_USER"."RM_LM_PRODUCT" 
   (	"ENTERPRISE_ID" NUMBER DEFAULT SYS_CONTEXT('ARGUS_MART_CTX','enterprise_id'), 
	"PRODUCT_ID" NUMBER, 
	"PROD_NAME" VARCHAR2(70 CHAR), 
	"FAMILY_ID" NUMBER, 
	"FORMULATION_ID" NUMBER, 
	"MANUFACTURER_ID" NUMBER, 
	"CONCENTRATION" VARCHAR2(10 CHAR), 
	"CONC_UNIT_ID" NUMBER, 
	"INDICATION_ID" VARCHAR2(50 CHAR), 
	"CODE_DICT" NUMBER, 
	"INDICATION_TEXT" VARCHAR2(250 CHAR), 
	"INTL_BIRTH_DATE" DATE, 
	"MODEL_NO" VARCHAR2(20 CHAR), 
	"DRL_ID" VARCHAR2(45 CHAR), 
	"DRUG_CODE" VARCHAR2(20 CHAR), 
	"DELETED" DATE, 
	"PROD_GENERIC_NAME" CLOB, 
	"PROD_GENERIC_NAME_J" CLOB, 
	"IND_LLT_CODE" VARCHAR2(50 CHAR), 
	"IND_LLT" VARCHAR2(250 CHAR), 
	"IND_HLT_CODE" VARCHAR2(50 CHAR), 
	"IND_HLT" VARCHAR2(250 CHAR), 
	"IND_HLGT_CODE" VARCHAR2(50 CHAR), 
	"IND_HLGT" VARCHAR2(250 CHAR), 
	"IND_SOC_CODE" VARCHAR2(50 CHAR), 
	"IND_SOC" VARCHAR2(250 CHAR), 
	"IND_SYN_CODE" NUMBER, 
	"IND_CODE_STATUS" NUMBER, 
	"MEDICINAL_PROD_ID" VARCHAR2(10 CHAR), 
	"PROD_NAME_ABBRV" VARCHAR2(5 CHAR), 
	"DEVICE_CODE" VARCHAR2(50 CHAR), 
	"PSUR_GROUP_NAME" VARCHAR2(50 CHAR), 
	"COMMENTS" VARCHAR2(1000 CHAR), 
	"IND_CODED" VARCHAR2(250 CHAR), 
	"IND_REPTD" VARCHAR2(250 CHAR), 
	"DRL_ID_J" VARCHAR2(45 CHAR), 
	"DRUG_CODE_J" VARCHAR2(20 CHAR), 
	"DRUG_CODE_TYPE_J" NUMBER, 
	"INDICATION_TEXT_J" VARCHAR2(250 CHAR), 
	"IND_CODE_STATUS_J" NUMBER, 
	"IND_HLGT_J" VARCHAR2(250 CHAR), 
	"IND_HLT_J" VARCHAR2(250 CHAR), 
	"IND_LLT_CODE_J" VARCHAR2(50 CHAR), 
	"IND_LLT_J" VARCHAR2(250 CHAR), 
	"IND_SOC_J" VARCHAR2(250 CHAR), 
	"PROD_NAME_J" VARCHAR2(70 CHAR), 
	"IND_SYN_CODE_J" NUMBER, 
	"IND_CODED_J" VARCHAR2(250 CHAR), 
	"IND_REPTD_J" VARCHAR2(250 CHAR), 
	"DEV_INTL_BIRTH_DATE" DATE, 
	"COMMENTS_J" VARCHAR2(1000 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

	"TERM_CODE" NUMBER, 
	"TERM_LEVEL" NUMBER, 
	"TERM_SCOPE" NUMBER, 
	"TERM_CATEGORY" varchar(1), 
	"TERM_WEIGHT" NUMBER, 
	"TERM_STATUS" varchar(1), 
	"TERM_ADDITION_VERSION" varchar(5), 
	"TERM_LAST_MODIFIED_VERSION" varchar(5 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
