TmCalls Table

All of the following fields must exist in the TmCalls table. Scenario, CallID, LastName, FirstName, Account, Telephone, and TroubleAtAccount must contain values. If a record contains a No value in the TroubleAtAccount field, it is submitted to Responder, but no incident will be created for it. The SetTroubleAtAccount query in TroubleMaker Scenario.mdb provides an easy method for assigning Yes to the TroubleAtAccount field for all records.

Field

Description

Scenario

Records may be separated into different scenarios using different scenario numbers.

This field is a primary key and a foreign key to the TmScenario table.

CallId

A unique number within the scenario that identifies the call. It also determines the order in which the calls are submitted.

This field is a primary key.

RegionCode

Indicates the region in which the incident resides.

CriticalCode

A numeric value that corresponds to the critical status of the incident. 0=not critical; 1=critical

CauseCode

A numeric value that corresponds to the cause of the incident.

TroubleCode

A numeric value that corresponds to the trouble type for the incident.

DeviceFcid

Feature class ID for the incident device.

DeviceOid

Object ID for the incident device.

Account

The customer's account number. If this field is blank, TroubleMaker will use the FirstName, LastName, and Telephone fields to query Responder to locate the account number.

LastName

Customer's last name.

FirstName

Customer's first name.

Telephone

Customer's telephone number.

TroubleAtAccount

Indicates whether the trouble reported occurs at the customer's location. Yes/No

CallBackRequested

Indicates whether the customer wants a return call. Yes/No

CallbackPowerNotRestored

Yes/No value indicating whether callback customer indicates that the power has been restored.

Remarks

Any remarks associated with the incident.

Hazard1Type

Type of a hazard associated with the incident

Hazard1OnSite

Yes/No value indicating whether a public safety official has arrived on the hazard site.

Hazard2Type

Type of a second hazard associated with the incident

Hazard2OnSite

Yes/No value indicating whether a public safety official has arrived on the hazard site.

CallTaker

The name of the customer service representative who fielded the customer call.

TimeReceived

The time the call was originally received.

SubmitOrder

A numeric value indicating the random order in which to submit calls.

QR code for this page

Was this helpful?