UBoard Data Dictionary - SCADA
UGEMS Data Dictionary
dm_qw_scada_archieveitemsfloat_
dm_qw_scada_archieveitemsfloat_category merupakan table yang berisikan kategori (Max, Min, Under, Average) berdasarkan perbandingan nilai value yang akan digunakan sebagai tabel referensi pembuatan view view_scada_archieveitemsfloat_category.
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
datereport |
date |
|
|
|
1/22/2023 |
|
yearreport |
int4 |
32 |
|
|
2,023 |
|
monthreport |
int4 |
32 |
|
|
202,301 |
|
deviceid |
varchar |
|
|
|
sKp3RjYB |
|
devicename |
varchar |
|
|
|
OMS+_S7-1500_BunatiCPPStockpile&Port (1) |
|
itemid |
varchar |
|
|
|
Va8v7BPM |
|
itemname |
varchar |
|
|
|
CV_105_FLOWRATE_ACTUAL |
|
aliasname |
text |
|
|
|
Flowrate Average Actual |
|
groupname |
text |
|
|
|
CV105 |
|
quality |
varchar |
|
|
|
TRUE |
|
value |
numeric |
|
|
|
1,505.16 |
|
hihi_value |
int8 |
64 |
|
|
1,900 |
|
hi_value |
int8 |
64 |
|
|
1,700 |
|
lo_value |
int8 |
64 |
|
|
1,600 |
|
lolo_value |
int8 |
64 |
|
|
0 |
|
category |
text |
|
|
|
Under |
|
view_scada_archieveitemsfloat_category
view_scada_archieveitemsfloat_category merupakan view yang digunakan untuk menampilkan informasi tentang total masing-masing category setiap harinya.
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
datereport |
date |
|
|
|
44,951 |
|
yearreport |
int4 |
32 |
|
|
2,023 |
|
monthreport |
int4 |
|
|
|
202,301 |
|
deviceid |
varchar |
|
|
|
6169FO1W |
|
devicename |
varchar |
|
|
|
OMS+_CPU |
|
itemid |
varchar |
|
|
|
2ih05BGQ |
|
itemname |
varchar |
|
|
|
CV_22_TOTALIZER_THIS_MONTH |
|
aliasname |
text |
|
|
|
Totalizer This Month |
|
groupname |
text |
|
|
|
BLC CV 22 |
|
quality |
varchar |
|
|
|
TRUE |
|
hihi_value |
int8 |
64 |
|
|
1,400,000 |
|
hi_value |
int8 |
64 |
|
|
1,300,000 |
|
lo_value |
int8 |
64 |
|
|
1,000,000 |
|
lolo_value |
int8 |
64 |
|
|
100,000 |
|
category |
int8 |
64 |
|
|
Min |
|
total |
int8 |
64 |
|
|
37 |
|
total_yesterday |
int8 |
64 |
|
|
0 |
|