Database Connection to Platform Automation System
Weatherford's RMS software contains an SQL database. In addition, an ODBC driver is available for direct interconnection to other databases.
Well Sensor History Table:
Table Name : WellSensor_History
Description : This table has information about all sensor tables.
Table Layout :
| Date Time Stamp |
Well Name |
Sensor Name |
Sensor Type |
Depth |
Data Table Name |
Status |
Age |
| |
|
|
|
|
|
|
|
Well Sensor Current Table:
Table Name : WellSensor_Current
Description : This table has information about the sensor tables for the current configuration.
Table Layout :
| Date Time Stamp |
Well Name |
Sensor Name |
Sensor Type |
Depth |
Data Table Name |
| |
|
|
|
|
|
Pressure Sensor Data Table:
Table Name : WellName_SensorName_Date_Time
Description : This table stores the data for this pressure sensor.
Table Layout :
| Date Time Stamp |
PRS |
PRS Status |
TMP |
TMP Status |
| |
|
|
|
|
Flow Sensor Data Table:
Table Name : WellName_SensorName_Date_Time
Description : This table stores the data for this flow sensor.
Table Layout :
| Date Time Stamp |
PRS |
PRS Status |
TMP |
TMP Status |
BV |
BV Status |
SS |
SS Status |
| |
|
|
|
|
|
|
|
|
Continued ....
| Oil FR |
Oil FR Status |
Water FR |
Water FR Status |
Oil PF |
Oil PF Status |
Water PF |
Water PF Status |
| |
|
|
|
|
|
|
|
Three-Phase Flow Sensor Data Table:
Table Name : WellName_SensorName_Date_Time
Description : This table stores the data for this 3 phase flow sensor.
Table Layout :
| Date Time Stamp |
PRS 1 |
PRS 1 Status |
TMP 1 |
TMP 1 Status |
PRS 2 |
PRS 2 Status |
| |
|
|
|
|
|
|
Continued ....
| TMP 2 |
TMP 2 Status |
PRS_DH |
PRS_DH Status |
TMP_DH |
TMP_DH Status |
| |
|
|
|
|
|
Continued ....
| PRS_STD |
PRS_STD Status |
TMP_STD |
TMP_STD Status |
PRS_STD |
PRS_STD Status |
| |
|
|
|
|
|
Continued ....
| TMP_SEP |
TMP_SEP Status |
BV |
BV Status |
SS |
SS Status |
| |
|
|
|
|
|
Continued ....
| Oil FR_STD |
Oil FR_STD Status |
Water FR_DH |
Water FR_DH Status |
Gas FR_DH |
Gas FR_DH Status |
| |
|
|
|
|
|
Continued ....
| Oil FR_STD |
Oil FR_STD Status |
Water FR_STD |
Water FR_STD Status |
Gas FR_STD |
Gas FR_STD Status |
| |
|
|
|
|
|
Continued ....
| Oil FR_SEP |
Oil FR_SEP Status |
Water FR_SEP |
Water FR_SEP Status |
Gas FR_SEP |
Gas FR_SEP Status |
| |
|
|
|
|
|
VelSOS (Velocity and Speed of Sound) Sensor Table:
Table Name : WellName_SensorName_Date_Time
Description : This table stores the data for this VelSOS sensor.
Table Layout :
| Date Time Stamp |
BV |
BV Status |
SS |
SS Status |
Total FR |
Total FR Status |
| |
|
|
|
|
|
|
DTS Sensor Table:
Table Name : WellName_SensorName_Date_Time
Description : This table stores the data for this DTS sensor.
Table Layout :
| Date Time Stamp |
DTS Data |
Zone Alarms |
| |
|
|
Overview
Connection to Platform Automation System
Modbus Connection
CSV ASCII String Connection
OPC Connection
PROFIBUS Connection
Database Connection
Flat Files Connection
Network Accessible Storage
|
