This example show the transfer of well test data, but only if it has changed. Notice the first field in the cross ref table, it contains the value of a time stamp that will be checked to see if it has changed. The poll rate was set up so that there was enough time for the scan task to detect a new well test and transfer it to Oracle.
| Point Name - Well Test
Alias - WELL_TEST 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 | "WELL_TEST" |
| transfer direction | rtUINT8 | 2 |
| cross ref table | (see below) | |
| debug level | rtUINT8 | 0 |
| sql filename | rtBYTES32 | "" |
| device stats | rtUINT32 | |
| point control | poll type mask | st buffer size | # of elements | RTAP DE type | deadband type | deadband | rtap alias name |
|---|---|---|---|---|---|---|---|
| 1 | (0x)00000004 | 0 | 1 | 1 | 0 | 0 | "100022206311W500" |
| 1 | (0x)00000004 | 0 | 1 | 1 | 0 | 0 | "100042206311W500" |
| 1 | (0x)00000004 | 0 | 1 | 1 | 0 | 0 | "100102206311W500" |
| 1 | (0x)00000004 | 0 | 1 | 1 | 0 | 0 | "100121406311W500" |
| oracle field | rtap attribute | conv rtap de type |
|---|---|---|
| .results(9, timestamp) | ||
| TAGNAME | [alias] | 0 |
| TIMESTAMP | .results(9,timestamp) | 0 |
| TERMINATION | .results(9,status) | 0 |
| TEST_STATUS | [v]\\\\"xxx\\\\" | 17 |
| VALIDATION | [v]\\\\"nochk\\\\" | 17 |
| PROCESS_UNIT | [v]\\\\”???\\\\” | 17 |
| TEST_DURATION | .results(9,test duration) | 0 |
| PURGE_DURATION | .results(9,purge duration) | 0 |
| OIL_RATE | .results(9,oil) | 0 |
| TOTAL_WATER_RATE | .results(9,total water) | 0 |
| FREE_WATER_RATE | .results(9,free water) | 0 |
| ASSOC_WATER_RATE | .results(9,emulsion water) | 0 |
| TOTAL_GAS_RATE | .results(9,total gas) | 0 |
| FORMATION_GAS_RATE | .results(9,formation gas) | 0 |
| LIFT_GAS_RATE | .results(9,gas lift) | 0 |
| ORIGIN | [v]\\\\"FDC\\\\" | 16 |