System Tables

This system-generated field holds the unique, primary key for the row.

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)

This field holds the file (table) number of either the Gift or Dues table,

indicating to which kind of row this Payment row is attached.

This field holds a copy of the primary key field from the primary Gift or Dues row to which this log row is attached.

This field holds the tender type of the Gift or Dues row to which this log row is attached.

This field holds the reason for the failed credit card or bank draft processing attempt. (For Example, INVALID C_EXP means the processing attempt failed because the credit card expiration date was expired or in an invalid format.

Paya Payment Solutions identifier for the failed credit card or bank draft processing attempt.

This field holds the code associated with the reason for the failed credit card or bank draft processing attempt.

This field holds the approval status code. If the process failed because of a front end error (Declined), this field is set to 'E'. If the process failed because of a gateway error (Unable to Process) this field is set to 'X'.

The User ID of the operator that submitted the credit card or bank draft for processing.

This system-generated field holds the unique, primary key for the row.

Return email address.

email message type; 'user' for user name, 'pwd' for password. (system field)

The name (title) of the report criteria with which these report settings are associated.

The name (system name) of the report criteria with which these report settings are associated.

The name of the report library for the criteria. (Biographical, Financial, etc.)

The User ID of the user who created the saved set of criteria to which this Express report is linked.

'X' if a report is saved as an Express Report.

'R' if a report has prompted criteria lines, is run and is not saved as an Express Report.

Once a report has been saved as an Express Report, it cannot be changed to a non-Express Report unless the user deletes the Express Report definition and reruns the criteria without saving as an Express Report.

Prior to Millennium version 7.6, report_type = 'T' for all Express Report rows. Once an Express Report is re-saved, the value of this field is changed to 'X'.

The date and time that they report was created.

The date and time when the report was last edited.

The Millennium UserId of the person who last edited the report.

The date and time when the report was last run.

The Millennium UserId of the person who last ran the report.

The amount of time that the last selection process took.

The amount of time that it took the formatting software to process, the last time that the report was run.

The total amount of time that it took for the report to be completed, the last time it was run.

The number of data rows that were selected by the last run of the report.

The amount of time spent preparing the export worktable, the last time that the report was run.

The Millennium UserId for the person who 'owns' the saved export worktable.

The name of the saved export worktable.

The maintenance security associated with the report group.

The maintenance security associated with the report group.

The access security

The free-text description of the report.

The Millennium UserId for the person who 'owns' this report.

ASC

The name of the data table (or search) where the field 'lives'.

The system name of the field.

The nature of the field (datetime, date, integer, numeric, number, money, varchar/varchar2, varchar2, etc.)

This is the precision for the field.

This is the scale the field.

The size of the field in characters.

This indicates whether the field may or may not be null.

This field is generated by SQL and used as an identifier. The key fields are examples.

If the field being described in this row has a foreign key constraint (it is driven by a lookup table), this will identify that lookup.

This field is the user-defined alias (if any) to be shown in the MR pull-down field list, the list of Available Columns on the Clipboard Setup page and the list of Available Columns in all of the Define Results Display applets.

SQL query tools can be used to change the field alias. In addition, if the label of a field is modified via the Custom Display Designer or by using any of the Define Results Display applets, the system will update the contents of this field to reflect the new label.

This field indicates to the system the type of data entry component the field will use (check box, text box, list box, etc.)

This is the position within its table for the field described in this row.

The User ID for the operator to whom this filter belongs. If the user is sa or MILLORA, then user_name ismillennium_admin.

This field holds the name that the filter was given.

This field shows the number of the data table this filter defines.

This field identifies to the system where the criteria defined in this row fits in relation to the other criteria statements for the complete Filter definition.

This field shows the screen version of the criteria statement (spelled out in English).

This field contains the field name, a coded version of the comparison and the object for the select statement.

This is the primary key field, automatically generated by the system on insert.

If this filter is the active one for the data table on which it is defined, the value of this field will be 'Y'. If not, then the value of this field will be 'N'.

If this filter is the active one for the data table on which it is defined, when the data table is shown in Snapshot View, then the value of this field will be 'Y'. If not, then the value of this field will be 'N'.

ASC

The name of the Millennium user if the row is used to store a user option or setting. kvuser is set to (System) if the row stores a system option or a system setting.

The system-generated key word for the row’s system or user option or setting.

This is the primary key field, automatically generated by the system on insert.

The User ID of the user who attempts to log on to Millennium.

The IP address of the machine that the user is utilizing when attempting the log on

The date and time the log on attempt is made.

Set to 1 if the log on attempt is successful. Set to 0 if the log on attempt fails.

ASC

ASC

The name of the Summary definition.

The line number. This is reset to 1 for each new type within a definition, and for each new definition. If field3 = Years, then this field will be 1.

The type of definition. May be: Numeric, Descriptors, Calculations, or Years. The information for this field determine what fields 4 - 10 represent.

N - Code from the Memory Type lookup table.
D - Total name 1.
C - operand1
Y - Code for year of largest transaction.

N - Name of total or calculation.
D - Comparison.
C - operand2
Y - Code for year of latest transaction.

N - 'A' or 'R' for Add or Replace.
D - Total name 2.
C - operator (plus, minus, multiply, divide)
Y - Code for year of first transaction

N - unused
D - Total name 3 (null unless comparison like * Between)
C - unused
Y - Code for number of years giving.

N - unused
D - Code from the Memory Type lookup table.
C - unused
Y - Code for consecutive years giving.

N - unused
D - Code from the Memory Descriptors lookup table.
C - unused
Y - Start month.

The name of the Summary definition, copied from the memory_definitions table.

The line number, copied from the memory_definitions table.

The type of definition. May be: Numeric, Descriptors, Calculations, or Years, copied from the memory_definitions table. Currently, this is set to NUMERIC.

A classification of the name of the memory field defined. May be LOOKUPNAME, CAMPYRNAME, MONEYNAME, DATENAME, YESNONAME, COMMNAME, TEXTNAME

A line number. This is reset to 1 for each new field2 value within a definition.

the name of the Summaries table column

L - not used

Camp -- not used

M -'A' or 'R' for Add or Replace

D - not used

Y - not used

Comm- not used

T - not used

Paya Payment Solutions licensing information: the Key that is associated with this merchant account row.

Paya Payment Solutions licensing information: the Id number that is associated with this merchant account row.

The descriptive name associated with this merchant account row.

A flag to tell the system to allow constituents' credit card and bank draft account information to be saved for future use.

This flag can be set only on the default merchant account. If this row is the default account and this option is On, and then another merchant account row is flagged as the default, the triggers will set this option to Off, on this row, and the user must then set this option to On on the new default merchant account row.

A flag to indicate to the system that this is the merchant account is to be utilized as the default account for credit card payment and bank draft processing.

Only one merchant account row can be flagged as the default. If this row is the default merchant account and another merchant account row is subsequently flagged as the default, the triggers will reset this flag on this row to Off.

A flag to indicate to the system that this is the merchant account to be utilized as the account for the credit card payment and bank draft processing of event registration fees.

Only one merchant account can be flagged for use with event registration fees. If this is the row so flagged, and another merchant account row is subsequently flagged as the events merchant account row, the triggers will reset this flag on this row to Off.

Automatically entered by the system and set to millennium_admin (system field) if the merchant account row was entered through the System Options screen.

The date this merchant account row was last edited. It is automatically entered by the system. (system field)

The SPS Vault.

ASC

ASC

This is the primary key, automatically generated by system at insert

Name of the map

Field number of the Millennium field that is being mapped

Name of the Millennium field that is being mapped

Used as a system field by the Advanced Data Examiner (ADE) Import Tool

Name of the Input File field that the Millennium field is mapped to, or table code of the lookup table that the Millennium field is mapped to, or a constant value that the Millennium field is mapped to.

Field Number of the Input File field that the Millennium field is mapped to

Millennium User ID of the user who created the map. Also used as a system field by the Advanced Data Examiner (ADE)

Used as a system field by the Advanced Data Examiner (ADE) Import Tool

This is the primary key field, automatically generated by the system on insert.

This field defines when the last time the prototype was created or changed.

This field defines what user created the prototype. If this is a System Defined Default, or prototype, protouserid will be set to millennium_admin.

This field holds the name the prototype was given. If a System Defined Default, or prototype, this will be set the System Default.

This field holds the table number of the data table that the prototype is linked to. For example, if a default is defined for the gifts table, this field is set to '05'.

This key field points to the row in the default table for the data table (for example, def_gifts is the default table for gifts) that the prototype row is associated with.

This is a Y/N flag to indicate which prototype is the current active one.

ASC

ASC

ASC

This is the primary key field, automatically generated by the system upon insert.

The user name of the person who owns the criteria lines that were copied to the Main Report Form Clipboard.

The date and time the criteria lines copied to the Main Report Form Clipboard were copied or last modified

This the user-assigned name for the Total or Group.

This flags the criteria for use with any of the Profiles libraries (P) or the Event library (E).

This indicates whether the criteria is part of a Total (T) or a Group (G).

This is the User ID for the user who saved the lines of criteria.

This is the date on which the criteria was saved.

This identifies the position of each line of criteria in the set that has been saved as a unit.

U - The name of the criteria. (for example, November Cash Receipts Detail)
T - The name of the template. (for example, Cash Receipts)
Q - The system name of the advanced search. (for example, kfs_query)
V - The system name of the HTML output. (for example, November Cash Receipts Detail)

P - The name of the criteria. (for example, November Cash Receipts Detail)

U - The name of the table. (for example, november_cash_receipts_det1000)
T - The name of the template. (for example, template_cash_receipts)
Q - The table name. (for example, kfs_query)
V - none

P - none

U - The name of the report group. (for example, Financial)
T - The name of the report group. (for example, Financial)
Q - Search Query
V - The name of the report group. (for example, Financial)

P - The name of the report group. (for example, Financial)

U - The User ID of the user who created the row. (for example, abc)
T - Always dbo.
Q - The User ID of the user who owns the advanced search. (for example, abc)
V - The User ID of the user who ran the report. (for example,abc)

P - The User ID of the user who ran the report. (for example, abc)

U - User-created criteria.
T - Template as shown in New Criteria.
Q - Query for Advanced Search.
V - The name of the report group. (for example, Financial)

P - The report destination is PDF.

Q - The date on which the report was created.

U - The date on which the report was created.

(U only) The most recent date on which the report was edited.

(U only) The user Id who made the most recent edit.

(U only) The date of the most recent run.

P - The User ID for whom the most recent run was executed.

U - The User ID for whom the most recent run was executed.

V - The User ID for whom the most recent run was executed.

(U only) The amount of time spent performing the selection, the last time this report was run.

(U only) The amount of time spent by the 3rd party formatting software, the last time this report was run.

(U only) The sum of the select, format, and export times, the last time this report was run.

(U only) The number of rows that were initially selected, minus any that were removed according to duplicate, spouse, and deceased removal options.

(U only) The amount of time spent building the export worktable, including name formatting time.

(U only) The User ID for the user who owns the export worktable.

(U only) The name of the saved export worktable.

(U only) The database where the export worktable is stored.

P - The code for the Report Groups lookup table entry that is associated with this row.

U - The code for the Report Groups lookup table entry that is associated with this row.

V - The code for the Report Groups lookup table entry that is associated with this row.

P - The code for the Maintenance 1 field from the Report Groups entry that is associated with this row.

Q - The code for the Maintenance 1 field from the Report Groups entry that is associated with this row.

T - The code for the Maintenance 1 field from the Report Groups entry that is associated with this row.

U - The code for the Maintenance 1 field from the Report Groups entry that is associated with this row.

V - The code for the Maintenance 1 field from the Report Groups entry that is associated with this row.

P - The code for the Maintenance 2 field from the Report Groups entry that is associated with this row.

Q - The code for the Maintenance 2 field from the Report Groups entry that is associated with this row.

T - The code for the Maintenance 2 field from the Report Groups entry that is associated with this row.

U - The code for the Maintenance 2 field from the Report Groups entry that is associated with this row.

V - The code for the Maintenance 2 field from the Report Groups entry that is associated with this row.

P - The code for the Access 1 field from the Report Groups entry that is associated with this row.

Q - The code for the Access 1 field from the Report Groups entry that is associated with this row.

T - The code for the Access 1 field from the Report Groups entry that is associated with this row.

U - The code for the Access 1 field from the Report Groups entry that is associated with this row.

V - The code for the Access 1 field from the Report Groups entry that is associated with this row.

P - The code for the Access 1 field from the Report Groups entry that is associated with this row.

Q - The code for the Access 1 field from the Report Groups entry that is associated with this row.

T - The code for the Access 1 field from the Report Groups entry that is associated with this row.

U - The code for the Access 1 field from the Report Groups entry that is associated with this row.

V - The code for the Access 1 field from the Report Groups entry that is associated with this row.

This is the User ID for the user or Millennium User Group whose defaults are defined in this row.

This flags the system to display the values only (N) or the codes followed by the values ( Y) within the MR.

This flags the system to send the report results to a Printer (P), HTML (S), PDF (F), or export (E).

This flags the system, if set to Yes (Y) to print the criteria when the set of criteria is run.

This flags the system, if set to Yes (Y) to save the export worktable that is created by the run of the criteria.

Not currently in use by the system.

Not currently in use by the system.

This is the flag signaling the use of the advanced name (1), preferred name (2), or no name (3) in the export worktable.

This signals whether the salutation name should be constructed Yes (Y) or No (N)

This tells the system the name type to use in construction the salutation name.

This tells the system the name type to use for the formatted name.

This indicates whether the criteria is or is not to be password protected. (no longer used)

This indicates whether deceased constituents should or should not be included.

This indicates whether the system should use cash (1), asset (2), or net present values (3).

This indicates whether spouse names should be combined if both are selected (2), combined if either is selected (3), or never combined (1).

This indicates whether duplicates should be included or excluded.

This indicates whether the setting for including an Address in the generic worktable is set to Selected (0), Preferred (1), or None (2).

If the export worktable uses them, this indicates the Address Type for the address information to be shown in the Home Address columns.

If the export worktable uses them, this indicates the Address Type for the address information to be shown in the Business Address columns.

This indicates whether the export worktable should be the generic table (0) or a custom layout.

This indicates whether one spouse's rows should be removed from the export worktable.

This is the path to the report formats.

Defaults to what is entered in System Info, Default Formats Location.

This indicates the default output option for this user, either Crystal (F), or Utilities (U).

This field identifies the default export format, either Word for Windows (0), Excel (1), Tab Delimited (2), Comma Delimited (3), or ASCII Text (4).

This field identifies the default output behavior when no format is selected (no output, tab delimited, or CSV).

This allows the user to specify a default location for Export worktables.

This field is a flag field. If set to 'Y', the Clipboard will be shown and enabled on the Report Form.

This field is used to hold the name of the queue to which the report will default for this user or this user group

This field is used to hold the descriptive name of the printer to which the report will default for this user or this user group.

Name of this standard parameter

This is the initial value of this parameter and will be the final value if the user is not permitted to alter the default value.

If 'Y', the user is prompted to enter a new value for this parameter when the criteria is executed. Otherwise, the default value is used.

This is the text used to prompt the user to change the default value if prompt_user = 'Y'.

This is the name of a lookup table-driven data field that is associated with this parameter. If this field is populated and prompt_user = 'Y', then, when the report is run, the user will be presented with a list box of valid table codes or values from the lookup table that the data field references. For example, if this field is populated with 'coreconst', then the user is presented with a list box of the valid codes or values from the constituent_types lookup table. He or she then chooses from this list.

On filling the list box with valid lookup table codes/values, a code of "*" representing any value will also be added.

This information must be in accordance with the data in the special_type field. If not, the information in the special_type field will take precedence.

This field is used to signal the nature of the data that will be accepted for this parameter.

A check box only accepts a 'Y' or 'N'. Year, Month, and Day displays a calendar and only accepts a year, month, or day. An 'F' prompts for a full date.
If a 'W; is in this field, the user will be prompted to enter the name of a new worktable, or select an existing worktable from a scrollable list.
Blank is a valid value indicating the parameter is not "special".

This is the free text description of the Queue.

This is the free text description of the printer to be used by the Queue.

This is the location of the printer as it is recognized by the computer.

This is the name of the printer, as it is known to the computer.

The name of the Queue - This is the free text description of the Queue, used to identify it to users.

This is the name of the computer where the database resides.

This is the full UNC path to the queue.

This field is not in use at the present time.

This is the name of the data database (for example, milldata)

This field is used in replicated database situations to identify the server to which the IIS is pointing. (SQL only)

This field is not is use as of Millennium 7.8

The primary key field. 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)

