Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
MESSAGETEXT | nvarchar(2000) | Default = '' | ||
MESSAGETYPECODE | tinyint | Default = 0 | ||
MESSAGETYPE | nvarchar(28) (Computed) | 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) | CASE [SEVERITYCODE] WHEN 0 THEN N'Error' WHEN 1 THEN N'Warning' END | ||
ORIGINCODE | tinyint | Default = 0 | ||
ORIGIN | nvarchar(8) (Computed) | 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) | CONVERT(bigint, TS) |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
BATCHEDUCATIONALHISTORYUPDATEID | uniqueidentifier | BATCHEDUCATIONALHISTORYUPDATE.ID | ||
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES_BATCHEDUCATIONALHISTORYUPDATEID | BATCHEDUCATIONALHISTORYUPDATEID | |||
IX_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES_DATEADDED | DATEADDED | |||
IX_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES_DATECHANGED | DATECHANGED | |||
PK_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES | ID |
Trigger Name | Description |
---|---|
TR_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES_AUDIT_UPDATE | |
TR_BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES_AUDIT_DELETE |