Tables and Stored Procedures
Most result sets are associated with a system stored procedure and a particular table in the Plant Applications database. When a result set is issued, the end result is a record added, updated, or deleted from its associated table.
The following table lists the result set and the associated stored procedure and table.
|
ID |
Result Set |
Database Table |
Stored Procedure |
|
1 |
Production Events |
Events |
spServer_DBMgrUpdEvent |
|
2 |
Variable Test |
Tests |
spServer_DBMgrUpdTest2 or spServer_DBMgrUpdTest (legacy) |
|
3 |
Product Change |
Production_Starts |
spServer_DBMgrUpdGrade2 or spServer_DBMgrUpdGrade (legacy) |
|
5 |
Downtime Event |
Timed_Event_Details |
spServer_DBMgrUpdTimedEvent |
|
7 |
Sheet Columns |
Sheet_Columns |
spServer_DBMgrUpdColumn2 or |
|
8 |
User Defined Events |
User_Defined_Events |
spServer_DBMgrUpdUserEvent |
|
9 |
Waste Events |
Waste_Event_Details |
spServer_DBMgrUpdWasteEvent |
|
10 |
Production Event Details |
Event_Details |
spServer_DBMgrUpdEventDet |
|
11 |
Production Event Component |
Event_Components |
spServer_DBMgrUpdEventComp |
|
12 |
Genealogy Input Events |
PrdExec_Input_Events |
spServer_DBMgrUpdPEInputEvent |
|
13 |
Defect Details |
Defect_Details |
spServer_DBMgrUpdDefectDetail |
|
14 |
Historian Write |
none |
None. Must use a result set. |
|
15 |
Production Plan |
Production_Plan |
spServer_DBMgrUpdProdPlan |
|
16 |
Production Setup |
Production_Setup |
spServer_DBMgrUpdProdSetup |
|
17 |
Production Plan Starts |
Production_Plan_Starts |
spServer_DBMgrUpdProdPlanStarts and |
|
18 |
PrdExec Path Unit Starts |
PrdExec_Path_Unit_Starts |
spServer_DBMgrUpdPrdExecPathUnitStarts and |
|
19 |
Production Stats |
Production_Plan |
spServer_DBMgrUpdProdStats |
|
20 |
Historian Read |
none |
None. Must use a result set. |
|
21 |
Non-Productive Time |
|
|
|
50 |
Output File Data Export |
none |
None. Must use a result set. |