Stores information pertaining to a segment.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
A name for the segment.
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
A description of the segment.
|
|
CODE
|
nvarchar(10)
|
false
|
|
A code identifying the segment.
|
|
DATEREFRESHED
|
datetime
|
true
|
|
The date the segment was last refreshed.
|
|
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.
|
|
SEGMENTTYPECODE
|
tinyint
|
false
|
|
The type of the segment.
|
|
SEGMENTTYPE
|
nvarchar(18) (Computed)
|
true
|
|
Provides a translation for the 'SEGMENTTYPECODE' field.
|
|
SEGMENTFAMILYTYPECODE
|
tinyint (Computed)
|
true
|
|
Indicates whether the segment is direct marketing or public media.
|
|
SEGMENTFAMILYTYPE
|
varchar(23) (Computed)
|
false
|
|
Indicates whether the segment is direct marketing or public media.
|
|
ISSYSTEM
|
bit
|
false
|
|
Flag used to hide segments meant for system use only.
|
|
ISHISTORICAL
|
bit
|
false
|
|
|
|
HISTORICALQUANTITY
|
int
|
false
|
|
|
