More information

Internet Address

The Internet Address table is a secondary table designed to hold a constituent's email and web page addresses. While there is no link between any of the individual rows in this table and any of the individual rows in the Address table, the Internet Address table is associated with the Address table for display purposes. This means that to view or access the information in the Internet Address rows, you must access the Address information, using the Millennium Explorer. The Internet Address rows will be displayed, following the display of the Address rows belonging to that constituent. If roving phone numbers exist for the constituent, Internet Address rows will be displayed following the display of these Phone Number rows.

The Internet Address Type (internetaddress_type) classifies the kind of information represented by a row in this data table. An Internet Address whose type code contains 'email' or 'www' displays as hyperlink text. When the hyperlink is executed, the software will either automatically launch your mail messaging system with the email address in place, or it will automatically access the constituent's website.

Notes:

An Administrator can remove the Internet Address table from the Millennium Explorer if not used. See Table Options for more information.
Millennium system administrators or the database administrator can configure audit logging for the Internet Address data table. For more information, see Audit Log.

Internet Address Utilizations

The Utilization portion of the Data Maintenance form 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 Internet 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 intmc1, intmc2, 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 field's alias in Millennium's fieldlst system table.

Internet Address Field Descriptions

Internet address data is stored in the internetaddress data table. The following fields are included. The field labels and non-displaying designations that are listed here are those that the system uses by default. If you wish to override these default settings, you must customize your display definition.

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
intkey non-displaying	none	numeric/number 13,0	The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (system field)
intid 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)
intdoc 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)
intdate no label	none	datetime/date [getdate()]	The date that this Internet Address row was last updated. This field is automatically entered by the system. (system field)
intuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this Internet Address row. It is automatically entered by the system. (system field)
intugroup 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)
intaddress Email/WWW address	none	char 200	This field holds a complete email address or web (WWW) address that you want to store in this row.
inttype no label	internetaddress_type	char 6 [' ']	The kind of "address" represented by the information in this row.
intsource Source	source_types	char 6 [' ']	The source for the information in this row.
intfnum non-displaying	none	char 2 ['81'] {'81'}	The file (table) number for the Internet Address table. (system field)
intcrdate non-displaying	none	datetime/date [getdate()]	The date that the row was created. (system field)
intcomm no label	none	varchar/varchar2 4000	A free text Comment that may be entered and displayed with this row only.
intdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intmny1	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.
intmny2	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.
intnum1	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.
intnum2	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.
intyesno	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.
intlook1	internetaddress_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.
intlook2	internetaddress_lookup2	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.
intlook3	internetaddress_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.
inttext	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.
intpend non-displaying	none	char 1 ['N'] {'N' or 'Y'}	This field is a flag to indicate that this data row has linked information in the 'pending' internetaddress table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is awaiting incorporation into this data row. (system field)
intpubfl Publish	none	char 1 ['N'] {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 Name table are set to 'Published by Consent'. Otherwise, the corepub81 field flag in the Basic Data table will be used.
intupkey non-displaying	none	numeric/number 13, 0	This field holds the Timekey of the pending data row that may be updated from the internetaddress_pending table. (system field)
intrest	Phone Restrictions	char 6 [' ']	The restriction (if any) that applies to this internet address.
intpref	none	char 1	This field is no longer in use by the software. Use intmc1 to mark an internet address as preferred.
intstart non-displaying	none	datetime/date	The first date this internet address was or will be valid.
intstop	none	datetime/date	The last date this internet address became or becomes invalid.
intmc1 Mailcode 1	address_utilization	char 1 ['N'] {'N' or 'Y'}	Indicates when a particular type of email should be sent to this internet address. More than one utilization may be assigned to the same internet address. Millennium will use the intmc1 field to flag this internet address as the preferred internet address.
intmc2 Mailcode 2	address_utilization	char 1 ['N'] {'N' or 'Y'}	Indicates when a particular type of email should be sent to this internet address. More than one utilization may be assigned to the same internet address.
intmc3 Mailcode 3	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc4 Mailcode 4	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc5 Mailcode 5	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc6 Mailcode 6	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc7 Mailcode 7	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc8 Mailcode 8	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc9 Mailcode 9	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc10 Mailcode 10	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc11 Mailcode 11	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc12 Mailcode12	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc13 Mailcode 13	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc14 Mailcode 14	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc15 Mailcode 15	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc16 Mailcode 16	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc17 Mailcode 17	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc18 Mailcode 18	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc19 Mailcode 19	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intmc20 Mailcode 20	address_utilization	char 1 ['N'] {'N' or 'Y'}	See description for intmc2.
intdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
intmny3	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.
intmny4	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.
intmny5	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.
intmny6	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.
intmny7	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.
intmny8	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.
intmny9	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.
intmny10	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.
intmny11	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.
intmny12	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.
intnum3	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.
intnum4	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.
intnum5	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.
intnum6	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.
intnum7	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.
intnum8	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.
intnum9	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.
intnum10	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.
intnum11	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.
intnum12	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.
intchk1	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.
intchk2	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.
intchk3	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.
intchk4	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.
intchk5	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.
intchk6	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.
intchk7	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.
intchk8	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.
intchk9	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.
intchk10	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.
inttxt1	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.
inttxt2	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.
inttxt3	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.
inttxt4	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.
inttxt5	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.
intadesrc non-displaying	ade_source	char 30	If this row is created or updated from data that originally came from the internetaddress_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.

Field Name

Field Label

Lookup Table

Type SQL/Oracle

Length

[Default]

{Check}

Description

intkey

non-displaying

none

numeric/number

13,0

The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (system field)

intid

non-displaying

none

char

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)

