Thank you very much to those who have responded. I am happy that we are able
to generate some discussion on this.  It seems like a simple task to
perform, there are so many different ways of doing it.  I do not need to
have a code in the SCODE because I create a list of active subscriptions
based on active checkin records,  (checkin exist).  An inactive subscription
would have an inactive checkin record (checkin not exist).  So there is no
problem here.

I also have codes to denote paid, package, gift or joint free subscription
in one of the SCODEs.   So at any one time I can generate a list of all
active subscriptions by type.  The only problem is we cannot cross over to
the order records to retrieve the prices, etc.  That has to be done
separately.

I agree we have to separate Collection statistics from Subscription
statistics.  I maintain both. Like I said, the problem is actually keeping
track of how many new subscriptions you have added and how many you have
cancelled/deleted that give rise to problems.

Ean

Mrs Lee Cheng Ean
Head, Serials
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Technical Services Division, Central Library,  National University of
Singapore,
89 Kent Ridge Crescent, Singapore 119275
Email: clbleece@nus.sg  Tel: (65) 8742035   Fax: (65) 7747180
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 ---------- Original message ------------
> From:         Marilee Rouillard <mrouilla@KEENE.EDU>
> Sent:         Wednesday, November 04, 1998 3:22 AM
> Subject:      Re: Subscriptions added/cancelled
>
> I am doing what the message below indicates (I use a for active in the
> scode) but I am watching this discussion because I now need to produce
> separate lists of how many were cancelled, ordered, died or merged and who
> paid what for them....All lists separate by type, and by date.  Just a
> running total won't be enough, so plan bigger.
>
>
> Marilee H. Rouillard, Supervisor Periodicals Department, Mason Library
> Keene State College, Keene, NH 03435-3201
>
> mrouilla@keene.edu  (603)358-2756
>
> >(2)----------------------------
> Date:         Tue, 3 Nov 1998 10:40:15 -0600
> From:         "L. Hunter Kevil" <mulkevil@SHOWME.MISSOURI.EDU>
> Subject:      Re: Subscriptions added/cancelled
>
>>My two cents on this problem:
>>
>>In software there is a big difference between maintaining running counts and
>>performing a new count whenever a total is needed. Generally the latter is
>>the better option, because running totals can easily get off and cannot be
>>corrected. Our mistakes simply cumulate. The better choice might be simply
>>to calculate the figures you need each time you need them. Perhaps using an
>>Innovative SCODE to indicate whether a check-in record is for an active,
>>currently received serial would be enough. When a title becomes no longer
>>current, either by reason of cancellation, cessation, or cancellation, you
>>simply change that one code. Then whenever you need to know the number of
>>currently received serials you would use that field to compute the total.
>>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~