Membership Benefits
When one of the privileges of a Membership involves Benefits, a Benefit Level row will be created and linked to the Membership row. The Benefit Level row will belong to the same constituent who owns the Membership row and it will define the nature of the Benefit 'package' that the Membership owner receives for a Membership of this type. That Benefit Level may specify multiple instances of the Benefit (of the same kind), and it is also possible that the owner of the Membership will convey some or all of those Benefits to other constituents. For each such Benefit assignment, a row will be created in the Benefit data table. Therefore, the Benefit row(s) may or may not belong to the same constituent who owns the Membership and Benefit Level to which they are linked.
Note: An Administrator can remove the Membership Benefits table from the Millennium Explorer if not used. See Table Options for more information.
For example, an individual may fund a Membership and assign some or all of the Benefits that result to other family members. If one of the privileges of that Membership is five reduced admissions to the museum, the owner might plan to use two of the reduced admissions for himself, and assign each of the other three to a different family member. In that circumstance, the owner's Membership row would have one linked Benefit Level row that describes the five reduced admissions as a package, and that data row would belong to the Membership owner. Then, a row would be created in the Benefits data table, linked to the Benefit Level, also belonging to the owner, and showing ownership of two of the admission Benefits. Three additional Benefits data rows would be created and linked to the Benefit Level, each one belonging to a family member who will receive one of the reduced admissions.
In addition to tracking the link to the name of the Benefit owner and the name of the Benefit, the Benefit row tracks the Start and Stop Dates, whether the Benefit was accepted or declined, the acceptance date and delivery date.
Benefit data displays in different ways.
- When the Benefit row belongs to the same constituent to whom the Benefit Level row belongs, the Benefit information will display as a secondary row with a Benefits section header, below the Benefit Level row (which is itself shown as a secondary row linked to the Membership row). In this situation, the full details from the Benefit row are displayed when the Long display is activated.
- When the Benefit row belongs to a different constituent than the one whose Membership and Benefit Level data is being displayed, a Benefit cross reference with a hyperlink to the owner's display is shown. This cross reference notation also displays the number of instances of the Benefit that have been assigned to that constituent.
- When the Benefit row belongs to a different constituent than the one who owns the Membership and Benefit Level data, the detailed display of the Benefit data is shown as a primary data row under the header titled, Benefits Received in the Membership display belonging to the Benefit owner. This header and data is shown following any other Membership or Benefit data that the constituent may own (different Memberships - not the one to which this Benefit is linked). This display includes a hyperlink cross reference to the Membership row and the name of the constituent who owns the Membership.
When using the Automated Membership Process, the system will prompt for the assignment of the Benefit Level and Benefits and the creation of those data rows as the Membership information is entered. For complete information, see either Automated Membership Process- Dues (if you process via Dues) or Automated Membership Process - Membership (if you process via Membership).
If you do not create the Benefit rows during the Automated Membership Process, but want to add them later, you may do so via the context menu accessible via the edit button to the left of the Benefit Level row to which the Benefit row will be linked. Pass the mouse pointer over this edit button, pass the mouse pointer over the Link menu item to access a cascading menu, and select Benefit from this menu. If the number of Benefits Available (the benlavail field in the Benefit Level data table) is zero, then the Benefit menu item will be grayed out.
Benefit rows may be edited from the display of the constituent who 'owns' the Benefit (only). For example, if the Benefit row that is attached to a Benefit Level row owned by a different constituent, then the Benefit will display as a hyperlink cross reference on the display of the Benefit Level owner's display. There is no Edit button next to that notation. To perform an edit on that information, you must first use the hyperlink to access the Benefit owner's display. The details of the Benefit will be shown below the heading, Benefits Received. In that setting, the Edit button will appear to the left and when you pass the mouse pointer over it, a context menu will be shown. You may then choose the Update/Delete item in the menu to access the update form.
If the Benefit belongs to the same constituent who owns the Benefit Level row, then the details are shown below the linked Benefit heading, and an Edit button appears to the left and when you pass the mouse pointer over it, a context menu will be shown. You may then choose the Update/Delete item in the menu to access the update form.
Benefits Field Descriptions
Membership Benefits data is stored in the benefits data table. The following columns are included. The column labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition.
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.
|
Field Name Field Label |
Lookup Table |
Type SQL/Oracle Length [Default] {Check} |
Description |
|---|---|---|---|
|
benkey non-displaying |
none |
numeric/number 13,0
|
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 column) |
|
benid non-displaying |
none |
char 10
|
This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System column) |
|
bendoc non-displaying |
none |
char 1 ['N'] {'Y' or 'N'} |
This field holds a Y/N flag to indicate the existence of a linked document for this row.(System column) |
|
bendate no label |
none |
datetime/date
[getdate()]
|
The date that this Benefits row was last updated. This field is automatically entered by the system (System column) |
|
benuserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this Benefits row. It is automatically entered by the system. (System column) |
|
benugroup non-displaying |
none |
char 1 ['Z']
|
This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System column) |
|
bentype Benefit |
Benefit Types |
char 6 [' ']
|
The name of the Benefit Type to which this Benefit row refers. The Benefits are defined by your institution in the Benefit Type lookup table. |
|
benstartdt Start Date |
none |
datetime/date
|
This is the date on which this benefit is first available to the constituent. |
|
benstopdt Stop Date |
none |
datetime/date
|
This is the date on which this benefit "expires". |
|
bennumber Number |
none |
integer
[0]
|
This field is used to track the number of Benefits represented in this row. The system will verify that the sum of this field from all Benefits that are linked to the same Benefit Level row does not exceed the Number of Benefits that are allotted to this Membership, as shown in the Benefit Level row. |
|
bensource Source |
Source |
char 6 [' ']
|
The source for the information in this row. |
|
benmembkey non-displaying |
none |
numeric/number 13,0 ['0']
|
This field is a copy of the key field from the Membership row to which this Benefit is linked. Note that the Benefit row belongs to the constituent who owns this one benefit and that may or may not be the same constituent who owns the Membership row and Benefit Level row to which this Benefit row is linked. (System column). |
|
benpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (System column) |
|
bencrdate non-displaying |
none |
datetime/date
[getdate()]
|
This system-assigned field holds the date that the row was created. (System column) |
|
benfnum non-displaying |
none |
char 2 ['40'] {'40'} |
This system-assigned field holds the file (table) number for the Benefits table. (System column) |
|
bencomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
|
benmemb non-displaying |
Membership Type |
char 6
|
This system-generated field holds a copy of the Membership Type code, for the Membership with which this Benefit row is associated. (System column) |
|
benmembid non-displaying |
none |
char 10
|
This system-generated field holds a copy of the ID Number of the constituent who owns the Membership row to which this row is linked. This may or may not be the same constituent who owns this Benefit row. (System column) |
|
benbenlky non-displaying |
none |
numeric/number 13,0
|
This system-generated field holds a copy of the key field from the Benefit Level row to which this Benefit row is linked. (System column) |
|
benvalue Single Benefit Value |
Membership Benefit |
money/number (19,4)/(16,2)
|
This system-generated field holds a copy of the value of a single Benefit of this type. (System column) |
|
bentvalue Total Benefit Value |
none |
money/number (19,4)/(16,2)
|
This system-generated field is the total value of the benefits that are represented in this row. It is calculated as the product of the Number (bennumber) times the Single Benefit Value (benvalue). (System column) |
|
benreceive Receives Benefit? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that indicates whether the Benefit has been accepted or declined. |
|
benaccptdt Date Accepted |
none |
datetime/date
|
If the Benefit was accepted, this field is used to track the date for the acceptance. |
|
benactive Active? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that indicates whether this Benefit row is active or inactive. |
|
bendate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information you want to associate with this data row. |
|
bendate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information you want to associate with this data row. |
|
benmny1
|
none |
money/number (19,4)/(16/2)
|
This custom field may be defined and used by your institution to track any monetary information you want to associate with this data row. |
|
benmny2
|
none |
money/number (19,4)/(16/2)
|
This custom field may be defined and used by your institution to track any monetary information you want to associate with this data row. |
|
bennum1
|
none |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information you want to associate with this data row. |
|
bennum2
|
none |
numeric/number 10,0
|
This custom field may be defined and used by your institution to track any numeric information you want to associate with this data row. |
|
benyesno
|
none |
char 1 ['N'] {'Y' or 'N'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benlook1
|
benefits_lookup1 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information you want to associate with this data row. |
|
benlook2
|
benefits_lookup2 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information you want to associate with this data row. |
|
benlook3
|
benefits_lookup3 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information you want to associate with this data row. |
|
bentext
|
none |
varchar/varchar2 255
|
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. |
|
bensentdt Delivery Date |
none |
datetime/date
|
This is the date on which this benefit was sent to or received by the constituent. It can be entered manually or system-generated. |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
bendte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
benmny3
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny4
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny5
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny6
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny7
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny8
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny9
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny10
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny11
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
benmny12
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
bennum3
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum4
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum5
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum6
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum7
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum8
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum9
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum10
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum11
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
bennum12
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
benchk1
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk2
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk3
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk4
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk5
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk6
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk7
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk8
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk9
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
benchk10
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
bentxt1
|
none |
varchar/varchar2 255
|
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. |
|
bentxt2
|
none |
varchar/varchar2 255
|
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. |
|
bentxt3
|
none |
varchar/varchar2 255
|
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. |
|
bentxt4
|
none |
varchar/varchar2 255
|
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. |
|
bentxt5
|
none |
varchar/varchar2 255
|
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. |
Indices - Benefits
| Index | Primary | Foreign | Unique | Fields | Sort |
|---|---|---|---|---|---|
| pk_benefits | Y | Y | benkey | ASC | |
| ben01 | Y | benid | ASC | ||
| ben02 | Y | benmembkey | ASC | ||
| ben03 | benbenlky | ASC |