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 |
|
|