I know it's off topic but I cannot resist...
http://youtu.be/-4EDhdAHrOg
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, July 09, 2013 12:19 PM
To: Midrange Systems Technical Discussion
Subject: Re: Database design: Sales "position" uniquely defined and permanent; people are impermanent, changeble
Perhaps it's a male thing on my part but my first instinct is to try and see if there's a problem you're asking help for, or, if I should go female and electronically put my arm on your shoulder and say I can see how you're frustrated and I would be exasperated also.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Eric Lehti" <elehti@xxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>,
Date: 07/09/2013 12:30 PM
Subject: Database design: Sales "position" uniquely defined and
permanent; people are impermanent, changeble
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Business analyst decided, let's define sales positions with a permanent
JDE Address Book number, but 'sales people' are not to be in any master
file permanently.
Region1 inside sales position has a JDE A/B# 914
Region1 outside sales position has a JDE A/B# 928
Region1 marketing position has a JDE A/B# 939
. . . (positions for other regions positions defined next)
Employee turnover example:
Two years ago JDE#914 was "Billy Bob"
Then JDE#914 became "Joe Schmoe" for 4 months,
Then JDE#914 became "Sam Salesman" for 9 months,
And finally, JDE#914 is now "Gertrude Gerty" until she leaves.
After Billy Bob left, Billy was no longer in any Address Book master
file, because JDE#914 became Joe Schmoe.
After Joe Schmoe left, Joe is no longer in any Address Book master file,
because JDE#914 became Sam Salesman.
After Sam Salesman left, Sam is no longer in any Address Book master
file, because JDE#914 is now Gertrude Gerty.
Best database implementation ever!
No problems in this design!
midrange.com
