XSPOC Client Help
tblWellDetails
Description of columns in the tblAeraSpoc Table.
COLUMNS
| Column Name |
Datatype |
Length |
AllowNulls |
Bound Criteria |
Description |
| NodeID |
varchar |
20 |
No |
|
|
| Runtime |
real |
4 |
Yes |
|
|
| PumpDepth |
smallint |
2 |
Yes |
|
|
| TubingPressure |
smallint |
2 |
Yes |
|
|
| CasingPressure |
smallint |
2 |
Yes |
|
|
| WaterCut |
smallint |
2 |
Yes |
|
|
| WaterSG |
real |
4 |
Yes |
|
|
| OilAPIGravity |
real |
4 |
Yes |
|
|
| FluidLevel |
smallint |
2 |
Yes |
|
|
| SPM |
real |
4 |
Yes |
|
|
| GrossRate |
smallint |
2 |
Yes |
|
|
| TubingOD |
real |
4 |
Yes |
|
|
| TubingAnchorDepth |
smallint |
2 |
Yes |
|
|
| PumpType |
varchar |
1 |
Yes |
|
|
| PlungerDiam |
real |
4 |
Yes |
|
|
| NumRodSections |
smallint |
2 |
Yes |
|
|
| TotalRodLength |
int |
4 |
Yes |
|
|
| RodLengthAdjust |
int |
4 |
Yes |
|
|
| RodTubingFriction |
real |
4 |
Yes |
|
|
| ServiceFactor |
real |
4 |
Yes |
|
|
| PumpingUnitID |
varchar |
6 |
Yes |
|
|
| MaxCBMoment |
smallint |
2 |
Yes |
|
|
| Rotation |
varchar |
3 |
Yes |
|
|
| HoleNumber |
smallint |
2 |
Yes |
|
|
| PowerMeterType |
varchar |
1 |
Yes |
|
|
| PrimeMoverType |
varchar |
4 |
Yes |
|
|
| MotorHP |
smallint |
2 |
Yes |
|
|
| TorqueMode |
varchar |
2 |
Yes |
|
|
| StrokeLength |
real |
4 |
Yes |
|
|
| XDGFileAvailable |
bit |
1 |
No |
|
|
| DownReasonCode |
varchar |
10 |
Yes |
|
|
| POCGrossRate |
smallint |
2 |
Yes |
|
|
| Cycles |
real |
4 |
Yes |
|
|
| LastTestDate |
datetime |
8 |
Yes |
|
|
| TopPerf |
int |
4 |
Yes |
|
|
| BotPerf |
int |
4 |
Yes |
|
|
| FluidTemp |
int |
4 |
Yes |
|
|
| ElectricityCost |
real |
4 |
Yes |
|
|
| TubingAnchored |
bit |
1 |
Yes |
|
|
| TubingID |
real |
4 |
Yes |
|
|
| FluidLevelSource |
int |
4 |
Yes |
|
|
| PumpIntakePressure |
real |
4 |
Yes |
|
|
| MotorTypeID |
int |
4 |
Yes |
|
|
| MotorSizeID |
int |
4 |
Yes |
|
|
| MotorSettingID |
int |
4 |
Yes |
|
|
| PeakLoad |
int |
4 |
Yes |
|
|
| MinLoad |
int |
4 |
Yes |
|
|
| LoadSensorType |
int |
4 |
Yes |
|
|
| IdleTime |
real |
4 |
Yes |
|
|
| DynoCorrectKinematic |
int |
4 |
Yes |
|
|
| DynoCorrectPhase |
int |
4 |
Yes |
|
|
| DynoLoadAdjustment |
int |
4 |
Yes |
|
|
| DynoPhaseAdjustment |
real |
4 |
Yes |
|
|
| DynoTOSAdjustment |
real |
4 |
Yes |
|
|
| GasRate |
real |
4 |
Yes |
|
|