More information

Summaries

The Summaries table is one of several ways in which a constituent's giving history is maintained and displayed (along with such displays as the Gift or Dues tables, and Giving Trends). The Summaries table displays cumulative, summary, or tallied information that has been calculated using the information that is stored in the Gift or Dues Transaction tables, rather than "new" or unique data that you would enter directly into the Summaries table.

Note: An Administrator can remove the Summaries table from the Millennium Explorer if not used. See Table Options for more information.

For example, the Summaries table may be constructed to contain and display the constituent's entire giving total, running totals to particular fund drives, the number of consecutive years of giving, the year and amount of largest giving total, etc. Each of these would be maintained in a separate row in the Summaries table.

Therefore, the Summaries table is unique in Millennium.

In other tables, the system has defined the intended use for each field and the default labels for each field in the display. The user enters the data that is to be displayed with that label, using either free text or a lookup table entry depending on the system-defined data type for that field. (Display labels for the fields may be altered by customizing the display templates.)

In the Summaries table, each institution defines both the use and the label for each field. The labels are defined by the entries in the Memory Names lookup table.

In addition, the data for the field is not entered using standard data entry procedures. Instead, the data for the Memory field is calculated and assigned using Millennium Reporting, along with the Summaries Utility or the Years Utility.

You may define as many Summary rows as you want, although you should bear in mind that the purpose of using this table is to have convenient access to summary information. The more rows you define and create for a constituent in the Summary, the more you must examine in order to find the specific information you want.

Create Summary Rows

Define the Memory Names and Memory Descriptors Lookup Tables

The first step in creating rows in the Summaries table is to determine what sort of cumulative or summary giving information will be required or most helpful for your institution, and assign names to each. This set of names will be entered as the Values in the Memory Names lookup table, using standard Lookup Table Maintenance procedures. At the same time, each entry in that lookup table will be assigned a particular Group, depending on the nature of the data that will be contained in the related Memory field as discussed in the chart that follows.

Also, if your institution wants to use textual designations as the data in some of the Summary rows instead of numerical data, they should be defined and entered in the Memory Descriptors lookup table. This would be the case for Giving Clubs or levels that are described in words rather than numbers (calling a particular giving level the "Platinum Club" instead of ">$5,000", for example). The system expects that every Summary row will use and display either the memamount field or the memdescriptor field.

Every Summary row will use an entry from the Memory Names lookup table as the label. This label tells what the information that follows in the display represents. In addition, the Group field from the Memory Name entry that is used triggers some other behaviors.

If the Group field contains anything other than "desc", then the system will display the memamount field following the label and ignore the memdescriptor field. If the Group field contains "desc", then the system will display the memdescriptor field following the label and ignore the memamount field.
The Group field signals the system as to the way that the data should be formatted in the display as shown in the following chart. (Note that in the chart, the Values and Codes are merely examples but the Group designations are the only acceptable choices to produce the results shown at the right.)

If the memtype field uses the Memory Names lookup table entry:	The display will show:	Formatted as:
Value: 1994 Annual Fund Code: 94af Group: $	memamount	$1987.00
Value: Year of Largest Code: lg Group: No	memamount	1987
Value: # of Giving Code: gft Group: (blank)	memamount	1,987
Value: 1990 Giving Club Code: 90gc Group: desc	memdescriptor	Patron's Club

When all lookup table entries have been defined for the Summaries that you want to calculate and assign, you may then use the Millennium Reporter and either the Summaries Utility or the Years Utility to assign the data to those rows.

Summaries and Millennium Drive

Summary rows that have a Memory Name code of abila1, abila2, abila3, or abila4 will display in Millennium Drive, on the Constituent Summary page and on Touch Points.

abila1 is a Total Giving summary
abila2 is a Consecutive Years Giving summary
abila3 is a Largest Gift summary
abila4 is a Total Giving Year to Date summary

Summaries Field Descriptions

Summaries data is stored in the memories 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 your display definition.

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 Summaries Display 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 forms.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
memkey 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)
memid 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)
memdoc 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)
memdate no label	none	datetime/date [getdate()]	The date that this Summaries row was last updated. This field is automatically entered by the system. (system field)
memuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this Summaries row. It is automatically entered by the system. (system field)
memugroup non-displaying	none	char 1 ['Z']	This field holds the Group letter that was associated with the User ID of the operator who created this row. It reflects this Group assignment at the time the row was created and is not updated. (system field)
memname no label	Memory Names	char 6 [' ']	This data in this field acts as a label in the display of the Summary row information. This label is defined by the entries in the Memory Names lookup table.
memamount no label	none	money/number (19,4)/(16,2) [0]	This field contains numeric or textual information related to the constituent's giving information. This field displays only in those Summary rows whose memname fields contain an entry from the Memory Names lookup table that has a Group field other than "desc". If the Group is "desc", the memdescrp field is used instead of memamount, in the display.
memdescrp no label	Memory Descriptors	char 6 [' ']	This field contains descriptions (textual values from the Memory Descriptors lookup table) that provide information about the constituent. This field displays only in those Summary rows whose memname field uses an entry from the Memory Names lookup table that has a Group of "desc". If it has any other Group, the memamount field is displayed instead.
mempoint non-displaying	None	int	This system-assigned field is no longer used or supported. (system field)
memfnum non-displaying	None	char 2 ['18'] {'18'}	The file (table) number for the Summaries table. (system field)
memcrdate non-displaying	None	datetime/date [getdate()]	The date that the row was created. (system field)
memdisp non-displaying	Table Groups	char 6 [' ']	This field holds a copy of the Group field from the lookup table entry that was used in the memname field in this row. That Group determines the type of formatting that is done to the display of the row. More information is given in the topic, Creating Summary Rows. (system field)
memlookup1	Memories Lookup1	char 6 {null}	This custom field may be defined and used by your institution to track any lookup table driven information associated with a data row showing a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memlookup2	Memories Lookup2	char 6 {null}	This custom field may be defined and used by your institution to track any lookup table driven information associated with a data row showing a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memlookup3	Memories Lookup3	char 6 {null}	This custom field may be defined and used by your institution to track any lookup table driven information associated with a data row showing a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memcampyr	none	char 4 {null}	This custom field is available to track a Campaign Year to be associated with a data row showing a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny1	none	money/number {null}	This custom field is available to track any monetary value associated with a data row showing a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny2	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny3	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny4	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny5	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny6	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny7	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny8	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny9	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny10	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny11	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny12	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny13	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny14	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny15	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate1	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate2	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate3	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate4	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate5	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate6	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate7	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate8	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate9	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate10	none	datetime/date {null}	This custom field is available to track any date you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno1	none	char 1 ['N'] {not null}	This custom field is available to flag a numeric Summary for any desired purpose. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno2	none	char 1 ['N'] {not null}	This custom field is available to flag a numeric Summary for any desired purpose. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno3	none	char 1 ['N'] {not null}	This custom field is available to flag a numeric Summary for any desired purpose. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno4	none	char 1 ['N'] {not null}	This custom field is available to flag a numeric Summary for any desired purpose. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memcomm	none	varchar/varchar2 4000 {null}	This custom field is available to track a more lengthy free text comment you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext1	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext2	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a numeric Summary. This field is not available on the Summaries Utility when you are using it to create Summaries that use Descriptors. This field is also not available on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny16	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny17	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny18	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny19	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny20	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny21	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny22	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny23	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny24	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny25	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny26	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny27	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny28	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny29	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny30	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny31	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny32	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny33	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny34	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memmny35	none	money/number {null}	This custom field is available to track any monetary value you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate11	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate12	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate13	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate14	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate15	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate16	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate17	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate18	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate19	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate20	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate21	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate22	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate23	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate24	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate25	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate26	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate27	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate28	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate29	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memdate30	none	datetime/date {null}	This custom field is available to track any date you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum1	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum2	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum3	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum4	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum5	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum6	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum7	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum8	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum9	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memnum10	none	numeric/number 10, 0	This custom field is available to track any numeric information you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno5	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno6	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno7	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno8	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno9	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno10	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno11	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno12	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno13	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memyesno14	none	char 1 ['N'] {not null}	This custom field is available to flag a Summary for any desired purpose. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext3	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext4	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext5	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext6	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.
memtext7	none	varchar/varchar2 255 {null}	This custom field is available to track any brief free text comment you want to associate with a Summary. This field is not available on the Summaries Utility or on the Years Utility. You can use a SQL or Oracle database query tool to assign a value to this field.

Indices - Summaries

Index	Primary	Foreign	Unique	Fields	Sort
pk_memories	Y		Y	memkey	ASC
memories02		Y		memid	ASC
memories03		Y		memname	ASC
memories04				memamount	ASC

Top of Page