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 -------------------------------------------------- A000031400 u011522 A000000241 Amy Gibbons D 15-SEP-74 F 61 1 N A000034000 u014388 A000000241 Amy Waterman S 12-OCT-77 F 61 1 Y A000049701 A000000241 AMY KLETZING M 19-NOV-73 F 2 2 Y A000146701 A000000241 AMY CLOYD C 22-JUN-76 F 2 2 Y A000127300 u010239 A000000241 Amy Baumgardner L 15-AUG-68 F 2 1 N A000131601 A000000241 Amy McCall Y 09-DEC-75 F 2 2 Y A000192701 A000000241 Amy Lowe E 23-OCT-72 F 2 2 Y A000195001 A000000241 AMY MEACOCK E 18-JUN-64 F 2 2 Y A000171600 u013493 A000000241 Amy Rivetts J 15-JUN-74 F 61 1 Y A000233901 A000000241 AMY BAILEY 21-OCT-70 F 2 2 Y A000280201 A000000241 AMY COLLINS L 11-OCT-75 F 2 2 Y A000319900 u00ayh1 A000000241 Amy Hook Y 17-DEC-74 F 2 1 Y A000323001 A000000241 AMY LEVI D 09-SEP-69 F 2 2 N A000369801 A000000241 AMY HORN A 18-FEB-76 F 2 2 Y A000379300 u00axn7 A000000241 Amy Norbot E 23-SEP-81 F 2 1 Y A000379500 yyyamk6 A000000241 Amy Baugh M 22-FEB-75 F 62 1 Y A000362201 0130551-amyjust A000000241 AMY JUST D 21-JAN-68 F 2 2 Y A000397901 A000000241 AMY KALLAHER M 10-DEC-76 F 2 2 Y A000429801 A000000241 AMY HARLOW R 27-OCT-65 F 2 2 Y A000461801 A000000241 AMY SPENCER L 10-JUL-67 F 2 2 Y A000462601 A000000241 AMY WILCOXEN M 13-APR-69 F 2 2 N A000463501 0120538-klinkap A000000241 AMY KLINKER L 05-APR-72 F 2 2 Y A000474901 A000000241 AMY LLOYD D 25-APR-69 F 2 2 N A000446600 u00ajf3 A000000241 Amy Farler J 28-NOV-72 F 2 1 Y A000448100 u013447 A000000241 Amy Rhine B 09-JUL-68 F 2 1 Y A000496701 A000000241 AMY PAWELKO J 18-JUN-67 F 2 2 Y A000566200 u00asc3 A000000241 Amy Collins S 06-AUG-75 F 2 1 Y A000542401 A000000241 Amy Rash R 11-NOV-72 F 2 2 Y A000603901 0170946-trace1 A000000241 Amy Maurer J 30-OCT-59 F 2 2 Y A000630201 A000000241 AMY WILLIAMS E 28-JUL-73 F 2 2 Y A000631701 A000000241 Amy Means L 13-MAY-68 F 2 2 Y A000667001 A000000241 AMY QUIRK L 22-OCT-70 F 2 2 Y A000667701 A000000241 AMY CONNERTY D 03-AUG-74 F 2 2 Y A000687901 0167356-nunnhamilton A000000241 AMY HAMILTON E 07-APR-79 F 2 2 Y A000638301 A000000241 AMY MALDENEY J 07-APR-60 F 2 2 Y A000638500 u00ajb8 A000000241 Amy Balsinger J 17-APR-72 F 61 1 Y A000640001 A000000241 Amy Troyer L 17-AUG-66 F 2 2 Y A000641900 u00abk2 A000000241 Amy Koller B 09-JUL-77 F 2 1 Y A000654901 A000000241 AMY TOWNSEND J 09-OCT-65 F 2 2 Y A000722400 u00axrp A000000241 Amy Rutkowski E 29-MAR-77 F 61 1 Y A000761201 A000000241 AMY COX D 02-MAY-79 F 2 2 N A000973800 u013830 A000000241 Amy Slaten A 05-APR-57 F 2 1 Y A000952601 0101410-amyboisselle A000000241 Amy Boisselle M 31-MAY-74 F 2 2 Y A000952900 u00amh5 A000000241 Amy Hartzell M 11-JUL-72 F 2 1 Y A000749700 u019777 A000000241 Amy Davis J 24-APR-77 F 2 1 Y A001109900 u021443 A000000241 Amy Compton M 13-AUG-76 F 61 1 Y A000856100 u00amm3 A000000241 Amy Morel M 07-JUL-81 F 2 1 Y A000860101 A000000241 AMY WILCOX B 27-OCT-77 F 2 2 Y A001115701 A000000241 Amy Curtin 12-AUG-70 F 2 2 Y A001118301 0172939-aosullivan37 A000000241 Amy Ober M 16-JUL-75 F 2 2 Y A000865601 A000000241 AMY MUNDEN E 10-JAN-76 F 2 2 Y A001103401 A000000241 Ramya Adam Reddy 29-JAN-84 F 2 2 Y A000872900 u00azm6 A000000241 Amy McCaskill M 07-AUG-73 F 61 1 Y A000777201 0120723-amystanton A000000241 AMY STANTON M 10-MAY-69 F 2 2 Y A000891701 0170349-amychurchill A000000241 Amy Churchill M 04-DEC-84 F 2 2 Y A000911300 u00alu1 A000000241 Amy Ullmann L 16-SEP-82 F 61 1 Y A000808701 A000000241 AMY YOUNG S 15-SEP-75 F 2 2 Y A000811401 0165261-apracko A000000241 AMY PRACKO M 13-DEC-72 F 2 2 Y A000813501 A000000241 Amy Luehring L 13-MAR-75 F 2 2 Y A000825600 u00arm2 A000000241 Amy Nicholson R 23-JAN-73 F 2 1 Y A001157700 u022487 A000000241 Amy Halliday L 30-OCT-77 F 2 1 Y A000946800 u00alp1 A000000241 Amy Presley L 04-JUN-88 F 61 1 Y A000854200 u00amf9 A000000241 Amy Freeman M 19-DEC-75 F 2 1 Y A000719701 A000000241 AMY KERFOOT M 30-MAY-64 F 2 2 N A000481901 0104287-ajhartman A000000241 AMY HARTMAN J 12-SEP-63 F 2 2 Y A000497101 A000000241 AMY SAMOSKY R 13-MAY-75 F 2 2 N A000627201 A000000241 Amy Lewis L 07-APR-76 F 2 2 Y A001004401 A000000241 AMY OSBORNE E 05-FEB-81 F 2 2 Y A001028901 0168568 -amyminnick A000000241 Amy Jun L 26-MAY-70 F 2 2 Y A001042800 u00arm5 A000000241 Amy Terry R 25-JUL-65 F 2 1 Y A001051000 u00axvc A000000241 Amy Vittatoe L 23-AUG-70 F 62 1 Y A001079200 u00w419 A000000241 Amy Tomlinson L 04-JUN-73 F 2 1 Y A000623301 A000000241 Amy Estep 03-MAR-71 F 2 2 Y A001106101 A000000241 Amy Degnan L 11-OCT-71 F 2 2 Y A000911401 A000000241 AMY SPICER R 22-MAY-75 F 2 2 Y A000981800 u011571 A000000241 Amy Goode L 23-NOV-69 F 2 1 Y A001125001 A000000241 Amy Weber B 19-APR-80 F 2 2 N 77 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 -------------------------------------------------- A000031400 u011522 A000000241 Amy Gibbons D 15-SEP-74 F 61 1 N A000288200 yyyslg9 A000000241 Shayne Gibbons L 19-JUL-71 M 2 1 Y A000288201 0105511-nangibbons A000000241 NANETTE GIBBONS K 23-DEC-74 F 2 2 Y 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 -------------------------------------------------- A000031400 u011522 A000000241 Amy Gibbons D 15-SEP-74 F 61 1 N 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 -------------------------------------------------- 4634 A000031400 Amy.Gibbons@Navistar.com Y Y Y A000031400 u011522 A000000241 Amy Gibbons D 15-SEP-74 F 61 1 N WNP@HWPROD1> spool off