For Customizer screens the YYYYMMDD date format has been added as an acceptable date format.

When you inactivate a Lookup in the Lookup Table Maintenance and that Lookup was used in a Define Default somewhere, it will no longer show on the Insert via Default screen and will be set back to - CHOOSE - if it is a non-value-based lookup or does not contain a blank value for that table. Otherwise, a blank will be shown when a blank value is active for that lookup or it is a value-based lookup.

A new feature has been added when linking attachments to make it easier to select a file to attach. Now there will be a Browse button that allows you to search for a file to Upload and Insert. Once the file is chosen, clicking the Upload and Insert button will copy the file from it's current location to the docs folder on the IIS for you. This saves users from copying the file manually over to the server and manually typing in the file name and extension.

ONLY if the Docs folder is set up as a virtual directory, the following Registry Key must be set up on the IIS: HKEY_LOCAL_MACHINE\Software\JSI FundRaising Systems, Inc.\ Millennium Internet\Docs with the string variable Path and set it as the path of the Docs virtual directory. If the Docs folder is not a virtual directory, this is NOT necessary.

When tabbing to a field that is a Value Based (super) Lookup the leading spaces are highlighted, when manually clicking in the field it will indent the cursor several spaces and mimic a space. Now when you click in the Value Based (super) Lookup field the system will automatically highlight the spaces for you allowing you to type without having to remove the spaces first.

Experiencing an extremely long delay before getting to the Windows Client Login screen.

Oracle sites are unable to produce any of the On Demand reports from the Millennium Explorer link My Millennium > Reports. Once the report request has been submitted, the request hangs and the report never produces. After 30 minutes or more, Internet Explorer generates "The page cannot be displayed" error message.

When an IIS name is more than 5 characters, a message appears during installation stating that valid virtual directories are required.

The file xrefstrt.exe is not installed on a client machine when installing the Agent via Browser, therefore email notifications on Assignments do not function for browser-only clients. This file is only delivered when installing the Millennium Windows Client.

Any updates made to an assignment of type 'Gift Account' clear the asgnstate field. If this field is empty, the assignment does not function and user will not receive any notifications.

Client has SSL enabled. When logging into Windows client and navigating to any menu, the following error occurs 'The page must be viewed over a secure channel.'

If the local account, 'Network Service' is not added to the de folder with Full Control, attempts to run any Yellow Button Reports in Millennium results in an error: Error Exporting Report. Please check the permissions on the \Inetpub\WWWRoot\Mill\de folder.

Default 403.4 error message has changed in IIS 6.0 causing errors in Millennium with SSL enabled on a Windows 2003 Server IIS, IIS 6.0.

FIX: Sites have the ability to change their IIS error messages. However, in order for SSL to work in the Windows client, that customized IIS error message must contain either; SSL required or HTTP Error 403.4".

When the users clicks on the My Millennium / Best/ Millennium Links / Technical Support link, the new content should open in a new window.

It is not possible to edit an existing Campaign Amount assignment. Attempting to do so will result in several successive error messages.

A new Bi-Weekly Pledge Payment Schedule has been added to the Billing Cycle options; which will start on the first day of month.

Value: Bi-Weekly

Code: bw

Value: Bi-Weekly No Bill

Code: bwn

A new field has been added to the Membership Type Lookup Table to indicate whether the Membership will be for a lifetime. This field, Lifetime?, acts as a flag to the system to show whether a particular Membership will expire or not. Checking this box will prevent lifetime members from being pulled in renewal reports as well as not requiring an expiration or renewal date upon insert.

See the field added for Lifetime Memberships below.

A new field has been added to the Benefit Type, Membership Benefits, Publication Name and Membership Publications Lookup tables to indicate whether the Benefit or Subscription is a One-time Benefit. This field, One Time?, acts as a flag to the system to show whether a particular Membership has a One-time Benefit. Checking this box will make that certain value a one-time benefit. Once the box has been checked on the Lookup tables side, and a Membership is upgraded from a different type of Membership, the constituent will get the one-time benefit associated with that Membership. If a Membership is upgraded to a level that has the one-time benefit from a level that does not, the constituent would get that one-time benefit. However; if upgraded from a high level Membership that already has the one-time benefit to an even higher level Membership that also has the same one-time benefit,the constituent would not receive it again.

See the fields added for One Time Benefits below.

Once a Membership row has been entered, a user has the ability to upgrade that specific Membership without creating a new Membership. This process applies to those members who have already paid for a lower level Membership and then send in additional money to apply towards a higher level Membership.

This applies only to those users who are part of a user group which has Membership Processing set to Dues within User Security. This Membership Upgrade, when processing through dues, will also use the prototype if one has been created.

After inserting Prospect Tasks, you may choose to have those tasks added to your Outlook Calendar and/or the Outlook Task List. This is only if the Outlook Options have been set by the user to Outlook Calendar, Outlook Task List or Both prior to inserting the Tasks. See Outlook Options, Browser or Outlook Options, Windows.

When linking a non-constituent relationship, all non-constituent information will be shown on the linked row, for example, gender, birthdate, etc.

A date field has been added to track delivery of a Benefit. This Delivery Date field will be displayed on the Benefits screen. Each site will have the choice whether or not to allow the Delivery Date for a Benefit to default to the Membership Renewal Date by the system or to be left blank to be filled in manually. If the system administrator decides to set this for the whole site they will do this from the System Options page, otherwise if the option is left unchecked on the System Options page the Delivery Date will not be filled in with any date allowing the user to fill the date in manually.

When the current Membership screen has already been set to short or mini display, and selecting the context menu to the left of one specific Membership, the menu item under Display shows Detail. When Detail is selected, that single Membership will be shown in detail. To get back to the previous Membership screen you will need to click on the Explorer menu on the left where it states Membership. When this function is completed, the screen will place its focus on the transaction that was just selected for Detailed Display. Please note that when the Membership is towards the top of the screen, the transaction selected for Detail, once returning to the main screen will be placed as the focus on that screen. If a Membership is towards the bottom, more specifically the last few, it will show that transaction at the middle or bottom of the screen.

If the Employment Status is changed to No Longer at this Position, the employer/employee relationships are changed to a former employer/former employee relationship. If an Employment row has a linked address, and the Employment Status is changed to No Longer at this Position, a message will appear asking you 'Would you like to change the linked address by setting the locator to former and the stop date to today?' If you select OK it will set the Locator to Former and the stop date to today's date on that linked address. If you hit Cancel, the information on that Linked Address will not change. After selecting OK or Cancel for that first message, another message will appear asking 'Would you like to unlink the linked address?'. If you select OK, it will remove the Linked to Address link from the Employment row as well as remove the Link to Employment link from the linked address row. If you hit Cancel, the link will remain on the Employment row and the Linked Address row.

