Honor and Memory Transactions for Non-Constituents
The Honoree table is a secondary table whose information is only displayed as part of the display of the Gift Transaction or Dues Transaction row to which it is attached. When donations are made with the instruction that the gift is "in honor of" a person, an organization, or perhaps even a pet, and the "honoree" is a non-constituent, the name information is maintained in an Honoree row, attached to the Gift or Dues Transaction row with which it is associated. (If the honoree is a constituent, a "reverse" Gift Transaction or Dues row is automatically created for that constituent and from that information, the name of the constituent is available to the system and is displayed accordingly. Therefore, an Honoree row is not necessary when the honoree is another constituent. See the Honor and Memory Transactions topic for details on constituent honors).
When entering a primary Gift or Dues Transaction row with an Honor/Memory for designation, the system requires that you indicate whether the honoree is a constituent or non-constituent. When you check non-constituent, the system prompts you to enter the honoree's name, and also to indicate whether the honoree is living (In Honor) or deceased (In Memory). (If the honoree is a constituent, it is not necessary to enter this information because the system can determine this information by checking the Names and the Death data for that constituent.)
The information from an Honoree row is incorporated into the display of the primary Gift or Dues Transaction row. If the honoree is living, that display will include the phrase, Given in honor of John Smith. If the honoree is deceased or disbanded, the phrase will read, Given in memory of John Smith.
A Gift or Dues Transaction row may have any number of attached Honoree rows for non-constituents, in any combination with any number of constituent honoree designations.
Honoree Field Descriptions
Non-constituent honor and memory data is stored in the honoree data table. The following fields are included. Note that the field labels and non-displaying designations that are listed 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 |
|---|---|---|---|
|
honkey 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) |
|
honid 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) |
|
hondoc non-displaying |
none |
char 1 ['N']
|
This field holds a Y/N flag to indicate the existence of a linked document for this row. (system field) |
|
hondate no label |
none |
datetime/date
[getdate()]
|
The date that this Honoree row was last updated. This field is automatically entered by the system. (system field) |
|
honuserid no label |
none |
varchar/varchar2 30 [suser_sname()]
|
The User ID of the operator that last edited this Honoree row. It is automatically entered by the system. (system field) |
|
honusergrp 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) |
|
honlinkfil non-displaying |
none |
char 2
|
This field holds the file (table) number of the table to which this Honoree row is attached (either Transaction or Dues). (system field) |
|
honlinkkey non-displaying |
none |
numeric/number 13,0
|
This field holds a copy of the key field from the Transaction or Dues row to which it is attached. (system field) |
|
honhontype non-displaying |
none |
char 3
|
This field indicates whether the honoree is living (hon) or deceased (mem). (system field) |
|
hontitle no label |
none |
char 30
|
The title for the name of the honoree. |
|
honlast no label |
none |
char 55
|
The last name of the honoree. |
|
honfirst no label |
none |
char 30
|
The first name of the honoree. |
|
honmiddle no label |
none |
char 30
|
The middle name of the honoree. |
|
honsuffix no label |
none |
char 30
|
The suffix from the name of the honoree. |
|
honsource Source |
Source |
char 6 [' ']
|
The source for the information in this row. |
|
honpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (system field) |
|
honcrdate non-displaying |
none |
datetime/date
[getdate()]
|
The date that the row was created. (system field) |
|
honfnum non-displaying |
none |
char 2 ['34'] {'34'} |
The file (table) number for the Honoree table. (system field) |
|
honcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
| hondate1 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate2 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| honmny1 | 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. |
| honmny2 | 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. |
| honnum1 | 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. |
| honnum2 | 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. |
| honyesno | 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. |
| honlook1 | Honoree Lookup1 |
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. |
| honlook2 | Honoree Lookup2 |
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. |
| honlook3 | Honoree Lookup3 |
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. |
| hontext | 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. |
|
honjrnlfl non-displaying |
none |
char 1 ['N'] {'Y' or 'N'} |
This system-generated field is a flag indicating whether the transaction to which this data row is linked has ('Y') or has not ('N') been journaled. (system field) |
|
honjrnldt non-displaying |
none |
datetime/date
|
This system-generated field is used to hold the date on which the transaction to which this data row is linked was journaled (if ever). (system field) |
| hondate3 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate4 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate5 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate6 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate7 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate8 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondate9 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondte10 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondte11 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| hondte12 | none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
| honmny3 | 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. |
| honmny4 | 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. |
| honmny5 | 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. |
| honmny6 | 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. |
| honmny7 | 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. |
| honmny8 | 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. |
| honmny9 | 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. |
| honmny10 | 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. |
| honmny11 | 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. |
| honmny12 | 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. |
| honnum3 | 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. |
| honnum4 | 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. |
| honnum5 | 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. |
| honnum6 | 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. |
| honnum7 | 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. |
| honnum8 | 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. |
| honnum9 | 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. |
| honnum10 | 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. |
| honnum11 | 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. |
| honnum12 | 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. |
| honchk1 | 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. |
| honchk2 | 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. |
| honchk3 | 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. |
| honchk4 | 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. |
| honchk5 | 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. |
| honchk6 | 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. |
| honchk7 | 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. |
| honchk8 | 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. |
| honchk9 | 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. |
| honchk10 | 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. |
| hontxt1 | 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. |
| hontxt2 | 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. |
| hontxt3 | 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. |
| hontxt4 | 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. |
| hontxt5 | 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 - Honoree
|
Index |
Primary |
Foreign |
Unique |
Fields |
Sort |
|---|---|---|---|---|---|
|
pk_hon |
Y |
|
Y |
honkey |
ASC |
|
hon02 |
|
Y |
|
honid |
ASC |