Data Dictionary

Question 1

SA

Answer 1

Default schema. Contains TABLE_CASE, TABLE_USER, TABLE_SITE_PART, etc.

Question 2

TABLE_CASE

Answer 2

Stores all cases created by the system

Question 3

TABLE_USER

Answer 3

Stores records of every users in the system

Question 4

TABLE_SITE_PART

Answer 4

Stores information on all locomotives

Question 5

GET_USR

Answer 5

Schema. Includes tables to represent users, such as GET_URS_USERS, GET_USR_USER_ROLES, etc.

Question 6

GETS_B2B

Answer 6

Schema. Customer-related information that is useful to our understanding of the locomotives and the customer operations, such as when vehicles go in and out of maintenance shops

Question 7

GETS_KEP

Answer 7

Schema. “Knowledge Engineering Platform”. Stores information used by the iTools environment.

Question 8

GETS_OMI

Answer 8

Schema. “Onboard Messaging Interface”. Contains tables that store information related to messaging with the vehicles.

Question 9

GETS_RMD

Answer 9

Schema. “Remote Monitoring and Diagnostics”. Contains tables that store data delivered to the UI.

Question 10

GETS_SD

Answer 10

Schema. “Service Delivery” Tables related to the delivery of recommendations to customers (like GETS_RMD).

Question 11

GETS_TOOLS

Answer 11

Schema. Contains data used by the rules engine and other diagnostic tools.

Question 12

GETS_TOOL_FAULT

Answer 12

Stores each fault recorded. Record includes data pertaining to the fault record itself (time, recorded by, etc.) as well as a limited number of parameters if concerning an older locomotive.

Question 13

GETS_TOOL_MP_…

Answer 13

Tables containing parameters stored for different kinds of locomotives. (The suffix will specify which kind of locomotive.)

Question 14

GETS_TOOL_VIRTUAL_…

Answer 14

Stores “virtual” parameters derived from the monitored parameters.

Question 15

GETS_TOOL_DPD_…

Answer 15

Tables that store the rule constructs used by the JDPAD rule engine

Question 16

GETS_TOOL_ANOM_…

Answer 16

Tables used by the anomaly server

Question 17

GETS_TOOL_CBR_…

Answer 17

Tables used by the case-based reasoner tool

Question 18

GETS_RMD_FAULT_CODES

Answer 18

Master list of fault codes generated by the vehicle controllers

Question 19

GETS_RMD_VEHICLE

Answer 19

List of all vehicles we monitor

Question 20

GETS_RMD_MODEL

Answer 20

List of model types we support

Question 21

GETS_RMD_FLEET

Answer 21

List of customer fleets the vehicles are grouped into

Question 22

GETS_RMD_CONTROLLER

Answer 22

Information on the on-board controllers

Question 23

GETS_TOOL_RUN

Answer 23

Stores info on each run created (by the Tool Schedule, example), such as its priority and when it was created and completed.

Question 24

GETS_RMD_FAULT_CODES

Answer 24

Stores information on each kind of fault, including a description of what is wrong

Question 25

What table stores all cases created by the system?

Answer 25

SA.TABLE_CASE

Question 26

What table stores information on all the locomotives?

Answer 26

SA.TABLE_SITE_PART

Question 27

What table stores a record for each fault created?

Answer 27

GETS_TOOLS.GETS_TOOLS_FAULT

Question 28

What table lists all the vehicles?

Answer 28

GETS_RMD.GETS_RMD_VEHICLE

Question 29

What table stores a record for each run created?

Answer 29

GETS_TOOL_RUN

Question 30

What table stores information on each kind of fault?

Answer 30

GETS_RMD_FAULT_CODES