Membership 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 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 is used to track the value of a single instance of this Benefit Type.

This field is used to track the total number of instances of this Benefit Type that are available to the institution (a starting inventory).

This system-generated field is used to track the number of Benefits of this type that have been assigned to constituents (and have been accepted).

This field is used to signal the system to also create a Quid Pro Quo row when a Benefit row of this type is created.

This field is used to track the Membership Type with which this Membership Benefit is associated.

This field is used to track the Benefit Type that describes this Membership Benefit.

This system-generated field is a copy of the value of a single instance of a Benefit of this type, as defined in the Benefit Type lookup table entry.

This field is used to describe the number of instances of a Benefit that will be made available to a Membership Benefit of this type.

This system-generated field is calculated to be the total value of the Benefits that are offered by this Membership Benefit, (table_vben times table_nben)

This field is used to indicate whether this Membership Benefit is standard for all constituents who hold a Membership of the corresponding type, or whether it is an optional Membership Benefit. A Standard Benefit triggers the automatic creation of a Benefit Level row for the constituent, but an Optional Benefit must be selected in order for such a row to be created. (Standard Benefits may be marked as 'declined' if appropriate.)

This system-generated field is used to signal the system to automatically generate a Quid Pro Quo row based on the Benefit specified in this Membership Benefit lookup row.

This field is used to track the code from the Solicitation lookup table for the Solicitation associated with this Membership Benefit.

This system-generated field tracks the name (value) of the Solicitation that was specified in the table_sol field.

This field holds a copy of the code from the Membership Type lookup entry with which this Membership Publication row is associated.

This field holds a copy of the code from the Publication Name lookup entry with which this Membership Publication row is associated.

This system-generated field holds a copy of the monetary value of a single subscription of the Publication identified in the table_pub field, as copied from the Publication Name lookup table.

This field is used to track the number of subscriptions to the Publication identified in the table_pub field, that make up this Membership Publication package.

This system-generated field contains the total monetary value of this Membership Publication package. It is calculated as the table_vsub multiplied by the table_nsub.

This field is used to indicate whether this Membership Publication is Standard for all constituents who have this Membership, or whether it is Optional.

This field is used to track the code for the Solicitation with which this Membership Publication is associated (if any).

This system-generated field holds a copy of the name (value) for the Solicitation identified in the table_sol field.

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.

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 is a free text comment that may be attached to this lookup table entry.

This field is used to indicate whether this Membership Type is primary or secondary.

This field is used to track the maximum amount that is to be associated with this Membership Type.

This field is used to track the minimum amount of a transaction that will qualify a constituent for a Membership of this Type.

This field is not in use at the present time.

This field is used to classify this Membership Type. Standard classifications are: Life, Single, Family, Joint, Joint Life, and Joint Family.

This field is used to track the numbers of months that comprise a standard membership time period for this Membership Type.

This field is used to track the number of months (if any) that the institution wants to offer as a grace period following the Membership Duration, during which time the Benefits and Subscriptions will still be made available to the constituent.

This system-generated field is calculated to be the sum of the Duration plus the Lapse Period. This field is used by the system when determining whether a Membership may be considered a Renewal or whether it should be considered a Rejoin.

This field is used to track the nature of the Renewal system for this Membership Type. The system possibilities are:

RF - Rolling Membership, First of Month

RE - Rolling Membership, End of Month

RS - Rolling Membership, Same Day

RB - Rolling Membership, End of Month Backward

RW - Rolling Membership, End of Month Forward

CF - Calendar Year Membership, First of Year

CE - Calendar Year Membership, End of Year

FE - Fiscal Year Membership, End of Year

This field may be used to track a day within the month when a Rolling Membership, First of Month should advance to the Renewal Date to the first day of the following month (in accordance with the Duration).

This field may be used to track the number of Membership Cards that are to be allotted to a Membership of this Type.

This field may be used to assign a unique number for the purpose of establishing a hierarchy of Memberships at your institution. Since the levels must be unique, you should define these levels to allow for growth. The system will interpret the Membership Type with the highest value for this field to be the highest level Membership Type.

This field is used to track the date on which this Membership Type was established in the institution.

This field may be used to track the date on which this Membership Type was closed.

This system-generated field flags the system that there is one (or more) standard Membership Benefit row that is linked to this Membership Type.

This system-generated field flags the system that there is one (or more) optional Membership Benefit row that is linked to this Membership Type.

This system-generated field flags the system that there is one (or more) standard Membership Publication row that is linked to this Membership Type.

This system-generated field flags the system that there is one (or more) optional Membership Publication row that is linked to this Membership type.

This field acts as a flag to the system, that any matching gift monies that are linked to the Gift or Dues transaction, should also be added to the transaction amount that is used to determine a 'Best Fit' Membership

This field is used to track the timing of the activation of this Membership Type. The possibilities are:

When the Pledge is made.
When the first Pledge Payment is received.
When the final Pledge Payment is received.

This field is used to designate the first month of the fiscal year for this Membership Type.

This field is used to track the monetary value of a single subscription to a publication of this type.

This field is used to track the starting inventory of this Publication which may be apportioned to any combination of Membership Publications.

This system-generated field tracks the total number of subscriptions of this publication that have been designated to Subscription Level rows (to any Membership).