Re: [Care2002-developers] suggestion of table change
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 null and not even unique. Regards, Ap.Muthu > Hi, > > Just out of experience.. and because I am doing that now again (as > always)... > > ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT > NULL AFTER `pid` > > What do you think? Is it a major need and all of you have the need to > place there somewhere existing and already used hospital file numbers? > > Then we will add it to the next care2x release. > > Thanks > Robert > > p.s. Is there any need of having a documentation or example file how to > use tools like pentho's PDI to migrate existing datasets to care2x? > > -- > -- > > CARE2X - free Integ Hospital Info System > https://sourceforge.net/projects/care2002/ > http://www.care2x.org > > > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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 another hospital. > > Rather than hospital_file_number, the field can be generic as alt_pid NULL > This field should be optional and not null and not even unique. > > Regards, > Ap.Muthu > > >> Hi, >> >> Just out of experience.. and because I am doing that now again (as >> always)... >> >> ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT >> NULL AFTER `pid` >> >> What do you think? Is it a major need and all of you have the need to >> place there somewhere existing and already used hospital file numbers? >> >> Then we will add it to the next care2x release. >> >> Thanks >> Robert >> >> p.s. Is there any need of having a documentation or example file how to >> use tools like pentho's PDI to migrate existing datasets to care2x? -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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 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 another hospital. >> >> Rather than hospital_file_number, the field can be generic as alt_pid >> NULL >> This field should be optional and not null and not even unique. >> >> Regards, >> Ap.Muthu >> >> >>> Hi, >>> >>> Just out of experience.. and because I am doing that now again (as >>> always)... >>> >>> ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT >>> NULL AFTER `pid` >>> >>> What do you think? Is it a major need and all of you have the need to >>> place there somewhere existing and already used hospital file numbers? >>> >>> Then we will add it to the next care2x release. >>> >>> Thanks >>> Robert >>> >>> p.s. Is there any need of having a documentation or example file how to >>> use tools like pentho's PDI to migrate existing datasets to care2x? > > > > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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, den 01.11.2010, 20:24 +0530 schrieb 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 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 another hospital. > >> > >> Rather than hospital_file_number, the field can be generic as alt_pid > >> NULL > >> This field should be optional and not null and not even unique. > >> > >> Regards, > >> Ap.Muthu > >> > >> > >>> Hi, > >>> > >>> Just out of experience.. and because I am doing that now again (as > >>> always)... > >>> > >>> ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT > >>> NULL AFTER `pid` > >>> > >>> What do you think? Is it a major need and all of you have the need to > >>> place there somewhere existing and already used hospital file numbers? > >>> > >>> Then we will add it to the next care2x release. > >>> > >>> Thanks > >>> Robert > >>> > >>> p.s. Is there any need of having a documentation or example file how to > >>> use tools like pentho's PDI to migrate existing datasets to care2x? > > > > > > > > -- > > Nokia and AT&T present the 2010 Calling All Innovators-North America > > contest > > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > > marketing > > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > > http://p.sf.net/sfu/nokia-dev2dev > > ___ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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 care2x has to work with it and I do not think that they will change it one day. If it can be NULL in that way I have some doubts, but let see what it will bring for results from the reality. But the indexing of that table is not really funny. Better would be a unique key over pid, "alt_pid", the birth date, first name, last name and registration timestamp instead of having index for each column. That could have good benefits when this table will be joined afterwards with other tables (avoiding of full table scans). Robert Am Montag, den 01.11.2010, 07:47 +0530 schrieb 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 null and not even unique. > > Regards, > Ap.Muthu > > > > Hi, > > > > Just out of experience.. and because I am doing that now again (as > > always)... > > > > ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT > > NULL AFTER `pid` > > > > What do you think? Is it a major need and all of you have the need to > > place there somewhere existing and already used hospital file numbers? > > > > Then we will add it to the next care2x release. > > > > Thanks > > Robert > > > > p.s. Is there any need of having a documentation or example file how to > > use tools like pentho's PDI to migrate existing datasets to care2x? > > > > -- > > -- > > > > CARE2X - free Integ Hospital Info System > > https://sourceforge.net/projects/care2002/ > > http://www.care2x.org > > > > > > -- > > Nokia and AT&T present the 2010 Calling All Innovators-North America > > contest > > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > > marketing > > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > > http://p.sf.net/sfu/nokia-dev2dev > > ___ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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 NULL would bring in anomalies and clash with similar numbers in the alt_pid that were not NULL in the first place. Hence the UNIQUEness for alt_pid would have to wait till you decide how to use it when alt_pid is absent (multiple NULL alt_pids should be able to exist). What is now in place is just a place holder. Please give it some thought as to how hospitals starting anew entirely in Care2x would be able to use it alongside with hospitals that intend to use Care2x for only a part of their operations whilst relying on their own HIS for others. Regards, Ap.Muthu > 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 care2x has to work with it and I do not > think that they will change it one day. > > If it can be NULL in that way I have some doubts, but let see what it > will bring for results from the reality. But the indexing of that table > is not really funny. Better would be a unique key over pid, "alt_pid", > the birth date, first name, last name and registration timestamp instead > of having index for each column. > > That could have good benefits when this table will be joined afterwards > with other tables (avoiding of full table scans). > > Robert > > > Am Montag, den 01.11.2010, 07:47 +0530 schrieb 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 null and not even unique. >> >> Regards, >> Ap.Muthu >> >> >> > Hi, >> > >> > Just out of experience.. and because I am doing that now again (as >> > always)... >> > >> > ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT >> > NULL AFTER `pid` >> > >> > What do you think? Is it a major need and all of you have the need to >> > place there somewhere existing and already used hospital file numbers? >> > >> > Then we will add it to the next care2x release. >> > >> > Thanks >> > Robert >> > >> > p.s. Is there any need of having a documentation or example file how to >> > use tools like pentho's PDI to migrate existing datasets to care2x? >> > -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] suggestion of table change
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 can do some (complex) customary work. There are some specific issues to be solve but I am lucky to able this kind of transferring the data with an PDI job once a day by a script. ( will send you the pdi pattern if you want and if it would help you ) But exactly what you mention in your mail is the aim we all have. Flexibility and gerneric. Robert Am Dienstag, den 02.11.2010, 19:00 +0530 schrieb 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 NULL would > bring in anomalies and clash with similar numbers in the alt_pid that were > not NULL in the first place. Hence the UNIQUEness for alt_pid would have to > wait till you decide how to use it when alt_pid is absent (multiple NULL > alt_pids should be able to exist). > > What is now in place is just a place holder. Please give it some thought as > to how hospitals starting anew entirely in Care2x would be able to use it > alongside with hospitals that intend to use Care2x for only a part of their > operations whilst relying on their own HIS for others. > > Regards, > Ap.Muthu > > > > > 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 care2x has to work with it and I do not > > think that they will change it one day. > > > > If it can be NULL in that way I have some doubts, but let see what it > > will bring for results from the reality. But the indexing of that table > > is not really funny. Better would be a unique key over pid, "alt_pid", > > the birth date, first name, last name and registration timestamp instead > > of having index for each column. > > > > That could have good benefits when this table will be joined afterwards > > with other tables (avoiding of full table scans). > > > > Robert > > > > > > Am Montag, den 01.11.2010, 07:47 +0530 schrieb 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 null and not even unique. > >> > >> Regards, > >> Ap.Muthu > >> > >> > >> > Hi, > >> > > >> > Just out of experience.. and because I am doing that now again (as > >> > always)... > >> > > >> > ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT > >> > NULL AFTER `pid` > >> > > >> > What do you think? Is it a major need and all of you have the need to > >> > place there somewhere existing and already used hospital file numbers? > >> > > >> > Then we will add it to the next care2x release. > >> > > >> > Thanks > >> > Robert > >> > > >> > p.s. Is there any need of having a documentation or example file how to > >> > use tools like pentho's PDI to migrate existing datasets to care2x? > >> > > > > > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Care2002-developers mailing list Care2002-developers@lists.sourcef