Run number

Start receipt number

End receipt number

Start receipt key

End receipt key

Run date

Receipts count

Payments count

Manual receipt flag

Run user

This is the user name of the user who owns this Sort definition. If the user is sa or MILLORA, then userid is millennium_admin.

This is the number of the table that the Sort defines.

This is the name of the field to be used as the basis of the primary sort order.

This indicates whether sortfield1 is to be ordered ascending (A) or descending (D).

This is the name of the field to be used as the basis of the second level of sort order.

This indicates whether sortfield2 is to be ordered ascending or descending.

This is the name of the field to be used as the basis of the third level of sort order.

This indicates whether sortfield3 is to be ordered ascending or descending.

This is the name of the field to be used as the basis of the fourth level of sort order.

This indicates whether sortfield4 is to be ordered ascending or descending.

This is the name of the field to be used as the basis of the fifth level of sort order.

This indicates whether sortfield5 is to be ordered ascending or descending.

This is the primary key field, automatically generated by the system on insert.

This field holds the name of the sort

If this sort is the active one for the data table on which it is defined, the value of this field will be 'Y'. If not, then the value of this field will be 'N'.

If this sort is the active one for the data table on which it is defined, when the data table is shown in Snapshot View, then the value of this field will be 'Y'. If not, then the value of this field will be 'N'.

