Basic Data

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 column)

I,C,O

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 column)

I,C,O

This field holds a Y/N flag to indicate the existence of a linked document for this row.(System column)

I,C,O

The date that this Core row was last updated. This field is automatically entered by the system.(System column)

I,C,O

The User ID of the operator that last edited this Core row. It is automatically entered by the system.(System column)

I,C,O

This field holds the Group letter that was associated with the User ID of the operator who last edited this row.(System column)

I,C,O

The Constituent Type field is used to classify constituents according to the standards or needs of your institution. You may have a need to categorize your constituents in a way other than the more rigid categories established by the CAE. This lookup table and field allow you to do so. (for example, Alumni, Friend, Individual, Patient, Foundation, Corporation, Religious Organization, etc.). (Don't confuse this field with the CAE Category.).

I,C,O

Indicates the gender of this constituent. The field may be left blank, it may be M for male, it may be F for female, X for non-binary, or it may be C to indicate that this row is a combined row for a spousal pair.
Note that gender information is one of the considerations when System-generated Names are created. If this information is not available when spouse combined name forms are created, results may vary.

I

Indicates the marital status of this constituent. If this field is set to Married and then a Death data row is entered for the constituent, this field is automatically set to Deceased Spouse, and if there is a constituent spouse, this field is set to Surviving Spouse. If a non-constituent spousal Relationship is changed to Deceased Spouse/Surviving Spouse, the Marital Status is also changed accordingly. If a spousal

I

Indicates your certainty of the information in the corechnum field. This field may be blank, it may be "=" or it may be ">=" (to indicate that you know that the constituent has at least the number of children indicated in corechnum, but you are not confident that is the exact number of children).

I

Indicates the number of children that you know the constituent to have.

I

Indicates the birth date of this constituent.

Note that each institution may choose to use this field OR the separate month, day and year fields (corebrthmn, corebrthdy, corebrthyr) and edit their display and data maintenance definitions accordingly. Using one option will not automatically populate the field(s) for the other option.

I

An alternate ID for this constituent. Often used if the constituent resides on another database within the institution.

I,C,O

Indicates the year that this constituent's youngest child will graduate from the institution. This is a four-digit year between 1600 and 2200.

I

Indicates the school within your institution from which this constituent's youngest child will graduate.

I

Indicates the class with which this constituent prefers to be associated. This is a four-digit year between 1600 and 2200.

I

Indicates the school within the institution which this constituent prefers to be associated.

I

Indicates the ethnic group with which this constituent is to be associated.

I

Indicates the industry with which this corporation is affiliated.

C

Indicates the type of foundation or organization represented in this row.

O

Indicates the total number of employees for the corporation.

C,O

Indicates the total number of employees of this corporation who have a constituent row in Millennium (and thus are "known" to the system.). This field is automatically updated when a Jobs row is created for a constituent that indicates an employment link between that individual and this corporation. (System column)

C,O

Indicates the total number of alumni employees. This field is automatically updated when a Jobs row is created for a constituent that indicates an employment link between that individual and this corporation and the individual has a CAE Category of A (Alumni). (System column)

C,O

If the corecorpid field includes the ID Number of a parent company, then this field will hold a copy of the key field from one half of the Relationship row that records that relationship.

C,O (System column)

If the corecorpid field includes the ID Number of a parent company, then this field will hold a copy of the key field from the other half of the Relationship row that records that relationship. (System column)

C,O

This field displays the name of the parent corporation. During data entry the name or the ID number may be entered.

C,O

Indicates the total number of subsidiaries this constituent parent corporation has.

C,O

Indicates the number of subsidiaries who are also constituents (and therefore "known" to the system) for this corporation. (System column)

C,O

Indicates the first proposal deadline month.

C,O

Indicates the first proposal deadline day.

C,O

Indicates the second proposal deadline month.

C,O

Indicates the second proposal deadline day.

C,O

Indicates the third proposal deadline month.

C,O

Indicates the third proposal deadline day.

C,O

Indicates the fourth proposal deadline month.

C,O

Indicates the fourth proposal deadline day.

C,O

Indicates the date that this constituent's row was created on the system. This field is automatically entered by the system and may reflect the date of conversion if your prior system did not maintain this data. (System column)

I,C,O

Indicates the category for this constituent as defined by the CAE. When a new basic data row is inserted, the triggers will automatically populate this field with contents of the table_cfae field of the constituent_types table. If a basic data row is updated, and that update includes a change in coreconst (Constituent Type), the update triggers will automatically change the value of corecfae. Override this behavior by editing the data row after insert or after update, and manually entering a corecfae code

I,C,O

Indicates the source of the information contained in the Basic Data row.

I,C,O

Indicates the month from the first of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the day from the first of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the month from the second of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the day from the second of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the month from the first of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the day from the third of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the month from the first of four dates this company may use as a deadline for accepting matching gift forms.

C,O

Indicates the day from the fourth of four dates this company may use as a deadline for accepting matching gift forms.

C,O

The Default Account Number field allows you to identify an account number that will automatically be filled into the Insert form for gift or dues transactions for this constituent, when used in connection with the Default form creation of transactions. If you enter the word, "default" in the Account Number field of the Gift or Dues Default form, the transaction will be created, using the Default Account Number field in Basic Data as the Account Number for the Transaction.

You may ignore this account number when creating gifts or dues transactions by using the Insert rather than the Default form or by entering an account rather than the word, "default" in the Default definition.

When an account is entered for this field, the Account name from the lookup table is also copied to the coreacctnm field and it is that data that is shown in the display of Basic Data.

I,C,O

The Title Bar field is a free text field of up to sixty characters. The text in this field will display in the title bar after the name. Some possible uses for this field might be to designate a Top Prospect, VIP or to remind operators Do Not Release Info. This field is simply free text and it is not the same as linking rows or entering data that will automate any other features.

I,C,O

Indicates the minimum gift amount that this company will match for the first of three possible, distinct ratio range amounts

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the maximum gift amount that this company will match for the first of three possible, distinct ratio range amounts.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the first of a set of distinct matching gift ratios for this company, based on the size of the original transaction. Each of these ratios may be associated with one, distinct gift amount range. When an individual's gift transaction is entered and that individual is employed by a matching gift corporation, the system will compare the individual's gift to the gift amount ranges in the corporation's Basic Data row and prompt for the creation of a match pledge or match potential transaction for the corporation, using the appropriate ratio for the size of the individual's gift to calculate a default amount of the matching gift for the insert form. If necessary, due to other matching guidelines, the amount should be edited before creating the matching pledge.

If you are entering fewer than three ratios, you must use the first (the top field box) first.

If an Employment row identifies this constituent as the employer, AND if this coremratl field shows a matching ratio, the Employment row is automatically updated to set the jobsmflag field (Matching Company?) to Y.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the minimum gift amount that this company will match for the second of three possible ratios.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

I,C,O

Indicates the maximum gift amount that this company will match for the second of three possible ratios.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

I,C,O

Indicates the second set of distinct matching gift ratios for this company, based on the size of the original transaction. Each of these ratios may be associated with one, distinct gift amount range. When an individual's gift transaction is entered and that individual is employed by a matching gift corporation, the system will compare the individual's gift to the gift amount ranges in the corporation's Basic Data row and prompt for the creation of a match pledge or match potential transaction for the corporation, using the appropriate ratio for the size of the individual's gift to calculate a default amount of the matching gift for the insert form. If necessary, due to other matching guidelines, the amount should be edited before creating the matching pledge.

If you are entering fewer than three ratios, you must use the first (the top field box) first.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the minimum gift amount that this company will match for the third of three possible, distinct ratios.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the minimum gift amount that this company will match for the third of three possible, distinct ratios.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

Indicates the third set of distinct matching gift ratios for this company, based on the size of the original transaction. Each of these ratios may be associated with one, distinct gift amount range. When an individual's gift transaction is entered and that individual is employed by a matching gift corporation, the system will compare the individual's gift to the gift amount ranges in the corporation's Basic Data row and prompt for the creation of a match pledge or match potential transaction for the corporation, using the appropriate ratio for the size of the individual's gift to calculate a default amount of the matching gift for the insert form. If necessary, due to other matching guidelines, the amount should be edited before creating the matching pledge.

If you are entering fewer than three ratios, you must use the first (the top field box) first.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM.

C,O

A flag to indicate whether or not this row has attached Attribute rows. (System column)

I,C,O

Indicates the country of birth for the constituent.

I

This is a copy of the Group field from the Constituent Type Lookup table entry that was chosen for the coreconst field. It signals the system for the appropriate use of the Individual, Corporation or Organizational form of the Basic Data page. It is automatically assigned by the system. (System column).

I,C,O

The table number of the current table. (System column)

I,C,O

A free text Comment that may be entered and displayed with this Basic Data row only.

I,C,O

A free text Comment, used for additional details about a corporation or organization's matching gift policies.

C,O

This flag indicates whether the Basic Data row belongs to an "active" constituent.

I,C,O

If the constituent is a matching gift company, this flag indicates whether they will or will not match the quid pro quo portion of the original constituent's gift.

C,O

Indicates the year that this constituent's youngest grandchild will graduate from the institution. This is a four-digit year between 1600 and 2200.

I

This field holds a copy of the Account Name for the Default Account (corerest).

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

This field is available for Profile Searches.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This field is a flag to indicate whether this data row will or will not be available for online publishing. This flag will be applicable when the Options for Publishing Data for the Basic Data table are set to 'Published by Consent'. Otherwise, the corepub00 field flag in the Basic Data table will be used.

I,C,O

If the constituent is a Corporation or Foundation that matches donations made by its employees or others, but if the matching funds are actually administered and delivered by another entity (such as a foundation created specifically for such a purpose), this field is used to hold a copy of the ID Number of that entity - also a constituent. If thePull Match Ratios from the Corporation system option is set to No, then the matching information from the 'Match Through' constituent is automatically copied to the corresponding fields for the original constituent. The following fields will be copied: coremrat1, coremxamt1, coremnamt1, coremduem1 coremdued1, coremrat2, coremxamt2, coremnamt2, coremduem2, coremdued2, coremrat3, coremxamt3, coremnamt3, coremduem3, coremdued3, coremduem4, coremdued4, corequidm, corespmfl, coreretmfl, matchcomm, corempkey.

Note that if your institution uses the optional Millennium component CorrectGM, and if the constituent you identify in this field as the Match Through entity already has a link to an entity in the Match Parent table, that same linkage will be established for the initial constituent using the corempkey field.

During giving data entry if you have activated the option to have the system suggest matching pledge or match potential transactions, and if the coremtchid field is populated in the Basic Data for the matching employer, the insert form for the Match Pledge or Match Potential will automatically show the Match Through ID as the source of the pledge or potential, rather than the actual employer.

C, O

If your site uses the optional Millennium component,Online Constituent Directory, this field is used to store the constituent's user name for logging onto your institution's member website.

I, C, O

If your site uses the optional Millennium component,Online Constituent Directory, this field is used to store the encrypted value of the constituent's password for logging onto your institution's member website.

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Basic Data information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Basic Data information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Name information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Name information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Address information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Address information for all constituents via the eDirectory under Options for Publishing Tables.)

'2' = 'Do Not Hide'

'1' = 'Hide the Phone Number'

'0' = 'Hide'

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Attribute information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Attribute information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Relation information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Relation information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Giving information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Giving information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Employment information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Employment information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Education information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Education information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Dues information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Dues information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Phone information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Phone information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Membership information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Membership information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

This field acts as a flag to indicate that any transactions that are created for this constituent should always, automatically be set to activate the Joint with Spouse option.

I

This field acts as a flag to indicate that any transactions that are created for this constituent should always, automatically be set to activate the Credit for Spouse option.

I

If the constituent has any Relationship rows which have the Credit for Other (relothcrd) flag set to 'Y', the system will automatically set this flag to Y. (System column)

I,C,O

If this row belongs to a corporation or other type of constituent that provides matching gifts, this field is used to flag whether they will do so for retired employees, as well as active employees.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM. (System column)

C, O

If this row belongs to a corporation or other type of constituent that provides matching gifts, this field is used to flag whether they will do so for gifts made by the spouse of employees.

If your institution uses the optional Millennium component, Correct GM, this field will be updated automatically in accordance with the most current matching data available from Higher Education Publishing. See Correct GM. (System column)

C, O

If your institution uses the optional, Correct GM component of Millennium, and if this row belongs to a corporation or other type of constituent that provides matching gifts, this field is used to track the link to a corresponding row in the Match Parent table with a copy of the key field from that table. When such a link is established, AND if the Pull Matching Ratios from the Corporation system option is set to No, the system automatically copies data from the Match Parent table into the coremnamt1, coremxamt1, coremnamt2, coremxamt2, coremnamt3, coremxamt3, coremrat1, coremrat2, coremrat3, coreretmfl, and corespmfl columns. When the Match Parent table is periodically updated (a regular function of the CorrectGM component) those same fields will also be updated on the basis of this linkage IF the Pull Matching Ratios from the Corporation system option is set to No. (System column)

