Re: Abbreviation List Tables Design, aka OTLT

On 18 Jan 2006 14:30:47 -0800, "dawn" <dawnwolthuis@xxxxxxxxx> wrote:

>
>Excalibur wrote:
>> Hi Dawn
>> We use this all the time for those umpteen little things that need to be
>> specified but do not need their own table.
>
>There's the rub. What do you mean by "do not need their own table".
>By what criteria do you decide that something needs its own table?

Aye, matey, there's another rub.

Because I never know what's going to happen some time into the future
(that, I am assured, comes from being "male" <g>), I always make
specific files for all these "reference" files, as opposed to new
items in an overall "reference" file, just in case we *might* need to
store/retrieve statistical data on the referenced items......

The "description" applicable to the reference code used is Field or
Attribute<1> and we can then, if necessary, whenever necessary, add
additional fields for related statistical data.....or we're left with
a "reference file" that has a few items with descritions.... 6 of one,
half a dozen of t'other...

Standard maintenance programs apply to these files...

Case in point: We had an instance where we were required to apply a
classification against Sales Credits (Credit Notes), eg, "Operator
Error", "Customer Error", "Pick and Pack Error", "Broken in Transit",
etc... Over time, at that particular site, it's grown from a simple
"classification" to a "Qty and $ value per month" per classification
to a "customer by classification - Qty and $" and a "product by
classification - Qty and $" to a "product by customer classification -
Qty and $", to a "supplier by product classification - Qty and $" if
it's a supplier-based problem, to a "picker/packer by classification -
Qty and $" if it's a picking/packing problem, and I think there are
even "rep by classification", "rep by product", and "rep by customer"
and "rep by product by customer" files to cover that now... ......
and on ...and on... it goes..... Disk must be cheap these days....

All useful information for CRM (Customer Relations Management) and SCM
(Supply Chain Management) I'm told....

I suppose the IMPORTANT bit is it's a case of, in more instances than
not, "If we're going to classify it, then we'll need to have
statistics against it", ergo, separate files.

>
Regards,

Bruce Nichol
Talon Computer Services
ALBURY NSW Australia

http://www.taloncs.com.au

If it ain't broke, fix it until it is....
.

Relevant Pages

  • Re: the greatest thing about freedom is...
    ... Process of elimination, Watson. ... Statistics is necessitated by the imperfection of the ... I cannot say with definiteness that this otherness is "God". ... own frame of reference, but from that I cannot reasonably conclude ...
    (misc.writing)
  • Re: OT: interesting global warming quote found elsewhwere
    ... from a small lab experiment. ... if the reference to "data not made available" was ... Methods of statistical analysis seem to comprise the largest bugaboo. ... Now, I do happen to have had a few courses in statistics, two for my ...
    (sci.electronics.design)
  • Re: Poland And Latvia Must Accept Homosexuality, Says EU
    ... are die hard gays or straight. ... I'm kidding, and, of course, you can't give no verifyable reference to ... statistics, and statistics shows that children get very good care in gay ... "SALT SHAKERS is dedicated to helping Christians understand the times and equipping them to be SALT and LIGHT in the community by upholding Biblical values and by being more aware of the ethical issues affecting today’s society." ...
    (soc.culture.baltics)
  • Gordon, can we please have a reference for your wild claims?
    ... various statistics. ... There is never any attempt by any party, least of all New Labour, to ... a reference number whenever they make a claim to have improved ... If the actual reference diverged from the statement the minister made, ...
    (uk.politics.misc)
Loading