ASC

This is the key (identifier) field for this row.

If the display string is used for a user's One Screen View display, then the value of this field is 'Profiles'. If the row is information that is used for displaying data display and maintenance forms, then the value of this field is the world within Millennium in which the display string is used.

If this is a One Screen View display string, then this is the Id of the sure who owns the One Screen View. Otherwise, this field is set to NULL for all rows.

This flags the row as being a standard, Millennium default data maintenance or display form or One Screen View (Y) or a site-defined customized one (N).

If this is a One Screen View display string, then the value of this field is 'onescreen'. If the row is information that is used for displaying data display and maintenance forms, then the value of this field is the display name for the table.

The number of the table described in this row.

If this is a One Screen View display string, then this field will be set to NULL.

The mode of display being described in this row. The possible modes are:

LONG
SHORT

MINI

SNAP
DIALOG
PALM
PALMDIALOG
TABLE

ECOMM

ECOMMDIA

Special

ONESCR

If this is a One Screen View display string, then this field will be set to NULL.

For those tables which may be displayed in different ways (for example, Basic Data has different displays for individuals, corporate, and other constituent types, giving data displays for the main and the allocation portions) or has different displays (for example, linked attribute vs. non-linked attribute displays) this field provides an indicator of which version of the displays is being described by this row.

