OperatorNotes note table

noteId

int

This field shows a unique ID for each note record.

categoryId

int

This field shows an ID that determines the category type referenced in the categoryDefine table.

activeFlag

boolType

This field shows a true or false flag to indicate if the note is active or not.

time

GMTtime

This field displays the time of the event in Greenwich Mean Time (GMT).

offset

GMToffset

This field displays the offset to the local time zone that was in effect when time occurred.

lastModDate

datetime

This field shows the time when the last change to the note was made.

lastModUser

nameType

This field shows the name of the Administrator/Controller that last modified the note.

headline

ON_headlineType

This field shows the title of the note.

noteText

ON_noteTextType

This field shows the details of the note.

stationName

nvarchar(32)

This field shows the station on which this note was created.

aorGroup

ON_aorGroupType

This field shows the Area Of Responsibility (AOR) group that the Controller was a member of at the time the note was written.

noteId

int

This field displays the Note ID of the modified note record.

categoryId

int

This field displays the ID that determines the category type referenced in the categoryDefine table.

activeFlag

boolType

This field displays a true or false flag to indicate if the note is active or not.

time

GMTtime

This field displays the time of the event in GMT.

offset

GMToffset

This field displays the offset to the local time zone that was in effect when time occurred.

lastModDate

datetime

This field displays the time when the last change was made to the note.

lastModUser

nameType

This field displays the name of the Administrator/Controller that last modified the note.

headline

ON_headlineType

This field displays the title of the note.

noteText

ON_noteTextType

This field displays the details of the note.