Membership Subscription Level
Most Membership programs include certain privileges to the constituent as a token of appreciation. If the privilege involves a publication, Millennium tracks that information in the Subscription tables. If the privilege takes some other form, either tangible or intangible, it is considered a Benefit and the information is tracked in the various Benefit data and lookup tables.
The institution may set up a variety of Subscription 'packages' to be associated with a particular Membership. The information for each 'package' is defined in the Membership Publications lookup table. Then when a constituent owns a particular Membership, a Subscription Level data row may also be created for the constituent to track the fact that one of those Subscription packages has been made available to the constituent because of the Membership. A 'package' may be made up of multiple instances of a particular Publication. For example, a Subscription Level might consist of five subscriptions, each valued at $10, for a total value of $50.
When a Subscription Level row is created, much of the information for the data row is copied from the corresponding entry in the Membership Publication lookup table. This includes the following columns:
- Membership Publication - the code for the Membership Publication Type.
- Publication Name - the code for the Publication Name.
- Total Number of Subscriptions - of this type that are available to the constituent because of the Membership (though this data may be overridden by the operator;
- Value of a single Subscription;
- Total Value of this Subscription Level (this is originally copied from the Membership Publication lookup table, but if the Total Number of Subscriptions is overridden, the system will re-calculate this column, too).
The individual instances of the Publication that is shown in a Subscription Level data row may be owned by the Membership owner, or they may be assigned to one or more different constituents. For example, an employer might purchase a Membership that includes as a Membership Subscription, four subscriptions to the Annual Report (the Annual Report is the Publication). When the single Subscription Level row is created for the employer, it will specify that it consists of four Annual Report Subscriptions (and other data about that Subscription). Each of those four Subscriptions may be conveyed by the employer to four different employees and if so, there will be four Subscription rows all linked to the one Subscription Level data row. In this scenario, the Membership row and the Subscription Level row will both belong to the employer, but each of the Subscription rows will belong to one of the employees (who must also be constituents in Millennium).
When the constituent's Membership information is displayed, the Membership row is shown as a primary row. Indented below the Membership row, and following all Benefit Level data, is the Subscription Level row. Indented below that are all Subscription rows that are linked to that Subscription Level. If there are multiple Subscription Level data rows for a single Membership, each is shown followed by its own set of linked Subscription data rows. For more information, see Membership Display.
When using the Automated Membership Process, the system will prompt for the creation of Subscription Level rows as the Membership information is entered. For complete information, see either Automated Membership Process (if you process via Dues) or Automated Membership Process - Membership (if you process via Membership).
Subscription Level rows may be created outside the Automated Membership Process. There are three possible ways. If you have not yet assigned a Subscription Level to the Membership, pass your mouse pointer over the edit button located to the left of the Membership row. Pass the mouse pointer over the Link context menu item to access a cascading menu and select Subscription Level from this menu. If you want to add an additional Subscription Level to the Membership, you may do so via this method, or via the Insert context menu item accessed via the edit button located to the left of an existing Subscription Level row for this Membership, or via the Insert context menu item accessed via the Subscription Level section header Edit button.
Subscription Level Field Descriptions
Membership Subscription level data is stored in the subscriptionlevel data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you wish to override these default settings, you must customize you 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 |
|---|---|---|---|
|
sublkey 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 field) |
|
sublid 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 field) |
|
subldoc 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 field) |
|
subldate no label |
none |
datetime/date
[getdate()]
|
The date that this Subscription row was last updated. This field is automatically entered by the system. (system field) |
|
subluserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this Subscription row. It is automatically entered by the system. (system field) |
|
sublugroup non-displaying |
none |
char 1 ['Z']
|
This system-generated field holds the Group letter that was associated with the User ID of the operator who last edited this row. (system field) |
|
subltype Publication Name |
(which draws this code from the Publication Name lookup table) |
char 6
|
This system-generated field holds a copy of the code for the Publication Name as it is shown in the Membership Publication lookup table row that was used to populate this Subscription Level row. |
|
sublmemb non-displaying |
char 6
|
This system-generated field holds a copy of the code for the Membership Type that associated with this Subscription Level table row. (system field) |
|
|
sublmembky non-displaying |
none |
numeric/number 13,0
|
This system-generated field holds a copy of the key field from the Membership row to which this Subscription Level row is linked. (system field) |
|
subltsubsc Number |
numeric/number 10,0
|
This field is used to track the maximum number of subscriptions that are available to this Subscription Level row. This number is initially drawn from the Membership Publication row, but it may be overwritten to a lesser number during data entry. |
|
|
sublused Used |
none |
numeric/number 10,0
|
This system-generated field is used to show the number of Subscriptions rows that are linked to this Subscription Level row. |
|
sublavail Available |
none |
numeric/number 10,0
|
This system-generated field is used to show the number of unassigned Subscriptions that are remaining for this Subscription Level. This field is calculated as the Number (subltsubsc) - Used (sublused) fields for this row. |
|
sublvalue Single Value |
money/number (19,4)/(16,2)
|
This system-generated field holds a copy of the value of a single issue of the publication, as taken from the Membership Publication lookup table row associated with this Subscription Level. |
|
|
subltvalue Total Value |
none |
money/number (19,4)/(16,2)
|
This system-generated field shows the total value of all the Subscriptions that are linked to this Subscription Level row. It is calculated as the number of Subscriptions used by this Subscription Level (sublused) times the Single Value (sublvalue) of an issue. |
|
sublsource Source |
char 6 [' ']
|
The source for the information in this row. |
|
|
sublactive Active? |
none |
char 1
{'Y' or 'N'} |
This field may be used to track whether the Subscription Level row is active or inactive. |
|
sublcrdate non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (system field) |
|
sublfnum non-displaying |
none |
char 2 ['64'] {'64'} |
This system-generated field holds the file (table) number for the Subscription Level table. (system field) |
|
sublcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
|
sublmempub Membership Publication |
char 6
|
This system-generated field holds a copy of the code for the Type from the entry in the Membership Publications lookup table that is associated with this Subscription Level. (system field) |
|
|
sublaccept Accepted? |
none |
char 1
|
This field acts as a flag to indicate whether a Subscription Level package was accepted or declined. If a Subscription Level is standard (rather than optional), a Subscription Level row is automatically created for the constituent, but it may be marked as either Accepted or Declined via this field as the row is created. If the Subscription Level is optional, when the row is created, it will automatically be marked as Accepted. In either case, the Accepted flag may be edited. |
|
subldate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
sublmny1
|
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. |
|
sublmny2
|
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. |
|
sublnum1
|
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. |
|
sublnum2
|
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. |
|
sublyesno
|
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. |
|
subllook1
|
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
|
subllook2
|
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
|
subllook3
|
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
|
subltext
|
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. This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subldte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
sublmny3
|
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. |
|
sublmny4
|
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. |
|
sublmny5
|
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. |
|
sublmny6
|
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. |
|
sublmny7
|
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. |
|
sublmny8
|
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. |
|
sublmny9
|
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. |
|
sublmny10
|
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. |
|
sublmny11
|
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. |
|
sublmny12
|
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. |
|
sublnum3
|
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. |
|
sublnum4
|
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. |
|
sublnum5
|
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. |
|
sublnum6
|
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. |
|
sublnum7
|
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. |
|
sublnum8
|
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. |
|
sublnum9
|
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. |
|
sublnum10
|
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. |
|
sublnum11
|
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. |
|
sublnum12
|
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. |
|
sublchk1
|
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. |
|
sublchk2
|
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. |
|
sublchk3
|
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. |
|
sublchk4
|
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. |
|
sublchk5
|
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. |
|
sublchk6
|
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. |
|
sublchk7
|
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. |
|
sublchk8
|
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. |
|
sublchk9
|
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. |
|
sublchk10
|
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. |
|
subltxt1
|
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. |
|
subltxt2
|
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. |
|
subltxt3
|
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. |
|
subltxt4
|
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. |
|
subltxt5
|
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 - Subscription Level
| Index | Primary | Foreign | Unique | Fields | Sort |
|
pk_subscriptionlevel |
Y |
|
Y |
sublkey |
ASC |
|
subl01 |
|
Y |
|
sublid |
ASC |
|
subl02 |
|
Y |
|
sublmembky |
ASC |
|
subl03 |
|
Y |
|
subltype |
ASC |