Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manuale Utente Pagina 31
- Pagina / 74
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
Collecting Batch Data Chapter 3
•
BHModeChange
• BHModeCommand
•
BHPromptResponse
•
RSDataPointSample
For instructions on removing the sample data, see Removing Sample
Data From an SQL Server Database (page 51).
The BHBatchHis table is used by the Batch Archiver as the primary
storage facility for batch event data. The columns in the FactoryTalk
Historian for Batch tables generally match the columns in the
BHBatchHis table for easy cross-reference.
Field Name Data Type Description Example
GMT
Date/Time
Time event is recorded in Greenwich Mean Time
2013-04-29 12:21:01.000
lclTime
Date/Time
Local time event is recorded
2013-04-29 14:52:07.000
UniqueID
Text
Unique identifier assigned by the Batch Server
31
BatchID
Text
Alpha Batch ID
BATCH_ID-030102-3
Recipe Text
The recipe element that was executing at the time
of the electronic batch record entry. The field
contents appear as:
<UniqueID>:[<Procedure>\][<Uni
t Procedure>:Instance\]
<Operation>:Instance-LoopCount
er
The data in the brackets is optional, depending on
the recipe level.
13:Y_300_YELLOW_PAINT
Descript
Text
Description of PValue data
Yellow Paint
Event Text Event type triggering the record
Material Tracking / Material Bound / Material
Unbound
PValue
Text
Value reported to the electronic batch record
50
DescriptAPI
Text
Description of PValue data
Engineering Units
EventAPI
Text
Event type triggering the record
Report
PValueAPI
Text
Value reported to the electronic batch record
50
EU
Text
Engineering units associated with Pvalue
GALLONS
Area Text
Area model name in batch equipment
configuration where batch was executed
THE_PAINT_COMPANY
ProcCell
Text
Process cell in Batch equipment configuration
YELLOWPAINT1
Unit
Text
Unit name in Batch equipment configuration
PREMIX_A
Phase
Text
Name of the phase generating the record
PROC_ORDER_N
BHBatchHis Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 31
- 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
Prodotti e manuali riguardandi Apparecchiature Rockwell-automation FactoryTalk Historian Classic for Batch User Guide
Apparecchiature Rockwell-automation 2711P ControlNet Communications for PanelView Plus Manuale Utente
(64 pagine)
(64 pagine)
Apparecchiature Rockwell-automation 5100 Background Suppression Control Type 42MBS Manuale Utente
(4 pagine)
(4 pagine)
Apparecchiature Rockwell-automation 2727-G7P20D1Q7 MobileView Guard G750 Quick Start Manuale Utente
(204 pagine)
(204 pagine)
Apparecchiature Rockwell-automation 2097-Vxxxx Kinetix 300 EtherNet/IP Indexing Servo Manuale Utente
(16 pagine)
(16 pagine)
Apparecchiature Rockwell-automation 7000 PowerFlex Medium Voltage Line Filter Capacito Manuale Utente
(10 pagine)
(10 pagine)
Apparecchiature Rockwell-automation 6185-K Economy Line Monitors User Manual Manuale Utente
(48 pagine)
(48 pagine)
Apparecchiature Rockwell-automation 7000 PowerFlex Medium Voltage AC Drive (B Frame) C Manuale Utente
(138 pagine)
(138 pagine)
Apparecchiature Rockwell-automation 1797-OE8H FLEX Ex 8 Output Analog Modules Manuale Utente
(52 pagine)
(52 pagine)
Apparecchiature Rockwell-automation 8510SA-TP Termination Panels Instructions Manuale Utente
(2 pagine)
(2 pagine)
Apparecchiature Rockwell-automation 6723-PCO DATA PROCESS CONFIG OPERATIO Manuale Utente
(36 pagine)
(36 pagine)
Apparecchiature Rockwell-automation 2707-NP2 MICROVIEW SOFTWARE PROGRAMMING MANUAL Manuale Utente
(134 pagine)
(134 pagine)
Apparecchiature Rockwell-automation 2706-LSW DL40 PLUS OFFLINE PROG.SFTWR.USER MANUAL Manuale Utente
(149 pagine)
(149 pagine)
© 2020, manymanuals.it. Tutti i diritti riservati | 0.080 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale