XSPOC Client Help

tblNodeMaster

Description of columns in the tblAeraSpoc Table.

COLUMNS

Column Name Datatype Length AllowNulls Bound Criteria Description
NodeID varchar 50 No    
Node varchar 50 Yes    
Enabled bit 1 No    
CommStatus varchar 50 Yes    
Comment varchar 50 Yes    
LastGoodScanTime datetime 8 Yes    
RunStatus varchar 15 Yes    
HighPriAlarm varchar 15 Yes    
CommAttempt smallint 2 Yes    
CommSuccess smallint 2 Yes    
DataCollection bit 1 No    
Positioner bit 1 No    
StringID smallint 2 Yes    
AdhocGroup1 varchar 20 Yes    
AdhocGroup2 varchar 20 Yes    
AdhocGroup3 varchar 20 Yes    
PagingEnabled bit 1 No    
PortID smallint 2 Yes    
Runtime24Flag bit 1 No    
POCType smallint 2 Yes    
GroupSDFlag bit 1 No    
OtherWellID1 char 20 Yes    
TodayRuntime real 4 Yes    
TodayCycles int 4 Yes    
TimeInState int 4 Yes    
LastAnalCondition varchar 80 Yes    
WellOpType int 4 Yes    
PumpFillage int 4 Yes    
BakerVersion int 4 Yes    
EnergyMode int 4 Yes    
EnergyGroup int 4 Yes    
PctCommYest int 4 Yes    
HostAlarm varchar 50 Yes    
HostAlarmState smallint 2 Yes    
LastGoodHistScan datetime 8 Yes    
RuntimeAcc int 4 Yes    
RuntimeAccGO int 4 Yes    
RuntimeAccGOYest int 4 Yes    
RuntimeSinceStart int 4 Yes    
StartsAcc int 4 Yes    
StartsAccGO int 4 Yes    
StartsAccGOYest int 4 Yes    
KWH int 4 Yes    
RuntimeAccGOYY int 4 Yes    
StartsAccGOYY int 4 Yes    
FirmwareVersion real 4 Yes    
InferredProd real 4 Yes