A PCS SCADA Archive system was not available for testing, thus a table was created to test the interface using MS SQL Server 2005. The following is a snapshot of the database.

Three main fields were needed:

TRANTIME is date/time of the reading

ITEMNAME is the signal tag name

READING is the value used to summarize data