Page is loading ...
Reference Guide
D301521X412
24-Feb-2010
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
Bristol OpenEnterprise Reference Guide
OpenEnterprise Schema
Reference Guide
D301521X412
24-Feb-2010 - Page 2
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
Contents
1 OpenEnterprise Schema.......................................................................................................13
Hint:............................................................................................................................................. 13
2 Tables......................................................................................................................................14
abcomplex................................................................................................................................... 14
abdevice...................................................................................................................................... 15
abdevicehealthalarmcondition .................................................................................................... 19
abdigital....................................................................................................................................... 20
abdriver ....................................................................................................................................... 21
abintegeranalog .......................................................................................................................... 24
abnetwork ................................................................................................................................... 25
abpolllist...................................................................................................................................... 27
abrealanalog ............................................................................................................................... 30
accessarea.................................................................................................................................. 31
accessareaconfig........................................................................................................................ 33
accessareaconfigforuser............................................................................................................. 34
adminuser ................................................................................................................................... 35
alarmcondition ............................................................................................................................ 36
alarmconditionlookup.................................................................................................................. 44
alarminhibitalarmcondition .......................................................................................................... 45
alarminhibitstatealarmcondition .................................................................................................. 46
alarmmailformat .......................................................................................................................... 47
alarmpagingformat...................................................................................................................... 48
alarmpagingrecipient .................................................................................................................. 49
alarmpattern................................................................................................................................ 50
alarmpriorityblock........................................................................................................................ 53
alarmrecipient ............................................................................................................................. 58
alarmredirection .......................................................................................................................... 60
alarmredirectiontimer .................................................................................................................. 64
alarmresponseaction .................................................................................................................. 65
alarmresponseactionemail.......................................................................................................... 66
alarmresponseactiongroup ......................................................................................................... 67
alarmsummary ............................................................................................................................ 68
alarmsuppressiontimer ............................................................................................................... 80
arbitrator...................................................................................................................................... 81
archivebackupitem...................................................................................................................... 82
archivebackupset........................................................................................................................ 84
archivecatalogue......................................................................................................................... 86
archivefile.................................................................................................................................... 90
archiveindex................................................................................................................................ 92
attributes ..................................................................................................................................... 94
attributetrigger............................................................................................................................. 97
autologouttimer ......................................................................................................................... 100
Reference Guide
D301521X412
24-Feb-2010 - Page 3
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
backupline................................................................................................................................. 103
backuplinestats ......................................................................................................................... 109
binarysignal............................................................................................................................... 112
breakpoint ................................................................................................................................. 114
bsapline..................................................................................................................................... 116
calculation ................................................................................................................................. 121
calculationcallbacktimer............................................................................................................ 125
calculationstatusalarmcondition................................................................................................ 126
calendarevents ......................................................................................................................... 127
calendareventsfordiary ............................................................................................................. 129
clcontrol..................................................................................................................................... 131
column_privileges ..................................................................................................................... 132
connection_config..................................................................................................................... 134
controlcurve .............................................................................................................................. 135
currentuser................................................................................................................................ 136
databasereplication................................................................................................................... 137
databasetimestatus................................................................................................................... 139
dataconnection ......................................................................................................................... 141
dataquery.................................................................................................................................. 146
dataquerymonitor...................................................................................................................... 148
dataservice................................................................................................................................ 149
datetimearchiveindex................................................................................................................ 150
dbcontrol ................................................................................................................................... 151
devicestatscallbacktimer........................................................................................................... 152
diary .......................................................................................................................................... 153
digital......................................................................................................................................... 159
digitalalarmcondition ................................................................................................................. 161
digitalchangetonullalarmcondition ............................................................................................ 162
digitaldelayalarmcondition ........................................................................................................ 163
digitaldelaytimer........................................................................................................................ 164
digitalsignaltrigger..................................................................................................................... 165
digitalstatealarmcondition ......................................................................................................... 166
dstinformation ........................................................................................................................... 167
dsttimer ..................................................................................................................................... 169
dvi_datum ................................................................................................................................. 171
dvi_device................................................................................................................................. 174
dvi_driver .................................................................................................................................. 178
dvi_network............................................................................................................................... 181
dvi_region ................................................................................................................................. 183
dvi_remote_driver ..................................................................................................................... 184
dvi_schedule............................................................................................................................. 186
emailserver ............................................................................................................................... 188
eventhistory .............................................................................................................................. 191
eventlog .................................................................................................................................... 201
eventperiods ............................................................................................................................. 211
eventreplication......................................................................................................................... 213
Reference Guide
D301521X412
24-Feb-2010 - Page 4
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
exception................................................................................................................................... 216
exceptionhandler ...................................................................................................................... 217
exclusions ................................................................................................................................. 218
expirywarningtime..................................................................................................................... 219
ftpserver .................................................................................................................................... 220
groups ....................................................................................................................................... 222
indexattrs .................................................................................................................................. 224
indexes...................................................................................................................................... 226
integeranalog ............................................................................................................................ 228
integeranalogalarmcondition..................................................................................................... 230
integeranalogchangetonullalarmcondition ................................................................................ 231
integeranalogchangevaluealarmcondition ................................................................................ 232
integeranalogdeviationalarmcondition ...................................................................................... 233
integeranalogequalsalarmcondition.......................................................................................... 234
integeranaloglimitalarmcondition .............................................................................................. 235
integeranalograteofchangealarmcondition ............................................................................... 236
integeranalogsignalalarmcondition ........................................................................................... 238
integeranalogsignaltrigger ........................................................................................................ 239
integerarchiveindex................................................................................................................... 240
ipline.......................................................................................................................................... 241
journalalarmcondition................................................................................................................ 243
journalcontrol ............................................................................................................................ 244
journalequalalarmcondition....................................................................................................... 246
journalrangealarmcondition ...................................................................................................... 247
journaltask................................................................................................................................. 248
klaxon........................................................................................................................................ 251
line ............................................................................................................................................ 254
localdigital ................................................................................................................................. 257
localintegeranalog..................................................................................................................... 259
localmultidigital2 ....................................................................................................................... 261
localmultidigital3 ....................................................................................................................... 263
localmultidigital4 ....................................................................................................................... 264
localrealanalog.......................................................................................................................... 265
localstringsignal ........................................................................................................................ 267
localtimesignal .......................................................................................................................... 269
lockouttimer............................................................................................................................... 271
logaccess.................................................................................................................................. 272
logarchive.................................................................................................................................. 275
logcolumn.................................................................................................................................. 278
logcontrol .................................................................................................................................. 281
logdata ...................................................................................................................................... 285
logextract .................................................................................................................................. 290
loghistory................................................................................................................................... 293
loghistory................................................................................................................................... 295
logobject.................................................................................................................................... 297
logworker .................................................................................................................................. 298
Reference Guide
D301521X412
24-Feb-2010 - Page 5
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
mailformat
................................................................................................................................. 300
memoryalarmcondition ............................................................................................................. 301
memorymonitor......................................................................................................................... 302
memorymonitorcallbacktimer.................................................................................................... 304
multidigital2............................................................................................................................... 305
multidigital3............................................................................................................................... 307
multidigital4............................................................................................................................... 308
multistatedigitalalarmcondition.................................................................................................. 309
notes ......................................................................................................................................... 310
notesalarmcondition.................................................................................................................. 315
nw3000alarmprioritymap .......................................................................................................... 316
nw3000analogpolllist ................................................................................................................ 317
nw3000archive.......................................................................................................................... 318
nw3000audit ............................................................................................................................. 320
nw3000device........................................................................................................................... 322
nw3000devicecommunicationalarmcondition ........................................................................... 342
nw3000devicestatusalarmcondition.......................................................................................... 343
nw3000deviceversionalarmcondition........................................................................................ 344
nw3000digital............................................................................................................................ 345
nw3000digitalalarmcondition .................................................................................................... 350
nw3000digitalpolllist.................................................................................................................. 351
nw3000driver ............................................................................................................................ 352
nw3000network......................................................................................................................... 363
nw3000polllist ........................................................................................................................... 364
nw3000questionablealarmcondition ......................................................................................... 368
nw3000realanalog .................................................................................................................... 369
nw3000realanalogalarmcondition............................................................................................. 379
nw3000rollingscantimer ............................................................................................................ 380
nw3000string ............................................................................................................................ 381
nw3000stringpolllist .................................................................................................................. 383
objectnotes................................................................................................................................ 384
objects....................................................................................................................................... 385
objectsextension ....................................................................................................................... 391
objectsuppressiongroup............................................................................................................ 392
oelogaccess.............................................................................................................................. 393
oelogarchive ............................................................................................................................. 394
oelogcolumn ............................................................................................................................. 395
oelogcontrol .............................................................................................................................. 397
oelogdata .................................................................................................................................. 398
oelogdataextension................................................................................................................... 402
oelogextract .............................................................................................................................. 404
oelogworker .............................................................................................................................. 405
oeprinter.................................................................................................................................... 406
oeprinteralarmcondition ............................................................................................................ 409
oeprintergroup .......................................................................................................................... 410
oeprintergroupalarmcondition................................................................................................... 413
Reference Guide
D301521X412
24-Feb-2010 - Page 6
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
oeprinterrelati
onship ................................................................................................................. 414
oeprinterrelationship ................................................................................................................. 416
oetimer ...................................................................................................................................... 418
opcdevice.................................................................................................................................. 419
opcdriver ................................................................................................................................... 420
opcgroup................................................................................................................................... 422
opcitemdigital............................................................................................................................ 425
opcitemintegeranalog ............................................................................................................... 427
opcitemrealanalog .................................................................................................................... 429
opcitemstring ............................................................................................................................ 431
opcserver .................................................................................................................................. 433
Pattern ...................................................................................................................................... 436
patterngroup ............................................................................................................................. 437
plantarea................................................................................................................................... 438
publishedreport ......................................................................................................................... 439
publishedreporttoaliaslookup.................................................................................................... 443
questionablealarmcondition ...................................................................................................... 444
questionableequalsalarmcondition ........................................................................................... 445
questionablerangealarmcondition............................................................................................. 446
realanalog ................................................................................................................................. 447
realanalogalarmcondition.......................................................................................................... 449
realanalogchangetonullalarmcondition ..................................................................................... 450
realanalogchangevaluealarmcondition ..................................................................................... 451
realanalogdeviationalarmcondition ........................................................................................... 452
realanalogequalsalarmcondition............................................................................................... 453
realanaloglimitalarmcondition ................................................................................................... 454
realanalograteofchangealarmcondition .................................................................................... 455
realanalogsignalalarmcondition ................................................................................................ 456
realanalogsignaltrigger ............................................................................................................. 457
realarchiveindex........................................................................................................................ 458
recipient .................................................................................................................................... 459
recipientassociations ................................................................................................................ 461
recipientgroup ........................................................................................................................... 462
recipientusernotes .................................................................................................................... 463
redundancy ............................................................................................................................... 474
redundancyalarmconditiona...................................................................................................... 478
redundancyalarmconditionb...................................................................................................... 479
remotedataservice .................................................................................................................... 480
remotedataservicealarmcondition............................................................................................. 482
remotedataservicetimer ............................................................................................................ 483
remotedigital ............................................................................................................................. 484
remoterealanalog...................................................................................................................... 485
report......................................................................................................................................... 486
reportalarmcondition ................................................................................................................. 491
reportcreation............................................................................................................................ 492
reportequalsalarmcondition ...................................................................................................... 495
Reference Guide
D301521X412
24-Feb-2010 - Page 7
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
reportformat
.............................................................................................................................. 496
reportformatalarmcondition....................................................................................................... 501
reportformatequalsalarmcondition ............................................................................................ 502
reportformatrangealarmcondition ............................................................................................. 503
reportformattorecipientlookup................................................................................................... 504
reportrangealarmcondition........................................................................................................ 506
reportrecipient........................................................................................................................... 507
reportrecipientalarmcondition ................................................................................................... 509
reportrecipientemail .................................................................................................................. 510
reportrecipientequalsalarmcondition......................................................................................... 511
reportrecipientfilecopy............................................................................................................... 512
reportrecipientftpcopy ............................................................................................................... 514
reportrecipientrangealarmcondition .......................................................................................... 516
reportschedule .......................................................................................................................... 517
reportschedulealarmcondition................................................................................................... 520
reportscheduleequalsalarmcondition........................................................................................ 521
reportscheduler......................................................................................................................... 522
reportschedulerangealarmcondition ......................................................................................... 525
reportscheduletimed ................................................................................................................. 526
reportschedulevaluechange...................................................................................................... 530
reporttemplate........................................................................................................................... 532
reporttoaliaslookup ................................................................................................................... 534
reporttoformatlookup................................................................................................................. 536
reporttoschedulelookup ............................................................................................................ 537
rocacinputoutputmodule ........................................................................................................... 538
rocadvancedpulsemodule......................................................................................................... 545
rocalarmcondition ..................................................................................................................... 561
rocalarmlog ............................................................................................................................... 562
rocbasedatum ........................................................................................................................... 567
rocblmuserlistparameters ......................................................................................................... 569
rocchannel ................................................................................................................................ 571
rocchannelalarmcondition......................................................................................................... 580
rocchannelset ........................................................................................................................... 581
rocchannelsetalarmcondition .................................................................................................... 583
rocchannelsetallocation ............................................................................................................ 584
rocchanneltypes........................................................................................................................ 586
rocchartuserlistparameters ....................................................................................................... 587
roccheckconfiguration............................................................................................................... 589
rocdatatypes ............................................................................................................................. 594
rocdevice................................................................................................................................... 596
rocdevicealarmcondition ........................................................................................................... 612
rocdevicechannelcomms .......................................................................................................... 613
rocdevicecommsroute............................................................................................................... 615
rocdeviceipcomms .................................................................................................................... 624
rocdigital.................................................................................................................................... 626
rocdriver .................................................................................................................................... 630
Reference Guide
D301521X412
24-Feb-2010 - Page 8
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
rocdriveralarmc
ondition ............................................................................................................ 637
rocds800configuration .............................................................................................................. 638
rocenhancedcommmoduleconfiguration................................................................................... 645
rocenumeratedvaluedescriptions.............................................................................................. 648
rocenumeratedvaluedescriptions2............................................................................................ 651
rocenumeratedvaluedescriptions3............................................................................................ 652
rocerrorcodelog......................................................................................................................... 653
roceventlog ............................................................................................................................... 655
rocexpandedioinformation ........................................................................................................ 661
rochartparameters .................................................................................................................... 664
rochistorylog ............................................................................................................................. 702
rochistorypoint .......................................................................................................................... 705
rochistorysegmentconfiguration................................................................................................ 711
rocinformationforuserdefinedpoints .......................................................................................... 714
rocinternetconfigurationparameters.......................................................................................... 715
rocjournaltypes ......................................................................................................................... 718
rocjournaltypes ......................................................................................................................... 720
roclicensekeyinformation .......................................................................................................... 722
roclinkparameterroctypeversion ............................................................................................... 725
roclogon .................................................................................................................................... 727
roclogonparameters.................................................................................................................. 728
rocmodbuseventalarmandhistory ............................................................................................. 735
rocmodbusmastermodemconfiguration .................................................................................... 755
rocmodbusmastertable ............................................................................................................. 758
rocmodbusregistertotlpmapping ............................................................................................... 781
rocnetwork ................................................................................................................................ 803
rocoedbfieldtypes...................................................................................................................... 804
rocorificemeterrunconfiguration ................................................................................................ 805
rocorificemeterrunvalues .......................................................................................................... 813
rocparameterpattern ................................................................................................................. 820
rocparameterpatternpoint ......................................................................................................... 821
rocparameters........................................................................................................................... 822
rocplusanaloginputs.................................................................................................................. 827
rocplusanalogoutputs................................................................................................................ 834
rocplusclock .............................................................................................................................. 837
rocpluscommports .................................................................................................................... 840
rocplusconfigurableopcode....................................................................................................... 850
rocplusdiscreteinputs ................................................................................................................ 876
rocplusdiscreteoutputs.............................................................................................................. 879
rocplusfstparameters ................................................................................................................ 884
rocplusfstregistertags................................................................................................................ 890
rocplushistorypoint.................................................................................................................... 892
rocplusmodbusconfigurationparameters .................................................................................. 895
rocplusmultivariablesensor ....................................................................................................... 901
rocpluspidcontrolparameters .................................................................................................... 912
rocpluspowercontrolparameters ............................................................................................... 925
Reference Guide
D301521X412
24-Feb-2010 - Page 9
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
rocpluspulsei
nputs .................................................................................................................... 929
rocplusrtd .................................................................................................................................. 934
rocplussoftpointparameters ...................................................................................................... 941
rocplussystemanaloginputs ...................................................................................................... 948
rocplussystemvariables ............................................................................................................ 952
rocplusthermocouple ................................................................................................................ 963
rocplususerdefineddatatypes.................................................................................................... 967
rocpoint ..................................................................................................................................... 968
rocpointalarmcondition.............................................................................................................. 973
rocpointtypes ............................................................................................................................ 974
rocpointwritetimeout.................................................................................................................. 977
rocportparameters .................................................................................................................... 978
rocprotocoltypes ....................................................................................................................... 983
rocreadalarmdata...................................................................................................................... 984
rocreadclock ............................................................................................................................. 989
rocreadconfigurableopcodedata ............................................................................................... 992
rocreadeventdata...................................................................................................................... 993
rocreadhistorydata .................................................................................................................... 998
rocreadhistorypointsconfig...................................................................................................... 1000
rocreadpointparameters.......................................................................................................... 1003
rocreadspecifiedparameters ................................................................................................... 1005
rocreadusertemplatedata........................................................................................................ 1006
rocrealanalog .......................................................................................................................... 1009
rocrequest............................................................................................................................... 1013
rocrequesttypes ...................................................................................................................... 1016
rocsamplerodorizorparameters............................................................................................... 1018
rocschedule ............................................................................................................................ 1021
rocschedulestatistics............................................................................................................... 1023
rocsecuritygroupconfiguration................................................................................................. 1026
rocsmartiomoduleinformation800 ........................................................................................... 1030
rocstandardagaflowcalculationvalues..................................................................................... 1033
rocstandardagaflowparameters .............................................................................................. 1044
rocstandardanaloginputcalibrationparameters ....................................................................... 1054
rocstandardanaloginputs ........................................................................................................ 1057
rocstandardanalogoutputs ...................................................................................................... 1063
rocstandardbatteryparameters ............................................................................................... 1065
rocstandardclock..................................................................................................................... 1068
rocstandardcommports ........................................................................................................... 1070
rocstandardconfigurableopcode ............................................................................................. 1077
rocstandarddiscreteinputs....................................................................................................... 1103
rocstandarddiscreteoutputs .................................................................................................... 1107
rocstandardextrarunparameters ............................................................................................. 1110
rocstandardflags ..................................................................................................................... 1115
rocstandardfstparameters....................................................................................................... 1122
rocstandardhistorypoint .......................................................................................................... 1127
rocstandardlocaldisplaypanel ................................................................................................. 1128
Reference Guide
D301521X412
24-Feb-2010 - Page 10
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
rocstandardlogonsecuritiesparameters
.................................................................................. 1131
rocstandardmetercalibrationandsampler ................................................................................ 1133
rocstandardmeterconfigurationparameters.............................................................................1136
rocstandardmeterflowvalues................................................................................................... 1153
rocstandardmodbusconfigurationparameters......................................................................... 1166
rocstandardmodbusfunctiontables..........................................................................................1170
rocstandardmodbusspecialfunctiontable ................................................................................ 1186
rocstandardmoduleinformation ............................................................................................... 1202
rocstandardmultivariablesensor.............................................................................................. 1207
rocstandardpidcontrolparameters ........................................................................................... 1215
rocstandardpidparameters...................................................................................................... 1224
rocstandardpowercontrolparameters...................................................................................... 1233
rocstandardpulseinputs........................................................................................................... 1236
rocstandardreadgeneralupdate .............................................................................................. 1240
rocstandardreadpointers......................................................................................................... 1241
rocstandardreadsysteminformation ........................................................................................ 1244
rocstandardrevisioninformation .............................................................................................. 1247
rocstandardrunparameters ..................................................................................................... 1248
rocstandardsoftpointparameters............................................................................................. 1267
rocstandardsystemvariables ................................................................................................... 1271
rocstandardtankparameters.................................................................................................... 1276
rocstandarduserdefineddatatypes ..........................................................................................1280
rocstandarduserlistparameters ............................................................................................... 1281
rocstationparameters .............................................................................................................. 1296
rocstationparameters .............................................................................................................. 1307
rocstring .................................................................................................................................. 1318
rocsystemparameters ............................................................................................................. 1320
rocsystemparametersaccessarea........................................................................................... 1321
rocsystemparametersalarmpriority ......................................................................................... 1322
rocsystemparametersbool ......................................................................................................1323
rocsystemparametersdriver .................................................................................................... 1324
rocsystemparametersinteger .................................................................................................. 1325
rocsystemparametersplantarea .............................................................................................. 1326
rocsystemparametersportparameters..................................................................................... 1327
rocsystemparametersschedule............................................................................................... 1328
rocsystemparametersstring .................................................................................................... 1329
roctime .................................................................................................................................... 1330
rocturbinemeterrunconfiguration............................................................................................. 1332
rocturbinemeterrunvalues....................................................................................................... 1342
roctypes .................................................................................................................................. 1349
rocusercconfiguration ............................................................................................................. 1351
rocuserdefinedpoint ................................................................................................................ 1354
rocuserprogramconfiguration.................................................................................................. 1355
rocversion ............................................................................................................................... 1357
rocwriteclock ........................................................................................................................... 1358
routine..................................................................................................................................... 1359
Reference Guide
D301521X412
24-Feb-2010 - Page 11
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
runsqlscript.............................................................................................................................. 1360
runsqlscripterroralarmcondition .............................................................................................. 1362
runtimeexception .................................................................................................................... 1363
scheduleevents....................................................................................................................... 1364
schedulepattern ...................................................................................................................... 1366
schemahelp ............................................................................................................................ 1368
securityreplication ................................................................................................................... 1370
selfusernotes .......................................................................................................................... 1372
senderusernotes ..................................................................................................................... 1383
signal....................................................................................................................................... 1394
signalattributetrigger ............................................................................................................... 1405
signalextension ....................................................................................................................... 1406
signalnotes.............................................................................................................................. 1407
signalsuppressiongroup.......................................................................................................... 1408
sqlprocedure ........................................................................................................................... 1409
stringsignal.............................................................................................................................. 1410
stringsignaltrigger ................................................................................................................... 1412
suppressiongroup ................................................................................................................... 1413
suppressiongroupdelaytimer................................................................................................... 1415
suppressiongrouplookup......................................................................................................... 1416
suspendedthread .................................................................................................................... 1418
table_privileges....................................................................................................................... 1420
tablegroups ............................................................................................................................. 1424
tables ...................................................................................................................................... 1425
tcpconnection.......................................................................................................................... 1427
tcpserver ................................................................................................................................. 1428
telephonenumber.................................................................................................................... 1429
time ......................................................................................................................................... 1431
timedarchive ........................................................................................................................... 1433
timer ........................................................................................................................................ 1437
timezones................................................................................................................................ 1439
tobescheduled ........................................................................................................................ 1440
token ....................................................................................................................................... 1443
tokenaccess ............................................................................................................................ 1445
tokengroup.............................................................................................................................. 1447
tokengroupaccess................................................................................................................... 1449
triggersqlprocedure................................................................................................................. 1451
triggersqlprocedureerroralarmcondition.................................................................................. 1454
triggersqlproceduretimer......................................................................................................... 1455
udpmsg ................................................................................................................................... 1456
udpport.................................................................................................................................... 1457
useraccess.............................................................................................................................. 1458
userconfig ............................................................................................................................... 1469
usergroups.............................................................................................................................. 1478
userlockout.............................................................................................................................. 1479
usernotes ................................................................................................................................ 1480
Reference Guide
D301521X412
24-Feb-2010 - Page 12
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
users ....................................................................................................................................... 1481
usersnameonly ....................................................................................................................... 1491
views ....................................................................................................................................... 1492
workstation.............................................................................................................................. 1493
3 Appendices ........................................................................................................................1496
Appendix B – Security Enabled Views ...................................................................................1496
Appendix A – Auto-IDPrimary Keys........................................................................................ 1497
4 Glossary .............................................................................................................................1498
5 Index ...................................................................................................................................1499
Reference Guide
D301521X412
24-Feb-2010 - Page 13
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
1 OpenEnterprise Schema
This document includes details of all of the tables that are shipped as part of the OpenEnterprise
product. Where a project might want to add its own tables (either derived or base) it is recommended
that a unique project identifier is included before the name of the table, e.g. xxxTable where xxx can
be uniquely identified with the project.
The OpenEnterprise database has both Relational and Object-Oriented features. This means that as
well as the more usual relationships between tables implemented by the use of foreign keys, there is
also an extra dimension of relationships made possible by the 'object-oriented' aspect of the
database. This uses table inheritance to enforce a relationship between tables. Table inheritance
means that some tables may be derived from other tables. Derived tables inherit the parent table's
attributes, and may add their own new attributes. This is the ideal solution for creating classes of
objects that bear an "IS A TYPE OF" relationship. An object added or deleted from the derived table is
automatically added or deleted from the parent table also, so there is no database programming
overhead required to guard the integrity of such tables.
A good example of the use of derived tables is seen in the dvi_datum derived tables. A datum is a
value obtained from a logging/controller device. The datum may represent a digital, integer, string or
realanalog signal value. It may also represent a signal from a Bristol or Allen-Bradley RTU/controller,
or even be a signal collected from an OPC Server. The object-oriented design of the OpenEnteprise
database enables us to depict all these complex relationships with ease.
In order to demonstrate this aspect of the OpenEnteprise database, the Contents tab on the left of the
Help window displays the tables as a tree, in a similar way to the Database Explorer. Parent tables
(i.e. those having tables derived from them) are shown as books. Tables which are not parents to
other tables are shown as pages. Base tables (those which are not derived from any other table) are
displayed on the extreme left of the tree, and the 'depth' of each table is indicated by how far it is from
the left of the tree. A base table may or may not be a parent for other tables.
Note that for the purpose of readability, some table or attribute descriptions on the actual topics may
capitalize and place spaces in table names. For instance the digitalalarmcondition_table may be
referred to as the Digital Alarm Condition table. Also note that the '_table' extension has been
removed from the table names for the same purpose.
Hint:
All signal tables are derived from the dvi_datum table, all alarmcondition tables are derived from the
alarmcondition table, the users table is derived from the objects table. Select the tables of interest
from the Contents tab pane, or select the Index tab to see the tables displayed in alphabetical order.
Reference Guide
D301521X412
24-Feb-2010 - Page 14
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
2 Tables
abcomplex
Derived From:
binarysignal
Description:
This table maintains information about complex signals specifically for
Allen Bradley devices.
A complex signal is used to handle Allen Bradley specific 'structured data
types e.g. Counters and Timers. The length of the data will vary depending
on the data type specified in the FileAddress. The ABComplex signal types
allows read and write access to AB structured data items.
Attributes:
fileaddress : char
The PLC data file address.
readquestionable : integer
This value indicates the last read value of the questionable status of the
readvalue from the device.
Reference Guide
D301521X412
24-Feb-2010 - Page 15
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
abdevice
Derived From:
dvi_device
Description:
The ABDevice table defines the Allen Bradley PLCs configured for data
collection and control by the OpenEnterprise database. A single ABDevice
object can describe a single standalone PLC or a redundant PLC pair.
The AB Configuration Tool will insert all the ABDevice entries, with the
information sourced from user input entered via the configuration tool. Like
ABNetwork entries, if it's possible to browse the configured RSLINX PLCs
then this should be considered as an option if it aids OE configuration.
Attributes:
accessarea : char
The access area to which this object belongs. Used with security
enabled views to restrict access for unauthorised users.
ahealthy : bool
Set to TRUE if the 'A' PLC is currently healthy. The 'A' PLC is identified
by the deviceaddress attribute.
Used for monitoring purposes only.
Reference Guide
D301521X412
24-Feb-2010 - Page 16
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
alarmcondition : array of AlarmCondition
This attribute is an array of Alarm Condition object. They are defined
within the ABDeviceHealthAlarmCondition table. Alarm conditions for
generating alarms based on the PLC health are automatically generated
when the device object is created.
alastconfigerror : integer
Set to the last configuration error value for the 'A' PLC.
Used for monitoring purposes only.
amainplc : bool
Set to TRUE if the A PLC is currently the Master. The A PLC is the PLC
specified by the devicename attribute.
Used for monitoring purposes only.
backupdeviceaddress : char
Identifies the back-up AB RSLINX Port ID and station number. Used for
redundant systems only. Same format as deviceaddress. This PLC is
also known as the B PLC.
Optional.
bhealthy : bool
Set to TRUE if the B PLC is currently healthy.
Used for monitoring purposes only.
Reference Guide
D301521X412
24-Feb-2010 - Page 17
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
blastconfigerror : integer
Set to the last configuration error value for the B PLC.
Used for monitoring purposes only.
bmainplc : bool
Set to TRUE if the B PLC is currently the Master. The B PLC is the PLC
specified by the BackupDeviceAddress attribute.
Used for monitoring purposes only.
defaultscheduleinterval : datetime
The default time interval for polling data from this device.
Optional.
description : char
An arbitrary string used to describe the PLC. The Description will be
automatically set if the user does not supply one.
Optional.
heartbeataddress : char
The address within the PLC used by the ABRDI to send heartbeats (e.g.
update with value 1) to act as a RDI to PLC heartbeat. The specified
PLC address must be a bit address e.g. B3:0/0 or N30:0/0.
Optional.
heartbeatrate : integer
Reference Guide
D301521X412
24-Feb-2010 - Page 18
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
The rate at which the ABRDI will update the Heartbeat value. Specified
in seconds.
Optional.
mainindicatoraddress : char
The address within the PLC used to indicate if the PLC is Master or
Standby. Only used for redundant systems.
Mandatory for a redundant PLC. The PLC file address must be a bit
address. e.g. N31:0/0
redundant : bool
Set to TRUE if this is a redundant PLC. Otherwise set to FALSE.
Mandatory for all PLCs.
redundantpair : bool
This is TRUE if the device is configured as a redundant pair.
Used for monitoring purposes only.
Reference Guide
D301521X412
24-Feb-2010 - Page 19
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
abdevicehealthalarmcondition
Derived From:
alarmcondition
Description:
This is the Alarm Condition associated with Allen Bradley devices. When
the ahealthy or bhealthy values of an Allen Bradley device change this
condition is checked to see whether an alarm should be generated,
updated or removed.
Attributes:
devicename : char references ABDevice
This is a reference to the device that is being monitored.
Reference Guide
D301521X412
24-Feb-2010 - Page 20
OpenEnterprise Schema
Remote Automation Solutions
Website: www.EmersonProcess.com/Remote
abdigital
Derived From:
digital
Description:
This table maintains information about digital signals specifically for Allen
Bradley devices.
Attributes:
fileaddress : char
The PLC data file address. The address must be a bit address e.g.
N101:0/0 or B1:0/0
readquestionable : integer
This value indicates the last read value of the questionable status of the
readvalue from the device.
/
