« Oracle Database Tuning | Main | Analyzing Oracle Objects and Creating Explain Plans »
April 20, 2006
Parts Upgraded
One of the main uses for SWAMP is a detailed tracking of all parts kept in Stores. We keep track of all sorts of things such as price, quantity on hand, last cost, reorder point, how many we used over such and such a time, etc., etc. Every so often, Marsha cleans up a particular area that has become disorganized over time. For instance, certain parts are no longer needed as the equipment they were used on has become obsolete. Also, part numbers are added in to accommodate new stock items. Eventually, certain areas need to be reworked. One such area is the filters and other consumable parts for the lawn mowers and other grounds equipment. Marsha recently reorganized this entire area and assigned new part numbers to every part. It was my job to upgrade SWAMP data to reflect the new organization, without losing any of the historical data on each part. I'm glad to say it went very nicely and a new comprehensive parts list was generated today to show all the changes - it's 97 pages long and looks pretty neat! I always wanted to write a book...
Posted by rossm at April 20, 2006 3:29 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)