If you have already been viewing one constituent's data and want to switch to a different constituent's data, you may click on the Next Search item located in the Millennium Explorer or hit the space bar as that is the Hot Key for Next Search. When you do so, the Search form will automatically be presented. This enhancement is not available when using Safari.

Leading spaces have been removed when copying an ID and pasting it into the Name / ID field on the Profiles Search screen.

Tasks Subject (tasksubjct) length has been increased from 80 to 160.

NOTE: Standard Millennium Templates and Customizer screens have been modified to reflect this new length. However, any Custom Templates must be manually modified to reflect this change and any Saved Custom screens in Customizer must be re-saved.

After a search has been run that will return more than 500 records a message will appear at the top of the Search Results page stating 'The maximum display number of 500 names has been reached. Use the Back and Next buttons at the bottom of the Search Results page to display additional names.' If you scroll to the bottom of the first Search Results page there will be a Next button to view the next 500 records. The Next button will appear until the last rows are displayed. Once you have clicked next you will also have the option to click the Back button to view the previous records again.

Once you have selected the Bookmark hyperlink, you will notice that the Bookmark hyperlink (to create a link) will no longer appear when you are displaying one of your own bookmarked constituents. Instead, the display header will show Remove Bookmark and include a yellow star as a visual reminder that this constituent is one of your Bookmarks as well as add the Constituent's Bookmark link to the Bookmarker's Favorites Bookmark page.  

If you decide to remove the bookmark for that constituent you may click the Remove Bookmark hyperlink shown in the upper right-hand corner just above the Spouse, Report, and Print buttons. It will confirm that you want to remove the individual as a bookmark. Selecting OK will result in removing the yellow star next to the constituent's name, remove the Constituent's Bookmark Link from the Favorites Bookmark page and change the link from Remove Bookmark back to Bookmark allowing the user to Bookmark this constituent again in the future.

NOTE: It is important to know that with this enhancement, Bookmarks are no longer stored in the Relationships table. All current Bookmarks will be moved from the Relationships table to the Bookmarks table when the Conv75.exe is run. This also means that the Bookmark and Bookmarker Relationship types have been removed as well and will no longer appear in the drop-down list on the Relationships insert screen. Also, when the Conv75.exe is run ALL groups will get insert/update/delete and select rights on bookmarks_full. So if you want to change the security for certain groups or users you will need to modify them as needed.

On the System Options page there is an option that allows the system to automatically update the Purpose, Campaign, Class1 and Class2 fields on the payment when they are updated on that associated allocation. Under the question "Do you want to automatically Update Payments when a Pledge is changed?" there is a checkbox "Automatically Update Payments". When the system administrator checks this box and any of the Purpose, Campaign, Class1 or Class2 fields have been changed on an allocation for a transaction, those rows that already have a payment made; the payment will also be updated with the changed information for those four fields.

See Editing Allocation Information for additional information.

When displaying Giving Detail or Dues Detail in Mini Display, the Match field will show MVD (matching pledge void) instead of MPL (matching pledge) when a Matching Pledge is Journaled. This way the user will know in Mini Display when a Match was voided.

On the System Options page there is an option that allows the system to automatically update linked Credits and Honors. Under the question "Do you want to allow Credits and Honors to be updated when a Transaction is changed?" there is a checkbox "Allow Credits and Honors to be updated". When the system administrator checks this box and a transaction that has a linked Credit or Honor is updated, those linked rows will be updated with the current information updated on the main transaction.

See Editing Data in the Primary Transaction for additional information.

In the Attribute Lookup Table you were allowed to enter in 65 characters, however the display shown in Profiles was truncated. Now the Attribute Type Value (attrtypenm) will show all 65 characters in Profiles.

My Bookmarks and My Prospects will now be available for Gift Amount when creating new Assignments. This enhancement is not available when using Safari.

If an address is a Preferred, Good, Business Address with Linked Employment and you select the Option to Write a Letter, the Company Name will appear with the Address underneath the Constituents Name on the letter. This enhancement is not available when using Safari.

The ability to add linked Phone Numbers to a particular Address row is now available during the Insert of a new address or using the edit menu of an existing Address.

When choosing Insert from the main Address menu, after you have inserted your Address information you will see a new button to Insert + Phone. Selecting this button after the Address information has been entered will open the Phone Numbers screen where you can insert a Phone Number to be linked to that address. Once the Address and Phone Number has been inserted together you will see the Address with a Phone Number right below it.

If you want to add a new Phone Number to an existing address this can be done by selecting the edit menu of the address to which you want to link a Phone Number to and selecting either Link Phone or Link Phone via Default. See Link for more information.

If you want to add an existing Phone Number to an existing address this can be done by selecting the edit menu of the address to which you want to link the existing Phone Number to and selecting Link to Existing Phone. See Link to Existing for more information.

Once a Phone Number or Phone Numbers have been linked to an Address the ability to Update or Delete those linked Phone Number rows is now available when selecting Update/Delete from the edit menu for that Address row. If you want to only update the information on the Address row you will select Update which will bring you back to the main Address screen and not allow you the option to change any linked Phone Number information. Otherwise, if there are updates that need to be made to the linked Phone Number as well, after updating the Address information you may select Update + Phone. This will bring you to the linked Phone Number screen allowing you to make any changes and select either Update to update the phone information, Cancel to not update any phone information or Delete to delete that linked Phone Number row. In the event that there are several linked phone numbers, selecting Update will update that phone row and then take you to the next linked Phone Number, selecting Cancel will cancel any changes made to that Phone Number and take you to the next linked Phone Number and selecting Delete will delete that Phone Number and take you back to the main Address row not allowing you to Update any other linked Phone Numbers.

As always, you are still allowed to Update or Delete linked phone numbers separately without having to go through Updating the main Address the Phone Numbers are linked to. This is done through selecting Update/Delete from the edit menu on the linked Phone Number row and not from the Address row.

For purposes of Update/Archive those linked Phone Numbers will be carried forward to the new Address. The original Phone Numbers will continue to be displayed with the archived Address but the phone type will be changed to 'former'.

Once a Phone Number has been added to an Address you can use the edit menu to select the options of Link Phone to Spouse, Link Phone to Other, or Link to Existing Phone on Other. See Link and Link to Existing for more information.

The City field is now case insensitive where in the past it needed to be in proper case, for example, Williamsburg.

The Last Search item is used to retrieve the Search Results page from the most recent constituent search that was performed be it either from a standard search or a search performed from a worktable.

