TEST RESULTS HANDLING VOLTECH AT3600 USER MANUAL
DATABASE TABLES
The server software automatically creates the following tables in the selected
database (if they do not already exist) and stores data within the tables using the
structure defined here.
The tables store all the information that is available concerning the results (including
time, date, limits, operator etc.) in a very compact and efficient structure.
Note that new data is not necessarily appended to the end of a table; it may appear
anywhere within.
Table: tblVoltechATUnitID
Field Format Notes
ATUnitID Text (25) Index ID
UnitType Text (10) AT3600, AT1600, ATi
UnitID Text (10) Unit Serial Number
FirmwareID Text (10) Unit Firmware Version
Table: tblVoltechResults
Field Format Notes
ResultID Text (25) Index ID
RunID Text (25) As tblVoltechRunID.RunID
TestID Text (25) As tblVoltechTestID.TestID
TestNo Number (Long Integer) Test number as in test program
OC_Comp Text (5) YES , NO , N/A
Open Circuit Compensation status
SC_Comp Text (5) YES , NO , N/A
Short Circuit Compensation status
Load_Comp Text (5) YES , NO , N/A
Load Compensation (future development)
Result Number (Single) Actual test result
TestStatus Text (5) DSP Status for test
PassFail Text (5) PASS/FAIL
Individual test pass or fail result
PAGE 4.3.12. VPN 98 - 024 USING THE SERVER