Viewing constituent birthdate information
Have you recently upgraded to Millennium version 7.3 or 7.3.1 and can no longer see your constituents’ birth dates? This is due to table structure changes in versions 7.3 and higher.
In previous versions, birthday information was stored in the corebirthd field in the corebio table. In 7.3 birthday data was separated into three columns, corebirthyr, corebirthmn, and corebirthdy. The installation and conversion process for 7.3 and above does not automatically populate the new columns with the legacy birthday information.
If your Millennium display settings are set to Customizer, the default Basic Data display displays corebirthyr, corebirthmn, and corebirthdy fields, but not the corebirthd field. Therefore the birthday information will be empty for any legacy data in your system.
Article #130632 is a recent addition to the MIP Knowledgebase that elaborates on this issue. The article also contains data repair scripts for Oracle and SQL Server clients that will populate the empty birthday fields for legacy data.
For additional information, please see Article 130632 in the MIP Knowledgebase at http://www.mip.com/boss.Published by Best Software Nonprofit and Government Division
Managing
Editor: Megan Hair, megan.hair@bestsoftware.com