This example shows the transfer of historical data (CE based) to Oracle. Note that the poll rate should be equal to the historian's archive rate.
Point Name - Oracle Power
Alias - ORACLE_POWER Residence = Ram Categories = 00000000000000000000000000000001 CE Indicator = Enabled CE Order = Natural |
||
---|---|---|
Attribute Name | DE Type | Value |
device poll types | rtBYTES4 | (0x)00000001 |
device PRBX types | rtBYTES4 | |
scan input control | rtLOGICAL | 1 |
scan input status | rtUINT8 | |
failure threshold | rtUINT8 | 3 |
scan input | (see below) | |
scan output control | rtLOGICAL | 0 |
scan output status | rtUINT8 | |
scan output | (not used) | |
dev fail threshold | rtUINT8 | 3 |
oracle table name | rtBYTES48 | "POWER" |
transfer direction | rtUINT8 | 8 |
cross ref table | (see below) | |
debug level | rtUINT8 | 0 |
sql filename | rtBYTES32 | "" |
initial hist read | rtLOGICAL | |
device stats | rtUINT32 |
point control | poll type mask | st buffer size | # of elements | RTAP DE type | deadband type | deadband | rtap alias name |
---|---|---|---|---|---|---|---|
1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "POWER ONE" |
1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "POWER TWO" |
1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "POWER THREE" |
oracle field | rtap attribute | conv rtap de type |
---|---|---|
TAGNAME | [alias] | 0 |
TIMESTAMP | [ht].process value | 0 |
CURRENT_VALUE | [hv].process value | 0 |
FLAG_VALUE | [hf].process value | 0 |
DATA_QUALITY | [hq].process value | 0 |