Elpidio Robert's remarks below stareted me thinking. But 1st, if I sound stupid disregard my message because I am not aware of the details of the subject, even though I've seen lots of messages the past week about "patients & personnel".
So here it comes from an analyst's view point: A staff member in a hospital can get treated at his/her hospital. By becoming a patient, this new entity MUST go on the patients file/table; Name and National Id nr get duplicated, and that's OK. To Normalise by keeping the data on the personnel table is a severe violation of entity definition. Also, a sick staffer is a patient class like an insured patient; he/she has a treatment/coverage plan, the provider of which is the hospital itself. In fact, in some cases both the hospital and insurance companies will provide the coverage based on a) the types of medical services/treatments rendered, and b) percentage of cover. If the above is Not applicable to the situation at hand, then please diregard the rest of this message. If it is applicable; then (I don't want community colleagues to get mad) coding solutions that do not adhere to proper data analyis is crazy and will create a very messy un-maintanable system. Regards, Salman Alharbi ----- Original Message ----- From: "Elpidio Latorilla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 15, 2004 11:42 PM Subject: Re: AW: [Care2002-developers] about patients and personnel in the same table Hi Robert, On Friday 12 November 2004 06:59, Robert Meggle wrote: > When I saw the idea of patients and personel data in the same table it was > also strange and new for me. But I think it's okay. Why not? > > Robert This could become less annoying at the PM/GP version when the clinic has very small number of employees (perhaps only one doctor and one clerk). So, one can in fact remove/disable the personnel module. elpidio ------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers
