Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manuel d'utilisateur Page 41
- Page / 74
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Collecting Batch Data Chapter 3
The BHBinding table contains data pertaining to the binding of the
recipe to a given unit. This table allows you to reproduce how the
recipe was bound to equipment. The userid/machineid columns
contain data only when an operator responds with binding
information. The BHBinding Table provides storage of essential
binding data and allows that data to be linked to a given batch
and/or unit. Each binding record is linked to only one batch.
Column Datatype Description Example
eventtime datetime Time stamp 2002-03-01 12:21:01.000
uniqueid text Unique ID 31
mainevent text Primary event Creation Bind / Bind / UnBind
subevent
text
Secondary event
Prompt Bind / First Available Bind
unitalias
text
Alias of the unit
Alias_REACTOR_1
unitname
text
Unit name
PREMIX_NORTH
area
text
Area
THE_PAINT_COMPANY
userid
text
User ID
mjames1
machineid
text
Machine ID
DEV-MJAMES-01
The BHOperation table contains data pertaining to the execution of
each operation during the batch. This table provides storage of
essential operation data and allows that data to be linked to a given
batch and/or unit (procedure). Each operation record is linked to
only one batch and/or unit (procedure).
Column Datatype Description Example
uniqueid text Unique ID 31
unit procedure text Unit procedure REACTOR_1:1
unitname
text
Unit name
REACTOR_1
operation
text
Operation
MAKE_PAINT:1
recipe
text
Recipe
31:DEMO_RECIPE\REACTOR_1:1\MAKE_PAINT:1-1
starttime
date/time
Operation start time
2002-03-01 12:21:06.000
area
text
Area
THE_PAINT_COMPANY
endtime
date/time
Time operation finished
2002-03-01 12:24:37.000
BHBinding (Unit Binding)
Table
BHOperation Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 41
- Table of Contents 3
- Chapter 4 4
- Analyzing Reports 4
- Chapter 1 7
- Types Of Users 8
- Where Can I Go for Help? 8
- Chapter 2 11
- Initializing the RSBizWare 12
- Database On Oracle 9i 12
- Database On SQL Server 15
- Migrating Batch History Data 17
- From an Oracle 8i 17
- Database 17
- To Oracle 9i 17
- From SQL Server 18
- Updating the Database GMT 21
- Offset Value 21
- Instructions for Daylight 21
- Savings Time (SQL Server 21
- Manually Updating the GMT 22
- Creating a Data Source For 22
- FactoryTalk Historian for 22
- Updating the Database 23
- Connection String 23
- Verifying the Database 23
- Batch Archiver Event Filters 23
- Recommendations for 25
- Optimum Data Access 25
- Event Filter 27
- Recommendations For 27
- Multiple Batch Server 27
- Environments 27
- Collecting Batch Data 29
- Batch Tables and Fields 30
- Sample Data 30
- BHBatchHis Table 31
- How To Display All 33
- Instruction HTML Data From 33
- Output.html 34
- BHBatch Table 35
- BHUnitProcedure Table 36
- BHUnit Table 36
- BHPhase Table 37
- BHParameter Table 38
- BHParameterChange Table 38
- BHPrompt Table 39
- BHPromptResponse Table 39
- BHModeCommand Table 40
- BHModeChange Table 40
- BHBinding (Unit Binding) 41
- BHOperation Table 41
- BHFailure and BHFailureClear 42
- BHStateCommand Table 42
- BHStateChange Table 43
- BHComment Table 43
- BHControlSteps Table 44
- BHMaterialEvent Table 45
- BHDeviationEvents Table 45
- BHTemporary Tables 47
- Manually Clear BHTemporary 47
- SELECT * FROM BHTempBatch 48
- DELETE FROM BHTempBatch 48
- SELECT * FROM BHTempBatchEnd 48
- DELETE FROM BHTempBatchEnd 48
- Modifying Batch Reports 50
- Removing Sample Data from 50
- Batch Analysis Chart Object 52
- (SQL Server Only) 52
- Adding the Batch Analysis 53
- Chart Object 53
- Batch Summary Report 54
- Selecting Data To Display On 55
- Objects 55
- Batch Compare Report 56
- Selecting Data to Display on 56
- Batch Equipment Utilization 57
- Utilization Report 58
- Analyzing Reports Chapter 4 59
- Report Objects 60
- Batch Event History Report 60
- Batch BHBatchHis 62
- Material Genealogy By Batch 63
- Material Genealogy By 63
- Material Report 63
- Material Report Objects 65
- Operator Action Report 65
- Batch Analysis Report (SQL 66
- Server Only) 66
- Deviation Events Report 67
- Chapter 4 Analyzing Reports 70
- Where Can I Go for Help? 8 73
- Rockwell Automation Support 74
Produits connexes et manuels pour Équipement Rockwell-automation FactoryTalk Historian Classic for Batch User Guide
Équipement Rockwell-automation 5100 Background Suppression Control Type 42MBS Manuel d'utilisateur
(4 pages)
(4 pages)
Équipement Rockwell-automation 2727-G7P20D1Q7 MobileView Guard G750 Quick Start Manuel d'utilisateur
(204 pages)
(204 pages)
Équipement Rockwell-automation 6185-K Economy Line Monitors User Manual Manuel d'utilisateur
(48 pages)
(48 pages)
Équipement Rockwell-automation 7000 PowerFlex Medium Voltage AC Drive (B Frame) C Manuel d'utilisateur
(138 pages)
(138 pages)
Équipement Rockwell-automation 1797-OE8H FLEX Ex 8 Output Analog Modules Manuel d'utilisateur
(52 pages)
(52 pages)
Équipement Rockwell-automation 8510SA-TP Termination Panels Instructions Manuel d'utilisateur
(2 pages)
(2 pages)
Équipement Rockwell-automation 6723-PCO DATA PROCESS CONFIG OPERATIO Manuel d'utilisateur
(36 pages)
(36 pages)
Équipement Rockwell-automation 2707-NP2 MICROVIEW SOFTWARE PROGRAMMING MANUAL Manuel d'utilisateur
(134 pages)
(134 pages)
Équipement Rockwell-automation 2706-LSW DL40 PLUS OFFLINE PROG.SFTWR.USER MANUAL Manuel d'utilisateur
(149 pages)
(149 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.086 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels