SQL VERSION :10.2.0.2.0 create table en1 (CLUSTR NUMBER(2), SITEID VARCHAR2(5), ABBRNAC NUMBER(2), CPSTPN NUMBER(2), CONCNO NUMBER(2), ENUM NUMBER(4), LCTYPE VARCHAR2(8), SYNTHETIC VARCHAR2(26)); LCTYPES SUPPORTED ---------------- MK3MCI MKSTSP MK2ORD USUALLY LCTYPES WILL BE PRESNT IN BLOCK OF 64 UNLESS SOMENE HAS MANUALLY REMOVE SOME ROWS MK3STSP AND MK3MCI WILL ALWAYS BE PRESNT AS A COMBO IN A BLOCK OF 64 WHERE MK3MCI WILL BE PRESENT AT EVERY 16 POSITION LOADING THE DATA ON TO CPSTPN=0 AND CONCNO=0 --------------------------------------------- insert into en1 values (0,'POOLE',1,0,0,0,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,1,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,2,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,3,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,4,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,5,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,6,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,7,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,8,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,9,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,10,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,11,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,12,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,13,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,14,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,15,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,16,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,17,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,18,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,19,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,20,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,21,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,22,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,23,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,24,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,25,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,26,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,27,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,28,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,29,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,30,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,31,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,32,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,33,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,34,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,35,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,36,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,37,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,38,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,39,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,40,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,41,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,42,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,43,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,44,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,45,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,46,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,47,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,48,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,49,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,50,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,51,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,52,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,53,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,54,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,55,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,56,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,57,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,58,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,59,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,60,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,61,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,62,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,63,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,64,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,65,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,66,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,67,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,68,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,69,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,70,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,71,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,72,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,73,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,74,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,75,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,76,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,77,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,78,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,79,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,80,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,81,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,82,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,83,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,84,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,85,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,86,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,87,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,88,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,89,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,90,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,91,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,92,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,93,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,94,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,95,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,96,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,97,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,98,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,99,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,100,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,101,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,102,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,103,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,104,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,105,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,106,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,107,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,108,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,109,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,110,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,111,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,112,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,113,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,114,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,115,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,116,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,117,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,118,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,119,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,120,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,121,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,122,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,123,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,124,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,125,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,126,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,127,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,128,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,129,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,130,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,131,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,132,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,133,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,134,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,135,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,136,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,137,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,138,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,139,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,140,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,141,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,142,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,143,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,144,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,145,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,146,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,147,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,148,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,149,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,150,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,151,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,152,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,153,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,154,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,155,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,156,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,157,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,158,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,159,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,160,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,161,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,162,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,163,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,164,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,165,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,166,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,167,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,168,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,169,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,170,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,171,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,172,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,174,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,175,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,176,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,177,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,178,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,179,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,180,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,0,181,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,182,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,183,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,0,184,'MK3STSP',''); update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 10 and 50 AND CPSTPN=0 AND CONCNO=0; update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 80 and 130 AND CPSTPN=0 AND CONCNO=0; LOADING THE DATA ON TO CPSTPN=0 AND CONCNO=1 --------------------------------------------- insert into en1 values (0,'POOLE',1,0,1,0,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,1,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,2,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,3,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,4,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,5,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,6,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,7,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,8,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,9,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,10,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,11,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,12,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,13,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,14,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,15,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,16,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,17,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,18,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,19,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,20,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,21,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,22,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,23,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,24,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,25,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,26,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,27,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,28,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,29,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,30,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,31,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,32,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,33,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,34,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,35,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,36,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,37,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,38,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,39,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,40,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,41,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,42,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,43,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,44,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,45,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,46,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,47,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,48,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,49,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,50,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,51,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,52,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,53,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,54,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,55,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,56,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,57,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,58,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,59,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,60,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,61,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,62,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,63,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,64,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,65,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,66,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,67,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,68,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,69,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,70,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,71,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,72,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,73,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,74,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,75,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,76,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,77,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,78,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,79,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,80,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,81,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,82,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,83,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,84,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,85,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,86,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,87,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,88,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,89,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,90,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,91,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,92,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,93,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,94,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,95,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,96,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,97,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,98,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,99,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,100,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,101,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,102,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,103,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,104,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,105,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,106,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,107,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,108,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,109,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,110,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,111,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,112,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,113,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,114,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,115,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,116,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,117,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,118,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,119,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,120,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,121,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,122,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,123,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,124,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,125,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,126,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,127,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,128,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,129,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,130,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,131,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,132,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,133,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,134,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,135,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,136,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,137,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,138,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,139,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,140,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,141,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,142,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,143,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,144,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,145,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,146,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,147,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,148,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,149,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,150,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,151,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,152,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,153,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,154,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,155,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,156,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,157,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,158,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,159,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,160,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,161,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,162,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,163,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,164,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,165,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,166,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,167,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,168,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,169,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,170,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,171,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,172,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,174,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,175,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,176,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,177,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,178,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,179,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,180,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,1,181,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,182,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,183,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,184,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,1,185,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,186,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,187,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,188,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,189,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,190,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,191,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,192,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,193,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,194,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,195,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,200,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,201,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,202,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,203,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,204,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,205,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,206,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,207,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,208,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,209,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,210,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,211,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,212,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,213,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,214,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,215,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,216,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,217,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,218,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,219,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,220,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,221,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,222,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,223,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,224,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,225,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,226,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,227,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,228,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,229,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,230,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,231,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,232,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,233,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,234,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,235,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,236,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,237,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,238,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,239,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,240,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,241,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,242,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,243,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,244,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,245,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,246,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,247,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,248,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,249,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,250,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,251,'MK2ORD',''); insert into en1 values (0,'POOLE',1,0,1,252,'MK2ORD',''); update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 10 and 20 AND CPSTPN=0 AND CONCNO=1; update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 70 and 80 AND CPSTPN=0 AND CONCNO=1; update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 200 and 240 AND CPSTPN=0 AND CONCNO=1; LOADING THE DATA ON TO CPSTPN=0 AND CONCNO=2 --------------------------------------------- insert into en1 values (0,'POOLE',1,0,2,0,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,1,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,2,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,3,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,4,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,5,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,6,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,7,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,8,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,9,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,10,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,11,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,12,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,13,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,14,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,15,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,16,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,17,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,18,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,19,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,20,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,21,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,22,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,23,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,24,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,25,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,26,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,27,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,28,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,29,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,30,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,31,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,32,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,33,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,34,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,35,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,36,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,37,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,38,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,39,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,40,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,41,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,42,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,43,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,44,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,45,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,46,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,47,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,48,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,49,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,50,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,51,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,52,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,53,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,54,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,55,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,56,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,57,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,58,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,59,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,60,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,61,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,62,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,63,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,64,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,65,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,66,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,67,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,68,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,69,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,70,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,71,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,72,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,73,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,74,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,75,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,76,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,77,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,78,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,79,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,80,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,81,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,82,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,83,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,84,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,85,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,86,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,87,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,88,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,89,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,90,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,91,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,92,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,93,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,94,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,95,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,96,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,97,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,98,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,99,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,100,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,101,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,102,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,103,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,104,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,105,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,106,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,107,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,108,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,109,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,110,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,111,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,112,'MK3MCI',''); insert into en1 values (0,'POOLE',1,0,2,113,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,114,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,115,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,116,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,117,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,118,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,119,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,120,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,121,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,122,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,123,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,124,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,125,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,126,'MK3STSP',''); insert into en1 values (0,'POOLE',1,0,2,127,'MK3STSP',''); update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 0 and 63 AND CPSTPN=0 AND CONCNO=2; *********************************************************************************************************************************************************************************************************** LOADING THE DATA ON TO CPSTPN=1 AND CONCNO=1 --------------------------------------------- insert into en1 values (0,'POOLE',1,1,1,0,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,1,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,2,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,3,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,4,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,5,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,6,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,7,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,8,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,9,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,10,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,11,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,12,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,13,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,14,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,15,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,16,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,17,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,18,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,19,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,20,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,21,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,22,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,23,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,24,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,25,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,26,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,27,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,28,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,29,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,30,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,31,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,32,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,33,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,34,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,35,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,36,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,37,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,38,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,39,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,40,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,41,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,42,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,43,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,44,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,45,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,46,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,47,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,48,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,49,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,50,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,51,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,52,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,53,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,54,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,55,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,56,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,57,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,58,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,59,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,60,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,61,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,62,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,63,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,64,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,65,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,66,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,67,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,68,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,69,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,70,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,71,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,72,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,73,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,74,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,75,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,76,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,77,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,78,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,79,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,80,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,81,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,82,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,83,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,84,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,85,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,86,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,87,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,88,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,89,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,90,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,91,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,92,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,93,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,94,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,95,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,96,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,97,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,98,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,99,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,100,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,101,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,102,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,103,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,104,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,105,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,106,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,107,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,108,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,109,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,110,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,111,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,112,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,1,113,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,114,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,115,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,116,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,117,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,118,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,119,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,120,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,121,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,122,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,123,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,124,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,125,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,126,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,1,127,'MK3STSP',''); update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 0 and 63 AND CPSTPN=1 AND CONCNO=1; LOADING THE DATA ON TO CPSTPN=1 AND CONCNO=3 --------------------------------------------- insert into en1 values (0,'POOLE',1,1,3,0,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,1,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,2,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,3,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,4,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,5,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,6,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,7,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,8,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,9,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,10,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,11,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,12,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,13,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,14,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,15,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,16,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,17,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,18,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,19,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,20,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,21,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,22,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,23,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,24,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,25,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,26,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,27,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,28,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,29,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,30,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,31,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,32,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,33,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,34,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,35,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,36,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,37,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,38,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,39,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,40,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,41,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,42,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,43,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,44,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,45,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,46,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,47,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,48,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,49,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,50,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,51,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,52,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,53,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,54,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,55,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,56,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,57,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,58,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,59,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,60,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,61,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,62,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,63,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,64,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,65,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,66,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,67,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,68,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,69,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,70,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,71,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,72,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,73,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,74,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,75,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,76,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,77,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,78,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,79,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,80,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,81,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,82,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,83,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,84,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,85,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,86,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,87,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,88,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,89,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,90,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,91,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,92,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,93,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,94,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,95,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,96,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,97,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,98,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,99,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,100,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,101,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,102,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,103,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,104,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,105,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,106,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,107,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,108,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,109,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,110,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,111,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,112,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,113,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,114,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,115,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,116,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,117,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,118,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,119,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,120,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,121,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,122,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,123,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,124,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,125,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,126,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,127,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,128,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,129,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,130,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,131,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,132,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,133,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,134,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,135,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,136,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,137,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,138,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,139,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,140,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,141,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,142,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,143,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,144,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,145,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,146,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,147,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,148,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,149,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,150,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,151,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,152,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,153,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,154,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,155,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,156,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,157,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,158,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,159,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,160,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,161,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,162,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,163,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,164,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,165,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,166,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,167,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,168,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,169,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,170,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,171,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,172,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,173,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,174,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,175,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,176,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,177,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,178,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,179,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,180,'MK3MCI',''); insert into en1 values (0,'POOLE',1,1,3,181,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,182,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,183,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,184,'MK3STSP',''); insert into en1 values (0,'POOLE',1,1,3,185,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,186,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,187,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,188,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,189,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,190,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,191,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,192,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,193,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,194,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,195,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,200,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,201,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,202,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,203,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,204,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,205,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,206,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,207,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,208,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,209,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,210,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,211,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,212,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,213,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,214,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,215,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,216,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,217,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,218,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,219,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,220,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,221,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,222,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,223,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,224,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,225,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,226,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,227,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,228,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,229,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,230,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,231,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,232,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,233,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,234,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,235,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,236,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,237,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,238,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,239,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,240,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,241,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,242,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,243,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,244,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,245,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,246,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,247,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,248,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,249,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,250,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,251,'MK2ORD',''); insert into en1 values (0,'POOLE',1,1,3,252,'MK2ORD',''); update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 10 and 20 AND CPSTPN=1 AND CONCNO=3; update en1 set synthetic=lpad(to_char(clustr),2,0)||siteid||lpad(to_char(abbrnac),2,0)||lpad(to_char(lctype),8,0)||lpad(to_char(cpstpn),2,0) where enum between 70 and 80 AND CPSTPN=1 AND CONCNO=3; ***************************************************************************************************************************************************************************************************** SYNTHETIC COLUMN INFORMATION -------------------------------- CHARCTERS COLUMN_NAME ADDITIONAL_NFORMATION 1-2 CLUSTR RIGHT PADDED WITH ZERO 3-7 SITEID 8-9 ABBRNAC RIGHT PADDED WITH ZERO 10-16 LCTYPE RIGHT PADDED WITH ZERO 17-18 CPSTPN RIGHT PADDED WITH ZERO eX: 00POOLE010MK3STSP00 fOR inFORMATION CLUSTER 0 HAS TWO CPSTPN SQL> SELECT DISTINCT(CLUSTR),CPSTPN FROM EN1 WHERE SYNTHETICORDER BY CLUSTR ASC; CLUSTR CPSTPN ---------- ---------- 0 0 0 1 CPSTPN 0 HAS THREE CONCNO CONCNO CPSTPN 1 HAS TEO CONCNO SQL> SELECT DISTINCT(CPSTPN),CONCNO FROM EN1 ORDER BY CPSTPN ASC; CPSTPN CONCNO ---------- ---------- 0 0 0 1 0 2 1 1 1 3 *********************************************** JOB Stament: Allocate 24 ENUM's to CUST_TYPE MULTI across the LCT's on a single concno or combination of concno under a single cpstpn with enum's picked in the order of lctype specified below CUST_TYPE CHOICE1 CHOICE2 CHOICE3 ---------------------------------- MULTI MK3STSP MK3MCI MK2ORD NOTE: CONSIDER M3STSP AND MK3MCI AS COMBO ALWAYS WHILE FORMING THE LCT AND REST AS INDEPENDENT LCT DEFINITION: BLOCK OF 64 ENUM HAVING THE SAME LCTYPE (EXCEPT MK3STSP AND MKMCI LCTYPES WHICH ARE PRESENT IN COMBO) sOLUTION: STEP 1 : PICKUP ALL THE CHOICES SUPPORTED FOR THE CUST_TYPE AND FIND CPSTPN,CONCNO SUCH THAT FREE COUNT IN ANY SINGLE CONCNO IS GREATER THAN OR EQUAL TO THE NUMBER OF ENUMS TO BE ALLOCATED SQL> SELECT CONCNO,COUNT(CONCNO) FROM EN1 WHERE (SYNTHETIC LIKE '00POOLE010MK3STSP%' OR SYNTHETIC LIKE '00POOLE0100MK3MCI%' OR SYNTH ETIC LIKE '00POOLE0100MK2ORD%' ) AND CPSTPN=0 GROUP BY CONCNO HAVING COUNT(CONCNO) >=24 ORDER BY COUNT(CONCNO) ASC; CONCNO COUNT(CONCNO) ---------- ------------- 1 63 2 64 0 92 SQL> SELECT CONCNO,COUNT(CONCNO) FROM EN1 WHERE (SYNTHETIC LIKE '00POOLE010MK3STSP%' OR SYNTHETIC LIKE '00POOLE0100MK3MCI%' OR SYNTH ETIC LIKE '00POOLE0100MK2ORD%' ) AND CPSTPN=1 GROUP BY CONCNO HAVING COUNT(CONCNO) >=24 ORDER BY COUNT(CONCNO) ASC; CONCNO COUNT(CONCNO) ---------- ------------- 1 64 ACTUAL oUTPUT REQUIRED IS: CPSTPN CONCNO COUNT(CONCNO) ------------------------------ 0 1 63 1 1 64 0 2 64 0 0 92 CPSTPN=0 AND CONCNO=1 **************************** STEP2: FIND THE 24 ENUMS KEEPING CPSTPN=0 AND CONCNO=1 ACROSS THE LCT'S 1) pICK THE CHOICE1(MKSTSP) AS MKSTSP AND MK3MCI WILL BE PRESENT IN COMBO SO CONSIDER MK3MCI AS WELL AND FIND THE TOTAL NOF OF RECORDS AND SPLIT IT IN TO PARTS(LCT'S HAVING 64 ROWS) SELECT COUNT(*) FROM EN1 WHERE CPSTPN=0 AND CONCNO=1 AND (LCTYPE='MK3STSP' OR LCTYPE='MK3MCI'); SQL> SELECT COUNT(*) FROM EN1 WHERE CPSTPN=0 AND CONCNO=1 AND (LCTYPE='MK3STSP' OR LCTYPE='MK3MCI'); COUNT(*) ---------- 186 NO OF LCT= 186/64=2.90 ROUNDING OFF ALWAYS TO THE NEXT HIGHER VALUE NO OF LCT=3 SUCH THAT LCT COUNT(ROWS) ------------------ 1 64 2 64 3 58 OUTPUT REQUIRED: SQL> SELECT CPSTPN,CONCNO,ENUM,SYNTHETIC FROM EN1 WHERE CPSTPN=0 AND CONCNO=1 AND (LCTYPE='MK3STSP' OR LCTYPE='MK3MCI') ORDER BY EN UM ASC; NOTE: REQUIRE LCT(IMAGINARY COLUMN) WITH OUTPUT AS BELOW CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- 0 1 0 1 0 1 1 1 0 1 2 1 0 1 3 1 0 1 4 1 0 1 5 1 0 1 6 1 0 1 7 1 0 1 8 1 0 1 9 1 0 1 10 00POOLE010MK3STSP00 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 11 00POOLE010MK3STSP00 1 0 1 12 00POOLE010MK3STSP00 1 0 1 13 00POOLE010MK3STSP00 1 0 1 14 00POOLE010MK3STSP00 1 0 1 15 00POOLE010MK3STSP00 1 0 1 16 00POOLE0100MK3MCI00 1 0 1 17 00POOLE010MK3STSP00 1 0 1 18 00POOLE010MK3STSP00 1 0 1 19 00POOLE010MK3STSP00 1 0 1 20 00POOLE010MK3STSP00 1 0 1 21 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 22 1 0 1 23 1 0 1 24 1 0 1 25 1 0 1 26 1 0 1 27 1 0 1 28 1 0 1 29 1 0 1 30 1 0 1 31 1 0 1 32 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 33 1 0 1 34 1 0 1 35 1 0 1 36 1 0 1 37 1 0 1 38 1 0 1 39 1 0 1 40 1 0 1 41 1 0 1 42 1 0 1 43 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 44 1 0 1 45 1 0 1 46 1 0 1 47 1 0 1 48 1 0 1 49 1 0 1 50 1 0 1 51 1 0 1 52 1 0 1 53 1 0 1 54 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 55 1 0 1 56 1 0 1 57 1 0 1 58 1 0 1 59 1 0 1 60 1 0 1 61 1 0 1 62 1 0 1 63 1 0 1 64 2 0 1 65 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 66 2 0 1 67 2 0 1 68 2 0 1 69 2 0 1 70 00POOLE010MK3STSP00 2 0 1 71 00POOLE010MK3STSP00 2 0 1 72 00POOLE010MK3STSP00 2 0 1 73 00POOLE010MK3STSP00 2 0 1 74 00POOLE010MK3STSP00 2 0 1 75 00POOLE010MK3STSP00 2 0 1 76 00POOLE010MK3STSP00 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 77 00POOLE010MK3STSP00 2 0 1 78 00POOLE010MK3STSP00 2 0 1 79 00POOLE010MK3STSP00 2 0 1 80 00POOLE0100MK3MCI00 2 0 1 81 2 0 1 82 2 0 1 83 2 0 1 84 2 0 1 85 2 0 1 86 2 0 1 87 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 88 2 0 1 89 2 0 1 90 2 0 1 91 2 0 1 92 2 0 1 93 2 0 1 94 2 0 1 95 2 0 1 96 2 0 1 97 2 0 1 98 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 99 2 0 1 100 2 0 1 101 2 0 1 102 2 0 1 103 2 0 1 104 2 0 1 105 2 0 1 106 2 0 1 107 2 0 1 108 2 0 1 109 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 110 2 0 1 111 2 0 1 112 2 0 1 113 2 0 1 114 2 0 1 115 2 0 1 116 2 0 1 117 2 0 1 118 2 0 1 119 2 0 1 120 2 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 121 2 0 1 122 2 0 1 123 2 0 1 124 2 0 1 125 2 0 1 126 2 0 1 127 2 0 1 128 3 0 1 129 3 0 1 130 3 0 1 131 3 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 132 3 0 1 133 3 0 1 134 3 0 1 135 3 0 1 136 3 0 1 137 3 0 1 138 3 0 1 139 3 0 1 140 3 0 1 141 3 0 1 142 3 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 143 3 0 1 144 3 0 1 145 3 0 1 146 3 0 1 147 3 0 1 148 3 0 1 149 3 0 1 150 3 0 1 151 3 0 1 152 3 0 1 153 3 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 154 3 0 1 155 3 0 1 156 3 0 1 157 3 0 1 158 3 0 1 159 3 0 1 160 3 0 1 161 3 0 1 162 3 0 1 163 3 0 1 164 3 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 165 3 0 1 166 3 0 1 167 3 0 1 168 3 0 1 169 3 0 1 170 3 0 1 171 3 0 1 172 3 0 1 173 3 0 1 173 3 0 1 174 3 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 175 3 0 1 176 3 0 1 177 3 0 1 178 3 0 1 179 3 0 1 180 3 0 1 181 3 0 1 182 3 0 1 183 3 0 1 184 3 186 rows selected. 2)Now Pick the Next Choice(MK2ORD) and Do the Same SQL> SELECT COUNT(*) FROM EN1 WHERE CPSTPN=0 AND CONCNO=1 AND LCTYPE='MK2ORD'; COUNT(*) ---------- 63 NO OF LCT=63/64=0.9 ROUNDING OFF ALWAYS TO NEXT HIGHER VALUE NO OF LCT=1 SQL> SELECT CPSTPN,CONCNO,ENUM,SYNTHETIC FROM EN1 WHERE CPSTPN=0 AND CONCNO=1 AND LCTYPE='MK2ORD' ORDER BY ENUM ASC; CPSTPN CONCNO ENUM SYNTHETIC LCT ---------- ---------- ---------- -------------------------- 0 1 185 1 0 1 186 1 0 1 187 1 0 1 188 1 0 1 189 1 0 1 190 1 0 1 191 1 0 1 192 1 0 1 193 1 0 1 194 1 0 1 195 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 200 00POOLE0100MK2ORD00 1 0 1 201 00POOLE0100MK2ORD00 1 0 1 202 00POOLE0100MK2ORD00 1 0 1 203 00POOLE0100MK2ORD00 1 0 1 204 00POOLE0100MK2ORD00 1 0 1 205 00POOLE0100MK2ORD00 1 0 1 206 00POOLE0100MK2ORD00 1 0 1 207 00POOLE0100MK2ORD00 1 0 1 208 00POOLE0100MK2ORD00 1 0 1 209 00POOLE0100MK2ORD00 1 0 1 210 00POOLE0100MK2ORD00 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 211 00POOLE0100MK2ORD00 1 0 1 212 00POOLE0100MK2ORD00 1 0 1 213 00POOLE0100MK2ORD00 1 0 1 214 00POOLE0100MK2ORD00 1 0 1 215 00POOLE0100MK2ORD00 1 0 1 216 00POOLE0100MK2ORD00 1 0 1 217 00POOLE0100MK2ORD00 1 0 1 218 00POOLE0100MK2ORD00 1 0 1 219 00POOLE0100MK2ORD00 1 0 1 220 00POOLE0100MK2ORD00 1 0 1 221 00POOLE0100MK2ORD00 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 222 00POOLE0100MK2ORD00 1 0 1 223 00POOLE0100MK2ORD00 1 0 1 224 00POOLE0100MK2ORD00 1 0 1 225 00POOLE0100MK2ORD00 1 0 1 226 00POOLE0100MK2ORD00 1 0 1 227 00POOLE0100MK2ORD00 1 0 1 228 00POOLE0100MK2ORD00 1 0 1 229 00POOLE0100MK2ORD00 1 0 1 230 00POOLE0100MK2ORD00 1 0 1 231 00POOLE0100MK2ORD00 1 0 1 232 00POOLE0100MK2ORD00 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 233 00POOLE0100MK2ORD00 1 0 1 234 00POOLE0100MK2ORD00 1 0 1 235 00POOLE0100MK2ORD00 1 0 1 236 00POOLE0100MK2ORD00 1 0 1 237 00POOLE0100MK2ORD00 1 0 1 238 00POOLE0100MK2ORD00 1 0 1 239 00POOLE0100MK2ORD00 1 0 1 240 00POOLE0100MK2ORD00 1 0 1 241 1 0 1 242 1 0 1 243 1 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 244 1 0 1 245 1 0 1 246 1 0 1 247 1 0 1 248 1 0 1 249 1 0 1 250 1 0 1 251 1 63 rows selected. 3)FINAL OUTPUT RERQUIRED(DISTRIBUTING THE 24 EQUIPMENTS) PICK THE FREE EQUIPMENT FROM LCT 1 OF CHOICE 1 PICK THE FREE EQUIPMENT FROM LCT 2 OF CHOICE 2 PICK THE FREE EQUIPMENT FROM LCT 3 OF CHOICE 3 NOTE: IF THERE ARE NO FREE EQUIPMENTS IN THE LCT SKIP AND GO TO THE IMMEDIATE NEXT IN THE ROUND ROBIN FASHION FOLLOW THE SAME UNTIL ALL THE FREE EQUIPMENTS ARE FILLED IN CHOICE 1 THEN GO TO THE 2 CHOICE AND DO THE SAME CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- ---------------------- 0 1 10 00POOLE010MK3STSP00 0 1 70 00POOLE010MK3STSP00 0 1 11 00POOLE010MK3STSP00 0 1 71 00POOLE010MK3STSP00 0 1 12 00POOLE010MK3STSP00 0 1 72 00POOLE010MK3STSP00 0 1 13 00POOLE010MK3STSP00 0 1 73 00POOLE010MK3STSP00 0 1 14 00POOLE010MK3STSP00 0 1 74 00POOLE0100MK3MCI00 0 1 15 00POOLE010MK3STSP00 0 1 75 00POOLE010MK3STSP00 0 1 16 00POOLE010MK3STSP00 0 1 76 00POOLE010MK3STSP00 0 1 17 00POOLE010MK3STSP00 0 1 77 00POOLE010MK3STSP00 0 1 18 00POOLE010MK3STSP00 0 1 78 00POOLE010MK3STSP00 0 1 19 00POOLE010MK3STSP00 0 1 79 00POOLE010MK3STSP00 0 1 20 00POOLE010MK3STSP00 0 1 80 00POOLE010MK3STSP00 0 1 200 00POOLE0100MK2ORD00 0 1 201 00POOLE0100MK2ORD00 0 1 202 00POOLE0100MK2ORD00 0 1 203 00POOLE0100MK2ORD00 0 1 204 00POOLE0100MK2ORD00 0 1 205 00POOLE0100MK2ORD00 0 1 206 00POOLE0100MK2ORD00 0 1 207 00POOLE0100MK2ORD00 0 1 208 00POOLE0100MK2ORD00 0 1 209 00POOLE0100MK2ORD00 0 1 210 00POOLE0100MK2ORD00 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 211 00POOLE0100MK2ORD00 0 1 212 00POOLE0100MK2ORD00 0 1 213 00POOLE0100MK2ORD00 0 1 214 00POOLE0100MK2ORD00 0 1 215 00POOLE0100MK2ORD00 0 1 216 00POOLE0100MK2ORD00 0 1 217 00POOLE0100MK2ORD00 0 1 218 00POOLE0100MK2ORD00 0 1 219 00POOLE0100MK2ORD00 0 1 220 00POOLE0100MK2ORD00 0 1 221 00POOLE0100MK2ORD00 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 222 00POOLE0100MK2ORD00 0 1 223 00POOLE0100MK2ORD00 0 1 224 00POOLE0100MK2ORD00 0 1 225 00POOLE0100MK2ORD00 0 1 226 00POOLE0100MK2ORD00 0 1 227 00POOLE0100MK2ORD00 0 1 228 00POOLE0100MK2ORD00 0 1 229 00POOLE0100MK2ORD00 0 1 230 00POOLE0100MK2ORD00 0 1 231 00POOLE0100MK2ORD00 0 1 232 00POOLE0100MK2ORD00 CPSTPN CONCNO ENUM SYNTHETIC ---------- ---------- ---------- -------------------------- 0 1 233 00POOLE0100MK2ORD00 0 1 234 00POOLE0100MK2ORD00 0 1 235 00POOLE0100MK2ORD00 0 1 236 00POOLE0100MK2ORD00 0 1 237 00POOLE0100MK2ORD00 0 1 238 00POOLE0100MK2ORD00 0 1 239 00POOLE0100MK2ORD00 0 1 240 00POOLE0100MK2ORD00 ALLOCTE THE FIRST 24 ENUM FOR THE CUST_TYPE MULTI AM LOOKING FOR THIS FINAL QUERY PLEASE LET ME KNOW IF ANY MORE INFORMATION REQURED THANKS IN ADVANCE FOR THE HELP