--------------------------------------------------------
--  File created - Wednesday-September-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table MD_COOP_EADDRESS
--------------------------------------------------------

  CREATE TABLE "STORETW"."MD_COOP_EADDRESS" 
   (	"PK_ISN" NUMBER(12,0), 
	"COOP_EADDR_IS_NUMBER" NUMBER(12,0), 
	"ORGANIZATION_ID" VARCHAR2(256 BYTE), 
	"COOP_EADDR_TYPE" VARCHAR2(256 CHAR), 
	"ADDRESS_ONE_TEXT" VARCHAR2(256 CHAR), 
	"ADDRESS_TWO_TEXT" VARCHAR2(256 CHAR), 
	"COOP_ORG_IS_NUMBER" NUMBER(12,0), 
	"FK_COOP" NUMBER(12,0), 
	"SOURCE_SYSTEM" VARCHAR2(256 CHAR), 
	"SOURCE_UID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 90 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETDATA_STORMODP" ;

   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."PK_ISN" IS 'Primary Key. Generated using sequence object SEQ_COOP_EADDRESS.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."COOP_EADDR_IS_NUMBER" IS 'cooperating organization electronic address internal serial number';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."ORGANIZATION_ID" IS 'The user-defined code that uniquely identifies an Organization.  Organization IDs are registered centrally with STORET so that they are guaranteed to be unique on the National level.  They become part of the Oracle Key on every row in the STORET database that belongs to the Organization.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."COOP_EADDR_TYPE" IS 'cooperating organization electronic address type';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."ADDRESS_ONE_TEXT" IS 'The first line of an Address which usually denotes the company or individual name.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."ADDRESS_TWO_TEXT" IS 'The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also contain company name in addition.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."COOP_ORG_IS_NUMBER" IS 'A system-generated value used to uniquely identify an occurrence of this table.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."FK_COOP" IS 'Foreign Key referencing DI_COOP.';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."SOURCE_SYSTEM" IS 'Metadata source system acronym';
   COMMENT ON COLUMN "STORETW"."MD_COOP_EADDRESS"."SOURCE_UID" IS 'Metadata source record unique identifier';
   COMMENT ON TABLE "STORETW"."MD_COOP_EADDRESS"  IS 'Cooperating Organization electronic address metadata table';
REM INSERTING into STORETW.MD_COOP_EADDRESS
SET DEFINE OFF;
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (1,2,'AWC_WQ','Phone             ','618-239-3249',null,1,7,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (6,5,'21FLTBW','Internet          ','www.pbsj.com',' ',1,62,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (7,4,'21FLTBW','Phone             ','813-281-8357',' ',1,62,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (8,17,'LAKELAND','Internet          ','info@phycotech.com',' ',6,79,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (11,14,'MNPCA1','Internet          ','www.dnr.state.mn.us',' ',2,199,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (12,19,'MNPCA1','Internet          ','www.metrocouncil.org',' ',3,200,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (13,18,'MNPCA1','Phone             ','651-602-1000',' ',3,200,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (14,34,'1117MBR','Fax               ','319-335-2754',' ',1,226,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (15,9,'1117MBR','Commercial Network','mskopec@igsb.uiowa.edu',' ',1,226,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (16,8,'1117MBR','Phone             ','(319) 335-1579','Iowa State STORET Contact',1,226,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (17,12,'1117MBR','Commercial Network','nrgatec@mail.dnr.state.mo.us',' ',2,227,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (18,11,'1117MBR','Fax               ','573-526-5797',' ',2,227,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (19,10,'1117MBR','Phone             ','573-751-4601','Missouri State STORET Contact',2,227,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (20,15,'1117MBR','Commercial Network','deq106@mail.deq.state.ne.us',' ',3,228,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (21,14,'1117MBR','Fax               ','402-471-2909',' ',3,228,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (22,13,'1117MBR','Phone             ','402-471-3196','Nebraska State STORET Contact',3,228,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (23,18,'1117MBR','Internet          ','SBROWN@kdhe.state.ks.us',' ',4,229,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (24,17,'1117MBR','Fax               ','785-296-6247',' ',4,229,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (25,16,'1117MBR','Phone             ','785-296-5612','Kansas State STORET Contact',4,229,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (26,45,'1117MBR','Commercial Network','fischsa@mail.conservation.state.mo.us',' ',5,234,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (27,44,'1117MBR','Fax               ','573-882-9880 x4517',' ',5,234,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (28,43,'1117MBR','Phone             ','573-882-9880 x3271',' ',5,234,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (29,42,'1117MBR','Other             ','785-864-2380','Foley Hall',6,235,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (30,41,'1117MBR','Phone             ','785-864-5093',' ',6,235,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (32,7,'MRSENVMB','Fax               ','805.650.0756',' ',1,330,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (33,4,'MRSENVMB','Phone             ','805.650.0546',' ',1,330,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (34,3,'MRSENVMB','Internet          ','jlemay12@pacbell.net',' ',1,330,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (35,2,'QUAPAWTR','Phone             ','(918) 543-1853',null,1,331,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (36,8,'MRSENVMB','Phone             ','800.878.4911',' ',2,337,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (37,9,'MRSENVMB','Internet          ','MMaier@Altalab.com',' ',3,338,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (38,12,'MRSENVMB','Internet          ','mbwwtp@yahooo.com',' ',4,339,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (39,11,'MRSENVMB','Phone             ','805.772.6272',' ',4,339,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (40,10,'MRSENVMB','Fax               ','805.772.6296',' ',4,339,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (41,36,'21NJDEP1','Phone             ','(201) 599-6171',' ',2,340,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (42,35,'21NJDEP1','Fax               ','(201) 599-6101',' ',2,340,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (43,24,'21NJDEP1','Internet          ','stedfast@usgs.gov',' ',1,341,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (44,23,'21NJDEP1','Phone             ','(609) 771-3969',' ',1,341,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (45,28,'21NJDEP1','Other             ','http://nj.water.usgs.gov/','USGS New Jersey District Web Page',1,341,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (46,25,'21NJDEP1','Phone             ','(609) 292-3950','Main phone number',6,345,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (47,27,'21NJDEP1','Internet          ','mferko@dep.state.nj.us',' ',6,345,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (48,26,'21NJDEP1','Fax               ','(609) 771-1774',' ',6,345,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (49,30,'SRMTAKNY','Fax               ','518-381-6055',' ',1,347,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (50,29,'SRMTAKNY','Phone             ','518-346-4592',' ',1,347,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (51,28,'SRMTAKNY','Fax               ','315-388-4061',' ',2,348,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (52,27,'SRMTAKNY','Phone             ','315-388-4476',' ',2,348,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (53,31,'SRMTAKNY','Phone             ','732-321-4364',' ',3,349,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (54,26,'SRMTAKNY','Other             ','800-843-5227',' ',4,350,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (55,25,'SRMTAKNY','Fax               ','716-554-4114',' ',4,350,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (56,24,'SRMTAKNY','Phone             ','716-554-5347',' ',4,350,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (57,33,'SRMTAKNY','Phone             ','1-800-765-4974  ext. 209',' ',6,352,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (58,2,'AWC','Phone             ','618-239-3249',null,1,353,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (59,34,'21NJDEP1','Fax               ','(609) 645-5923',' ',9,358,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (60,33,'21NJDEP1','Phone             ','(609) 645-5971  Ext: 4373',' ',9,358,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (61,38,'21NJDEP1','Fax               ','(609) 265-5541',' ',10,359,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (62,37,'21NJDEP1','Phone             ','(609) 265-5539',' ',10,359,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (63,40,'21NJDEP1','Phone             ','(856) 374-6065',' ',11,360,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (64,39,'21NJDEP1','Fax               ','(856) 374-6212',' ',11,360,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (65,42,'21NJDEP1','Phone             ','(609) 465-1208',' ',12,361,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (66,41,'21NJDEP1','Fax               ','(609) 465-6564',' ',12,361,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (67,44,'21NJDEP1','Phone             ','(856) 453-2158',' ',13,362,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (68,43,'21NJDEP1','Fax               ','(856) 453-2153',' ',13,362,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (69,46,'21NJDEP1','Phone             ','(856) 262-4100  Ext 4230',' ',14,363,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (70,45,'21NJDEP1','Fax               ','(856) 629-0469',' ',14,363,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (71,48,'21NJDEP1','Phone             ','(908) 782-7510',' ',15,364,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (72,47,'21NJDEP1','Fax               ','(908) 788-1351',' ',15,364,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (73,50,'21NJDEP1','Phone             ','(732) 745-8482',' ',16,365,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (74,49,'21NJDEP1','Fax               ','(732) 745-8480',' ',16,365,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (75,52,'21NJDEP1','Phone             ','(732) 431-7456',' ',17,366,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (76,51,'21NJDEP1','Fax               ','(732) 409-7579',' ',17,366,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (77,54,'21NJDEP1','Phone             ','(973) 225-3637',' ',18,367,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (78,53,'21NJDEP1','Fax               ','(973) 881-4396',' ',18,367,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (79,56,'21NJDEP1','Phone             ','(856) 935-7510',' ',19,368,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (80,55,'21NJDEP1','Fax               ','(856) 935-8483',' ',19,368,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (81,58,'21NJDEP1','Phone             ','(973) 579-0370',' ',20,369,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (82,57,'21NJDEP1','Fax               ','(973) 579-0399',' ',20,369,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (83,60,'21NJDEP1','Phone             ','(908) 654-9890',' ',21,370,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (84,59,'21NJDEP1','Fax               ','(908) 654-9851',' ',21,370,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (85,62,'21NJDEP1','Phone             ','(908) 689-6693',' ',22,371,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (86,61,'21NJDEP1','Fax               ','(908) 689-3832',' ',22,371,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (87,53,'11NPSWRD','Internet          ','http://www.usgs.gov/',' ',1,394,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (88,283,'11NPSWRD','Internet          ','rwebb@virginia.edu','Rick Webb, Project Coordinator',3,396,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (89,282,'11NPSWRD','Internet          ','deviney@virginia.edu','Frank Deviney, Database Manager',3,396,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (90,281,'11NPSWRD','Phone             ','(540) 468-2881','Rick Webb, Project Coordinator',3,396,null,null);
Insert into STORETW.MD_COOP_EADDRESS (PK_ISN,COOP_EADDR_IS_NUMBER,ORGANIZATION_ID,COOP_EADDR_TYPE,ADDRESS_ONE_TEXT,ADDRESS_TWO_TEXT,COOP_ORG_IS_NUMBER,FK_COOP,SOURCE_SYSTEM,SOURCE_UID) values (91,280,'11NPSWRD','Phone             ','(434) 924-7817','Frank Deviney, Database Manager',3,396,null,null);
--------------------------------------------------------
--  DDL for Index IECOORGID
--------------------------------------------------------

  CREATE INDEX "STORETW"."IECOORGID" ON "STORETW"."MD_COOP_EADDRESS" ("ORGANIZATION_ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 589824 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  DDL for Index PK_CO_ORG_EADDR
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_CO_ORG_EADDR" ON "STORETW"."MD_COOP_EADDRESS" ("PK_ISN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  DDL for Index IECOOP
--------------------------------------------------------

  CREATE INDEX "STORETW"."IECOOP" ON "STORETW"."MD_COOP_EADDRESS" ("FK_COOP") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 589824 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table MD_COOP_EADDRESS
--------------------------------------------------------

  ALTER TABLE "STORETW"."MD_COOP_EADDRESS" ADD CONSTRAINT "PK_CO_ORG_EADDR" PRIMARY KEY ("PK_ISN")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP"  ENABLE;
  ALTER TABLE "STORETW"."MD_COOP_EADDRESS" MODIFY ("COOP_EADDR_TYPE" NOT NULL ENABLE);
  ALTER TABLE "STORETW"."MD_COOP_EADDRESS" MODIFY ("ORGANIZATION_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table MD_COOP_EADDRESS
--------------------------------------------------------

  ALTER TABLE "STORETW"."MD_COOP_EADDRESS" ADD CONSTRAINT "FK_MD_ECOOP" FOREIGN KEY ("FK_COOP")
	  REFERENCES "STORETW"."MD_COOP" ("PK_ISN") ENABLE;
