2.40 NC_WkstnChanges Table

The NC_Workstation table tracks workstation changes.

Column

Key

Type

Null

Description

WkstnChangesOID

PK

binary(16)

No

Internal ID number used as a primary key.

TypeOfChange

smallinit

No

  • 0 = Created
  • 1 = Edited
  • 2 = Deleted
  • 3 = Moved
  • 4 = Retired

SourceOfChange

smallinit

No

  • 0 = Collector
  • 1 = Field editor
  • 2 = Collection server
  • 3 = Managed
  • 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

No

Date that the change was entered in the database.

WorkstationOID

FK

binary(16)

No

Reference to the workstation changed.