The address Indicator field is located on the CONSTIT_ADDRESS table and can have the following values: 
  • 0 = Alternate
  • 1 = Contact
  • 2 = Preferred (Primary Address entered on the Bio 1 tab of the constituent record)
  • 3 = Business
  • 4 = Spouse Business
  • 5 = Spouse Preferred
  • 6 = Spouse Alternate
  • 7 = Relationship
Note: The meaning of the values seen for the INDICATOR on the CONSTIT_ADDRESS table can be found in the Read-Only Database Assistance Guide under the "Addresses and Phone Information" section. The Description of these values are assigned via code and are not stored anywhere in the database.

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.