If this is a One Screen View display string, then this field will be set to NULL.

ASC

The data table number or data display number as it is known to the system. For example, the Basic Data table has an options_tablenum = '00’. Giving Trends has an options_tablenum = '91’. (system field)

The name of the data table as it exists in the database or the name of the display as it is known to the system. For example, the Basic Data table has an options_name = 'corebio’. Giving Trends has an options_name = 'gifts’. (system field)

The name of the table as it displays in Millennium. For example, the Basic Data table displays as 'Basic Data’.

A flag to indicate if the data table HAS been removed from the Millennium display. If a table has been removed, then options_removed = '1’. If it has not been removed, then options_removed = '0’.

the name of the theme that is defined by this row.

This is the user Id for the user whose settings are defined in this row.

The background color of the display area.

The url to the image that is applied to the display area, if any.

The section header and data rows Edit button menu font type.

The section header and data rows Edit button menu font color.

If set to Y, the section header and data rows Edit button menu font style will be Bold.

If set to Y, the section header and data rows Edit button menu font style will be Italic.

The field labels' font type.

The field labels' font size.

The field labels' font color.

If set to Y, the field labels' font style will be Bold.

If set to Y, the field labels' font style will be Italic.

The data's font type.

The data's font size.

The data's font color.

If set to Y, the data's font style is Bold.

