Stores source code part values.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
A short description for this position.
|
|
FORMAT
|
nvarchar(50)
|
false
|
|
A list of values for this position.
|
|
VALUE
|
nvarchar(10)
|
false
|
|
The actual value used when this item is linked to a marketing effort.
|
|
SAMPLE
|
nvarchar(10)
|
false
|
|
An example of the type of code you expect to see.
|
|
DELIM
|
nvarchar(1)
|
false
|
|
A character used to following this source code item.
|
|
REGEX
|
nvarchar(255)
|
false
|
|
The regular expression text used to validate this code item.
|
|
LENGTH
|
tinyint
|
false
|
|
The maximum length of this position.
|
|
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.
|
