Membership Subscriptions
When one of the privileges of a Membership involves a subscription to a publication, a Subscription Level row will be created and linked to the Membership row. The Subscription Level row will belong to the same constituent who owns the Membership row and it will define the nature of the Subscription 'package' that the Membership owner receives for a Membership of this type. That Subscription Level may specify multiple subscriptions (to the same publication), and it is also possible that the owner of the Membership will confer some or all of those subscriptions to other constituents. For each such assignment, a row will be created in the Subscription data table. Therefore, the Subscription row(s) may or may not belong to the same constituent who owns the Membership.
Note: An Administrator can remove the Membership Subscriptions table from the Millennium Explorer if not used. See Table Options for more information.
For example, an employer may fund a Membership and assign some or all of the subscriptions that result to employees. If one of the privileges of that Membership is five subscriptions to the monthly newsletter, the employer might retain two subscriptions, and assign each of the other three to a different staff member. In that circumstance, the employer's Membership row would have one linked Subscription Level row that describes the five subscriptions, as a package, and that data row would belong to the employer. Then, a row would be created in the Subscription data table, linked to the Subscription Level, also belonging to the employer, and showing ownership of two of the Subscriptions. Three additional Subscription data rows would be created and linked to the Subscription Level, each one belonging to an employee who will receive one of the Subscriptions.
In addition to tracking the link to the name of the Subscription owner and the name of the publication, the Subscription row tracks the Start and Stop Dates, whether the Subscription was accepted or declined and the acceptance date.
Subscription data displays in multiple ways:
- When the Subscription row belongs to the same constituent to whom the Subscription Level row belongs, the Subscription information will display as a secondary row, linked to the Subscription Level display (which is itself shown as a secondary row linked to the Membership row).
- When the Subscription row belongs to a different constituent, the data belonging to the Membership and Subscription Level rows' owner shows a Subscription cross reference with a hyperlink to the display of that data for the constituent who owns the Subscription. This cross reference displays below any Subscription data that is displayed for the Membership owner (if any exists).
- When the Subscription row belongs to a different constituent, the full display of the Subscription data is shown as a primary data row under the header titled, Subscriptions Received. This header and data is shown following any other Membership or Benefit data that the constituent may own (not the Membership to which this Subscription is linked). This display includes a hyperlink cross reference to the Membership row and the name of the constituent who owns the Membership.
The Automated Membership Process will prompt for the creation of Subscription rows as the Membership information is entered. For complete information, see Automated Membership Process. If you do not create the Subscription rows during that process but want to add them later, you may do so via the edit button to the left of the Subscription Level row to which the Subscription 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 Subscription from this menu. If the number of Subscriptions Available (the sublavail field in the Subscription Level data table) is zero, then the Subscription item will be grayed out.
Subscription rows may be edited from the display of the constituent who 'owns' the Subscription (only). For example, if the Subscription row attached to a Subscription Level row is owned by a different constituent, then the Subscription will display as a hyperlink cross reference on the display of the Subscription 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 Subscription owner's display. The details of the Subscription will be shown below the heading, Subscriptions Received on that constituent's membership display. The Edit button will appear to the left. Pass the mouse pointer over it to access a context menu; choose the Update/Delete menu item to access the update form.
If the Subscription belongs to the same constituent who owns the Subscription Level row, then the details are shown below the linked Subscription Level heading. The Edit button appears to the left. Pass the mouse pointer over it to access a context menu; choose the Update/Delete menu item to access the update form.
Subscription Field Descriptions
Subscription data is stored in the subscription 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 |
|---|---|---|---|
|
subkey 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) |
|
subid 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) |
|
subdoc 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) |
|
subdate 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) |
|
subuserid 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) |
|
subugroup 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 field) |
|
subpublica Publication |
char 6 [' ']
|
The name of the Publication to which this Subscription row refers. The Publications are listed by your institution in the Publication Name lookup table. |
|
|
substartdt Start Date |
none |
datetime/date
|
This field holds the beginning date of the subscription period. |
|
substopdt Stop Date |
none |
datetime/date
|
This field holds the ending date of the subscription period. |
|
subissues Issues |
none |
integer
[0]
|
This field is no longer being used. (system field) |
|
subsource Source |
char 6 [' ']
|
The source for the information in this row. |
|
|
submembkey non-displaying |
none |
numeric/number 13 ['0']
|
This field is a copy of the key field from the Membership row to which this Subscription is linked. Note that the Subscription row belongs to the constituent who owns this one subscription and that may or may not be the same constituent who owns the Membership row and Subscription Level row to which this Subscription row is linked. (system field) |
|
subpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (system field) |
|
subcrdate non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (system field) |
|
subfnum non-displaying |
none |
char 2 ['39'] {'39'} |
The file (table) number for the Subscription table. (system field) |
|
subcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
|
submemb non-displaying |
Membership Type |
char 6
|
This system-generated field holds a copy of the Membership Type code, for the Membership with which this Subscription row is associated. |
|
submembid 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 Subscription row. |
|
subsublky non-displaying |
none |
numeric/number 13,0
|
This system-generated field holds a copy of the key field from the Subscription Level row to which this Subscription row is linked. |
|
subaccept Receives? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that indicates whether the subscription has been accepted or declined. |
|
subaccptdt Date Accepted |
none |
datetime/date
|
If the subscription was accepted, this field is used to track the date for the acceptance. |
|
subactive Active? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that indicates whether this Subscription row is active or inactive. |
|
subdate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
submny1
|
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. |
|
submny2
|
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. |
|
subnum1
|
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. |
|
subnum2
|
|
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. |
|
subyesno
|
|
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. |
|
sublook1
|
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. |
|
|
sublook2
|
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. |
|
|
sublook3
|
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. |
|
|
subtext
|
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. |
|
subdate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
subdte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
submny3
|
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. |
|
submny4
|
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. |
|
submny5
|
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. |
|
submny6
|
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. |
|
submny7
|
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. |
|
submny8
|
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. |
|
submny9
|
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. |
|
submny10
|
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. |
|
submny11
|
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. |
|
submny12
|
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. |
|
subnum3
|
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. |
|
subnum4
|
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. |
|
subnum5
|
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. |
|
subnum6
|
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. |
|
subnum7
|
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. |
|
subnum8
|
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. |
|
subnum9
|
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. |
|
subnum10
|
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. |
|
subnum11
|
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. |
|
subnum12
|
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. |
|
subchk1
|
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. |
|
subchk2
|
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. |
|
subchk3
|
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. |
|
subchk4
|
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. |
|
subchk5
|
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. |
|
subchk6
|
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. |
|
subchk7
|
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. |
|
subchk8
|
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. |
|
subchk9
|
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. |
|
subchk10
|
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. |
|
subtxt1
|
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. |
|
subtxt2
|
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. |
|
subtxt3
|
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. |
|
subtxt4
|
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. |
|
subtxt5
|
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
| Index | Primary | Foreign | Unique | Fields | Sort |
|
pk_subscription |
Y |
|
Y |
subkey |
ASC |
|
sub01 |
|
Y |
|
subid |
ASC |
|
sub02 |
|
|
|
submembkey |
ASC |
|
sub03 |
|
|
|
subsublky |
ASC |