The ability is now available to make a non-constituent relationship into a constituent relationship. This can be done when updating a relationship row that was inserted as a non-constituent. Once Update is selected from the edit menu you will notice a new section at the bottom of the update relationship screen. A checkbox stating Change to a Constituent must be checked in order for the information entered below that checkbox to be updated. Please note, it is necessary to add the 'Is' (relrelisa) row to a Customized Non-Constituent screen for both Customizer and Templates in order for this enhancement to work properly.

When a search is performed that returns a list of Search Results, any user has the ability to click on each of the underlined column headers, whether it is a Default Search Results Display or a Customized Search Results Display. Clicking once on a header will sort that field in ascending order and when clicking that same field again it will sort in descending order.

Increased the membcomm field from 255 to 4000.

The system allows users to edit the allocation row of a pledge that has payments applied against that allocation. This subsequent allocation update does not cascade to the payments applied to that allocation row.

When a pledge payment for part of a pledge transaction is made in-honor of another constituent, the In-honor-of link reflects the full amount of the pledge transaction.

Search results criteria reaches 500 record limit but displays less than 500 records because it pulls 500 records and then removes the duplicates displaying less than 500 records.

The ID Number was not being displayed as part of the Constituent Infodata display. It should be shown as part of the non-scrolling region at the top of the display area.

If a Pledge has been written off and there is no remaining balance the ability is still available to post a payment on that written-off pledge.

If a filter contains a checkbox the filter would not return the data correctly.

FIX: In order to apply this fix if a filter was previously created that contained a checkbox, the filter must be deleted and reentered.

Once a default batch # is supplied it always appears on the first page of the define default form. Even after the defined default form has been deleted, it continues to pre-populate when inserting transactions without the use of defaults.

If the selection contains multiple rows, the detail does not immediately appear but the Data Table Name Display Header appears in the Active Title Bar. If the mouse passes over or clicks the name of the display header before the detail rows appear on screen an IE script error will occur.

Browser interface does not show the Death row on Basic Data, however, if a Define Display is created to show, it will appear once in Browser but twice in Windows.

Credit Card, Securities, or Gift In Kind tender rows are not being shown on the joint side for the Pledge Payments rows.

Deleting a relationship row that owns linked contact info does not remove the linked contact info from the contactinfo data table. It only removes it from the front end.

When adding a solicitor to a pledge payment, the linked solicitor row is displayed in different locations depending on the method used to add the solicitor.

Inserting a non-constituent relationship with Birthdate, Gender and Status information then using the menu option to link that relationship to spouse or to other, the information listed above is not showing on the linked relationship record.

Membership Comment field allowed more than 255 characters to be typed in even though the database only allowed 255 as was stated in the documentation.

After editing allocation details on a gift transaction with a credit for spouse and an employer match, the spouse will have an extra match credit from the employer.

Option to define default is not available for Membership Subscription Level, Membership, Membership Cards, and Benefit Level, even though Insert via Default is available.

When customizing the standard Custom Prospect screen to include a checkbox and either inserting/updating/deleting would cause an error.

Appearance set under My Millennium does not appear on Gifts when Display is set to Detail.

When entering a partial value in the Purpose or Solicitation value based (super) lookup fields, only one value would appear even though there were other matches.

The contactinfo table was not being updated when a non-constituent relationship was updated.

Quid Pro Quo items are not being created on the Linked Dues Detail when a Dues Transaction is given by another constituent.

Deleting a Planned Gift that is linked to spouse or other warns that it will delete the Planned Gift as well as the linked Planned Gift, but it does not on either record.

Filter (Filter On, Define Filter) and Sort (Sort On, Define Sort) Options were not included in the header menus for Relation and Correspondence.

Solicitation Code value is not displaying on the Giving Detail screen.

The Letters feature in Browser pulled the name randomly rather than pulling the preferred nametype.

When creating a transaction with Credit for Spouse or Credit for Other, Journal & Add Correction was not available from the Transaction menu.

Unable to write-off a portion of a pledge that has an outstanding balance.

In 7.2 there was a check box on the Profiles/Option screen where you could turn off the display of the id of constituent on the non-scrolling bar at the top of the screen. In 7.3, 7.3.1, 7.4 this feature is missing.

Using Sun Java gives "The page cannot be displayed" message when trying to Define a Default.

After defining a default for Correspondence the default is not shown in the dropdown list when you go back to Define a Correspondence Default. It is being stored under Basic Data instead of Correspondence.

When entering a Pledge Transaction, then making a Payment on it, then wanting to Journal the balance, the amount reflected on the Journal Transaction screen would be the balance, however, you would receive a message stating that the amount had to be less than that balance.

When inserting a Gift with more than 2 Allocations for a record with a Matching Employer it does not allow more than 2 allocations to be entered for that Matching Employer at the time the Gift is inserted. An error occurs; "Unable to find gift transaction."

When you display a constituent's Relation Tree and then click on the Groups button, the codes displayed do not match the group values displayed in the Relation Tree.

My Bookmarks and My Prospects will not show all Bookmarks and Prospects.

County field is missing from the default Address screen.

Fields giftnonded and gifttnonde are not populating properly for joint givers when a third party gives a gift (on behalf of joint givers).

Allocation changes do not carry over to the primary giver on the joint gift.

Joint pledge with a matching pledge payment does not allow the soft credit cannot be journaled from the company side.

Multiple allocation pledges show the payment and billing schedule icon under each allocation.

Oracle system accepts invalid dates for some tables. You can enter dates in a non-typical manner and get an Oracle system to accept a date that had a year with one, two, three, or four digits. Problem found in Profiles > Prospects > Tasks, Profiles > Biographical > Correspondence and Profiles > Biographical > Employment.

Payment transaction row shows full amount of pledge in the giftnonde field when a pledge transaction is joint and given by another constituent.

Non-constituent relationship names display with extra spaces in Customizer.

Customizing the Dues and Gifts Fast Data Entry forms remove the Purpose field.

Payment Schedule buttons grayed out when the userid and usergroup should have access.

Advanced search shows duplicate operators when specifying criteria from any table.

When a Pledge Transaction is given on behalf of a constituent and joint with another the giftnonded field holds incorrect amounts on (p,c,y) rows of giver and joint w/other credit row.

Windows client display settings on Demographics title bar causes the display name of the Financial title bar to change.

A constituent with over $36,000,000.00 in gifts. On the Giving Tree display, it shows as 3.6 E7.

When you click on the Groups button within the Relation Tree and select specific groups to display within the tree, when you click Apply, all the groups chosen are not showing up.

When you click on the Groups button within the Relation Tree, the values are being displayed by Code instead of by Value like the past release and documentation indicates.

Go to Profiles > Biographical > Relation Tree, the tree will not form, and when you click on 'Groups', no options are available. This is when using Sun Java.