If set to Y, the data's font style is Italic.

The Highlight Text font color

The Accent Text font color

The section header font type

The section header font size. The maximum size allowed is 13pt.

The section header font color

If set to Y, the section header font style is Bold

If set to Y, display the section header font style is Italic

The Highlight Text font type. This is the same value as the Data's font type.

The Highlight Text font size. This is the same value as the Data's font size.

The Highlight Text font style is Bold, if set to Y. This is the same value as the Data's font style.

The Highlight Text font style is Italic, if set to Y. This is the same value as the Data's font style.

The Accent Text font type. This is the same value as the Data's font type.

The Accent Text font size. This is the same value as the Data's font size.

The Accent Text font style is Bold, if set to Y. This is the same value as the Data's font style.

The Accent Text font style is Italic, if set to Y. This is the same value as the Data's font style.

The Button text font type

The Button text font size

The Button text font color

The background color of the button

If set to Y, the Button text font style is Bold.

If set to Y, the Button text font style is Italic.

Each item that is returned by a Search Results Display (Profiles, Event, Circles and so forth) or Constituent List Display (Prospect, My Staff, and so forth) is shown on a separate row, or line. For ease in readability, the colors of the lines will alternate. This is the color of the even numbered rows.

Each item that is returned by a Search Results Display (Profiles, Event, Circles and so forth) or Constituent List Display (Prospect, My Staff, and so forth) is shown on a separate row, or line. For ease in readability, the colors of the lines will alternate. This is the color of the odd numbered rows.

