| MESSAGETEXT |
nvarchar(2000) |
|
Default = '' |
|
| MESSAGETYPECODE |
tinyint |
|
Default = 0 |
|
| MESSAGETYPE |
nvarchar(28) (Computed) |
yes |
CASE [MESSAGETYPECODE] WHEN 0 THEN N'General error' WHEN 1 THEN N'Duplicate record error' WHEN 2 THEN N'Address validation error' WHEN 3 THEN N'Required field missing error' WHEN 4 THEN N'Type mismatch error' WHEN 5 THEN N'Invalid value error' END |
|
| INVALIDFIELDID |
nvarchar(200) |
|
Default = '' |
|
| INVALIDFIELDVALUE |
nvarchar(max) |
|
Default = '' |
|
| SEVERITYCODE |
tinyint |
|
Default = 0 |
|
| SEVERITY |
nvarchar(7) (Computed) |
yes |
CASE [SEVERITYCODE] WHEN 0 THEN N'Error' WHEN 1 THEN N'Warning' END |
|
| ORIGINCODE |
tinyint |
|
Default = 0 |
|
| ORIGIN |
nvarchar(8) (Computed) |
yes |
CASE [ORIGINCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Save' WHEN 2 THEN N'Validate' WHEN 3 THEN N'Import' END |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|