CompChangesOID |
PK |
binary(16) |
No |
Internal ID number used as primary key. |
TypeOfChange |
|
smallint |
No |
Created, field value edited, deleted, etc. The complete list with codes is:
0 Created
1 Edited
2 Deleted
3 Moved
4 Retired |
SourceOfChange |
|
smallint |
No |
Collector, Collection Server, Mgr, etc. The complete list with codes is:
0 Collector
1 Field Editor
2 Collection Server
3 Manager
4 Admin Server
5 Web Console |
FieldId |
|
int |
|
Field ID from the data model. |
FieldLabel |
|
nvarchar(50) |
|
Field name label from the data model. |
Value1 |
|
nvarchar(255) |
|
Old value that was changed. |
Value2 |
|
nvarchar(255) |
|
New value. |
CreateDate |
|
datetime |
|
Date that the change was captured by the collector. |
PrevWkstnOID |
|
binary(16) |
|
Workstation with which the component was associated. |
ComponentOID |
FK |
binary(16) |
No |
Reference to the component changed. |