If you add the giftlook1, giftlook2, giftlook3 fields to the Journal form in Customizer, the values are not being populated in the dropdown list in the form.

After defining a Default, when inserting via default from the Windows menu bar at the top the default form is not displaying for any users except sa or millora (these users are presented with the system default).

Sent By name not populating when inserting correspondence via Non-Constituent Default.

On the Correspondence screen, users have the option to define either a constituent default or a non-constituent default, but when inserting via default users do not have the option to choose which default they would like to use.

Adding the Correspondence Name field to Dues Fast Entry in Customizer, it will insert a new Correspondence record upon insert but when updating this record, you will be prompted for the Sent By constituent id when it was a non-constituent correspondence.

Tasks linked to actions linked to proposals are orphaned when the main constituent is deleted

When entering a Dues transaction with the In Honor Of checkbox marked for a constituent, both rows in the Dues table contain a 'g' in the duestype field when the In Honor Of constituent's row should contain an 'h'.

Update to linked Ratings by another user is not reflected in linked row ratedate and rateuserid fields.

When entering in a Pledge Transaction via a Dues and Pledge Information defined default, you receive an error when the Pledge Information default is presented.

Financial insert form does not appear if Demographics display is set to Long or Mini.

Millennium allows users to write off an amount larger than the remaining balance of a pledge.

Giving Detail Hotkeys do not activate user-defined default.

Enter in a gift with Quid Pro Quos. If you check the Joint with Spouse option on the Insert screen, it produces different results than if you entered in the gift with quids, and then make the gift joint via Transactions > Add Joint Transaction.

Insert an Action completed on date for an action with an incomplete task results in a script error. After closing the script error pop-up, the Action completed on date will display, even thought the task remains incomplete.

When adding a date to the payment schedule for an expectancy transaction with credit for spouse, a small pop-up appears which consists of a title bar only. After closing the pop-up, no date is entered into the schedule.

Choosing to Journal/correct transactions with links locks up the system or times it out. Automatically Journal Credits and Honors option is set to 'YES'.

Orphaned tasks are created when inserting/linking Actions with tasks or Proposals with tasks depending on method used and existence of defined defaults.

Adding Correspondence to conditional On Behalf of Pledge changes Total Asset and Total NPV Amounts

Millennium error after clicking Yellow Print Button immediately after inserting a gift.

When editing an allocation a user cannot change deductible amount.

Script Error when editing the deductible, asset or NPV amounts on allocations.

Giftmny1 or giftmny2 fields added to any of the gift layouts can not be populated on Sustainer pledge transactions. If the user enters an amount in either of the giftmny fields the following error occurs: 'Sustainer pledges do not allow a value other than zero. Change the amount to zero.'

Batch updates to joint gifts with tender of security, gift in kind, or credit card delete the secondary transaction.

Incorrect total, balance, and NPV after deleting the write-off of an overpaid pledge.

When defining a user correspondence default, if you define a Sent By ID, the default will not be available for selection. The information will be added to the database, but will not be available for editing or use within Millennium.

Update to credit transaction adds extra match credit.

Updating write off transaction changes giftasset to 0.

The default form for the Registration screen has the Event Name field set to Wide Row, but the data is being truncated. Only the first 24 characters are displayed.

Write a letter function errors out when using SSL. The error message indicates that the application is trying to access the letter using http rather than https.

If you create a filter that filters all Relationships out, you cannot turn off the filter. The menu under Relationships does not show Filter On/Off or Define Filter under Options.

When switching from Short or Mini display of a gift transaction with Quid Pro Quo to Long, the Quid Pro Quo portion remains in either Short or Mini display rather than Long.

If a constituent's Preferred Name contains double quotes, users will receive a script error anywhere in Profiles.

When you link an Address to an Employment Record via a Default, the hyperlink to the Employment row is not being created on the Address screen.

A user without insert rights is presented with an Actions>Insert form that contains an Insert button and 2 functioning Cancel buttons.

If you have a Defined Default set up for a Non-Constituent Honor/Memory, you receive an error when adding an Honor transaction for a Non-Constituent.

Archive Address does not create former address for the linked spouse.

Updates to primary constituent do not reset the Change Date + User ID on linked relation.

Custom fields are included in the data table and are available for any purpose that your institution wants to define. These fields are not shown on the standard display or data maintenance form templates. If your institution chooses to make use of any of these columns, the standard definitions should be edited to include them, using the Customizer, according to your system setting.

Customizer - Within the Tools World, use the Custom Display Designer to edit the templates to include the desired custom fields. See the topic, Custom Display Designer.

In the Events World, Correspondence rows are now allowed to be created from within an Event or Activity. When selecting Correspondence under Events or Activities a Search/Create Correspondence screen will appear. You will notice two buttons at the bottom of the Search/Create Correspondence screen, New and Search. Filling in any of the search fields and selecting New will return a list of constituents. Selecting the constituent from the results list will open the Correspondence screen and allow you to insert a correspondence row for that constituent. Filling in any of the search fields and selecting Search will return any constituents who already have a Correspondence row for that Event you previously chose.

When selecting New from the Correspondence Search screen if your search returns list of constituents, there will be a note at the top of the Constituent Search Results, an envelope icon indicates the constituent already has a correspondence row for the Activity or Event you working with, clicking that constituent will display their correspondence row. Those that do not have an envelope icon next to their name can be selected to have a correspondence row created. Once selected the Correspondence screen will appear with the Constituent Name already filled in. Fill in the rest of the information as needed and click Insert. The Sent By field is mandatory, please fill in with either the name of the constituent or the ID of the constituent who sent the correspondence. If the Sent By person is not in Millennium, select the Non-Constituent button at the top of the Correspondence screen. There you will be able to type in the non-constituent information for the sender.

Once the Correspondence row has been inserted you can click on the Constituent Name who the correspondence was sent to or the Sent By if you chose to insert a constituent Sent By. In doing so the hyperlinks will take you to the last display looked at in Profiles, if you have not been in Profiles your defined display is used. The Correspondence row will also be displayed for that constituent under their Profiles Event Log.

Now the Custom Display Designer for both Browser and Windows has added the ability to define the Search displays for Profile Search, Registrant Search, Attendees Search, Guests Search and Correspondence Search. This allows the system administrator to make changes to the appearance of displaying the Search forms. Customizing the Search screens allows adding or removing available columns, changing the labels and/or position of most columns. In the section above, Using the Default Search Form, you will see the list of available fields that you may work with to achieve your customized search screen. Please note that the Name/ID (nameid) field cannot be removed from the Customized Search screens. Please note that the Registrant and Correspondence Search screens will have the same fields available to add as the Profile Search does. The Attendees and Guests Search screens on the other hand will have a limited list of fields to add.

If there is an Event that has completed or you want to no longer have available for use without deleting it, you may make it Inactive. You can do so by selecting that Event and using the edit menu to Update the main Event row. On the update screen for that Event there will be an Inactive? checkbox. Checking that box will deactivate that Event making it so that it cannot be searched upon unless otherwise specified on the search for Events screen and not allowing it to be updated or added to. Meaning that deactivating the Event will no longer allow any other Event Info, Activity or Registration rows to be added or updated; this includes Actions, Guests, Items, Speakers, Organizers, etc. In doing so, Insert will not be on any of the Popup menus, and the Insert Activity hyperlinks will not appear on the Activity Search results page.

Once an Event has been made inactive you will still have ability to search on that Event at all times if you choose. To do so, the box 'Include Inactive Events in the Search' must be checked on the main Event Search screen before the search is started. Checking that box will show all active and inactive Events, displaying an (I) next to the Events that have been made Inactive. Selecting an Inactive Event will allow you to only view any of that Event information but remember; because it is inactive, you will not be allowed to make any changes to that Event. If you want to make that Event active again, simply uncheck the Inactive? checkbox when updating the main Event row. This will allow all menu items for that Event and its Activity and Registration rows to become available for use again.

The new Express Registration process allows users to enter all Event information for a registrant or guest on one form including Registration Detail, Guest Detail and any of the following if applicable; Guest Lodging, Guest Special Needs, Guest Tourney Needs, Guest Transportation Needs, Activities, Activity Guest Special Needs, and Activity Guest Tourney Needs. From that same form users will be able to Finish Registration, Add Another Registration, Add A Guest, Enter A Fee or Cancel This Insert.

If the Events World is not open, begin by accessing the Event with which the Activity is associated. When that is done, click on the Activities header in the Millennium Explorer to expand the Activity menu then click on Sort. This will display a form that allows you to change the order in which the list of Activities is displayed during the Express Registration. It is important to note that this will not reflect the sort order of the Activities listed under an Event, this will only change the sort during the Express Registration process. To sort the list of Activities in a different order highlight one of the Activities in the list and click either the Move Up or Move Down buttons to change the sort order. When the list of Activities have been moved to the order you want, click OK to save, otherwise click Cancel to have the sort order revert back to the system sort of alphabetical. Once the sort has been saved, the Activities will display as such during the Express Registration for all users. Each site may want to discuss this amongst its users as to which sort order would suit them best since when a change is made by one user it will affect all users inserting Registration.

The Activity display on the Registration Form can be modified by customizing the SHORT display of Activities. Any fields can be added or removed and the registration form will reflect the changes. On the registration form if any of the data in the activity is blank it will not display on the registration form (not even the label), this is to save space.

Once you have selected an Event and navigated to the Registrations screen, the Search/Create Registration screen will appear with an Import Registrants button. Clicking this button will open the Import Registrants applet listing the worktables that have been previously run and saved through Millennium Reporter. Here you will need to select a worktable from the Filenames list and click either Accept, Cancel or Delete. Clicking Cancel will cancel the selection of the worktable to run, clicking Delete will Delete the selected worktable from the list and clicking Accept will run the worktable that you have selected. In order for the Import of Registrants to run successfully from the Worktable you have selected, you must click Accept. In doing so, a new screen will open showing the following while the Import is running.

Start date and time

Work Table

Error Log path

Number of Records Processed

Completed date and time

Total number of Records Processed

Number of those who were Registered

Number of Errors

Number of Duplicate IDs

Number of those who were Already Registered

Once completed, those constituents who were selected and marked as Registered will appear as registered for that Event.

Now when the Activity Name (actvname) is changed on the main Activity row, it will be globally changed throughout Events, wherever that name was referenced.

Table Name, Price and Section have been added to the Seating Information screen when inserting a table and will also be displayed when right-clicking the table after it has been inserted to view the Table Information.

Table Name - This may be any free text designation that you want to assign to the table.*

Price - Enter the cost of each of the seats at this table.*

Section - This may be any free text designation that you want to assign to the table.*

*The display of this table information will be truncated to fit the screen.

When linking an attachment to either an Event Action or an Event Activity Actions the attachments would not display.

Customer has an existing registration where the fee has already been paid. If they go back and edit the main record by adding a comment, for example, the fees will no longer display.

When entering a new registration for an event, the Solicitor field is not populating correctly. When viewing the registration following insert, the Solicitor field reads 'No Name Found for ID' followed by a 4 digit number, which is actually reglnkkey.

When modifying an Activity Item, the update screen that comes up has Event Items in the title instead of Activity Items.

You can define a default for Events;Actions;Tasks, but when you attempt to insert via default, the default is not presented to the user.

Double-clicking the column header of Guest Name or Registrant Name does not sort the names.

This enhancement also affects the Generic Import, Gift Import and Harris Import Utilities, Online Directory Login and Reporting as they have all been modified to work with the new encryption feature. In regards to Reporting, when corebio, gifts or credit card is the key file of a report, logic has been included to decrypt these fields as well.

The ability has been added to insert Correspondence rows to an Event Activity by using the Add Correspondence Utility. Under New Criteria select Custom Profile Criteria. Once the Custom Profile criteria screen is open make sure to change the Report Options to Utility and then select the Add Correspondence Utility from the Format/Utility dropdown list. Clicking New Line will allow you to define a set of criteria that will select the desired constituents. You may use any data table as the key table, and any set of criteria statements you want to define those constituents to be added as a Correspondence row to the Activity you have chosen.  

NOTE: In the past you were able to run this utility for Activities but no Activity Correspondence rows were created.

The Chart of Account table now appears in the Tables drop-down list when the Millennium Reporter menu item New Line is clicked. Selecting the Chart of Accounts table is only available when you create a new Custom Profile Criteria or edit existing criteria that already has Chart of Accounts as the key table, the first line of criteria. It cannot be added to criteria that start with another table, not even the gift table. Otherwise, if you have an existing criteria or create new criteria that start with a table other than the Chart of Accounts, you will receive the message; "The Chart of Accounts table cannot be added to a criteria that has been started with a different Key Table." Once those criteria have been created with the Chart of Accounts as the first line, any additional lines of criteria added or edited will also need to be from the Chart of Accounts. This means when that criteria is edited, the only table available in the New Line Tables drop-down list will be the Chart of Accounts.

When starting a New Custom Criteria for an Event and selecting Event Code as the first line of criteria, any subsequent Activity rows to be added to that criteria will only contain the list of Activities associated with that Event in the drop-down list. To create a new Event criteria under New Criteria select Custom Event then New Line and chose Event from the Tables drop-down list. When the fields are displayed click on Event Code then Next, select the Event you want to report on from the drop-down list. Once the first line of criteria is set to the Event Code you may select any other new lines to add. When you select Activity from the Tables drop-down list, that list will contain only the Activities related to that Event Code you chose.

When a prompted report runs, the prompted values entered by a user will be saved, and when the report is run again, the last prompted values will be displayed on the Run Report Page. If the Criteria prompts have been modified since the last run of the report, there will be prompts that will not have matching saved values.

NOTE: Reports with multiple prompts must have distinct prompt text.

Check boxes and List boxes have been added to the Run Report's page which will allow the interaction between the Prompt Values in Millennium Reporter and Crystal. For each Prompt, excluding the 'in the list of' and 'never in the list of' operators, the user will have the option of passing the Prompt Value to a Crystal Parameter. To pass the Prompt Value to Crystal, check the 'Pass Prompt Value to Crystal' box, and to the right, choose the 'Crystal Parameter' from the drop-down List box. For each Prompt there will be one check box and list box combination, unless the operator is 'between' or 'not between', then there will be two set of these fields for the prompts.

When a report is chosen to run, and the Priority is changed to 'Run After', a new item, 'Last Day of Month', has been added to the Frequency drop down list box. When this frequency is chosen, and a report is submitted the queue, QUEUE.EXE will adjust the date to take into account the last day of the month. It uses the last day based on the current month, and takes into account the Leap years and February.

On the System Options page there is an option that allows the system to display a higher Screen Resolution for the Edit Report Criteria page. The Default Screen Resolution item is automatically set to Low and displays the screen just as it has in the past. When the system administrator decides that a higher resolution would benefit everyone, changing the resolution to High will expand the Edit Criteria section allowing more criteria to display and less white-space.

Along with the Run and Delete buttons already on the Express Report Applet, we have added Save and Cancel which allow you to save any changes made to the Express Report without running it or cancel without making any changes and bringing you back to the main Express Reports page.

If you want to copy a criteria statement and/or lines of criteria from one report criteria to another separate report criteria, you may use the Clipboard function. This function will only be available when the Show Clipboard option has been set to yes on the Options, Default screen and will not be available for Events Reports.

When running a report to the Queue and viewing it's status before it has completed, you will see detailed information for a Destination of Printer or Export. They will now show

Printer: and the Printer Name

Export: and the Type of Export

where previously it only showed Printer and Export with no additional information.

A report_format_name field has been added to the report_descripts table which will display the Crystal report format name once the criteria is saved.

When the Reporting World is shown in the Millennium Explorer, one of the items is Run Criteria. This function allows you to locate an existing set of criteria that has been named and saved, and initiate its run. At the top of this Run Reports page there are seven headers displayed that allow you to sort the list of reports by. They are Name, Owner, Created, Run, Run By, Worktable, and Format. Clicking the header once will sort that piece of information in ascending order, clicking it again will sort the information in descending order. Please note that not all reports will have information for each of the headers, so when sorting in ascending order, those with blank report information will be shown first, unless sorted in descending order. See the Report Descripts table for detailed information on what those headers mean.

When navigating to View Report, Run Criteria, or Edit Criteria then selecting from Biographical, Comparison, Daily, Event, Financial, Mailing, Membership, Pledge or Tracking, you will see that the Report Groups are listed in three fields now instead of one long field.

When creating criteria and adding a new line to include certain custom lookups, the values were not available for selection. Specifically with regards to Lookup1, Lookup2 and Lookup3 for Membership, Membershipcards, Benefits, Benefitlevel, Subscription, Subscriptionlevel, and Donor.

Giftacdprt is available to select for criteria but the lookup values do not appear in the list to select from.

The selected values window disappears when creating criteria when the Reporting default option for Tables is set to Code.

When Options > Default > Tables is set to codes in reporting, a dash will appear before Titles in the criteria selection window.

Non-numeric entries in the giftcampyr field will cause the Create Years Utility to fail.

When creating a Custom Report, the Options > Report > Report Path is not defaulting to the User Default Report Path setting.

When creating a new line of criteria, clicking the white space above 'Tables' causes erratic behavior.

Report log shows that report completed selecting x number of records. The folder is created in the reports directory, but the folder contains no output (html or pdf). When user goes to Reporting>View Report and selects the report, a 'Page not found' screen appears.

Batch reports don't run if thousands of batches (over 4,800) exist in the lookup table and the batch number prompt operator is set to 'Equal To'.

Sites using batch numbers containing dashes cannot select batch at reporting prompt.

A utility has been created to allow users to import rows in to the eDirectory. This utility is launched by navigating to X:\Inetpub\wwwRoot\Mill\Tools\eDirectoryImport.exe using the Microsoft Windows Explorer (not the Millennium Explorer), and double clicking that file. It executes in its own window - not from within the standard Millennium interface.

Once you have clicked the eDirectoryImport.exe file from the Tools folder the Login applet will appear. There you will need to Enter the User Name and Password, and the Name of the IIS Server. This information is used to determine whether the site has appropriate licenses to use the utility, and for logging into Millennium. This utility may be run from any machine and by any user as long as that user has Select permissions on data tables, full permissions on the pending tables and the online_import_mapping table. Users must also have permissions to navigate to and open the input file(s) and permissions to delete files from the location of the exe.

The Log In page will include the link, 'For non-members, please click here to make

a donation'. This will allow any person to make a donation to your institution, not

just the constituents. When the link is clicked, the non-constituent will be able to put in their giving information and will also need to enter a limited amount of biographical information including affiliation (constituent type), name, address and email; the information similar to what is entered by an Millennium user when manually creating a constituent. This donor information will be used to create a new constituent profile. All biographical information must be completed before the gift or pledge donations from such donors can be integrated into the database. In the event that a constituent inadvertently uses that link to make a donation, you have the opportunity during the use of the Data Examiner to search the database using the name and address information that the donor provided, to confirm that the donation is from a new constituent, or to assign it to an existing constituent.

You may define the levels as to which a New Constituent can be matched upon before entering them in to Millennium. This item can be found when using the eDirectory Matching Levels item in the Setup area of eDirectory in the Tools World.

Once the Matching Levels have been set and the New Constituent information has been entered in the pending data table either through the Online Constituent Directory or by using the new eDirectory Import Utility, the Data Examiner will be used to insert the New Constituent information.

Your institution may accept donations from both constituents who have an online Directory userid and password (an authenticated user), and also from non-constituents - a person who was previously unknown to the institution, but who wants to contribute via the website (an un-authenticated user.)

Once a donation is made, the Data Examiner will be used to insert the Giving information from the Pending data table in to Millennium.

The size of the Chart of Accounts field, chart_comm, has been increased to 4000 characters.

