Remote Automation Solutions OpenEnterprise Schema User guide

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.

Page is loading ...

Remote Automation Solutions OpenEnterprise Schema User guide

Remote Automation Solutions OpenEnterprise Schema User guide

Related papers

Other documents