MTE PTS 400.3 PLUS - Database Structure

PTS 400.3 PLUS Operation Manual_R02 Page 67/306
Data Base structure
Stored measuring data [Result] contains two major parts:
• Administrative Dataset (ADS) [Result (Administration)]
• Test Results Dataset (TDS) [Result (Measurement)]
The ADS contains the main parts:
• Administrative dataset
• Meter dataset [Meter #1 to #3]
The TDS contains the parts:
• Results of the different measuring functions [Error] to [Query CR]
• Sequence results [Sequence Results]
Database structure
#3
#2
Meter #1
Owner No.
Contract No.
Manufact.. No.
Manufact.. Date
Certificat. No.
Certificat. Date
Comment
Customer Data
Meter Type
CT
PT
CT Type
PT Type
#4
#3
#2
Meas. System #1
Manufacturer
Energy Supplier
No.
Address
Tel. No. (Off.)
Tel. No. (Mob.)
Email
Comment
Installation Setup
No.
Address
Tel. No. (Off.)
Tel. No. (Mob.)
Email
Comment
Energy Customer
No.
Address
Tel. No. (Off.)
Tel. No. (Mob.)
Email
Comment
Network Operator
No.
Address
Tel. No. (Off.)
Tel. No. (Mob.)
Email
Comment
Adminstrative Dataset ADS
Sequence Results
(incl. U,I,,P,Q,S, .)
Error
(incl. U,I,,P,Q,S, .)
Energy
(incl. U,I,,P,Q,S, .)
Counter
(incl. U,I,,P,Q,S, .)
Harmonics
(incl. U,I,,P,Q,S, .)
Waveforms
(incl. U,I,,P,Q,S, .)
Burden U
(incl. U,I,,P,Q,S, .)
Burden I
(incl. U,I,,P,Q,S, .)
Ratio U
(incl. U,I,,P,Q,S, .)
Ratio I
(incl. U,I,,P,Q,S, .)
DC
REF
/ f
REF
(incl. U,I,,P,Q,S, .)
Query CR
(incl. U,I,,P,Q,S, .)
Result
Result (Measurement)
Result (Administration)