Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manual de usuario Pagina 44
- Pagina / 74
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 3 Collecting Batch Data
be important when reconstructing the batch. A comment record is
linked to only one batch record.
Column Datatype Description Example
uniqueid text Unique ID 13
area
text
Area
THE_PAINT_COMPANY
usercomment text
Comment entered by the
user
Buck fell into the paint
machineid text
Machine ID where comment
was entered
DEV-MJAMES-01
userid
text
User's ID
mjames1
eventtime
date/time
Time stamp
2002-03-01 12:21:01.000
The BHControlSteps table contains a record for every control step
start and stop event in a batch. This table provides storage of
essential control step data and allows that data to be linked to a
given batch. A BHControlSteps record is linked to only one batch
record.
Column Datatype Description Example
uniqueid
text
Unique ID
13
area
text
Area
THE_PAINT_COMPANY
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PROC
_ORDER:1\PROC_ORDER_CLS:1-1
event
text
Event
BHControlStep START / BHControlStep STOP
stepindex
text
Step index
1
userid
text
User's ID
mjames1
eventtime
date/time
Time stamp
2002-03-01 12:21:01.000
reactivation number integer
Number of times an active
eProcedure control step has
been reactivated.
1
BHControlSteps Table
44 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014
- 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
Relacionado con productos y manuales para Equipo Rockwell-automation FactoryTalk Historian Classic for Batch User Guide
Equipo Rockwell-automation 2711P ControlNet Communications for PanelView Plus Manual de usuario
(64 paginas)
(64 paginas)
Equipo Rockwell-automation 5100 Background Suppression Control Type 42MBS Manual de usuario
(4 paginas)
(4 paginas)
Equipo Rockwell-automation 2727-G7P20D1Q7 MobileView Guard G750 Quick Start Manual de usuario
(204 paginas)
(204 paginas)
Equipo Rockwell-automation 2097-Vxxxx Kinetix 300 EtherNet/IP Indexing Servo Manual de usuario
(16 paginas)
(16 paginas)
Equipo Rockwell-automation 7000 PowerFlex Medium Voltage Line Filter Capacito Manual de usuario
(10 paginas)
(10 paginas)
Equipo Rockwell-automation 2198-CAPMOD-1300 Kinetix 5500 Capacitor Module Ins Manual de usuario
(8 paginas)
(8 paginas)
Equipo Rockwell-automation 7000 PowerFlex Medium Voltage AC Drive (B Frame) C Manual de usuario
(138 paginas)
(138 paginas)
Equipo Rockwell-automation 9303 Drive Tools SP / Drive Executive Installation Manual de usuario
(4 paginas)
(4 paginas)
Equipo Rockwell-automation 2707-NP2 MICROVIEW SOFTWARE PROGRAMMING MANUAL Manual de usuario
(134 paginas)
(134 paginas)
Equipo Rockwell-automation MV SMC Flex OEM Components - Fiber Optic Multiplex Manual de usuario
(2 paginas)
(2 paginas)
Equipo Rockwell-automation 2706-LSW DL40 PLUS OFFLINE PROG.SFTWR.USER MANUAL Manual de usuario
(149 paginas)
(149 paginas)
Equipo Rockwell-automation 2100 Receiving, Handling, and Storing MCCs Manual de usuario
(12 paginas)
(12 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.179 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales