Introducing Lookup Tables
Lookup Tables are used throughout Millennium as a means of standardizing information. By entering data using concise lookup table entries, it is possible to retrieve that data in the most efficient and accurate manner. Millennium data tables together use more than one hundred lookup table-driven columns.
When Millennium is installed, many lookup tables will already have some entries defined. Some of these are considered Required Entries because they trigger automatic features. Other entries may also be present as a result of your data conversion. In most cases, you may add entries to lookup tables as needed by your institution. The exceptions will be noted in the lookup table's individual descriptions.
Millennium uses six sets of lookup tables. Each set is accessed for lookup table data maintenance purposes by using .
- The Batch Control item provides access to the Gift Batch Numbers and the Dues Batch Numbers lookup tables.
- The Custom Lookups item provides access to the lookup tables that control the custom data fields xxxlook1, xxxlook2, and xxxlook3 in each data table.
- The Event Lookups item provides access to the lookup tables that are used by the Events data tables.
- The Membership Lookups (Mbrshp Lookups) item provides access to the lookup tables that are used by the Membership data tables within the Profiles World.
- The Profile Lookups item provides access to the lookup tables that are used by the data tables within the Profiles World, except for those used by the Membership tables.
- The Report Groups item provides access to one special lookup table used in the Reporting World to provide an additional level of Report classification.
Millennium also uses the Circle Definition table to create and maintain Circles and Circle Members. While technically a lookup table, it actually functions as a sub-World of the Profiles World. The Circle Definition table can be accessed by using Millennium Explorer, .