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