Millennium Data Tables Index
Millennium uses tables to maintain and display constituent data.
The following table provides a list of Millennium data tables, a short description of each data table, and a link to more information about the data table. The name of the table as it physically exists in the Millennium database is listed in parenthesis under the table name.
For more information about table numbers and names as they exist in the Millennium database, see Table Numbers.
| Table Name | Description | For more information, see... |
|---|---|---|
|
Actions (actions) |
Allows you to describe the actions that should be taken for a constituent in order to further the goals of the institution. | Actions |
|
Activities (activity) |
Allows you to track individual activities related to an event. | Activity |
|
Addresses (address) |
Allows you to maintain address information for a constituent. | Addresses |
|
Advisories (advisories) |
Contains a row for each advisory generated by the system. | Advisory Notifications |
|
AFO Forms (afo_forms) |
Contains the Community Brands Fundraising Online form names to be displayed in Millennium, and the code snippets that are added to the constituent's page in the Online Constituent Directory. | Community Brands Fundraising Online Forms |
|
Attachments (attachments) |
Allows you to track the link between an attachment file, such as a document, scanned image, graphics file, spreadsheet, or audio/video file, and the data row to which it is attached. | Attachments |
|
Attendance (attendance) |
Allows you to maintain information about any number and combination of activities that a guest at an event may choose to attend. | Activity Attendance |
|
Attribute (attribute) |
Allows you to maintain additional constituent information that is specific to your institution. | Attribute |
|
Audit (audit_tablename) |
Audit tables track the changes made to fields in data tables for which audit logging is enabled. These tables are populated automatically. | Audit Log |
|
Basic Data (corebio) |
Allows you to maintain basic data for an individual constituent, corporation, or organization. | Basic Data |
|
Benefits (benefits) |
Allows you to specify the benefit package that a constituent with a membership receives in conjunction with the membership. | Benefits |
|
Benefit Level (benefitlevel) |
Membership Benefit Level data is stored in the benefitlevel data table. | Benefit Levels |
|
Bookmarks (bookmarks) |
Contains information about each user's bookmarked items. This table is automatically populated when a user creates a bookmark. | Bookmarks |
|
Circles (circles) |
Allow you to track relationships between a constituent and a group of constituents. | Circle Membership |
|
Citizenship (nationality) |
Allows you to specify information about a constituent's nationality, citizenship, visa, passport, and more. | Citizenship |
|
Comments (comments) |
Allows you to enter brief, free text information about a constituent. | Comments |
|
Contact Info (contactinfo) |
Allows you to maintain contact information such as a primary salutation, address, phone number, and email address for any contact stored in your Relation data table. | Contact Info |
|
Correspondence (correspondence) |
Allows you to track details regarding any written correspondence between an institution and a constituent. | Correspondence |
|
Coverage (coverage) |
Allows you to maintain Coverage relationships between constituents. A coverage relationship is a relationship where one constituent covers donations for another constituent. The covered constituent receives a soft credit whenever the other constituent makes a donation. | Coverage |
|
Credit Card (creditcard) |
Allows you to enter credit card and bank draft information for gifts, dues, or registration fees. | Credit Card |
|
Custom Bio (custombio) |
Allows you to maintain unique or highly specialized constituent data that does not readily fit into other standard data tables. | Custom Bio |
|
Custom Prospect (customprospect) |
Allows you to maintain unique or highly specialized data for a prospect that does not readily fit into any other standard data tables. | Custom Prospect |
|
Death (death) |
Allows you to record information concerning the place and time of death for an individual constituent, or information concerning the dissolution/disbanding of a corporation or foundation. | Death |
|
Demographics (demogrph) |
Allows you to maintain evaluative ratings about some aspect of a constituent's possible ability to give. This information is typically provided by a third-party. | Demographic |
|
Dues Detail (dues) |
Allows you to track donations that have been received or that are anticipated as a result of a constituent's membership in an organization. | Dues Transactions |
|
Education (school) |
Allows you to maintain information about an individual constituent's attendance at a particular school, college, university, or other training institution, and the specific degree, if any, associated with that attendance. | Education |
|
Employment (jobs) |
Allows you to maintain information about an individual's current job, as well as past jobs. | Employment |
|
Event (events) |
Allows you to maintain information about a specific social, fund-raising, or other type of function sponsored by an institution. | Events |
|
Event Actions (event_actions) |
Allows you to specify the jobs or actions needed to successfully sponsor an event or activity within an event. | Event Actions |
|
Event Guest (event_guest) |
Allows you to specify primary information for guests within an event registration. | Guest Items |
|
Event Income (event_income) |
Allows you to track registration fees for an event. | Event Income - Fee |
|
Event Solicitor (event_solicitor) |
Allows you to maintain information about solicitors, or staff members and volunteers, who ask others to commit to attend, pledge, assist, or in some other way support an event. | Event Solicitor |
|
Expenses (expenses) |
Allows you to track information about the nature and amount of expenses for a specific event or event activity. | Expenses |
|
Finance (finance) |
Allows you to maintain information about the financial holdings, revenues, and profits for an individual, corporation, or foundation. | Financials |
|
Gift in Kind (giftinkind) |
Allows you to track donations of items such as time, effort, expertise, or company products. | Gift in Kind |
|
Giving (gifts) |
Allows you to track gifts that have been received or that are anticipated as a result of a constituent's donation to your institution. | Gift Transactions |
|
Guest Items (event_guest) |
Allows you to track information for each guest (constituent and non-constituent) registered for an event independently of the other guests under the same registration. |
|
|
Honoree (honoree) |
Allows you to maintain information about donations made in honor of a person, organization, or pet. | Honoree |
|
Internet Addresses (internetaddress) |
Allows you to maintain information about a constituent's email and web page addresses. | Internet Address |
|
Items (items) |
Allows you to maintain a catalog of all merchandise associated with an event or event activity. | Items |
|
Match Foundation (matchfoundation) |
Stores gift matching information. | Correct Gift Match Tables |
|
Match Parent (matchparent) |
Stores gift matching information. | Correct Gift Match Tables |
|
Match Subsidiary (matchsubsidiary) |
Stores gift matching information. | Correct Gift Match Tables |
|
Media Reference (media) |
Allows you to maintain information about media appearances made by or media references to a constituent. | Media |
|
Membership (membership) |
Allows you to maintain membership information for a constituent. | Membership |
|
Membership Benefit Level (benefitlevel) |
Allows you to track information about benefit packages available to a constituent based on the constituent's membership. | Benefit Level |
|
Membership Cards (membershipcards) |
Allows you to maintain information about membership cards provided to a constituent with a membership. | Membership Cards |
|
Membership Subscription Level (subscriptionlevel) |
Allows you to maintain information about the subscription packages available to a constituent based on the constituent's membership. |
|
|
Name (name) |
Allows you to maintain information about the name of a constituent, such as a preferred name, formal name, and maiden name. | Names |
|
Organizer (organizer) |
Allows you to maintain information about constituents who are event organizers. | Organizer |
|
Other Info (other_info) |
Allows you to maintain information about equipment needed for an event or activity, accommodation arrangements for an event guest, event guest special needs, schedules and assignments for guests participating in tournaments, and event guest transportation arrangements. | Other Info |
|
Payments (payments) |
Allows you to create and track an anticipated schedule of payments for a pledge. | Payments |
|
Planned Gift/Proposal Ratings (pgrating) |
Allows you to maintain a rating system that evaluates the likelihood that a constituent will fund a request. | Proposal/Planned Gift Rating |
|
Phone Numbers (phone) |
Allows you to maintain information about a constituent's home, business, cell, fax, and pager phone numbers. | Phone Numbers |
|
Planned Giving (plannedgifts) |
Allows you to maintain information about a planned gift a constituent has made or is planning to make to your institution. | Planned Gift |
|
Proposals (proposal) |
Allows you to maintain information about a proposal for a major gift your institution is proposing to a constituent. | Proposal |
|
Quid Pro Quo (quidpro) |
Allows you to maintain information about items of appreciation received by a constituent as a result of a donation. | Quid Pro Quo |
|
Ratings (rating) |
Allows you to maintain information about a constituent's general interest and ability to contribute to a specific campaign. | Ratings |
|
Receipts (receipts) |
Allows you to enter a receipt number and date for a gift or dues payment. This functionality is currently not available. | Receipts |
|
Relationships (relation) |
Allows you to maintain information about familial, professional or corporate, and fund raising relationships between constituents. | Relation |
|
Registration (registration) |
Allows you to maintain information about a constituent who registered for a specific event. | Registration |
|
Research Source (research_source) |
Allows you to schedule and monitor the progress of donor research activities performed for individual constituents. | Research Source |
|
Screening (screener) |
Allows you to maintain information about the results of a constituent screening session, or session designed to segment a prospect pool. | Screening |
|
Seating Assignments (seating_layout) |
Allows you to map the seating arrangement for an activity. | Seating Layout |
|
Securities (securities) |
Allows you to maintain information about donations of stock or bond certificates. | Securities |
|
Serial Receipts (serialreceipt) |
Allows you to store data about Serialized Tax Receipts in persistent data tables for audit purposes. Maintaining persistent receipt data is a requirement of the Canada Revenue Agency. | Serial Receipts |
|
Serial Receipts Payments (serialreceipt_payment) |
Allows you to view information about the gifts and dues transactions that are linked to serialized tax receipts. | Serial Receipts |
|
Solicitor (solicitor) |
Allows you to maintain information about event solicitors, or staff members or volunteers who ask other to commit to attend, to pledge, to assist, or in some way support an event or institution. | Event Solicitor |
|
Speaker (speaker) |
Allows you to maintain information about a speaker or presenter for an event or an activity within an event. | Speaker |
|
Subscriptions Received (subscription) |
Allows you to specify the subscription package that a constituent with a membership receives in conjunction with the membership. | Membership Subscription |
|
Summaries (memories) |
Allows you to view cumulative, summary, or tallied information calculated by using information stored in the Gift or Dues Transaction tables. | Summaries |
|
Sustainer Payments (sustainerpayments) |
Allows you to maintain information about anticipated payments on sustainer pledges, which are open-ended promises in which the donor commits to donating a specified amount on a defined schedule for an indefinite time period. | Sustainer Pledges and Payments |
|
Tasks (tasks) |
Allows you to track past, current, and future assignments or responsibilities assigned to a constituent. | Tasks |
|
Tracking (donor) |
Allows you to maintain information about the status or progress of the research performed on a specific constituent. | Tracking |