WNP@HWPROD1> show user USER is "WNP" WNP@HWPROD1> sta database-select.txt WNP_ID EMPLOYEE_NETWORK_ID COMPANY_ID ---------- ---------------------------------------- ---------- MEMBER_FIRST_NAME MEMBER_LAST_NAME ------------------------------ ------------------------------ MIDDLE_INITIAL DATE_OF_B DATE_OF_DEATH G MARITAL_STATUS_ID -------------------- --------- ------------------ - ----------------- RELATIONSHIP_ID ETHINICITY_ID EDUCATION_ID LANGUAGE_ID PASSWORD I --------------- ------------- ------------ ----------- -------------------- - NSH -------------------------------------------------- A000072701 A000000241 Rogers Tucker 26-OCT-63 M 2 2 Y A000075200 u012834 A000000241 Roger Miller W 11-OCT-62 M 61 1 Y A000027400 u011320 A000000241 Roger Fent Jr L 03-FEB-70 M 61 1 Y A000041700 u010258 A000000241 Roger Beaver D 05-SEP-55 M 2 1 Y A000042800 u012889 A000000241 Roger Moore L 10-MAY-69 M 2 1 Y A000181601 A000000241 ROGER LORD D 16-AUG-54 M 2 2 Y A000300800 u00rib2 A000000241 Roger Bourne I 19-APR-59 M 2 1 Y A000342500 u00r675 A000000241 Roger Spice 15-SEP-47 M 61 1 Y A000488700 u00rxk5 A000000241 Roger Kenitz C 30-DEC-57 M 62 1 Y A000493101 A000000241 ROGER BAEUMLER W 23-OCT-63 M 2 2 Y A000522700 u00rxd8 A000000241 Roger Dunn S 08-APR-51 M 2 1 N A000523000 u011191 A000000241 Roger Eaton E 03-AUG-58 M 2 1 Y A000590400 u00rwm5 A000000241 Roger Miller W 19-JUL-66 M 62 1 Y A000622300 u00rssd A000000241 Roger Shaffer S 17-MAR-59 M 2 1 N A000600700 u018892 A000000241 Roger Kauffman L 03-OCT-59 M 61 1 Y A000663901 0168517-rogerebyers A000000241 ROGER BYERS E 24-FEB-57 M 2 2 Y A000723901 A000000241 Roger McNeil 29-FEB-48 M 2 2 Y A000953600 u00rwbk A000000241 Roger Baeumler W 23-OCT-63 M 2 1 Y A000957700 u010887 A000000241 Roger Cowan D 01-SEP-70 M 61 1 Y A000964500 u00rds4 A000000241 Roger Sherrill D 08-SEP-60 M 2 1 Y A000752400 u00rdt1 A000000241 Roger Tyree D 04-JUN-58 M 2 1 Y A001102700 u022068 A000000241 Roger Rocha 19-FEB-81 M 2 1 Y A000770500 u00res3 A000000241 Roger Stumpf E 09-MAY-48 M 2 1 Y A000806500 u012285 A000000241 Roger Kelly W 10-SEP-51 M 2 1 Y A000923801 0105665-rguinn61 A000000241 ROGER GUINN L 27-JAN-49 M 2 2 Y A000926400 u012342 A000000241 Roger Klinger L 05-MAR-53 M 2 1 Y A000928500 u011125 A000000241 Roger Dozler 16-OCT-65 M 61 1 Y A000840200 u00rjh9 A000000241 Roger Hildreth J 14-OCT-60 M 2 1 Y A000852300 yzyrlr1 A000000241 Roger Rush L 18-MAY-60 M 2 1 Y A001014000 u00rdh1 A000000241 Roger Hale D 16-MAR-54 M 61 1 Y 30 rows selected. WNP_ID EMPLOYEE_NETWORK_ID COMPANY_ID ---------- ---------------------------------------- ---------- MEMBER_FIRST_NAME MEMBER_LAST_NAME ------------------------------ ------------------------------ MIDDLE_INITIAL DATE_OF_B DATE_OF_DEATH G MARITAL_STATUS_ID -------------------- --------- ------------------ - ----------------- RELATIONSHIP_ID ETHINICITY_ID EDUCATION_ID LANGUAGE_ID PASSWORD I --------------- ------------- ------------ ----------- -------------------- - NSH -------------------------------------------------- A000075200 u012834 A000000241 Roger Miller W 11-OCT-62 M 61 1 Y A000098100 u010368 A000000241 Ray Bodenmiller T 29-NOV-53 M 62 1 Y A000024000 u010080 A000000241 Lewis Altemiller D 07-JAN-66 M 2 1 N A000026500 u010095 A000000241 Judy Miller L 12-DEC-59 F 2 1 Y A000033200 u018819 A000000241 James Miller R 30-AUG-53 M 61 1 Y A000037900 u012836 A000000241 Roy Miller R 17-APR-49 M 2 1 Y A000037901 A000000241 NANCY MILLER C 12-APR-47 F 2 2 Y A000041500 u012818 A000000241 Dana Miller M 30-SEP-57 M 61 1 Y A000120400 u012830 A000000241 Lurand Miller A 09-OCT-61 M 61 1 Y A000121500 u00jpmc A000000241 John Miller P 06-SEP-57 M 61 1 Y A000121501 A000000241 JoAnn Miller 05-AUG-59 F 2 2 Y A000140900 u012832 A000000241 Robert Miller D 15-MAR-83 M 61 1 Y A000137000 u012814 A000000241 Bart Miller E 21-JUN-61 M 2 1 Y A000139500 u00jsm3 A000000241 Joseph Miller S 09-JAN-70 M 61 1 Y A000139501 A000000241 RAMONA MILLER 09-DEC-69 F 2 2 Y A000109800 u012817 A000000241 Dale Miller H 18-OCT-70 M 2 1 Y A000186200 u012837 A000000241 Travis Miller W 27-JUN-71 M 61 1 Y A000186201 A000000241 JENNIFER MILLER 23-FEB-72 F 61 2 Y A000219900 u020713 A000000241 Eric Miller S 26-APR-60 M 61 1 Y A000248700 u020967 A000000241 Harley Miller J 08-JUL-57 M 2 1 Y A000276600 u00jamg A000000241 Jennifer Miller A 22-JAN-73 F 61 1 Y A000285500 u00rcm5 A000000241 Robert Miller C 13-NOV-68 M 2 1 Y A000285501 0166416-heidimiller A000000241 HEIDI MILLER L 18-DEC-67 F 2 2 Y A000264500 u014805 A000000241 Gregory Miller D 21-APR-69 M 64 1 Y A000264501 A000000241 Brenda Miller J 13-OCT-70 F 2 2 Y A000268500 u00jama A000000241 James Miller A 27-APR-54 M 62 1 Y A000334700 u00cxmr A000000241 Carol Miller A 31-AUG-63 F 61 1 Y A000331200 u00emm1 A000000241 Elwyn Miller M 11-DEC-58 M 2 1 Y A000331201 A000000241 CHRISTINE MILLER M 11-SEP-62 F 2 2 Y A000378200 u00mjmq A000000241 Michael Miller J 16-FEB-68 M 61 1 Y A000380300 u00ladc A000000241 Lynn Miller A 31-OCT-68 F 2 1 Y A000385400 u00plm2 A000000241 Patrick Miller L 06-SEP-53 M 2 1 Y A000385401 A000000241 PEGGY MILLER S 04-JUL-56 F 2 2 Y A000350700 u018936 A000000241 Danny Miller L 27-APR-57 M 61 1 Y A000357100 u00lxm2 A000000241 Lawrence Miller E 28-JAN-61 M 2 1 Y A000357101 0162417-Pam65478 A000000241 PAMELA MILLER A 07-JUL-62 F 2 2 Y A000412200 u00memb A000000241 Maylene Miller E 29-SEP-63 F 61 1 Y A000412201 A000000241 SCOTT MILLER L 28-JUL-62 M 2 2 Y A000421800 u012813 A000000241 William Miller Jr E 22-MAY-51 M 2 1 Y A000421801 A000000241 LUCY MILLER D 19-JUL-52 F 2 2 Y A000424700 u00dmm8 A000000241 Dennis Miller M 15-MAY-46 M 62 1 Y A000464900 u00mrmf A000000241 Michael Miller R 17-OCT-48 M 2 1 Y A000464901 A000000241 DEBORAH MILLER K 24-OCT-51 F 2 2 Y A000484500 u00jrmt A000000241 Johnny Miller R 25-JAN-44 M 2 1 N A000484501 A000000241 RHONDA MILLER L 06-JAN-45 F 2 2 N A000440600 u00jsmc A000000241 Jon Miller S 12-JUN-53 M 61 1 Y A000440601 A000000241 BETH MILLER A 11-MAR-54 F 2 2 Y A000451200 yyyrjmg A000000241 Randal Miller J 24-SEP-59 M 2 1 Y A000451201 0102066-dudakmiller A000000241 LORRAINE MILLER K 23-AUG-56 F 2 2 Y A000504100 u012821 A000000241 Derwin Miller K 13-FEB-52 M 62 1 Y A000526100 yyyrel3 A000000241 Ruth Miller E 04-OCT-57 F 61 1 Y A000526101 A000000241 LEWIS MILLER JR. M 18-APR-57 M 2 2 N A000532300 u00bam1 A000000241 Benjamin Miller A 18-JUL-43 M 2 1 N A000532301 A000000241 SAUNDRA MILLER L 12-MAY-46 F 2 2 N A000512000 u00sxm3 A000000241 Steven Miller P 28-JAN-71 M 2 1 N A000512001 A000000241 Angela Miller N 09-JAN-74 F 2 2 N A000560500 u012820 A000000241 David Miller F 10-FEB-57 M 2 1 Y A000579100 u00djm1 A000000241 Donna Miller J 08-JUL-57 F 2 1 Y A000541600 u00mdmd A000000241 Michael Miller D 17-FEB-49 M 2 1 N A000541601 A000000241 DINAH MILLER L 01-APR-53 F 2 2 N A000590400 u00rwm5 A000000241 Roger Miller W 19-JUL-66 M 62 1 Y A000590401 A000000241 THERESA MILLER D 13-OCT-69 F 61 2 Y A000605100 u00w580 A000000241 Gregory Miller C 08-DEC-63 M 2 1 Y A000610600 u00m182 A000000241 Lorna Miller S 11-AUG-72 F 2 1 Y A000610601 A000000241 Michael Miller D 25-NOV-65 M 2 2 Y A000619200 u012819 A000000241 David Miller A 09-DEC-46 M 2 1 Y A000619201 A000000241 JANICE MILLER E 13-DEC-48 F 2 2 Y A000600600 u018728 A000000241 Anthony Miller J 30-NOV-62 M 2 1 Y A000659700 u00rmmg A000000241 Rodger Miller M 01-MAY-50 M 61 1 Y A000649800 u00s649 A000000241 Paul Miller E 04-JAN-47 M 2 1 N A000649801 A000000241 DELORES MILLER A 13-APR-41 F 2 2 N A000693300 u00sem6 A000000241 Stanton Miller E 08-SEP-54 M 2 1 Y A000724900 u021106 A000000241 David Miller L 03-JAN-74 M 61 1 Y A000969301 A000000241 PATRICIA MILLER A 22-JUL-68 F 2 2 Y A000971100 u019707 A000000241 Angelia Miller M 30-SEP-69 F 2 1 Y A000969300 u012826 A000000241 Jeffrey Miller L 22-JAN-66 M 2 1 Y A000738100 u00msmd A000000241 Michael Miller S 26-JUL-51 M 2 1 Y A000743200 u021076 A000000241 Brandon Miller L 23-NOV-84 M 2 1 Y A000743201 0172650-alilmil712 A000000241 Alissa Miller L 12-OCT-87 F 2 2 Y A000748300 u00dam9 A000000241 David Miller A 28-APR-62 M 2 1 Y A001145900 u022205 A000000241 Gregory Miller A 27-JUN-68 M 61 1 N A000868400 u00sxm2 A000000241 Seth Miller F 13-AUG-76 M 62 1 Y A000769900 u00pam3 A000000241 Patricia Miller M 03-NOV-52 F 62 1 Y A000878400 u012828 A000000241 Linda Miller M 15-JUL-49 F 2 1 Y A001174300 u023033 A000000241 Michael Miller H 25-MAR-60 M 2 1 Y A000892800 u00smme A000000241 Steven Miller M 09-JAN-80 M 2 1 Y A000892801 0155207-andrea_dawn_miller A000000241 ANDREA MILLER D 02-AUG-81 F 2 2 Y A000906600 u00mcmg A000000241 Megan Miller C 02-MAY-86 F 61 1 Y A000911200 u00m894 A000000241 Douglas Miller E 04-NOV-47 M 2 1 N A000911201 A000000241 EVA MILLER M 07-APR-51 F 2 2 N A000817600 u00tdm1 A000000241 Theresa Miller D 09-AUG-51 F 61 1 Y A000826800 u00jzmt A000000241 Jonathan Miller G 21-MAY-83 M 61 1 Y A000830900 u00ghm1 A000000241 Eugene Miller H 22-JUL-64 M 61 1 Y A000937700 u00whm2 A000000241 William Miller H 14-AUG-48 M 2 1 Y A000940600 u017951 A000000241 Michael Miller D 25-FEB-55 M 2 1 Y A000940601 A000000241 SUSAN MILLER M 12-DEC-54 F 2 2 Y A000946500 u00som1 A000000241 Stevie Miller O 09-DEC-45 M 2 1 Y A000946501 A000000241 DIANE MILLER L 11-FEB-52 F 2 2 Y A001184601 A000000241 Alaina Miller D 05-OCT-63 F 2 2 Y A000991600 u021326 A000000241 Jason Miller S 26-FEB-85 M 61 1 Y A000659701 A000000241 Carol Miller A 20-MAR-45 F 2 2 Y A001184100 u023018 A000000241 Dale Miller L 21-NOV-54 M 61 1 Y A001184600 u022883 A000000241 Stephen Miller P 05-MAR-67 M 2 1 Y A001033501 A000000241 MELISSA MILLER D 06-NOV-76 F 2 2 Y A001013000 u012833 A000000241 Robert Miller R 22-APR-59 M 61 1 Y A001013001 A000000241 KARLA LARSON-MILLER D 15-SEP-66 F 2 2 Y A001019400 u012838 A000000241 Victor Miller J 18-OCT-72 M 61 1 Y A001021500 u012812 A000000241 Don Miller Jr W 03-JAN-68 M 62 1 Y A001024000 u00ajm5 A000000241 Angela Miller J 19-MAR-68 F 61 1 Y A001033500 u00wsm1 A000000241 Wade Miller S 22-APR-77 M 61 1 Y A001034400 u00p531 A000000241 Douglas Miller L 02-APR-55 M 61 1 Y A001034401 A000000241 Marybeth Miller A 21-SEP-64 F 2 2 Y A001034500 u012822 A000000241 Edward Miller Q 02-SEP-71 M 61 1 Y A001062000 u00mxe5 A000000241 Malgorzata Eitenmiller A 25-FEB-72 F 2 1 Y A001062001 0167973-curt1970 A000000241 CURT EITENMILLER 24-JUL-70 M 2 2 Y A001074800 u00l103 A000000241 Bonnie Miller J 29-MAR-61 F 2 1 Y A000605101 0172732-Kathleen A000000241 Kathleen Miller M 06-SEP-65 F 2 2 Y A000977500 u012835 A000000241 Ronald Miller L 10-APR-47 M 2 1 N A000977501 A000000241 ALICE MILLER K 06-FEB-47 F 2 2 N A000984000 u00dhm7 A000000241 Duane Miller H 05-MAR-46 M 2 1 N A000984800 u00stm4 A000000241 Steven Miller T 01-MAR-69 M 2 1 Y A000984801 A000000241 KRISANDRA MILLER K 18-OCT-69 F 2 2 Y A001143400 u022163 A000000241 Richard Miller R 27-FEB-57 M 2 1 Y 123 rows selected. no rows selected EMAIL_UNIQUE_ID WNP_ID EMAIL_ADDRESS I --------------- ---------- -------------------------------------------------- - P EM WNP_ID EMPLOYEE_NETWORK_ID COMPANY_ID - -- ---------- ---------------------------------------- ---------- MEMBER_FIRST_NAME MEMBER_LAST_NAME ------------------------------ ------------------------------ MIDDLE_INITIAL DATE_OF_B DATE_OF_DEATH G MARITAL_STATUS_ID -------------------- --------- ------------------ - ----------------- RELATIONSHIP_ID ETHINICITY_ID EDUCATION_ID LANGUAGE_ID PASSWORD I --------------- ------------- ------------ ----------- -------------------- - NSH -------------------------------------------------- 10224 A000590400 Roger.Miller@PurePowerTechnologies.Com Y Y Y A000590400 u00rwm5 A000000241 Roger Miller W 19-JUL-66 M 62 1 Y WNP@HWPROD1> spool off