BwPData.mdb definition
1. BwActionTable: User action log table.
a. ProjNodeId : Unique ID for a SCADA node.
b. LogDate : Date of the record was recorded.
c. LogTime : Time of the record was recorded.
d. Priority : Not Used.
e. TagName : Tag name, if it is tag related record.
f. Description : Tag Description
g. Action : Description of the User Action
h. UserName : The user who made the action
i. NodeName : The node that this action happened.
j. NodeIP : The IP address of the node where the action happened.
2. BwAlarmTable: Alarm log table
a. ProjNodeId : Unique ID for a SCADA node.
b. LogDate : Date of the record was recorded.
c. LogTime : Time of the record was recorded.
d. Priority : Alarm priority.
e. TagName : Tag name.
f. Description : Tag Description
g. Action : Alarm information
h. UserName : User involved in the alarm action.
i. NodeName : Not Used.
j. NodeIP : Not used.
3. BwAnalogTable : Data log for Analog tags
a. ProjNodeId : Unique ID for a SCADA node.
b. TagName : Tag Name.
c. LogDate : Date of the record was recorded.
d. LogTime : Time of the record was recorded.
e. MaxValue: Maximum value of the recording period.
f. AvgValue: Average value of the recording period.
g. MinValue: Minimum value of the recording period.
h. LastValue: The Maximum value of the recording period.
i. Alarm: If the tag is in alarm during the recording period.
-2147483648 (Decimal) or 0x80000000 (HEX) means there is no data during the minute of collection. Otherwise, the value of this field is a LOGICAL OR of all the Alarms that occurred during the interval.
Alarm Code Alarm Code
Description
Decimal
Hex
-2147483648 0x80000000 no data during the minute of collection.
2 0x02 Acknowleged Alarm
4 0x04 High High Alarm
8 0x08 High Alarm
16 0x10 Low Alarm
32 0x20 Low Low Alarm
64 0x40 Rate of change Alarm
128 0x80 High Deviation Alarm
256 0x100 Low Deviation Alarm
512 0x200 Discrete Alarm
4. BwDiscreteTable : Data log for Discrete tags
a. ProjNodeId : Unique ID for a SCADA node.
b. TagName : Tag Name.
c. LogDate : Date of the record was recorded.
d. LogTime : Time of the record was recorded.
e. LogMilliSecond : The millisecond of the time of the record was recorded
f. LogValue : The value recorded.
g. Alarm: If the tag is in alarm during the recording period.
-2147483648 (Decimal) or 0x80000000 (HEX) means there is no data during the minute of collection. Otherwise, the value of this field is a LOGICAL OR of all the Alarms that occurred during the interval.
Alarm Code Alarm Code
Description
Decimal
Hex
-2147483648 0x80000000 no data during the minute of collection.
2 0x02 Acknowledged Alarm
512 0x200 Discrete Alarm
5. BwTextTable : Data log for Analog tag
a. ProjNodeId : Unique ID for a SCADA node.
b. TagName : Tag Name.
c. LogDate : Date of the record was recorded.
d. LogTime : Time of the record was recorded.
e. TextData : The data recorded.
6. BwLogTag: All the tags with ODBC log enabled
a. ProjNodeId : Unique ID for a SCADA node.
b. TagName : Tag Name.
c. TagType : 1/2/3 for Analog/Discrete/Text tag
d. ProjId : Project ID for the tag.
7. BwLogTblInfo : For internal used only.
8. BwReportTable : For internal used only.
9. BwReportTagTable : For internal used only.
10. BwSysLogTable: System operation log
a. ProjNodeId : Unique ID for a SCADA node.
b. LogDate : Date of the record was recorded.
c. LogTime : Time of the record was recorded.
d. UserName : User name who made the action.
e. ActionType : An action type ID.
f. Action : Text Description of the action.
g. SourcePC : The computer name where the action was originate.
h. SourceIP : IP address of the source computer.
i. ProjId : Unique number for the project involved.
j. ProjName : Project name involved in this action.
k. NodeName : SCADA node name involved in this action.