Hi, Elpidio I�m new to the list. I think the end date of the transaction it could be neccesary. In my country a billable item are the number of days a patient stay in some hospital service (for example intensive care unit). We could insert in this table this kind of information in this table. One option is to use the start date and the end date to manage this . An other option would be measuring the time of staying in hours or days and use the field count.
Best regards, Javier Franck ----- Original Message ----- From: "Elpidio Latorilla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 03, 2004 4:44 PM Subject: Re: [Care2002-developers] Flagging of billable/transaction items in Care2x Hi Noel, thanks for the advice. Let us include them in the design. Regards, Elpidio On Wednesday 02 June 2004 15:16, Noel Villamor wrote: > A single date to indicate timestamp when transaction is inserted may > suffice instead of having date_start and date_end. > > You may want to also include a status flag(s) for indicating whether the > transaction has been billed, cancelled, served, etc. > > Prices of certain items could change from the time it was inserted into > the transaction table and the time it is billed for payment. This > complicates things and you may want to leave it for the time being. > Otherwise, a price field (and discount field) needs to be added as well. > > Best regards. ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers
