Lookup Tables Layouts

This field holds the characters that are actually stored in the field in the constituent's data row. These characters identify the lookup table entry (the row in the lookup table) so that additional fields in the lookup may be associated with the data row.

This field holds a descriptive version of the lookup table entry. This information is usually used (instead of the code) when the constituent's data is displayed. The value may also be used instead of the code in data entry or in a formatted report.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.

This field is reserved for future use by Millennium.

This field is reserved for future use by Millennium.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This field flags the entry to make it available for use in Attribute rows linked to Basic Data rows.

This field flags the entry to make it available for use in independent Attribute rows.

This field flags the entry to make it available for use in Attribute rows linked to Employment rows.

This field flags the entry to make it available for use in Attribute rows linked to Education rows.

This field flags the entry to make it available for use in Attribute rows linked to Tracking rows.

This field is a flag, used to signify that a particular entry in this lookup table should be made available for use in the Online Constituent Directory module. If this flag is 'Y', when the lookup table is included on data maintenance forms for the Online Constituent Directory website, the entry will be included in the pull-down list for the lookup table. If the flag is 'N', then this entry will be suppressed from that pull-down list. This field has no impact on regular Millennium data maintenance.

This field holds the characters that are stored in the Default Division field in the constituent's Basic Data row, or in the Division column in the constituent's Ratings row. These characters identify the lookup table entry (the row in the lookup table) so that additional fields in the lookup may be associated with the data row.

This field holds a descriptive version of the lookup table entry, and it is also stored in the Default Division Name in the constituent's Basic Data row, or the Division Name column in the constituent's Ratings row. This information is usually used (instead of the code) when the constituent's data is displayed. The value may be used instead of the code in data entry or in a formatted report.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.

This field is not used for any specific Millennium defined purpose.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This field is a flag, used to signify that a particular entry in this lookup table should be made available for use in the Online Constituent Directory module. If this flag is 'Y', when the lookup table is included on data maintenance forms for the Online Constituent Directory website, the entry will be included in the pull-down list for the lookup table. If the flag is 'N', then this entry will be suppressed from that pull-down list. This field has no impact on regular Millennium data maintenance.

This field holds the characters that are actually stored in the field in the constituent's data row. These characters identify the lookup table entry (the row in the lookup table) so that additional fields in the lookup may be associated with the data row.

This field holds a descriptive version of the lookup table entry. This information is usually used (instead of the code) when the constituent's data is displayed. The value may be used instead of the code in data entry or in a formatted report. In this lookup table, the value is generally used for the name of the Account.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution. This field is standard in all lookup tables, however in this case, it is labeled Type, so that it is not confused with another field, the chart_grp field which is labeled Group. (That field may also be used in this lookup table (only) to further classify or group table entries.)

This field holds the Account Number that is assigned to this lookup table entry. Entries from this lookup table may be identified to the system by the code (chart_code), the name (chart_val), or the Acct # (chart_acct).

This field is driven by the Account CAE lookup table to indicate the way that the funds in this account are to be used, in a coding system that is consistent with the preparation of the annual report to the Council for the Advancement of Education. If your institution does not report to the CAE, you do not need to use this field.

This field holds the ID Number of the Division (or the person in the Division) within the Institution that is responsible for this account, and the one that should be notified (if the chart_ntfy flag is Y).

This field acts as a flag to indicate that the Department within the institution that is responsible for this account wants to be notified when donations are received for this account.

This field reflects the Division within the institution that is associated with this account.

This field is used to track a monetary goal or target amount that was set for this account.

This field is not in use at the present time.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field tracks the Campaign goal designation associated with this account number.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This field tracks the Campaign that is associated with this account number.

During data entry for Gift or Dues Transactions, IF no data is entered for the Campaign field, the system will attempt to determine an appropriate campaign.

It will first check the Default flag in the Solicitation lookup entry that was used. If it is "Y", then the Campaign from the Solicitation entry is used.

If not, the Chart of Accounts is checked. If the Default field from this lookup table entry has a "Y" (and all the preceding circumstances are met), then the Campaign from this Chart of Accounts entry will be copied into the Campaign field in the Gift or Dues Transaction row.

This field may be used to hold the account number in a general ledger system of the credit account that is associated with this account.

This field may be used to hold the account number in a general ledger system of the debit account that is associated with this account.

This field may be used to track the beginning date for this account.

This field may be used to track the ending date for this account.

This field may be used to identify another entry in this lookup table that is associated with the current account in the following way: If one account is used for the receipt of primary donations, then the associated account is used for any matching funds that are received as a result of the primary donations. This field (chart_macc) holds the code from another entry in this lookup table (also Chart of Accounts) that should be used for matching donations. The chart_mval field holds a copy of the name of the specified entry.

This is a free text comment that may be attached to this lookup table entry.

This field holds a version of the name of this account (chart_val), formatted by the system for use in sorting.

This field is used to classify or describe accounts in some way (that is not accomplished by another column). The use of this field is completely at the discretion of your institution.

This field flags the system for the presence or absence of an attachment (a document, spreadsheet, or any other object).

This field is used to flag an account number so that the Deductible Amount for any Transaction that uses this Account Number will automatically be calculated by deducting 20% from the Total Amount field for the Transaction. This calculation occurs if the Automatic 80/20 Quid is Accepted during data entry. If it is Declined, the Deductible Amount will not be reduced by 20%.

When another entry in the Chart of Accounts is chosen as a linked, matching account, this field holds a copy of the Account Name from that entry. The chart_macc field holds a copy of that entry's code. See chart_macc for additional information.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

This custom field may be defined and used by your institution to track any free text information associated with this data row.

This field is used to track the Department within the institution that is to be associated with this account. Note that this field is driven by the Department lookup table, while the chart_dept field is used to store the 10 character Millennium ID number of the department or the person within the department who is to be the point of contact.

This field is a flag, used to signify that a particular entry in this lookup table should be made available for use in the Online Constituent Directory module. If this flag is 'Y', when the lookup table is included on data maintenance forms for the Online Constituent Directory website, the entry will be included in the pull-down list for the lookup table. If the flag is 'N', then this entry will be suppressed from that pull-down list. This field has no impact on regular Millennium data maintenance.

This field is used to associate a Paya Payment Solutions merchant account with this account. This field is driven by the merchant_account system table. When a merchant account name is selected for this Chart of Accounts account, this field will be populated with that merchant account's id. See Note for the chart_mkey field.

This field is used to associate a Paya Payment Solutions merchant account with this account. This field is driven by the merchant_account system table. When a merchant account name is selected for this Chart of Accounts account, this field will be populated with that merchant account's unique key.

Note: While this field is associated with the merchant_account system table, there are no check constraints present. However, the Millennium software will show, on both the Chart of Accounts insert and Chart of Accounts update forms, only the names for the merchant accounts that are maintained by your institution .

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any date information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to flag this data row for any purpose.

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

ASC

ASC

ASC

This field is a flag, used to signify that a particular entry in this lookup table should be made available for use in the Online Constituent Directory module. If this flag is 'Y', when the lookup table is included on data maintenance forms for the Online Constituent Directory website, the entry will be included in the pull-down list for the lookup table. If the flag is 'N', then this entry will be suppressed from that pull-down list. This field has no impact on regular Millennium data maintenance.

This field is holds the Code from the Solicitation lookup table that is responsible for this Correspondence piece.

This field is holds the Value (name) from the Solicitation lookup table that is responsible for this Correspondence piece.

This field is used to hold a District that you want to associate with a non-USA country.

This field is used to hold a Territory that you want to associate with a non-USA country.

This field is used to hold a Region that you want to associate with a non-USA country.

This field holds a descriptive version of the lookup table entry. This information is usually used (instead of the code) when the constituent's data is displayed. The value may be used instead of the code in data entry or in a formatted report.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.

This field may be used to track the number of pieces or transactions that make up the Batch.

This field may be used to track the total amount of this Batch.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This is a free text comment that may be attached to this lookup table entry.

This field is available to allow a site to associate any money amount with a batch. For example, you might want to associate an amount with a batch, using different types of transactions than those used to calculate the table_amt2 field. Data for this field is NOT system-generated or maintained.

This field is available to allow a site to flag a batch, to indicate whether Membership cards have or have not been generated for the transactions in this batch. Data for this field is NOT system-generated or maintained.

This field is available to allow a site to flag a batch, to indicate whether acknowledgment letters have or have not been generated for the transactions in this batch. Data for this field is NOT system-generated or maintained.

This field holds a descriptive version of the lookup table entry. This information is usually used (instead of the code) when the constituent's data is displayed. The value may be used instead of the code in data entry or in a formatted report.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.

This field may be used to track the number of pieces or transactions that make up the Batch.

This field may be used to track the total amount of this Batch.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This is a free text comment that may be attached to this lookup table entry.

This field is available to allow a site to associate any money amount with a batch. For example, you might want to associate an amount with a batch, using different types of transactions than those used to calculate the table_amt2 field. Data for this field is NOT system-generated or maintained.

This field is available to allow a site to flag a batch, to indicate whether Membership cards have or have not been generated for the transactions in this batch. Data for this field is NOT system-generated or maintained.

This field is available to allow a site to flag a batch, to indicate whether acknowledgment letters have or have not been generated for the transactions in this batch. Data for this field is NOT system-generated or maintained.

The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (system field)

The first side of an acceptable relationship pair. Codes must be active relationship type codes from the relationships lookup table in order to be displayed in the Is A list box during relation inserts and updates.

The second side of an acceptable relationship pair. Codes must be active relationship type codes from the relationships lookup table in order display in the Whose list box during relation inserts and updates.

This field is reserved for future use by Millennium.

This field is reserved for future use by Millennium.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this row.

This field holds the User ID of the last user to edit this row.

This field holds the User Group letter of the last user to edit this row.

This field flags the row as active or inactive for further data entry or maintenance purposes.

ASC

ASC

ASC

This field is a flag, used to signify that a particular entry in this lookup table should be made available for use in the Online Constituent Directory module. If this flag is 'Y', when the lookup table is included on data maintenance forms for the Online Constituent Directory website, the entry will be included in the pull-down list for the lookup table. If the flag is 'N', then this entry will be suppressed from that pull-down list. This field has no impact on regular Millennium data maintenance.

