Re: [Care2002-developers] suggestion of table change

2010-10-31 Thread Ap.Muthu
Hi Robert, Isn't this more of a legacy issue. Once the hospital is entirely on Care2x, it will not be necessary. This is quite useful if the patient is referred from another hospital. Rather than hospital_file_number, the field can be generic as alt_pid NULL This field should be optional and not

Re: [Care2002-developers] suggestion of table change

2010-11-01 Thread Ap.Muthu
Hi Robert, You've deleted the mysql dump file in SVN 6914 and have not put in the new one as yet! Regards, Ap.Muthu > Hi Robert, > > Isn't this more of a legacy issue. > Once the hospital is entirely on Care2x, it will not be necessary. > > This is quite useful if the patient is referred from a

Re: [Care2002-developers] suggestion of table change

2010-11-01 Thread Ap.Muthu
Restored the MySQL Dump in SVN 6915 with care_person.alt_pid field. Existing users can upgrade with: ALTER TABLE `care_person` ADD `alt_pid` VARCHAR(20) DEFAULT NULL AFTER `pid` Regards, Ap.Muthu > Hi Robert, > > You've deleted the mysql dump file in SVN 6914 and have not put in the new > one a

Re: [Care2002-developers] suggestion of table change

2010-11-02 Thread Robert Meggle
Hi Muthu, Sorry for my late answer (was out over the weekend and yesterday was public holiday here). I feel sorry that I seem really removed the dump file, it was not the idea. Well, but I am not that happy now about the name of this column now. Thanks for correcting it. Robert Am Montag,

Re: [Care2002-developers] suggestion of table change

2010-11-02 Thread Robert Meggle
Hi Muthu, I am not so sure that it is really a legacy issue. Nearly all hospitals I've visited they have either their own HIS and want to use care2x from a specific point or they use it side-by-side. But in all cases they will continue their numbering format what is always historical based and c

Re: [Care2002-developers] suggestion of table change

2010-11-02 Thread Ap.Muthu
Hi Robert, The field name can be what you suggested - what I put in was a little generic. I certainly want you to be happy. In case there are hospitals that do not use the alt_pid field, keeping it NULL would allow them to proceed. Attempting to copy into alt_pid the value in pid if alt_pid is

Re: [Care2002-developers] suggestion of table change

2010-11-02 Thread Robert Meggle
Hi Muthu, No worry - it is just developer's discussion :-) Here I do have the same issue. A hospital here wants to have our care2x for researches but want to keep their own (historical) HIS up and running. Just for some view forms in a specific department they want link it with care2x that they c