Attribute Name

Type

Field Size

Description

Required

AlertID

int

4

Unique internal DB identifier of the Alert record.

Required

RouteID

int

4

Unique internal DB identifier of the Route record. Must exist on the FWRoute table.

StopID

int

4

Unique identifier of the Stop record. Must exist on the FWStop table.

DateTime

datetime

8

The Date/Time stamp reported in the Alert.

ResourceKey

nvarchar

50

Business key to identify the Resource this Alert refers to.

AlertCodeID

int

4

Unique Identifier of the Alert code record.

HiddenInd

bit

1

This field indicates if this alert is to be hidden in the user interface (UI).

·        0 - hidden

·        1 - shown

·    Null - shown

HiddenByID

int

4

User ID that hid this field.

ModifiedBy

int

4

See ModifiedBy.

AlertCodeValue

nvarchar

This alert code may have a default value that if reported by the wireless device and no value comes in, then this value will be used to display in the UI.

Type

Comment

nvarchar

500

It is used to provide additional information about a specific record.

HiddenTime

datetime

8

Time when the alert is changed to  hidden

OrderLineID

int

4

Unique internal DB Identifier of the Order Line record.

DateTimeUTC

datetime

8

Timestamp of the alert (Coordinated Universal Time)

wGLNSyncInd

bit

1

Can be set to true or false depending on the response from wGLN.

0 – Failure. wGLN does not have the latest changes.

1 – wGLN is in sync with Route Planner.

wGLNResponse

nvarchar

This field holds the response from wGLN

ModifyDate

datetime

8

See ModifyDate.