 	"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_FAMILY" 
   (	"ENTERPRISE_ID" NUMBER DEFAULT SYS_CONTEXT('ARGUS_MART_CTX','enterprise_id'), 
	"FAMILY_ID" NUMBER, 
	"NAME" VARCHAR2(40 CHAR), 
	"PRIMARY_VIEW" NUMBER, 
	"DELETED" DATE, 
	"PRODUCT_GROUP_ID" NUMBER, 
	"COMMENTS" VARCHAR2(1000 CHAR), 
	"SEARCH_EQUATION_NUMBER" VARCHAR2(10 CHAR), 
	"NAME_J" VARCHAR2(40 CHAR), 
	"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

	"DET_LISTEDNESS_ID" NUMBER, 
	"RPT_CAUSALITY_ID" NUMBER, 
	"DET_CAUSALITY_ID" NUMBER, 
	"LISTED_JUSTIFY" varchar(1000), 
	"CAUSE_JUSTIFY" varchar(1000), 
	"LAM_ASSESSED" NUMBER(12,0), 
	"DELETED" DATE, 
	"CAUSALITY_ASSESSMENT" varchar(50), 
	"CAUSALITY_SCORE" NUMBER, 
	"SOURCE_ID" NUMBER, 
	"PRT_CAUSALITY_ID" NUMBER, 
	"CAUSE_JUSTIFY_J" varchar(1000), 
	"LISTED_JUSTIFY_J" varchar(1000), 
	"DLP_REVISION_NUMBER" NUMBER, 
	"LAST_UPDATE_TIME" DATE, 
	"REVISION_DELETE_FLAG" NUMBER DEFAULT 0, 
