XSPOC Client Help
tblXDiagResults
Description of columns in the tblAeraSpoc Table.
COLUMNS
| Column Name |
Datatype |
Length |
AllowNulls |
Bound Criteria |
Description |
| NodeID |
varchar |
50 |
No |
|
|
| Date |
datetime |
8 |
No |
|
|
| PumpCond1 |
varchar |
50 |
Yes |
|
|
| PumpCond2 |
varchar |
50 |
Yes |
|
|
| FillagePct |
smallint |
2 |
Yes |
|
|
| NetProd |
smallint |
2 |
Yes |
|
|
| FluidLevelXDiag |
int |
4 |
Yes |
|
|
| ElecCostPerBO |
money |
8 |
Yes |
|
|
| ElecCostMinTorquePerBO |
money |
8 |
Yes |
|
|
| ElectCostMinEnergyPerBO |
money |
8 |
Yes |
|
|
| PumpEffPct |
smallint |
2 |
Yes |
|
|
| SystemEffPct |
smallint |
2 |
Yes |
|
|
| PumpStroke |
smallint |
2 |
Yes |
|
|
| GearBoxLoadPct |
smallint |
2 |
Yes |
|
|
| MinTorqueGBLoadPct |
smallint |
2 |
Yes |
|
|
| MinEnergyGBLoadPct |
smallint |
2 |
Yes |
|
|
| BalanceUnit |
bit |
1 |
No |
|
|
| TubingPressure |
int |
4 |
Yes |
|
|
| CasingPressure |
int |
4 |
Yes |
|
|
| GrossProd |
int |
4 |
Yes |
|
|
| WaterCutPct |
smallint |
2 |
Yes |
|
|
| MinHP |
int |
4 |
Yes |
|
|
| PeakGBTorque |
int |
4 |
Yes |
|
|
| MinGBTorque |
int |
4 |
Yes |
|
|
| MinEnerGBTorque |
int |
4 |
Yes |
|
|
| MonthlyElecCost |
datetime |
8 |
Yes |
|
|
| MinMonthlyElecCost |
money |
8 |
Yes |
|
|
| ElecCostPerBG |
money |
8 |
Yes |
|
|
| MinElecCostPerBG |
money |
8 |
Yes |
|
|
| PumpSize |
real |
4 |
Yes |
|
|
| TubingLeak |
bit |
1 |
No |
|
|
| BadSG |
bit |
1 |
No |
|
|
| AddOilProduction |
int |
4 |
Yes |
|
|
| AnalysisDate |
datetime |
8 |
Yes |
|
|
| PPRL |
int |
4 |
Yes |
|
|
| MPRL |
int |
4 |
Yes |
|
|
| BouyRodWeight |
int |
4 |
Yes |
|
|
| PolRodHP |
real |
4 |
Yes |
|
|
| UnitStructLoad |
smallint |
2 |
Yes |
|
|
| MaxRodLoad |
smallint |
2 |
Yes |
|
|
| MinEnergyCLF |
real |
4 |
Yes |
|
|
| MinTorqueCLF |
real |
4 |
Yes |
|
|
| CurrentCLF |
real |
4 |
Yes |
|
|
| MinEnergyMCB |
smallint |
2 |
Yes |
|
|
| MinTorqueMCB |
smallint |
2 |
Yes |
|
|
| CurrentMCB |
smallint |
2 |
Yes |
|
|
| MinEnergyCBE |
int |
4 |
Yes |
|
|
| MinTorqueCBE |
int |
4 |
Yes |
|
|
| CurrentCBE |
int |
4 |
Yes |
|
|
| MinEnergyKWH |
int |
4 |
Yes |
|
|
| MinTorqueKWH |
int |
4 |
Yes |
|
|
| CurrentKWH |
int |
4 |
Yes |
|
|
| MinEnergyMonthlyElec |
int |
4 |
Yes |
|
|
| MinTorqueMonthlyElec |
int |
4 |
Yes |
|
|
| CurrentMonthlyElec |
int |
4 |
Yes |
|
|
| MinEnergyElecBG |
real |
4 |
Yes |
|
|
| MinTorqueElecBG |
real |
4 |
Yes |
|
|
| CurrentElecBG |
real |
4 |
Yes |
|
|
| MinEnergyElecBO |
real |
4 |
Yes |
|
|
| MinTorqueElecBO |
real |
4 |
Yes |
|
|
| CurrentElecBO |
real |
4 |
Yes |
|
|
| TubingMovement |
int |
4 |
Yes |
|
|
| FluidLoadonPump |
int |
4 |
Yes |
|
|
| PumpIntakePressure |
int |
4 |
Yes |
|
|
| LoadShift |
smallint |
2 |
Yes |
|
|
| WaterSG |
real |
4 |
Yes |
|
|
| OilAPIGravity |
real |
4 |
Yes |
|
|
| FluidSG |
real |
4 |
Yes |
|
|
| GrossPumpStroke |
smallint |
2 |
Yes |
|
|
| DownholeAnalysis |
text |
16 |
Yes |
|
|
| RodAnalysis |
text |
16 |
Yes |
|
|
| SurfaceAnalysis |
text |
16 |
Yes |
|
|
| InputAnalysis |
text |
16 |
Yes |
|
|
| GrossPumpDisplacement |
int |
4 |
Yes |
|
|
| NetStrokeApparent |
real |
4 |
Yes |
|
|
| AvgDHDSLoad |
int |
4 |
Yes |
|
|
| AvgDHUSLoad |
int |
4 |
Yes |
|
|
| AvgDHDSPOLoad |
int |
4 |
Yes |
|
|
| AvgDHUSPOLoad |
int |
4 |
Yes |
|
|
| DryRodWeight |
int |
4 |
Yes |
|
|
| PumpFriction |
int |
4 |
Yes |
|
|
| POFluidLoad |
int |
4 |
Yes |
|
|
| PumpEfficiency |
int |
4 |
Yes |
|
|