Information Model
Database Schema
SCADA_IDS Database Table
The schema for this table is defined in ces_schema_scada.sql file.
The script, OPAL_scada_ids.sql, populates generic SCADA sources for the OPAL model. A source is any SCADA system that can provide information to the adapter. There could be one SCADA source defined for each of multiple SCADA vendors, or a utility may choose to divide their territory into multiple regions, with each region acting as a separate SCADA source. Each SCADA source must have a unique name as well as a unique integer ID.
SCADA_IDS
Column
Data Type
Description
ID
NUMBER
Numeric identifier for each "SCADA source" that we want RTI to process.
SCADA_NAME
VARCHAR2(32)
Name for the SCADA source
ADAPTER_TYPE
VARCHAR2(32)
Adapter type for this SCADA source.
ACTIVE
VARCHAR2(1)
Is the adapter active (Y/N)
 
SCADA_POINTS Database Table
The SCADA_POINTS table contains a row for each device in the Oracle Utilities Network Management System operations database that has SCADA information associated with it. Each record has a "scada_name" column which, in order to populate one of the measurements tables, must match a valid "scadapop -scada <scada>" parameter - where <scada> is a valid and active scada_ids.scada_name value. Where there is a match, a row is populated in the scada_measurements_st table for each defined attribute.
The SCADA_POINTS table is normally populated via device driven attribute population during the model build process. It is a staging table for the scadapop-driven measurement point population process. It is not accessed during adapter execution.
The schema for this table can be found in the file ces_retain_scada.sql
SCADA_POINTS
Column
Data Type
Description
H_CLS
SMALLINT
Object handle class
H_IDX
INTEGER
Object handle index
SCADA_NAME
VARCHAR2(32)
SCADA system name
RTU_ALIAS
VARCHAR2(32)
SCADA point RTU name - for demand scans (optional)
RTI_ALIAS
VARCHAR2(128)
SCADA point name
FEEDER
VARCHAR2(100)
Nominal feeder for this point (optional)
SUBSTATION
VARCHAR2(100)
Nominal substation for this point (optional)
TEMPLET
VARCHAR2(32)
Template to use in <project>_rti.dat file for this model device
PARTITION
INTEGER
Partition of this object
BIRTH
DATE
Date object activated into the model
BIRTH_PATCH
INTEGER
Patch which activated this object
DEATH
DATE
Date object de-activated into the model
DEATH_PATCH
INTEGER
Patch which de-activated this object
ACTIVE
VARCHAR2(1)
Active flag (Y/N)
 
SCADA_MEASUREMENTS_ST Database Table
The scada_measurements_st table is a staging table used to help populate the analog_measurements and digital_measurements (production) tables. The schema for this table can be found in the file ces_retain_services.sql.
SCADA_MEASUREMENTS_ST
 
Column
Data Type
Description
H_CLS
SMALLINT
Object handle class.
H_IDX
INTEGER
Object handle index.
PARTITION
INTEGER
Object partition.
ATTRIBUTE
SMALLINT
Data attribute index (from ATTRIBUTES table).
TTL
SMALLINT
Time-To-Live Value. See Understanding TTL.
LIMIT_GROUP_ID
INTEGER
Object limit group.
RTI_ALIAS
VARCHAR2(128)
RTI device measurement name.
RTI_ALIAS_A
VARCHAR2(128)
RTI device measurement name for phase A. Only applies for digital measurements and only used by the MultiSpeak SCADA adapter.
RTI_ALIAS_B
VARCHAR2(128)
RTI device measurement name for phase B. Only applies for digital measurements and only used by the MultiSpeak SCADA adapter.
RTI_ALIAS_C
VARCHAR2(128)
RTI device measurement name for phase C. Only applies for digital measurements and only used by the MultiSpeak SCADA adapter.
SCADA_ID
INTEGER
SCADA source identifier - matches scada_ids.id
RTU_ID
VARCHAR2(32)
RTU ID - unique name within SCADA system.
QUALITY
INTEGER
Quality code.
VALUE
FLOAT
Manual replace value.
UPDATE_FLAG
INTEGER
Manual Replace Flag. Set this to 1 to be sure that the adapter always sends the first value it receives, even when it matches the current NMS value.
ICCP_OBJECT
VARCHAR2(32)
ICCP mms object name.
DISPLAY_ID
VARCHAR2(64)
ID for display call up.
CONTROLLABLE
VARCHAR2(1)
Is this row controllable.
ACTIVE
VARCHAR2(1)
Is this row active.
SOURCE
VARCHAR2(33)
Source of measurements.
COMMENTS
VARCHAR2(512)
Comment associated with measurements.
OFF_NOMINAL_TIME
DATE
Time quality went off-nominal (in the UTC time zone).
NORMAL_STATE
INTEGER
Normal state for measure. Only used for digital measurements.
MEASUREMENT_TYPE
VARCHAR2(1)
Measurement Type:
A -- Analog measurement
D -- Digital measurement
ICCP_DATA_SET
VARCHAR2(64)
Data set name.
FEEDER
VARCHAR2(100)
Nominal feeder name.
SUBSTATION
VARCHAR2(100)
Nominal substation name.
GANG
VARCHAR2(1)
'Y'/'N' - is this a gang measurement.
DEVICE
VARCHAR2(64)
Device the measurement is on.
NCG
INTEGER
The NCG of the device.
 
Understanding TTL
The Time to live (TTL) column determines whether the measurement is broadcast to other NMS Services such as the Viewer, Power Flow, or FLISR every time the measurements value or quality changes.
The TTL can be set to one of the following values
0 = the measurement is not broadcast
1 = the measurement is broadcast
2 = the measurement is broadcast.
Furthermore, the measurement is not deemed to be a real telemetered point but rather a pseudo point. In addition to broadcasting to services, NMS will broadcast any NMS initiated change in value (for example, manual or override) back to the external SCADA system responsible for the point.