Stores email addresses for constituent update batch.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
SEQUENCE
|
int
|
false
|
|
|
|
EMAILADDRESS
|
UDT_EMAILADDRESS
|
false
|
|
|
|
ISPRIMARY
|
bit
|
false
|
|
|
|
DONOTEMAIL
|
bit
|
false
|
|
|
|
UPDATEHOUSEHOLD
|
bit
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
STARTDATE
|
date
|
true
|
|
The date the email address becomes valid.
|
|
ENDDATE
|
date
|
true
|
|
The date the email address becomes invalid.
|
|
ISMANUALEXCEPTION
|
bit
|
false
|
|
|
|
ROWORIGINCODE
|
tinyint
|
false
|
|
|
|
ROWORIGIN
|
nvarchar(129) (Computed)
|
true
|
|
|
