** Extract from ECF V 1.0 FILERID - Changed to AlphaNumeric since its generated as string in our new Election and Campaign Finance System ( ECF ) CONTRIB -------- FILERID VARCHAR(20) --Changed to AlphaNumeric since its generated as string in our new ECF system EYEAR INT CYCLE INT SECTION VARCHAR(10) CONTRIBUTOR VARCHAR(255) ADDRESS1 VARCHAR(50) ADDRESS2 VARCHAR(50) CITY VARCHAR(50) STATE VARCHAR(10) ZIPCODE VARCHAR(15) OCCUPATION VARCHAR(255) ENAME VARCHAR(255) EADDRESS1 VARCHAR(50) EADDRESS2 VARCHAR(50) ECITY VARCHAR(50) ESTATE VARCHAR(10) EZIPCODE VARCHAR(15) CONTDATE1 VARCHAR(20) CONTAMT1 MONEY CONTDATE2 VARCHAR(20) CONTAMT2 MONEY CONTDATE3 VARCHAR(20) CONTAMT3 MONEY CONTDESC VARCHAR(500) DEBT ---- FILERID VARCHAR(20) --Changed to AlphaNumeric since its generated as string in our new ECF system EYEAR INT CYCLE INT DBTNAME VARCHAR(255) ADDRESS1 VARCHAR(50) ADDRESS2 VARCHAR(50) CITY VARCHAR(50) STATE VARCHAR(10) ZIPCODE VARCHAR(15) DBTDATE VARCHAR(20) DBTAMT MONEY DBTDESC VARCHAR(500) EXPENSE ------- FILERID VARCHAR(20)--Changed to AlphaNumeric since its generated as string in our new ECF system EYEAR INT CYCLE INT EXPNAME VARCHAR(255) ADDRESS1 VARCHAR(50) ADDRESS2 VARCHAR(50) CITY VARCHAR(50) STATE VARCHAR(10) ZIPCODE VARCHAR(15) EXPDATE VARCHAR(20) EXPAMT MONEY EXPDESC VARCHAR(500) FILER ------ FILERID VARCHAR(20)--Changed to AlphaNumeric since its generated as string in our new ECF system EYEAR INT CYCLE INT AMMEND VARCHAR(1) TERMINATE VARCHAR(1) FILERTYPE VARCHAR(10) FILERNAME VARCHAR(255) OFFICE VARCHAR(15) DISTRICT VARCHAR(15) PARTY VARCHAR(15) ADDRESS1 VARCHAR(50) ADDRESS2 VARCHAR(50) CITY VARCHAR(50) STATE VARCHAR(10) ZIPCODE VARCHAR(15) COUNTY VARCHAR(15) PHONE VARCHAR(15) BEGINNING MONEY MONETARY MONEY INKIND MONEY RECEIPT -------- FILERID VARCHAR(20)--Changed to AlphaNumeric since its generated as string in our new ECF system EYEAR INT CYCLE INT RECNAME VARCHAR(255) ADDRESS1 VARCHAR(50) ADDRESS2 VARCHAR(50) CITY VARCHAR(50) STATE VARCHAR(10) ZIPCODE VARCHAR(15) RECDESC VARCHAR(500) RECDATE VARCHAR(20) RECAMT MONEY