MES Stateless API

GetOeeExecEnts Method

Save PDF

GetOeeExecEnts Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetOeeExecEnts() method retrieves records from Oee_Exec table of the OEE exec entities that the user has logged on to.

Syntax

'Declaration
 
Public Shared Function GetOeeExecEnts( _
   ByVal sessionId As Integer, _
   ByVal userId As String, _
   ByVal startTime As Date _
) As DataSet

'Usage
 
Dim sessionId As Integer
Dim userId As String
Dim startTime As Date
Dim value As DataSet
 
value = Session.GetOeeExecEnts(sessionId, userId, startTime)

public static DataSet GetOeeExecEnts( 
   int sessionId,
   string userId,
   DateTime startTime
)

Parameters

sessionId: Optional. Holds the session ID and thus the user who is making this method call.
userId: Required. Holds the ID of the user who has logged on to the session.
startTime: Required. Holds the date/time that indicates the session start time.

Return Value

Returns a DataSet that contains all the records in the Oee_Exec table of the OEE exec entities that the specified user has logged onto. If a non-null value for the startTime parameter is supplied, then the DataSet is limited to the OEE exec entities that the user has logged onto after the supplied start time. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
ent_id	An integer that is the ID of the entity that can track OEE, from the ent.ent_id column
ent_name	A string that is the name of the entity, from the ent.ent_name column linked to this ent_id.
job_ent_id	An integer that is the ID of the entity from which to get production data.
job_ent_name	A string that is the name of the entity, from the ent.ent_name linked to this job_ent_id column.
util_ent_id	An integer that is the ID of the entity from which to get utilization data.
util_ent_name	A string that is the name of the entity, from ent.ent_name linked to this util_ent_id column.
target_perf	A double that is the target performance.
current_perf	A double that is the current performance.
target_qual	A double that is the target quality.
current_qual	A double that is the actual current quality.
def_prod_rate	A double that is the default production rate or time, so OEE can be calculated if the item is unknown, as in a straight monitoring application.
prod_uom	An enumeration that identifies the unit of measurement.
target_oee	A double that is the target OEE.
current_oee	A double that is the actual current OEE.
basis	An integer that indicates whether the OEE is reported for a shift (0) or it is reported for a job (1).
last_edit_comment	A string that contains comments about why the record was changed.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A date/time that indicates when the record was added or last updated.

MES Stateless API