table header font type

table header font size

Not used.

table header background color

If set to Y, the table header font style is Bold.

If set to Y, the table header font style is Italic.

The Millennium Explorer Menu ( Millennium Explorer) font type

Not used.

If set to Y, the Millennium Explorer Menu ( Millennium Explorer) font style is Bold.

If set to Y, the Millennium Explorer Menu ( Millennium Explorer) font style is Italic.

Not used.

The Millennium Explorer Menu ( Millennium Explorer) standard font color.

The Millennium Explorer Menu ( Millennium Explorer) font color when the item is highlighted

This is the primary key field, automatically generated by the system on insert.

The user Id of the Millennium user whose settings are defined in this table.

a string of table numbers that the system uses to determine which data tables to display when the user selects his or her Snapshot View of the data. For example, if a user's Snapshot View consists of the Basic Data, Address, Attribute and Internet Address data tables, this code will read 0002038189. (89 signals to the system that the string of table numbers has ended)

not used at this time.

not used at this time.

The primary key of the Sort that is applied to the user's Snapshot View of the name table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the name table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the address table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the address table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the attribute table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the attribute table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the relation table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the relation table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the gifts table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the gifts table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the jobs table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the jobs table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the school table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the school table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the dues table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the dues table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the comments table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the comments table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

not used at this time.

not used at this time.

The primary key of the Sort that is applied to the user's Snapshot View of the actions table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the actions table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the tasks table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the tasks table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the media table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the media table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the screener table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the screener table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the rating table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the rating table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the plannedgifts table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the plannedgifts table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

not used at this time.

not used at this time.

The primary key of the Sort that is applied to the user's Snapshot View of the memories table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the memories table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the finance table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the finance table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the demogrph table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the demogrph table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the correspondence table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the correspondence table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

This field is not in use at this time. The primary key of the Sort that is applied to the user's Snapshot View of the receipts table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

This field is not is use at this time. The primary key of the Filter that is applied to the user's Snapshot View of the receipts table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the national table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the national table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the phone table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the phone table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the research_source table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the research_source table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the membership table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the membership table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the quidpro table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the quidpro table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the pgrating table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the pgrating table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the securities table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the securities table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the giftinkind table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the giftinkind table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the solicitor table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the solicitor table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the honoree table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the honoree table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the creditcard table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the creditcard table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the payments table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the payments table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the subscription table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the subscription table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the benefits table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the benefits table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the proposal table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the proposal table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the custombio table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the custombio table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the customprospect table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the customprospect table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the sustainerpayments table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the sustainerpayments table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the contactinfo table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the contactinfo table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Sort that is applied to the user's Snapshot View of the internetaddress table. If the user's Snapshot View does not include this table, or if a Sort is not applied, then this field will be Null.

The primary key of the Filter that is applied to the user's Snapshot View of the internetaddress table. If the user's View does not include this table, or if a Sort is not applied, then this field will be Null.

This field holds the name of the first data field in a user's Copy to Clipboard layout definition. If the field references a lookup table and the user chooses to copy out the lookup table's code, then a 'c' will be stored in the eleventh position. If the user chooses to copy out the lookup table's value, then a 'v' will be stored in the eleventh position. This field will be Null if a user does not have a customized Copy to Clipboard layout definition.

See Clipboard Setup User Option, Addresses - Copy to Clipboard.

This field holds the name of the second data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there is no second column in the layout definition.

See copy_col1.

This field holds the name of the third data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only two fields in the layout definition

See copy_col1.

This field holds the name of the fourth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only three fields in the layout definition

See copy_col1.

This field holds the name of the fifth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only four fields in the layout definition

See copy_col1.

This field holds the name of the sixth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only five fields in the layout definition

See copy_col1.

This field holds the name of the seventh data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only six fields in the layout definition

See copy_col1.

This field holds the name of the eighth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only seven fields in the layout definition

See copy_col1.

This field holds the name of the ninth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only eight fields in the layout definition

See copy_col1.

This field holds the name of the tenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only nine fields in the layout definition

See copy_col1.

This field holds the name of the eleventh data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only ten fields in the layout definition

See copy_col1.

This field holds the name of the twelfth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only eleven fields in the layout definition.

See copy_col1.

This field holds the name of the thirteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only twelve fields in the layout definition.

See copy_col1.

This field holds the name of the fourteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only thirteen fields in the layout definition.

See copy_col1.

This field holds the name of the fifteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only fourteen fields in the layout definition.

See copy_col1.

This field holds the name of the sixteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only fifteen fields in the layout definition.

See copy_col1.

This field holds the name of the seventeenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only sixteen fields in the layout definition.

See copy_col1.

This field holds the name of the eighteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only seventeen fields in the layout definition.

See copy_col1.

This field holds the name of the nineteenth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only eighteen fields in the layout definition.

See copy_col1.

This field holds the name of the twentieth data field in a user's Copy to Clipboard layout definition. This field will be Null if a user does not have a customized Copy to Clipboard layout definition, or if there are only nineteen fields in the layout definition.

See copy_col1.

A string of '0's and '1's to tell the system to either display (1) or not display (0) the section header for a table that is included in the user's Snapshot View of the data. Note that this option is applied individually to each data table in his or her Snapshot View.

A string of '0's and '1's to tell the system to either display (1) or not display (0) the record separators for a table that is included in the user's Snapshot View of the data. Note that this option can be applied to each data table individually. Note that this option is applied individually to each data table in his or her Snapshot View.

If a user's Copy to Clipboard layout definition includes fields from the Internet Address data table and the user chooses to match Address to Internet Address by Utilization, the value will be 0. If the user chooses to match Address to Internet Address by Type, the value will be 1.

See Clipboard Setup User Option, Addresses - Copy to Clipboard.

If the user wants to include pop-up menus in his or her Snapshot View of the data, this field will be set to '1'. If not, this field will remain set at '0'. Note that this option applies to all of the data tables included in the user's Snapshot View; it cannot be set per individual table.

This is the user Id for the user whose settings are defined in this row.

This is the date on which this row was last updated.

This is the User ID of the operator who last performed an edit to this row.

This is the SQL group for the user_name (not the operator who entered the data for this row.)

This is the next Gift Transaction Number that should be used when this operator inserts a new Gift data row.

This is the next Dues Transaction Number that should be used when this operator inserts a new Dues data row.

This field holds a list of the table numbers in the order that they should be displayed according to this user's Defined Display preferences. Leading zeros are used when appropriate to list the table numbers and when this definition does not use all available table numbers, the number 98 is used as a placeholder.

This field holds a string of 0's and 1's - one for each data table, shown in order. These track whether the user last displayed each table in Short (0) or Long (1) or Mini (2) display mode.

This field holds a string of 0's and 1's - one for each data table, shown in order. These track whether the user last displayed each table with the Sort On (1) or Off (0).

This field holds a string of 0's and 1's - one for each data table, shown in order. These track whether the user last displayed each table with the Filter On (1) or Off (0).

This field holds a string of 0's and 1's to track User Options that are currently active for the user. These include the Transaction Display Options, and the Matching Options.

The first digit indicates the user's Lookup table permissions with 0 = none, 1 = select, and 2 - full. The second and third digits indicate the user's method of Membership Processing with 28 = by Membership, 08 = by Dues, and 05 = by Giving (Gift option not yet available).

For a user group, the fifth, sixth, and seventh digits indicate the Display Mask settings for social security numbers and bank account numbers respectively, with 0 = System Default Mask, 1 = No Mask, 2 = Mask all but the last 4 digits, and 3 = Mask all digits.

If the user is also a constituent on the system, this field holds the constituent Id.

This is the name of the Database group/role.

This is a free text comment that may be associated with this User ID.

This is the most recent date and time that this user logged on to the system.

This is the most recent date and time that this user logged off of the system.

This is the date on which the user information row was created.

This field will hold the oldest of the four previous passwords. (encrypted)

This field will hold the second oldest of the four previous passwords. (encrypted)

This field will hold the third oldest of the four previous passwords. (encrypted)

This field will hold the date the password was last changed.

This Y/N flag indicates whether the user must change their password at next login.

The primary key, from the alerts system table, of the last alert that was displayed to this user. This indicates to the system that this user has seen the alert referenced by this key, and to not show this alert again to this user.

If this user is a Visual Analyzer user, the value of this field is set to '1'; else it is set to '0'

If this user is a Visual Analyzer administrator, the value of this field is set to '1'; else it is set to '0'.

If this user is a Millennium system administrator, the value of this field will be set to '1', else it is set to '0'.

This field will hold the user's current password (encrypted).

This field holds the user's Millennium Display theme option - Green, Orange, Blue, Red, or Custom. This option is set on the Display Theme page.

This field will hold the user's Millennium and MS Outlook Integration settings as follows:

Character - 0/1 - Enable Outlook Integration flag

Character - 0/1 - Synchronize at login flag

Character - 0/1 - Synchronize before logoff flag

Character - 0/1 - Synchronize when opening My Tasks

Character - 0/1 - Synchronize every X minutes is checked

Integer -              The value of X minutes entered in the option above.

Character - 0/1 - if Always use Millennium data is selected, set to 0. If Use data with latest timestamp is selected, set to 1

Integer -                The value of X in the synchronize tasks with Outlook having an end date within the last X days

This field holds a code that determines the user's access WealthEngine. If the user is allowed to perform only WealthEngine imports, the value of this field is set to 1. If the user is allowed to perform only WealthEngine search, the value of this field is set to 2. If the user is allowed to perform both WealthEngine imports and searches, the value of this field is set to 3. If the user is not allowed to perform WealthEngine imports or searches, the value is set to 0.

This field holds a string of 0's and 1's - one for each kind of linked data (for example, Attributes linked to Basic Data) that can be sorted, shown in order. These track whether the user last displayed the linked data with the Sort On (1) or Off (0).

This field holds a string of 0's and 1's - one for each kind of linked data (for example, Attributes linked to Basic Data) that can be Filtered, shown in order. These track whether the user last displayed the linked data with the Filter On (1) or Off (0).

This field holds the user's option to display or to not display the Community Brands footer frame at the bottom of each display page. Each user sets this option on the Display Theme page.

For sites that use Named User Accounts to access WealthEngine, this field holds the WealthEngine Account Name that is assigned to the user.

This field is not in use at this time.

If this user is a Visual Analyzer user, this field is the Qlikview Group to which he or she belongs. A site can create special Groups, through Group Maintenance, just for Visual Analyzer users.

This is the SQL user group name. (Example: mill)

This field holds the Views that are to be associated with data tables 0 through 13.

This field holds the Views that are to be associated with data tables 14 through 27.

This field holds the Views that are to be associated with data tables 28 through 41.

This field holds the Views that are to be associated with data tables 42 through 55.

This field holds the Views that are to be associated with data tables 56 through 69.

This field holds the Views that are to be associated with data tables 70 through 83. (Reserved for future growth.)

The name of the external application. The name must be unique.

The path to the external application. This will function as a hyperlink.

A free-text description of the external application.

This is the code used to identify a View. This code is used in the uview1-6 fields in the Userview table, and consists of a three letter table prefix, followed by three digits. (Example: cor000)

This is the number of the table that is the source for the View.

This field contains the WealthEngine Account Name entered in System Options.