A new System Options page has been added under Tools. This page holds some components that were previously stored on the System Information page, they are the Millennium System Options and Millennium Password Options. Though the System Options page is the same for the Browser and Windows interfaces, access to this page varies slightly between the two interfaces. In either interface, you must be logged on as the system administrator to access this page.

Browser - From the Millennium Explorer, open the Tools World and click on System Upkeep, and then System Options. The page will be shown in the display area.

Windows - From the main Millennium toolbar, click on the Tools item, and then System Configuration in the Millennium Explorer at the left. Note that this item is only shown for the system administrator's login. From the list of choices shown in the display area, click on System Options. The page will be shown in the display area.

When selecting the context menu from the display header to you will see options to Insert, switch to Long view, Sort or Close Menu.

If you select Long, you will see more of the information for each user, with a separator bar between each. Note that the passwords do not display on this page, or on the edit form for user information. The system administration may change someone's password, but not view the current password.

If you select Insert, it allows you to create a new Millennium user.

If you select Sort, the menu will expand and show you three options; Alphabetically by User, Alphabetically within Sql Group, Alphabetically within User Group. The Default Sort Order is Alphabetically within Sql Group, and when the Sort is changed to anything other than the default, and the IIS is reset, the Sort order will go back to the Default Sort Order.

Alphabetically by User - will sort by Name; the Millennium User

Alphabetically within Sql Group - will sort by Sql Group; the Database Group

Alphabetically within User Group - will sort by Group; the Millennium User Group

When clicking Search to locate the constituent, the system will return a list of all those constituents who conform to the information you entered, in that list, Constituent Type will be an available field to help you identify which constituent you want to select.

Browser - The utility will process the merge and return a message showing that the merge completed successfully and a link to delete the remaining Basic Data, Tracking and Death rows. If you want to delete the remaining data at the time the merge was completed you will need to click on the link 'Click here if you want to delete Basic Data, Tracking and Death information from the 'Merge From' ID.', if you do not want to delete the remaining rows for the merged constituent at that time, you must delete those rows manually later. You may then click on OK to merge additional constituent IDs or Cancel to close the utility.

Windows - The utility will process the merge from the Secondary ID to the Primary ID and return a message that the merge completed successfully. At this point you may click Yes to delete the Basic Data, Prospect and Death rows as that time, or No to delete the rows manually later. If Yes is chosen, a screen will appear letting you know that the remaining data has been deleted. If you chose No, you will receive a message stating that you must manually delete the data for that merged constituent manually. Click OK.

The values for these three fields in Millennium will be masked when viewing the constituent's data. Although, the insert and edit forms for those tables listed above will always display the full unencrypted data. The mask for each field is set via the System Options page under Tools.

In addition to the table fields you may chose from in the drop down list, you will now see two new rows you can add. The first is (FREETEXT) and the second is (LINE). After adding a row and looking in the drop-down list to add these two items that the list starts with (No Data), you must scroll up to select either (FREETEXT) or (LINE). Those two fields are considered wide fields and can only be placed one per row and must be on the left side of the display. You may use these two new features as many times as you want on the customized screen.

After adding giftkey to the Profiles > Profiles > Giving > Gifts > Main in Display Design viewing a gift, the giftkey field shows 'Lookup Not Found' and the truncated giftkey.

When linking an attachment to a Chart of Account Lookup table the attachments would not display.

When two constituents are merged, the giftgiveid and gifthonrid fields are not populated on the Merge To ID.

When attempting to open and close batches with an extremely large number of transactions (greater than 3000), the process will never complete.

The User Security settings were not saving causing a message that the number of users has exceeded the license was appearing even though the users were set up correctly to match the license agreement.

When inserting a new Attribute Type in Customizer the Table Links boxes are not defaulted to checked like they are in Templates.

The utility was looking for a specific .qqq file that was not taken out before the utility was released.

View Generator is spawning an error when using the concatenation operator in the SQL statement generated to create a view.

When two constituents are merged, a pledge and a write-off entered on the Merge From ID are not populating the giftasset and giftnetpv fields with the correct amounts on the Merge To ID.

Inserting a Chart of Accounts Lookup with a blank CAE returns an error.

Customizer displays incorrect data for Gift Batch Number Lookup.

Spouse relationships are not created when running the Generic Import Utility.

Only one table (Actions) showing up in the Table list box in Group Maintenance.

Events Seating Layout, Tables and Rows should not be available.

Membership Benefits in Lookup Tables name doesn't wrap causing you to scroll horizontally to the right.

In Customizer, the Fees > Credit Card form pulls from Profiles > Giving > Credit Card rather than Event > Fees > Credit Card.

Dues and Gifts Fast Data Entry - Main, Labels for Amount-Balance contains forbidden '&' character.

Customizing Name Hot Keys definition causes duplicate 'override' lines in Name insert form.

User Security settings are not carried over to the database after adding the role to the user through the back-end.

When trying to create, edit, or copy a group in Group Maintenance, the only table listed in the Table List is 'Actions'.

Setting 'Allow users to change their password:' to 'Y' forces users to change passwords even though 'Force users to change their password at next login:' is unchecked and all other password options are set to '0'.

Unable to change user password. Log file indicates millennium_admin password is not in sync on Primary and Replication Server.

When running the Datasync utility on the chart_of_accounts table, for instance, giftdate field is updated for all records, even if a change was not made.

Generic Import utility errors out when importing dBASE IV file.

When you link an attachment on the Chart of Accounts lookup table, the hyperlink to the document is not showing.

When creating a New Assignment, an IdeaAgent run-time error 339 occurs with the message "Component 'msmapi32.ocx' or one of it's dependencies are not correctly registered: a file is missing or invalid." This only occurred on a machine that did not have a MAPI compliant email installed on it, for example, MS Outlook.

The Report_Descripts table has been updated to include a report_type of 'P' for PDF and to include additional information with regards to all report types of 'P', 'Q', 'T', 'U' & 'V'.

Once the comparison has been chosen and the data has been selected to include in the criteria, there will be a section at the bottom with the header 'Special'. Here there will be two items displayed, Prompt and Relation to Constituent. Clicking the Prompt button will allow the selections in this section to be prompted for information during runtime. When the button is clicked you will notice that the in the data selection area the object box will display <a prompted reply>. Please note that Relation to Constituent is not currently functional and has been saved for future use.

It is important to note that the value of the securities (stocks) can change between the time of donation and the time when they are sold. Most times the amount the donor expects is recorded but may not add up to the actual amount received. Not requiring the securities to add up to the original gift amount allows the flexibility to record the donation as needed. Meaning that the system allows you to enter in an amount of the securities greater than the original gift amount.

SS# has been removed as an option to use for the Online Directory Login ID because the SS# is now encrypted. For the Login ID, you may choose to use any of the following; Preferred Name, Millennium ID Number and Random Generate. The option to use the SS# as the password is still available.

