Membership Cards
Most Membership programs offer their members a printed Membership Card. Frequently, a single Membership may issue multiple Membership Cards, under different names. To track this information, an unlimited number of Membership Card data rows may be linked to the Membership row. While the Membership Card row will always 'belong' to the Membership constituent, the names that are specified for the cards may be any name or any text that you want.
When the Membership structure is designed by the institution, the number of Membership Cards that will typically be made available to each Membership Type is defined in the Membership Type lookup table. That information is transferred to the Membership data row when it is created.
Each Membership Card row may be used to track the following information:
- Name - this may be the name of the Membership constituent, or any other name that is desired, including non-constituent names. This name information should be entered as you want to have it appear on the card (John Smith, not Smith/John).
- Line Two - additional information that you may choose to print on the card.
- Line Three - additional information that you may choose to print on the card.
- Card Printed? - A flag indicating whether or not the card has been printed.
- Active? A flag indicating whether the data row is active or inactive.
Membership Card information is displayed as secondary data rows linked to a Membership row.
The system will prompt for the creation of the Membership Card data rows as the Membership information is entered. For complete information, see Automated Membership Process.
If you do not create the Membership Card rows at the time the Membership is created, and want to add them later, you may do so by using the Insert item on the context menu available by passing the mouse pointer over the edit button for an existing Membership Card row, or via the Insert item on the context menu accessed via the Membership Card Section Header Edit button.
Once created, a Membership Card row may be edited via the Update/Delete item on the context menu for the edit button which appears to the left of the display of the row. You will be given a data maintenance form containing the existing data.
Membership Cards Field Descriptions
Membership Card data is stored in the membershipcards 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 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 |
|---|---|---|---|
|
cardkey 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) |
|
cardid 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) |
|
carddoc 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) |
|
carddate no label |
none |
datetime/date
[getdate()]
|
The date that this Membership row was last updated. This field is automatically entered by the system. (system field) |
|
carduserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this Membership row. It is automatically entered by the system. (system field) |
|
cardugroup 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) |
|
cardname Card Name |
none |
char 255
|
This field is the name that should appear on the Membership Card. |
|
cardline2 Card Line 2 |
none |
char 255
|
This field is the information you want to appear on the second line of the Membership Card. |
|
cardline3 Card Line 3 |
none |
char 255
|
This field is the information you want to appear on the third line of the Membership Card. |
|
cardprint? Card Printed? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that may be used to indicate whether the Membership Card has or has not been printed. |
|
cardactive Active? |
none |
char 1
{'Y' or 'N'} |
This field is a flag that may be used to indicate whether the Membership associated with this card is or is not active. |
|
cardsource Source |
char 6
|
This field may be used to track the Source of the information shown in the data row. |
|
|
cardcrdate non-displaying |
none |
datetime/date
|
This system-generated field is used to hold a copy of the date on which this Membership Card row was created. (system field) |
|
cardfnum non-displaying |
none |
char 2 [65] {65} |
This system-generated field is used to hold a copy of the table number for the Membership Card data table. (system field) |
|
cardcomm no label |
none |
char 4000
|
This field is used to hold any free text information that you want to associate with this Membership Card row. |
|
cardmembky non-displaying |
none |
numeric/number 13,0
|
This system-generated field is used to hold a copy of the key field from the Membership row with which this Membership Card row is associated. (system field) |
|
carddate1 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate2 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cardmny1 |
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. |
|
cardmny2 |
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. |
|
cardnum1 |
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. |
|
cardnum2 |
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. |
|
cardyesno |
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. |
|
cardlook1 |
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. |
|
|
cardlook2 |
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. |
|
|
cardlook3 |
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. |
|
|
cardtext |
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. |
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
|
carddate4 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate5 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate6 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate7 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate8 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddate9 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddte10 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddte11 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
carddte12 |
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
cardmny3 |
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. |
|
cardmny4 |
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. |
|
cardmny5 |
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. |
|
cardmny6 |
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. |
|
cardmny7 |
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. |
|
cardmny8 |
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. |
|
cardmny9 |
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. |
|
cardmny10 |
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. |
|
cardmny11 |
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. |
|
cardmny12 |
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. |
|
cardnum3 |
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. |
|
cardnum4 |
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. |
|
cardnum5 |
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. |
|
cardnum6 |
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. |
|
cardnum7 |
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. |
|
cardnum8 |
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. |
|
cardnum9 |
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. |
|
cardnum10 |
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. |
|
cardnum11 |
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. |
|
cardnum12 |
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. |
|
cardchk1 |
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. |
|
cardchk2 |
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. |
|
cardchk3 |
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. |
|
cardchk4 |
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. |
|
cardchk5 |
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. |
|
cardchk6 |
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. |
|
cardchk7 |
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. |
|
cardchk8 |
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. |
|
cardchk9 |
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. |
|
cardchk10 |
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. |
|
cardtxt1 |
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. |
|
cardtxt2 |
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. |
|
cardtxt3 |
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. |
|
cardtxt4 |
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. |
|
cardtxt5 |
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 - Membership Cards
| Index | Primary | Foreign | Unique | Fields | Sort |
|
pk_membershipcards |
Y |
|
|
cardkey |
|
|
card01 |
|
|
|
cardid |
|