intdoc

non-displaying

none

char

['N']

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

intdate

no label

none

datetime/date

[getdate()]

The date that this Internet Address row was last updated. This field is automatically entered by the system. (system field)

intuserid

no label

none

varchar/varchar2

[suser_sname()]

The User ID of the operator that last edited this Internet Address row. It is automatically entered by the system. (system field)

intugroup

non-displaying

none

char

['Z']

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

intaddress

Email/WWW address

none

char

200

This field holds a complete email address or web (WWW) address that you want to store in this row.

inttype

no label

internetaddress_type

char

[' ']

The kind of "address" represented by the information in this row.

intsource

Source

source_types

char

[' ']

The source for the information in this row.

intfnum

non-displaying

none

char

['81']

{'81'}

The file (table) number for the Internet Address table. (system field)

intcrdate

non-displaying

none

datetime/date

[getdate()]

The date that the row was created. (system field)

intcomm

no label

none

varchar/varchar2

4000

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

intdate1

none

datetime/date

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

intdate2

none

datetime/date

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

intmny1

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.

intmny2

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.

intnum1

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.

intnum2

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.

intyesno

none

char

['N']

{'N' or 'Y'}

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

intlook1

internetaddress_lookup1

char

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

intlook2

internetaddress_lookup2

char

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

intlook3

internetaddress_lookup3

char

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

inttext

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.

intpend

non-displaying

none

char

['N']

{'N' or 'Y'}

This field is a flag to indicate that this data row has linked information in the 'pending' internetaddress table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is awaiting incorporation into this data row. (system field)

intpubfl

Publish

none

char

['N']

{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 Name table are set to 'Published by Consent'. Otherwise, the corepub81 field flag in the Basic Data table will be used.

intupkey

non-displaying

none

numeric/number

13, 0

This field holds the Timekey of the pending data row that may be updated from the internetaddress_pending table. (system field)

intrest

Phone Restrictions

char

[' ']

The restriction (if any) that applies to this internet address.

intpref

none

char

This field is no longer in use by the software. Use intmc1 to mark an internet address as preferred.

intstart

non-displaying

none

datetime/date

The first date this internet address was or will be valid.

intstop

none

datetime/date

The last date this internet address became or becomes invalid.

intmc1

Mailcode 1

address_utilization

char

['N']

{'N' or 'Y'}

Indicates when a particular type of email should be sent to this internet address. More than one utilization may be assigned to the same internet address.

Millennium will use the intmc1 field to flag this internet address as the preferred internet address.

intmc2

Mailcode 2

address_utilization

char

['N']

{'N' or 'Y'}

Indicates when a particular type of email should be sent to this internet address. More than one utilization may be assigned to the same internet address.

intmc3

Mailcode 3

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc4

Mailcode 4

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc5

Mailcode 5

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc6

Mailcode 6

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc7

Mailcode 7

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc8

Mailcode 8

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc9

Mailcode 9

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc10

Mailcode 10

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc11

Mailcode 11

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc12

Mailcode12

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc13

Mailcode 13

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc14

Mailcode 14

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc15

Mailcode 15

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc16

Mailcode 16

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc17

Mailcode 17

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc18

Mailcode 18

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc19

Mailcode 19

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intmc20

Mailcode 20

address_utilization

char

['N']

{'N' or 'Y'}

See description for intmc2.

intdate3

none

datetime/date

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

intdate4

none

datetime/date

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

intdate5

none

datetime/date

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

intdate6

none

datetime/date

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

intdate7

none

datetime/date

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

intdate8

none

datetime/date

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

intdate9

none

datetime/date

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

intdte10

none

datetime/date

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

intdte11

none

datetime/date

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

intdte12

none

datetime/date

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

intmny3

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.

intmny4

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.

intmny5

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.

intmny6

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.

intmny7

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.

intmny8

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.

intmny9

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.

intmny10

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.

intmny11

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.

intmny12

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.

intnum3

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.

intnum4

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.

intnum5

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.

intnum6

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.

intnum7

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.

intnum8

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.

intnum9

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.

intnum10

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.

intnum11

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.

intnum12

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.

intchk1

none

char

['N']

{'N' or 'Y'}

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

intchk2

none

char

['N']

{'N' or 'Y'}

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

intchk3

none

char

['N']

{'N' or 'Y'}

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

intchk4

none

char

['N']

{'N' or 'Y'}

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

intchk5

none

char

['N']

{'N' or 'Y'}

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

intchk6

none

char

['N']

{'N' or 'Y'}

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

intchk7

none

char

['N']

{'N' or 'Y'}

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

intchk8

none

char

['N']

{'N' or 'Y'}

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

intchk9

none

char

['N']

{'N' or 'Y'}

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

intchk10

none

char

['N']

{'N' or 'Y'}

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

inttxt1

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.

inttxt2

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.

inttxt3

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.

inttxt4

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.

inttxt5

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.

intadesrc

non-displaying

ade_source

char

If this row is created or updated from data that originally came from the internetaddress_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.

Indices - Internet Address

Index	Primary	Foreign	Unique	Fields	Sort
pk_internetaddress	Y		Y	intkey	ASC
internetaddress02		Y		intid	ASC
internetaddress03				intdate	ASC
internetaddress04				intaddress	ASC

Top of Page