Social Security Number - This field may be used to narrow a constituent search. If data is entered in this text box, it must be an EXACT match for the data in the constituent's Basic Data row in the SS# field, wildcards cannot be used with this field.

Search Using Wildcards

Wildcards are particular symbols that the system will recognize as "substitutes" for another set of characters. Wildcards are available to use with any free text or Value-based (super) Lookup field on the Profiles Search screen with the exception of the Social Security Number field. They are not available for list boxes (drop-down lists).

Define Search Results Display

The Search Results Display contains two lists; Available Column and Saved Column. Each site will be able to add up to twenty fields from the Available Column list to the Saved Column list. When a field is added to the Saved Column list, it will be removed from the Available Column list. The Available Column lists all fields for Address, Name and Basic Data (excluding SS#).

5. CSV2 - These files have the following format: Each field within a record is separated by a comma. This is the format typically produced by Excel when saving the file as a .CSV. The file must contain a header record as the first row will automatically be skipped. There must be 124 fields per record, even if all fields do not contain data. If a field is blank, the comma for that field must still be present as a placeholder.

For Example, a CSV2 record might appear as:

1000,N,N,,19631226,A,I,news,m,M,,1982 (and so on)

Specific steps were written in to the documentation when a gift was given On Behalf of a constituent as well as given In Honor/Memory Of either a constituent or non-constituent.

Updated the membcomm field to show a length of 4000.

Under the section Registration Web Reports, Registrants with Guests was still written there, but should have been removed as it was removed from the software in a previous release.

Let it be known that differing behavior will occur when you either create a Honor/Memory Transaction at the time of the Payment or after the Payment has been made by using the Edit menu item Transactions and locating selecting either Add Honor for Non-Constituent or Add Honor for Constituent.

1. When a constituent or non-constituent Honor/Memory Transaction is created at the time the Pledge Payment is created, you will see the "Honor for..." or "In Memory of..." then the hyperlink text showing the second constituent's name at the bottom of the main Transaction section. Clicking the "Honor for..." or "In Memory of..."hyperlink will bring you to the "Honor for..." or "In Memory of..."constituent's transaction showing the full amount of the pledge transaction. This rule also applies when the transaction menu is selected from the main pledge transaction.

2. When a constituent or non-constituent Honor/Memory Transaction is created after the Pledge Payment is created by using the transaction menu to the left of the Pledge Payment, you will see the "Honor for..." or "In Memory of..." then the hyperlink text showing the second constituent's name at the bottom of the Pledge Payment Transaction row. Clicking the "Honor for..." or "In Memory of..."hyperlink will bring you to the "Honor for..." or "In Memory of..."constituent's transaction showing the payment amount of the pledge payment transaction.

If screens have been customized to include any Custom Lookup table (lookup1, lookup2, lookup3) and those screens are in turn used during the linking process, the custom lookups will only display on the primary row and not the secondary rows.

CAE Categories has been added to the list of lookup tables having Exceptions to the Standard Behavior.

Tab to the Code text box and enter the desired character (up to 6 characters) for the Code. See the Exceptional Behavior section of this topic for the following lookup tables: Account CAE, CAE Categories, Dues Batch Number, Gift Batch Number, Titles, ZIP Code.

Clicking the Hot Keys radio button will allow you to customize the hot keys for any field on that screen. If you do not have a Customized Long display you will receive the message; "Hot Keys are tied to the Long display. You must first create a Customized Long display before you may customize your Hot Keys." Once the Customized Long display has been saved you may now click on the Hot Keys radio button. To create a Hot Key, click on the row that contains the field you want to use, the Label(s) will be filled in with items for that row and you will need to place an '&' before the letter you would like to set as the Hot Key (without the quotation marks). Most fields in Millennium already have default Hot Keys set up, however you are allowed to change them as you want. If the '&' is removed from the Label, the Hot Key will default to the first letter of that label.

It is important to note that if the system administrator does set the 'Allow users to change their password' to Yes and update any of the four items below, even if the 'Force users to change their password at next login' is not checked, the users will be forced to initially change their password in order to validate that their passwords follows and complies with the settings set by the system administrator.

This will result in a negative deductible (giftdeduct) amount and a zero non-deductible (giftnonded) amount on the gift types of 'p', 'e', 'mp', 'o', 't', 'sp', 'a', 'r', and 'c'.

Removed Installing_and_Running_the_Queue_As_a_Service.htm and Queue_Admin.html from the help files and incorporated them in to the existing Queue.html and generalized the documentation to say the Millennium Release Install CD instead of the current version.

SQL sites only: As of Millennium version 7.4, millennium_admin was added to the system administrators Servers Roles in order to enable the functionality for the new E72 enhancement, allowing users to change their own password.

Set to "Y" if a "Spouse" relationship should be created between this record and the next, otherwise, set to 'N'.

The protorowtype field has been added as part of the prototype_name table listed in the documentation.

Protorowtype holds the type of the prototype, and this field is only used with tables such as relations (constituent vs. non-constituent) and Corebio (individual, corporation, or foundation).

Three entries were missing from the Sample DB under the Dues Types Lookup Table; Pledge Credit Trans. (r), Pledge Credit Trans. (rj), Pledge Credit Void (rv).

The Social Security #, Credit Card #, and Bank Account # will be encrypted in the following tables: corebio, corebio_pending, def_corebio, gifts, def_gifts, dues, def_dues, creditcard, def_creditcard, and ecommerce_pending.

benefit_type: table_one

publication_name: table_one

membership_benefits: table_one

membership_publications: table_one

membership_type: mem_lifefl

evntlodg

evntspec

evnttrans

evnttourn

evntdeactv

actvspec

actvtourn

actvstndrd

actvorder

phndncflg

This field is a flag to be used with Correct Call to indicate "Do Not Call". All sites will be able to view this field, but it will only be used and updated by Correct Call. (system field)

The following fields have been added:

ecomallamt

ecomallflg

ecomallkey

ecomallrst

ecombill

ecomcccomm

ecomgcmpyr

ecomgcomm

ecomhfirst

ecomhlast

ecomhmiddl

ecomhsuffx

ecomhtitle

ecomjoint

ecommfirst

ecommlast

ecommmiddl

ecommsuffx

ecommtchco

ecommtitle

ecomplgamt

ecomplgdt

ecomplgrst

ecomsus01

ecomsus02

ecomsus03

ecomsus04

ecomsus05

ecomsus06

ecomsus07

ecomsus08

ecomsus09

ecomsus10

ecomsus11

ecomsus12

ecomsusamt  

ecomtamnt

ecomtender

ecomverif

ecomvouchr