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) |
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) |
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. |
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. |