Addresses
A constituent can have an unlimited number of Address rows. Each row will be assigned an Address Type identifying it as a home, business, college, or any other type of address desired. In addition to the information necessary to create a mailing address, other information (such as phone numbers, fax number, modem number, county, and time zone) is recorded in the Address row. Your institution may classify certain zip code ranges into districts, regions, territories, or zones for your own purposes.
You may designate the particular months for which any address is valid, if an address is seasonal. You may assign Start and Stop dates to the address if the address is temporary.
A Locator (addrlocatr) is used to describe the validity of the address information. If the information is presumed to be current, it is labeled Good. If it has been returned at least once by the postal system, you may choose to label it Returned. If you conclude that it is not valid, it may be considered Lost. If you want to keep an archive of previous address information for certain groups of constituents or for all constituents, you may use the Update Address function, which uses a Locator of Former for historical information.
Utilization codes are available to designate that certain address rows are to be used for certain kinds of mailings on a constituent by constituent basis. For example, a constituent may want that newsletters be sent to the Business address while solicitations are to be sent to the Home address.
The first Utilization code (addrmc1) is used by the system to designate an Address row as the preferred address. While the system does allow a constituent to have multiple preferred addresses, or no preferred address at all, one and only one Address row for each constituent should be designated as the preferred address; to be used in all default situations.
You may choose to keep a history of all former addresses if you want, or you might choose to do so only for a select set of constituents. If you choose to maintain former address information, you should use the Start and Stop dates and the Locator field to track the past addresses. You may also use Millennium's Update/Archive function to assist you in archiving a former address as you create a new one.
Address rows may be linked to addresses that belong to a spouse or another constituent and then when edits are made to one, they will also automatically be made to the other. Address rows may also be linked to Employment rows that belong to the same constituent, allowing you to incorporate the job title as part of a business address. Phone rows may also be linked to an Address.
In addition to address information, this table supports a secondary table for additional Phone Numbers (those that are not linked with a particular Address as well as those that are) and Internet Addresses.
Note: Millennium system administrators or the database administrator can configure audit logging for the Address data table. For more information, see Audit Log.
If your organization uses Instant Address:
The 
Envelope button displays next to the Line 1 field to indicate that Instant Address is available to help you enter a valid mailing address or verify that a mailing address is valid according to "postal authority data". Instructions for using Instant Address are located in the Using Instant Address to enter and verify addresses topic.
What is Instant Address?
Instant Address is a third party service that is offered by Initium Software and integrated into Millennium. It assists users when entering and updating address information by providing real-time address autocomplete functionality and address verification. For information about Initium Software and Instant Address, visit www.initiumsoftware.com.
Countries Considerations
Address ZIP Codes and Non-USA Countries
When Millennium is installed, the ZIP Code lookup table (zipcodes) is included containing standard USA zip code information (only). When you create an Address row indicating USA as the Country (as described below), the system will assume that the ZIP Code text box for that Address will contain an entry from the ZIP Code lookup table. In that case, the system will examine the first five characters that you enter in that text box and compare them to the lookup table. The remaining characters in the text box are treated as free text. This allows you to enter the ZIP plus four digits or not, as you prefer. The system will automatically format the text you enter as five characters, dash, and the remaining characters.
USA/Non-USA Countries
The system interprets an Address to be USA if one of the following conditions is met:
- The Country text box is left blank on the Insert or Update form.
- The Country which is selected from the list box is one whose row in the Countries lookup table has a Group designation that is anything other than for (foreign). This would include a blank for the Group field.
Therefore, in order to have the system treat the entire ZIP Code text box as free text and not apply USA formatting to the data you enter, you must choose an entry from the Country lookup table that does have a Group of for. When you use such an entry, the standard Address display will show that row with the notation, Non-USA following the Address information.
Automatic Data Entry from the ZIP Code Lookup Table
When USA is the Country (according to the definition above), and therefore , the system will utilize the ZIP Code lookup table while creating a new Address row to find the matching ZIP Code entry and then automatically copy several other standard fields in that same ZIP Code row into the Address row. In addition, your institution may have defined some of the optional fields in the ZIP Code lookup table and if so, that information will also be copied into the Address row along with the other standard data. These fields are:
City (standard)
Place (standard)
County (standard)
Time Zone (standard)
Longitude (standard)
Latitude (standard)
District (optional)
Region (optional)
Territory (optional)
Zone (optional).
This behavior occurs automatically when an Address row is inserted, even if you have entered contradictory information for any of the fields listed above, in the insert form. Therefore, when creating new Addresses which use a USA ZIP Code you should make it a practice to leave the text boxes for the listed fields blank and allow the system to fill them in. You should fill in any of the additional text boxes as desired (Type, Locator, Utilization, etc.)
You may override the automatic entry of certain of this data from the ZIP Code information to the Address row if you want, by editing the data row once it has been created. If you manually edit any existing data in the City, State, District, Region, Territory, or Zone, the system will accept your data in preference to the data that corresponds to the ZIP Code lookup entry.
When editing an Address row, if you edit the ZIP Code itself but do not edit the data from any of the listed fields on the same edit form, the system will assume that you do not want to override the automatic behavior and it will automatically edit the listed data fields to conform to the ZIP Code entry in the zipcodes lookup table that you entered as an edit.
When editing an Address row, if you edit the ZIP Code itself AND you also manually edit any of the listed data columns, the system will accept your data as an override for those that you changed. It will automatically edit any of the remaining listed fields that you do not manually edit, using the data in the ZIP Code lookup table entry that you choose.
Note: The following fields are only allowed to be changed during the Edit process after an address row has been inserted, they cannot be forced during the insert process; County, Region, District, Zone, Territory.
Automatic Data Entry from the Countries Lookup Table
When you use a non-USA Country (according to the definition above) while creating a new Address row, the system ignores the ZIP Code lookup table, but instead automatically copies several other fields from the Countries lookup table row into the Address row, if your institution has chosen to make use of them. These fields are:
District (optional)
Region (optional)
Territory (optional)
Zone (optional).
This behavior occurs automatically when an Address row is inserted even if you have entered contradictory information for any of these fields in the insert form. Therefore, when creating new Addresses which use a non-USA Country, you should make it a practice to leave the text boxes for the listed fields blank and allow the system to fill them in. You should fill in any of the additional text boxes as desired (Type, Locator, Utilization, etc.)
You may override the information that was automatically entered in this way by re-accessing the data row (after it has been created) and editing the desired information.
Address Utilization
Specific kinds of mailings may be directed to a certain address if desired. For example, you might want all alumni mailings to go to the home address, while all athletic mailings would go to the business address. The Address Utilization portion of the input screen permits you to assign these mailing preferences.
The Address Utilization portion of the maintenance screen shows check boxes for up to twenty Utilization codes. You may define these codes as you want using the Address Utilization lookup table. Any entries in that lookup table that have not been re-defined at your institution will display as Utilization 9, Utilization 10, etc.
All twenty Utilizations are included on the Data Maintenance form for the Address data table. The Long Display form will show the label 'Utilizations:', and then list the labels for all Utilizations that are checked (that is to say, set to 'Y'). If you want to add one or more, but not all, of the Utilizations to a different Display form (for example, Short, or Mini), do so via the Custom Display Designer by selecting addrmc1, addrmc2, and so forth, from the Customizer's Data Field List Box. But, be aware that the labels for these codes will no longer be automatically derived from the address_utilization lookup table, but from the data column's alias in Millennium's fieldlst system table.
Preferred Address
For consistent results in reporting using Address rows, constituents should have one (and only one) Address row that is checked as the Preferred Address (the first position in the Utilization area and lookup table Code 1). If your system administrator has enabled the Check Preferred Address system option and you attempt to enter more than one preferred address, you will receive a warning. And, if this system option is enabled and a constituent does not have a preferred address and you enter one and do not mark it preferred (or remove the preferred address designation from an existing address, leaving a constituent with no preferred address), you will receive a warning.
Updating Address Records
Update/Archive
If your institution makes it a policy to retain the details of previous address information for some or all constituents, the Address Update/Archive function will facilitate the processing of that information.
The Address Update/Archive function is available via the context menu for the specific Address row. This menu is accessed by passing the mouse pointer over the Edit button to the left of that row and choosing Update/Archive. This item will only be available for Addresses that have a Locator set to 'Good'.
When the Address row is updated, the system automatically performs several edits to that existing address row and then prompts for the creation of an address row for the new information. (Remember that the Update function is available in addition to the standard editing functions.)
When using the automatic update, the following things occur:
The original Address row's Locator is changed to Former.
The Type is set to the 'former' version of the original Type (Home becomes Former Home, Business becomes Former Business, etc.). It is important that each address type entered in the address_types lookup table has a corresponding 'former' version of that type also entered in the address_types lookup table in order for this to function correctly.
If the original row does not already have a Stop Date, it will be set to the Start Date that is manually entered for the new Address row. If none is manually entered, it will be set to the current day's date.
The Utilizations are unchecked.
That data row is saved and closed. (Note that if this Address row was linked to other Addresses, these automatic updates will also occur for those data rows in the same way that they would occur if the edits were entered manually.)
Most of the information from the previous Address is copied to a new, Insert form, with these exceptions:
- If the original already had a Stop Date, that date will default to the Start Date in the insert form.
- If the original did not have a Stop Date, the current day's date will default to the Start Date in the insert form, but it may be manually edited prior to the creation of the new Address row. If it is manually edited and there was no Stop Date in the original, the Start Date of the new row will become the Stop Date of the original.
- The Locator is set to Good.
- The District, Region, Territory, and Zone are removed from the Insert form. (The system enters that information automatically, based on the ZIP Code that is entered.)
All of the information that is shown in the Insert form is available for editing before you click Insert to create the data row.
If you Update/Archive an Address that links to an Employment row, the Archived Address row and Employment row are unlinked and the new Address row is automatically linked to the Employment row.
Manual Update
You may use the Locator entry former and/or the former Address Types in data maintenance forms to manually update Address rows. If you set an Address Locator to former, the system will automatically set the Address Type to the former version of the original Type (Home becomes Former Home, Business becomes Former Business, etc.). Each address type entered in the address_types lookup table will have a corresponding 'former' version of that type also entered in the address_types lookup table in order for this to function correctly. The system will also clear the Preferred Address utilization. However, if you set an Address Type to the former version of the original Type, the system will not automatically set the Locator to former, nor will it automatically unchecked the Preferred Address utilization.
If you update an Address that links to an Employment row with an Active job status by setting the Address's locator and type to Former, you will be prompted to set the Employment row's status to No Longer at this Position. The Address row will remain linked to the Employment row regardless of your choice at the prompt.
Copy to Clipboard
The Copy to Clipboard function allows you to copy to the clipboard specific Address row information and other information that directly relates, or is linked to, a specific Address row. Each user can customize his or her own Copy to Clipboard layout definition. Up to twenty data fields from the Address, Employment, Internet Address, Name, and Phone data tables can be included in the definition. Each user's Copy to Clipboard definition is set using the Clipboard Setup User Option.
- The copied information will not be visible to the user until the application to where you want the information pasted (for example, WordPad) is opened. Once opened, use the appropriate menu item from this other application to Paste, and then your selected data fields will be visible.
- If you are pasting to Notepad, your selected data fields will not be separated by carriage returns.
To use Copy to Clipboard with Internet Explorer:
- Point to the Edit button
located to the left of the Address row. - Click Copy to Clipboard.
- Open the application to where you want to paste the information (for example, WordPad).
- Use the appropriate menu item from this application to Paste.
To use Copy to Clipboard with Firefox and Chrome browsers:
- Point to the Edit button located to the left of the Address row.
- Click Copy to Clipboard. A message displays to show you the information that you will be copying.
- On your keyboard, press Ctrl+C.
- Press Enter or click OK to close the message.
- Open the application to where you want to paste the information (for example, WordPad).
- Use the appropriate menu item from this application to Paste.
Note: The Copy to Clipboard feature is not available for Safari users.
Copy to Clipboard will copy out the data fields that you have selected in your Copy to Clipboard layout definition, according to these rules:
- If one or more Name data fields are included in your definition, Copy to Clipboard will ASCII order the constituent's Name rows by name type (nametype) and then select the first one. If there is a preferred name. and your site's code for the preferred name is 'a', then that will be the Name row selected; otherwise, the first name found will be used.
- If one or more Employment data fields are included in your definition, Copy to Clipboard will select the Employment row that links to your selected Address. If no Employment row is linked to your selected Address, then no Employment data fields will be copied out.
- If one or more Phone Number data fields are included in your definition, Copy to Clipboard will select the Phone Number row that links to your selected Address. If no Phone Number row is linked to your selected Address, then no Phone Number data fields will be copied out. If more than one Phone Number row are linked to your selected Address, Copy to Clipboard ASCII order them by phone type (phntype) code, and then select the first one.
- If one or more
Internet Address data fields are included in your definition:
- If your definition matches Address to Internet Address by Utilization, and your selected Address is the constituent's preferred address, Copy to Clipboard will select the constituent's preferred Internet Address row (intmc1 = 'Y'). If no preferred Internet Address row exists, then no Internet Address data fields will be copied out. And if your selected Address is not the constituent's preferred address, then no Internet Address data fields will be copied out.
- If your definition matches Address to Internet Address by Type, Copy to Clipboard will select the Internet Address row that matches your selected Address by type. If no Internet Address of that type exists, then no Internet Address data fields will be copied out. If more than one Internet Address row matches your selected Address, then Copy to Clipboard will select the first one found.
- Copy to Clipboard will not copy out former web or former email addresses.
-
If the Address City Line is included in your definition, it will display City, State, Zip and/or Country as follows:
City, State Zip
Example Mr. John Doe
555 Community Brands Road
Lynchburg, VA 24502-3818
If there is not a value in State (addrplace), but there is a value in Postal Code (addrzipcod) it will display:
Zip City
Country
Example 1 Example 2 Mr. John Doe
Mr. John Doe
St. Peter Freienstein
555 Bay St., Suite 1000
2P 4L 6K Bzi Leoben
M5J 2S1 Toronto, Ontario
Austria
Canada
If there is not a value in State (addrplace) and there is not a value in Postal Code (addrzipcod) it will display:
City
Country
Example 1 Example 2 Mr. Edward W. Bickford, Jr.
Mr. John Doe
32/25 Taranto Rd.
555 Sunny Lea Avenue West
Marsfield NSW 2122
Toronto, Ontario M8Y 2J8
Australia
Canada
If a user does not have a Copy to Clipboard layout definition, then the standard Copy to Clipboard layout will be used.
This standard includes the following data columns, in order, and adheres to the rules listed above.
- Formatted Name
- Job Title (from linked Employment Row)
- Company Name (from linked Employment Row)
- Address Line 1 (if not blank)
- Address Line 2 (if not blank)
- Address Line 3 (if not blank)
- Address City Line (the formatted City, State, Zip and Country line)
Write a Letter
By using an address row's Write a Letter Edit button menu item, the system will automatically generate a 'form' letter for the constituent. The letter will include the constituent's name, salutation, and the information from the selected address row. See the Write a Letter topic for details about this feature.
The Write a Letter feature works only for the Internet Explorer browser.
Address Dates
There are several fields in the Address row that are used to track dates that are associated with the address. Each is designed for a different purpose, and several are automatically maintained by the system.
|
addrcrdate |
This is the date on which this row was created. It is entered by the system and is not modified. |
|
addrdate |
This standard Millennium field records the last date that any information in the Address row was edited. It is entered and maintained by the system. |
|
addraddrdat |
This field records the last date on which the Lines 1, 2, or 3, City, State or ZIP Code fields (only) were edited. It would not be updated (for example) if Phone Number information were added to an Address row. This allows you to track the "age" of the most significant address information. It is entered and maintained by the system. |
|
addrstart |
This is first date on which the address information is valid for the constituent. This information is entered and maintained by the user. |
|
addrstop |
This is the last date on which the address information is valid for the constituent. This information is entered and maintained by the user. |
|
addrncoadt |
This date is used with CorrectAddress (an optional Millennium component) and tracks the date of the certification of this address. It is entered and maintained by the system, via CorrectAddress. |
|
addrcaupdt |
This date is used with CorrectAddress (an optional Millennium component) and tracks the date that CorrectAddress made a change to the address. It is entered and maintained by the system, via CorrectAddress. |
|
addrlacsdt |
This date is used with CorrectAddress (an optional Millennium component) and tracks the date that CorrectAddress made a LACS change to the address. It is entered and maintained by the system, via CorrectAddress. |
|
addrccupdt |
This date is used with CorrectCall (an optional Millennium component) and tracks the date that CorrectCall made a change to the phone number in the row. It is entered and maintained by the system, via CorrectCall. |
| addrindate | This date-time field is used with Initium Instant Address and tracks the date and time the address was validated by that utility. |
Linked Address Rows
It is possible to create a link between a particular Address row and certain other rows in the database, possibly belonging to another constituent. In this situation, the data from the linked row is not displayed with the original. The hyperlink text acts a cross reference telling you the destination of the hyperlink jump. When you click that text to execute the jump, the linked row will be displayed. That display will also include hyperlink text that will return you to the display of the original row.
Information on the specific techniques for establishing links between rows are located in the topics, Data Maintenance, How to Link New to Existing and Data Maintenance, How to Link Existing to Existing.
There are four kinds of links that may be established for Address rows.
Spousal Address/ Link
If an Address row belongs to a constituent who has a spousal relationship with another constituent, you may choose to create a linked Address for that spouse. This is done on an individual basis for any of the Addresses belonging to the primary constituent (either may be used as the primary). This enables the automatic updating of both rows when either is edited.
When two Address rows are linked and edits are made to one of the rows, the system automatically makes the same edits to the other row, with the exception of the Utilization columns. Those settings are not automatically edited, in order to preserve the ability to set different mailing preferences for each constituent.
Non-spouse Addresses/Address Link
It is possible to create linked Address rows for any two constituents, regardless of whether they have an existing relationship or not. When the link has been created, updating the row belonging to one, automatically updates the other.
When two Address rows are linked and edits are made to one of the rows, the system automatically makes the same edits to the other row. The exception to this behavior is the Utilization columns. Those settings are not automatically edited, in order to preserve the ability to set different mailing preferences for each constituent.
Linked Address/Employment
You may also create a link between an Address row and an Employment row belonging to the same constituent. By creating this linkage, the system can use data from the Name, Address and Employment rows to construct a business mailing label.
If you change the status of an Employment row from Active to No Longer at this Position and that Employment row has a linked Address, you will be prompted with the opportunity to set the locator of the linked Address to Former and the Address stop date to the date you change the status. If you choose not to, then you will be prompted with the opportunity to unlink the Address. This option preserves the Address just as it was, but without the link to the Employment row.
If you update an Address that links to an Employment row using Update/Archive, the Archived Address row and Employment row are unlinked and the new Address row is automatically linked to the Employment row.
If you update an Address that links to an Employment row with an Active job status by setting the Address's locator and type to Former, you will be prompted to set the Employment row's status to No Longer at this Position. The Address row will remain linked to the Employment row regardless of your choice at the prompt.
Linked Phone
A new Phone Number can be linked to an Address during the Address insert process. On the Address Insert form, select Insert + Phone, instead of Insert, when creating the new address. The Phone Insert form is presented automatically; enter the phone number information on this form, and select Insert.
A new Phone Number can be linked to an existing Address by selecting the edit menu of the address to which you want to link a Phone Number to, and selecting either Link Phone or Link Phone via Default. See Link New to Existing for more information.
An existing Phone Number can be linked to an existing Address by selecting the edit menu of the address to which you want to link a Phone Number to, and selecting Link to Existing Phone. See Link Existing to Existing for more information.
Once a Phone Number has been linked to an Address, you can use the Phone row's edit menu to select the options of Link Phone to Spouse, Link Phone to Other, or Link to Existing Phone on Other. See Link and Link to Existing for more information.
If you want to update or delete a Phone Number which is linked to an Address, you may do so in one of two ways.
- If an update on
the Address row as well as the Phone Number is row is necessary, access
the Update form for the Address, make desired changes, and select Update + Phone instead of Update.
The Phone Update form for the linked Phone Number is presented automatically.
Make changes to the information on the Phone Number Update form and select
Update. If more than one Phone Number is
linked to this Address row, the update form for the next linked Phone
number is then automatically presented.
- If you want to delete the linked Phone Number, select Delete instead. If more than one Phone Number is linked to this Address row, you are returned to the Address row; the update form for the next linked Phone Number is not presented. It is important to note that Delete does not just unlink the Phone Number from this Address row, but deletes the Phone Number from the database as well.
- To halt the Phone Number update process, select Cancel. If more than one Phone Number is linked to this Address row, the update form for the next linked Phone number is then automatically presented.
- To update or delete a linked Phone Number without making changes to the address to which it is linked, use the appropriate menu item on the context menu accessed via the Edit button located to the left of the Phone Number that you want to update or delete.
Update/Archive and Linked Phone Numbers
When an Address is Updated via Update/Archive, all Phone Numbers linked to the Address will be Update/Archived as well.
- New Phone Number rows are created and linked to the New Address row;
- The information in the new linked Phone Number rows is the same as the information in the existing linked Phone Number rows.
- Existing linked Phone Number rows remain linked to the archived address, but their type (phntype) is changed to 'former' version of their original type (for example, a fax phone number is changed to former fax phone number).
Addresses and Contact Info
If a constituent is maintained as a contact in a Contact Info row, and that constituent's address information is linked to an Address row, the following system behaviors can occur:
- If an Address row is updated, the address information in the Contact Info row will be updated as well.
- If an Address row is deleted, the deleted address information will remain in the Contact Info row.
Addresses for Deceased or Disbanded Constituents
When a Death data row is created for a constituent, the Locator for all Address rows for that constituent are automatically set to Deceased. This helps to ensure data consistency and assists in the prevention of inadvertent mailings to deceased constituents.
Address Field Descriptions
Address data is stored in the address data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you want to override these default settings, you must customize your display definition.
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.
|
Field Name Field Label |
Lookup Table |
Type SQL/Oracle Length [Default] {Check} |
Description |
|---|---|---|---|
|
addrkey no label |
none |
numeric/number 13,0
|
The Time field is the primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (system field) |
|
addrid non-displaying |
none |
char 10
|
This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (system field) |
|
addrdoc non-displaying |
none |
char 1 ['N']
|
This field holds a Y/N flag to indicate the existence of a linked document for this row. (system field) |
|
addrdate no label |
none |
datetime/date [getdate()]
|
The date that this row was last updated. This field is automatically entered by the system. Note that this date reflects the last change to any information in the row. (system field) |
|
addruserid no label |
none |
varchar/varchar2 30 [suser_sname]
|
The User ID of the operator that last edited this row. It is automatically entered by the system. (system field) |
|
addrugroup non-displaying |
none |
char 1 ['Z']
|
This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (system field) |
|
addrline1 no label |
none |
char 60
|
The first line of the street address. |
|
addrline2 no label |
none |
char 60
|
The second line of the street address. |
|
addrline3 no label |
none |
char 60
|
The third line of the street address. |
|
no label |
none or |
char 30
|
The city associated with this address. If an entry from the standard US ZIP Code lookup table is used and the Country is either blank or non-USA, this field will default to the City from that ZIP Code lookup table entry. You may override that default by entering data in the City text box. |
|
no label |
char 6 [' ']
|
The state or province associated with this address. If an entry from the standard US ZIP Code lookup table is used and the Country is either blank or non-USA, this field will default to the State from that ZIP Code lookup table entry. You may override that default by entering data in the State text box. | |
|
addrzipcod no label |
ZIP Code |
char 15
|
This field is used for the ZIP Code in an address. When you enter one of the standard entries for a five or nine digit U.S. Postal ZIP Code, and the Country is either blank or non-USA, then the system defaults several Address fields to the corresponding fields in the ZIP Code lookup table entry. You may override this data by entering data in the text boxes in the update form. These fields are the City, State, County, Time Zone, District, Region, Territories, Zones, Longitude, and Latitude. |
|
Region |
char 6 [' ']
|
If the Country is a USA or blank, and if your institution has used the Region field in the ZIP Code lookup table to set up a system of geographic regions for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the ZIP Code that was chosen for the row. You may override this behavior by editing the row with a Region that is at variance with the one specified for this ZIP Code in that lookup table. For complete information, see Automatic Data Entry from ZIP Code. If the Country is not USA, and if your institution has used the Region field in the Countries lookup table to set up a system of geographic regions for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the Country that was chosen for the row. You may override this behavior by editing the row with a Region that is at variance with the one specified for this Country in that lookup table. For complete information, see Automatic Data Entry from Countries. (system field) |
|
|
District |
char 6 [' ']
|
If your institution has used the District field in the ZIP Code lookup table to set up a system of geographic districts for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the ZIP Code that was chosen for the row. You may override this behavior by editing the row with a District that is at variance with the one specified for this ZIP Code in that lookup table. For complete information, see Automatic Data Entry from ZIP Code. If the Country is not USA, and if your institution has used the District field in the Countries lookup table to set up a system of geographic districts for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the Country that was chosen for the row. You may override this behavior by editing the row with a District that is at variance with the one specified for this Country in that lookup table. For complete information, see Automatic Data Entry from Countries. (system field) |
|
| Locators |
char 6 [' ']
|
Indicates the status of the address, (for example, good, lost returned, deceased, former, or omit). When edits are made to Line 1, Line 2, Line 3, City, Place, or the first five characters of the ZIP Code, the system will ask if you also want to update the Locator for the Address row to good. | |
|
addrtype Type |
Address Types |
char 6 [' ']
|
Indicates the type of address (for example, Home, Business) |
|
addrjan Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
Each of the Effective Month fields may have a "Y", to indicate that the address is valid for that month or an "N" to indicate that it is not. These designations are entered by the system when the operator clicks on the check boxes in the Address Maintenance screen, to turn them on or off. A toggle button is available to select or clear all effective months check boxes at one time. |
|
addrfeb Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrmar Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrapr Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrmay Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrjun Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrjul Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addraug Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrsep Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addroct Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrnov Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addrdec Eff. months |
none |
char 1 [N] {'Y' or 'N'} |
See addrjan description. |
|
addraltph Alt # |
none |
char 30
|
Free form field for phone number. This field might be used for foreign phone numbers. |
|
addrforign non-displaying |
none |
char 1 [null] {'Y' or 'N'} |
When an entry is made in the addrcntry field in an Address row, the system checks the lookup table entry that was entered. If the Lookup table Type field for that entry is "for" (indicating that this entry is foreign) then the addrforign field is set to "Y". If not, it is left blank. (system field) |
|
Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
Indicates when a particular type of mailing should be sent to this address. More than one utilization may be assigned to the same address. Millennium will use the addrmc1 field to flag this address as the preferred address. |
|
addrmc2 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
Indicates when a particular type of mailing should be sent to this address. More than one utilization may be assigned to the same address. |
|
addrmc3 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc4 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc5 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc6 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc7 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc8 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc9 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc10 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc11 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc12 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc13 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc14 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc15 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc16 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc17 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc18 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc19 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrmc20 Mailcode |
Address Utilization |
char 1 ['N'] {'Y' or 'N'} |
See addrmc2 description. |
|
addrlnkadd non-displaying |
none |
numeric/number 13,0 [0]
|
This field is used to link two or more addresses together. This field is indexed on the ADDRESS05 tag. There is a filter on this index which excludes addresses which have a ADDRLNKADD field <= 0. In order to link addresses, one address must be chosen as the Primary Address. Once a Primary Address row has been defined, the ADDRLNKADD field in the Primary Address row would be set equal to its own ADDRKEY field. The ADDRLNKADD field of all addresses linked to the Primary Address, are set equal to the ADDRKEY field of the Primary Address. If an address is not to be linked to other addresses, this field is zero. (system field) |
|
addrlnkjob non-displaying |
none |
numeric/number 13,0 [0]
|
This field is used to link an employment row from the Jobs table to an address. If this is the case, the ADDRLNKJOB field is set equal to the JOBSKEY field of the employment row. If an address is not linked to a Jobs row, this field is zero. (system field) |
|
addrsource Source |
Source |
char 6 [' ']
|
The source of the information in this Address row. |
|
addrph1rst Restriction |
Phone Restriction |
char 6 [' ']
|
Indicates the restriction (if any) that applies to the Phone Number. |
|
addrph2rst Restriction |
Phone Restriction |
char 6 [' ']
|
Indicates the restriction (if any) that applies to the FAX Phone Number. |
|
addrph3rst Restriction |
Phone Restriction |
char 6 [' ']
|
Indicates the restriction (if any) that applies to the Alternate Phone Number. |
|
County |
none |
char 6 [' ']
|
The county associated with the address. This information is entered automatically based on the ZIP Code entry that is chosen for this Address row. (system field) |
|
addrphone Phone # |
none |
char 30
|
Indicates the area code, phone number, and extension associated with the address. |
|
addrfaxph FAX # |
none |
char 30
|
Free form field for FAX phone number. |
|
addrcntry Country |
Countries |
char 6 [' ']
|
The country associated with the address. If the Countries lookup table entry you choose for the Address row has a Type (Group) of "for" as determined at your institution, the designation, 'Non USA' will display in the upper right corner of the display area for that row, and the ZIP Code information will be treated as free text. Also, for non-USA Countries, the District, Region, Territory and Zone fields will automatically be populated with that data from the Countries lookup entry, when the Address row is inserted. You may override this information by editing the Address row after it has been created. |
|
addrcrrte Carrier Route |
none |
char 6
|
This field holds the Carrier Route associated with this address. |
|
addrpoint non-displaying |
none |
numeric/number 10,0
|
This system-assigned field is no longer used or supported. (system field) |
|
Time Zone |
none |
char 3
|
This field holds a copy of the time zone for this Address row. This information is automatically entered by the system, using the Time Zone field from the entry in the ZIP Code lookup table. (system field) |
|
addraddrdt non-displaying |
none |
datetime/date [getdate()]
|
This field shows the last date on which the Lines 1, 2, or 3, City, State, or ZIP Code fields were edited (as opposed to addrdate, which reflects any edit to any field in the row). (system field) |
|
addrstart Start |
none |
datetime/date
|
The first date that this address was (or will be) valid. |
|
addrstop Stop |
none |
datetime/date
|
The date that this address becomes (became) no longer valid. |
|
addrfnum non-displaying |
none |
char 2 ['02'] {'02'} |
The file (table) number for the Address table. (system field) |
|
addrcrdate non-displaying |
none |
datetime/date [getdate()]
|
The date that the Address row was created. (system field) |
|
Latitude |
none or |
varchar/varchar2 20
|
Each entry in the ZIP Code lookup table has an associated Latitude field that is automatically copied into this field in the Address row. (system field) |
|
Longitude |
none or |
varchar/varchar2 20
|
Each entry in the ZIP Code lookup table has an associated Longitude field that is automatically copied into this field in the Address row. (system field) |
|
addrcomm no label |
none |
varchar/varchar2 4000
|
A free text Comment that may be entered and displayed with this row only. |
|
Territory |
char 6 [' ']
|
If your institution has used the Territory field in the ZIP Code lookup table to set up a system of geographic territories for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the ZIP Code that was chosen for the row. You may override this behavior by editing the row with a Territory that is at variance with the one specified for this ZIP Code in that lookup table. For complete information, see Automatic Data Entry from ZIP Code. If the Country is not USA, and if your institution has used the Territory field in the Countries lookup table to set up a system of geographic territories for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the Country that was chosen for the row. You may override this behavior by editing the row with a Territory that is at variance with the one specified for this Country in that lookup table. For complete information, see Automatic Data Entry from Countries. (system field) |
|
|
Zone |
char 6 [' ']
|
If your institution has used the Zone field in the ZIP Code lookup table to set up a system of geographic zones for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the ZIP Code that was chosen for the row. You may override this behavior by editing the row with a Zone that is at variance with the one specified for this ZIP Code in that lookup table. For complete information, see Automatic Data Entry from ZIP Code. If the Country is not USA, and if your institution has used the Zone field in the Countries lookup table to set up a system of geographic zones for your constituency, that information will automatically be copied into this field during the creation of a new Address row, based on the Country that was chosen for the row. You may override this behavior by editing the row with a Zone that is at variance with the one specified for this Country in that lookup table. For complete information, see Automatic Data Entry from Countries. (system field) |
|
|
addrdate1
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate2
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrmny1
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny2
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrnum1
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum2
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addryesno
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrlook1
|
Address Lookup1 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrlook2
|
Address Lookup 2 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrlook3
|
Address Lookup3 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrtext
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrbarcde non-displaying |
none |
char 4
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track the barcode version of this address information. (system field) |
|
addrlot non-displaying |
none |
char 5
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track the Line of Travel. (system field) |
|
addrncoa non-displaying |
none |
char 4
{' ', 'ncoa', 'ca'} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track the certification of the address. (system field) |
|
addrncoadt non-displaying |
none |
datetime/date
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track the date of the certification of this address. (system field) |
|
addrcass1 non-displaying |
none |
char 60
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to hold the CASS form of the first line of the address. (system field) |
|
addrcass2 non-displaying |
none |
char 60
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to hold the CASS form of the second line of the address. (system field) |
|
addrcass3 non-displaying |
none |
char 60
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to hold the CASS form of the third line of the address. (system field) |
|
addrccity non-displaying |
none |
char 30
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to hold the CASS form of the city portion of the address. (system field) |
|
addrcplace non-displaying |
places |
char 6
|
This field is available for use with CorrectAddress (an optional Millennium component). It is used to hold the CASS form of the place (state) portion of the address. (system field) |
|
addrccert non-displaying |
none |
char 1 ['N'] {Not Null} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to flag the address as CASS certified. (system field) |
|
addrpend Pending |
none |
char 1 ['N'] {Not Null} |
This field is a flag to indicate that this data row has linked information in the 'pending' Address table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is pending incorporation into this data row. (system field) |
|
addrpubfl Publish |
none |
char 1 ['2'] {Not Null} |
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 Address table are set to 'Published by Consent'. Otherwise, the corepub02 column flag in the Basic Data table will be used.
'2' - 'Do Not Hide' '1' - 'Hide the Phone Number' '0' - 'Hide' |
|
addrupkey non-displaying |
none |
numeric/number 13,0
|
This field holds the timekey of the pending data row that may be updated from the address_pending table. |
| addrphnfl | none |
char 1 ['N'] {'N' or 'Y'} |
This field is a flag used by the system to indicate that a phone number row is linked to this address. (system field) |
| addrdncflg | none |
char 1 ['N'] {'N' or 'Y'} |
This field is a flag to be used with Correct Call to indicate "Do Not Call" (addrphone). All sites can view this field, but it will only be used and updated by Correct Call. (system field) |
|
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate4
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate5
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate6
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate7
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate8
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdate9
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdte10
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdte11
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrdte12
|
none |
datetime/date
|
This custom field may be defined and used by your institution to track any date information associated with this data row. |
|
addrmny3
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny4
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny5
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny6
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny7
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny8
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny9
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny10
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny11
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrmny12
|
none |
money/number (19,4)/(16,2)
|
This custom field may be defined and used by your institution to track any monetary information associated with this data row. |
|
addrnum3
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum4
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum5
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum6
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum7
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum8
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum9
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum10
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum11
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrnum12
|
none |
numeric/number 10, 0
|
This custom field may be defined and used by your institution to track any numeric information associated with this data row. |
|
addrchk1
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk2
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk3
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk4
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk5
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk6
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk7
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk8
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk9
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrchk10
|
none |
char 1 ['N'] {'N' or 'Y'} |
This custom field may be defined and used by your institution to flag this data row for any purpose. |
|
addrtxt1
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrtxt2
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrtxt3
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrtxt4
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrtxt5
|
none |
varchar/varchar2 255
|
This custom field may be defined and used by your institution to track any free text information you want to associate with this data row. |
|
addrlook4
|
address_lookup4 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrlook5
|
address_lookup5 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrlook6
|
address_lookup6 |
char 6
|
This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row. |
|
addrdpv DP Validation
|
none |
char 1 [''] {'', 'Y','N'} |
This field is available for use with CorrectAddress (an optional Millennium component).It is used to track Delivery Point Validation.(system field)
Blank - No Lookup Y - Confirmed N - Not confirmed |
|
addrnostat DP No Status |
none |
char 1 [''] {'', 'Y','N', 'V'} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track Delivery Point Status. (system field)
Blank - No Lookup Y - Confirmed N - Not confirmed V - Vacant |
|
addrdpvcnt DP Vacant |
none |
char 1 [''] {'','Y','N','S','D'} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track Delivery Point Confirmation. (system field)
Blank - address not submitted for confirmation. Y - Confirmed entire address. N - Could not confirm address (address invalid or does not correspond to a delivery point) S - Confirmed address by dropping secondary information D - Confirmed a high rise or PO Box type address without secondary information An address receiving a code of Y, S, or D is considered. DPV™ Confirmed. |
|
addrlacsch LACS COA |
none |
char 1 [''] {'','L'} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track LACS Change of Address - indicates whether or not a record may benefit from Locatable Address Conversion. (system field)
L - Yes, address will benefit. |
|
addrmovtyp Move Type |
none |
char 1 [''] {'','F','I','B','L'} |
This field is available for use with CorrectAddress (an optional Millennium component). It is used to track Type of Move (system field)
I - Individual Move F - Family Move B - Business Move L - LACS Move |
|
addrcaupdt CA Date |
none |
datetime
|
This field is available for use with CorrectAddress (an optional Millennium component). The date that CorrectAddress makes a change to the address row. (system field) |
|
addrlacsdt LACS Date |
none |
datetime
|
This field is available for use with CorrectAddress (an optional Millennium component). The date that CorrectAddress makes an LACS change to the address row. (system field) |
|
addrccupdt CC phone Date |
none |
datetime
|
This field is available for use with CorrectCall (an optional Millennium component). The date that CorrectCall makes a change to the Phone Number in the address row. (system field) |
|
addrcoamtc Move Match Type |
none |
char 1 ['']
|
This field is available for use with CorrectAddress (an optional Millennium component). Used to track Move Match Type. (system field)
M - Forwardable Move F - Foreign Move (no forwardable address) G - Box Closed (no fowardable address) K - Moved Left No Address( no forwarding address) P - Error in Primary address (format or none CASS) S - Error in Secondary address (format or None CASS) |
|
addrsupprs Suppress Types |
none |
char 14
|
This field is available for use with CorrectAddress (an optional Millennium component). Used to track Address Suppression Reasons. (system field)
A1 - Business or Shopping Center A2 - College ZIP Code A3 - Prison Address A4 - Military ZIP Code A5 - Nursing Home A6 - Retirement Home A7 - Trailer Park C1 - Official USPS Mailing Complaints C2 - Maining Complaints Received by Donnelly Marketing D1 - Deceased D2 - Relative input of another's death M1 - DMA Mail Preference Services (Do Not Mail) P3 - Requests no Pandering |
|
addradesrc non-displaying |
ade_source |
char 30
|
If this row is created or updated from data that originally came from the address_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. |
|
addrinitum Initium Status |
none |
char 1 [null] {' ','O','V'} |
This column displays the status of the address if your organization uses Initium Instant Address. It contains a single character that indicates whether the address has been validated or overridden, as follows: O - Overridden V - Validated Blank - no status |
|
addrinitds non-displaying
|
none |
char 1 [''] {'','E','T','M','S', |
This field is available for use with Initium Instant Address. It contains a single character that describes the detail status of the address as follows: E - Exact T - Tentative M - Multiple S - Secondary U - Unmatched F - Foreign P - Primary Blank - No detail status |
|
addrindate Initium verification date |
none | datetime | This field specifies the last date and time that the address was validated using Initium Instant Address. |
|
addrinitvr Initium verification Info |
none |
varchar 30 |
This field contains the verification information returned from Initium for the address, if any. |
Indices - Address
| Index | Primary | Foreign | Unique | Fields | Sort |
| pk_address | Y | Y | addrkey | ASC | |
| address02 | Y | addrid | ASC | ||
| address03 | addrzipcod | ASC | |||
| address04 | Y | addrregion | ASC | ||
| address05 | addrlnkadd | ASC | |||
| address06 | addrlnkjob | ASC | |||
| address07 | addrdate | ASC | |||
| address08 | addrcity | ASC | |||
| address09 | addrphone | ASC | |||
| address10 | addraltph | ASC | |||
| address11 | addrfaxph | ASC | |||
| address12 | Y | addrcntry | ASC | ||
| address13 | Y | addrdstrct | ASC | ||
| address14 | addrplace | ASC |
Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.