SKF AWAIV-12, User Manual

Page: 211 / 250

Appendix D — Database definition
Version 4.0 database definition
The AWA database is an Access 97 database (.mdb) it can also be converted to an Access
2000 database and be used by the AWA. The Access database is divided into several tables.
The motor information and test results data is contained in the following tables: MotorID,
TestResults, TestResultsParameters, TestResultsPI, TestResultsPrgHiPot, and
SurgeWaveform. The testing criteria used to run the tests are contained in the following
tables: TestId, TestIdPrgHiPot, and RefSrgWaveform. Two addition tables are used, one is the
DatabaseInfo table and the other is the Route table.
Nameplate table—(MotorID)
The MotorID table contains the nameplate information for each motor added to the database.
There is only one motor record per motor. The motor_key is the primary keyed field. It is
automatically generated when a new motor is added. The Motor ID field is a unique identifier
that the user gives each motor.
Table 28.
Field name descriptions.
Field name Type Description
motor_key Long integer Automatically generated
number used as the primary
key.
tree_level_1 Text (25) First level used in the tree
view. Motor location 1 user
defined field label, defaults to
Location.
tree_level_2 Text (25) Second level used in the tree
view. Motor location 2 user
defined field label, defaults to
Building.
motor_id Text (30) User entered Motor
Identification value. It must
be unique.
manuf Text (25) Manufacturer of the motor.
manuf_type Text (25)
NEMA MG 1 requires
manufacturer’s type but may
vary depending on
manufacturer.
manuf_date_code Text (16) Manufacturer’s nameplate
date.
model Text (25) Manufacture’s Identification
of model type.
sn Text (25) Manufacture’s serial number.
hpkw Single Nameplate horse power or
kilowatts.
rpm Single Revolutions per minute
(RPM).