For use primarily with Millennium Favorites functionality and Favorites On Demand reports, this field is used to denote a relationship type as a Prospect Management relationship.

A relationship type can be assigned to a Prospect Management Role of Assistant/Researcher, Prospect, Manager and Director.

This field holds the code that is actually stored in the field in the constituent's data row. These characters identify the lookup table entry (the row in the lookup table) so that additional fields in the lookup may be associated with the data row.

This field holds a descriptive version of the lookup table entry. This information is usually used (instead of the code) when the constituent's data is displayed. The value may be used instead of the code in data entry or in a formatted report.

This field is driven by the Table Groups lookup table and may be used to classify entries into groups based on the nature of the entries, the office responsible for the entry, or any other grouping that is useful at your institution.

This field may be used to signify the number of mailing (or other) pieces that were produced for this solicitation.

This field represents the cost per piece for this solicitation. It is generated by the system and is the sol_tlcost (total cost) divided by the sol_pieces (number of pieces).

This field may be used to track the last date that this solicitation was used.

This field may be used to track the printing costs for this solicitation.

This field may be used to track any other costs associated with this solicitation.

This field may be used to track the postage costs for this solicitation.

This field represents the total cost associated with this solicitation. This field is generated by the system and is the sum of the sol_print, sol_other, and sol_postge columns.

This field may be used to record the date that material was printed.

This field may be used to record the date that other costs were incurred (those that are shown in the sol_other column).

This field may be used to record the date that postal costs were incurred.

This field is used to track a monetary goal or target amount that was set for this solicitation.

This field is not in use at the present time.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field holds the date of the last edit to this row and is automatically generated by the system.

This field holds the User ID of the last user to edit this row and is automatically generated by the system.

This field holds the User Group letter of the last user to edit this row and is automatically generated by the system.

This field flags the row as active or inactive for further data entry or maintenance purposes.

This free text field holds the name of the manager of this solicitation effort.

This field shows the date that this solicitation was closed.

This is the campaign that is responsible for this solicitation. This field is driven by the Campaigns lookup table.

This is the year of the campaign that is responsible for this solicitation.

If this field is flagged as (Y), and if the Campaign field is left blank during the data entry of a Gift or Dues Transaction row, then the sol_camp and sol_campyr data are automatically copied into the Gift or Dues Transaction row. If either of those conditions is not present, no automatic copying of the sol_camp or sol_campyr data occurs.

This is a free text comment that may be attached to this lookup table entry.

This field specifies an entry in the Division lookup table that you may want to associate with this Solicitation.

This system-generated field is used to track the fact that this Solicitation has linked Membership Benefits, where one or more are defined as Standard.

This system-generated field is used to track the fact that this Solicitation has linked Membership Benefits, where one or more are defined as Optional.

This system-generated field is used to track the fact that this Solicitation has linked Membership Publications, where one or more are defined as Standard.

This system-generated field is used to track the fact that this Solicitation has linked Membership Publications, where one or more are defined as Optional.

This field is used by the system's Task Integration with Outlook functionality. If a task of this type is flagged to integrate with Outlook's calendar, the value of this field is 'C'. If flagged to integrate with Outlook's Tasks, the value of this field is 'T'. If a task of this type cannot be integrated with Outlook, the value of this field is 'N'.

This field holds the characters that are actually stored in the field in the constituent's data row. These characters identify the lookup table entry (the row in the lookup table) so that additional fields in the lookup may be associated with the data row.

This field holds the name of the city that is associated with this US ZIP Code. This information is included as part of the standard data that is provided when Millennium is installed at your institution.

This field holds the two letter code for the US state that is associated with this ZIP Code. This information is included as part of the standard data that is provided when Millennium is installed at your institution.

This field is reserved for future use.

This field holds the name of the county that is associated with this US ZIP Code. This information is included as part of the standard data that is provided when Millennium is installed at your institution.

This field holds the entry from the Districts lookup table that your institution wants to associated with this ZIP Code. Entries in the Districts lookup table may be defined in any way that your institution wants.

This field holds the entry from the Regions lookup table that your institution wants to associated with this ZIP Code. Entries in the Regions lookup table may be defined in any way that your institution wants.

This field holds the entry from the Territories lookup table that your institution wants to associated with this ZIP Code. Entries in the Territories lookup table may be defined in any way that your institution wants.

This geographical information for US ZIP Codes is part of the standard data that is provided when Millennium is installed at your institution.

This geographical information for US ZIP Codes is part of the standard data that is provided when Millennium is installed at your institution.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Maintenance Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field is used to track Access Group information for security purposes.

This field holds the date of the last edit to this table entry. This information is automatically generated by the system.

This field holds the User ID of the last user to edit this table entry. This information is automatically generated by the system.

This field holds the User Group letter of the last user to edit this row. This information is automatically generated by the system.

This field holds the Time Zone that is associated with this US ZIP Code. This information is included with the standard data that is provided when Millennium is installed at your institution.