C, O

This field, along with corebrthmn and corebrthdy, provide an alternative to the use of the corebirthd field. This is a four-digit year between 1600 and 2200.

Your institution has the option to modify the display and maintenance definitions of the Basic Data row and replace the corebirthd (a true datetime/date field which includes all three pieces of the date) with all or some of the fields corebrthyr, corebrthmn, and corebrthdy which store the three pieces of information in separate columns. Using one option will not automatically populate the field(s) for the other option.

I

If your site uses the optional Millennium component,Online Constituent Directory, this field is used to store a constituent's hint question. This would usually be a question provided by the constituent, along with an answer (coreanswec), used to verify the identity of the constituent before e-mailing a forgotten password for logging onto your website (corepwdec). (System column)

I, C, O

If your site uses the optional Millennium component,Online Constituent Directory, this field is used to store a constituent's answer to a hint question (corehintec). This is used to verify the identity of the constituent before e-mailing a forgotten password for logging onto your website (corepwdec). (System column)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's Comments information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the Comments information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's email (via internetaddress table) information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the email (via internetaddress table) information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

If your site has purchased the optional Millennium component, Online Constituent Directory, this field is used to indicate whether any of this constituent's custombio information may or may not be used for publication on your institution's website.

(Note that your institution will need to set the custombio information for all constituents via the eDirectory under Options for Publishing Tables.)

I, C, O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any date information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to flag this data row for any purpose.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

I,C,O

An alternate ID for this constituent.

I,C,O

An alternate ID for this constituent.

I,C,O

An alternate ID for this constituent.

I,C,O

An alternate ID for this constituent.

I,C,O

If this row is created or updated from data that originally came from the corebio_pending table, then this field will hold information about the data's import source. Data from the Online Constituent Directory will have a source of Online Directory. Data from Soft Edit users will have a source of Soft Edit. Data whose import source is the ADE Import Tool can be assigned a value (other than Online Directory or Soft Edit) from the ade_source lookup table by the user who executes the utility, or the source can be blank.

If your site uses the optional Millennium component,Online Constituent Directory, this field is used to store the IP Address of the computer that the constituent used to log on to your institution's member website.

This field is used by your institution to identify and categorize constituents who are delinquent with payments and/or outstanding pledges.

This field is used by your institution to give a constituent an Active or Inactive status (such as Active, Inactive - deceased, Inactive - moved, Inactive - removed by request).

I,C,O