CertSignOff(Int32,String,String,Int32,String,Nullable<Int32>,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<ProcessStatus>,Nullable<Boolean>,String,String,Nullable<DateTime>,String,Nullable<Int64>,Int32) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The CertSignOff() method signs a user off a job or a job step that requires a certification signoff.
This overload of the method uses the group ID or description to identify the data log group for the method and references the datalog row ID with a long integer.
'Declaration
Public Overloads Shared Sub CertSignOff( _
ByVal sessionId As Integer, _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Integer, _
ByVal certName As String, _
ByVal stepNo As Nullable(Of Integer), _
ByVal lotNo As String, _
ByVal subLotNo As String, _
ByVal prodLogId As Nullable(Of Integer), _
ByVal consLogId As Nullable(Of Integer), _
ByVal grpId As Nullable(Of Integer), _
ByVal grpDesc As String, _
ByVal processId As String, _
ByVal processStatus As Nullable(Of ProcessStatus), _
ByVal active As Nullable(Of Boolean), _
ByVal userId As String, _
ByVal userPw As String, _
ByVal signOff As Nullable(Of Date), _
ByVal comments As String, _
ByVal refRowId As Nullable(Of Long), _
ByRef rowId As Integer _
)
'Usage
Dim sessionId As Integer
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim certName As String
Dim stepNo As Nullable(Of Integer)
Dim lotNo As String
Dim subLotNo As String
Dim prodLogId As Nullable(Of Integer)
Dim consLogId As Nullable(Of Integer)
Dim grpId As Nullable(Of Integer)
Dim grpDesc As String
Dim processId As String
Dim processStatus As Nullable(Of ProcessStatus)
Dim active As Nullable(Of Boolean)
Dim userId As String
Dim userPw As String
Dim signOff As Nullable(Of Date)
Dim comments As String
Dim refRowId As Nullable(Of Long)
Dim rowId As Integer
JobExec.CertSignOff(sessionId, woId, operId, seqNo, certName, stepNo, lotNo, subLotNo, prodLogId, consLogId, grpId, grpDesc, processId, processStatus, active, userId, userPw, signOff, comments, refRowId, rowId)
public static void CertSignOff(
int sessionId,
string woId,
string operId,
int seqNo,
string certName,
Nullable<int> stepNo,
string lotNo,
string subLotNo,
Nullable<int> prodLogId,
Nullable<int> consLogId,
Nullable<int> grpId,
string grpDesc,
string processId,
Nullable<ProcessStatus> processStatus,
Nullable<bool> active,
string userId,
string userPw,
Nullable<DateTime> signOff,
string comments,
Nullable<long> refRowId,
out int rowId
)
Parameters
- sessionId
- Optional. Holds the session ID and thus the user who is making this method call.
- woId
- Required. Holds the ID of the work order of the job.
- operId
- Required. Holds the ID of the operation of the job.
- seqNo
- Required. Holds the job's sequence number.
- certName
- Required. Holds the certification name.
- stepNo
- Optional. Holds the job step number.
- lotNo
- Optional. Holds the lot number.
- subLotNo
- Optional. Holds the sublot number.
- prodLogId
- Optional. Holds the row ID from the Item_Prod table.
- consLogId
- Optional. Holds the row ID from the Item_Cons table.
- grpId
- Optional. Holds the ID of the data log group.
- grpDesc
- Optional. Holds the description of the data log group. The group desciption is only used if the grpId is NULL.
- processId
- Optional. Holds the process ID.
- processStatus
- Optional. Holds an enumeration to specify the process status.
- active
- Optional. Holds a flag that specifies whether or not this record relevant to a pending change. The default is true.
- userId
- Required. Holds the ID of the user who is signing off on this certification.
- userPw
- Required. Holds the password of the user who is signing off on this certification.
- signOff
- Optional. Holds the date/time of this signoff.
- comments
- Optional. Holds additional comments describing the signoff.
- refRowId
- Optional. Holds the reference row ID of the relevant job_step_data record. For signoffs related to a data log sample, the row_id of the relevant data_log record.
- rowId
- Output. Holds the returned unique row_id from the Cert_Audit_Log table for this certification signed off.
This method first verifies whether this job/job_step or a data log has a certification that needs to be signed off. The supplied process_id (if not null; otherwise defaults to the process _id from the WO table), oper_id, and the step are used to verify whether a signoff is allowed for this certification. Refer to the CertSignOffAllowed method for more details.
If the supplied lot number is null, then this method defaults to the lot number from the job_exec entity that is running the supplied job, if and only if the supplied job is currently running. Otherwise the supplied lot number is used during the signoff process. A new row in the Cert_Audit_Log table is created to identify the signoff for a user against this job/job_step/data_log_n row.
Note that this method assumes the supplied user was authenticated just before calling this method.
If the system attribute “Log certification sign offs as job events” attr_id:231 is turned on, then the supplied entity and the job position is extracted from the supplied job, if the supplied job is running. Finally, a new job event is created for the supplied data if a job event record identifying the supplied data does not exist in the database; otherwise, the existing job event data is updated with the supplied values.
For the method to succeed, the following must be true:
- The supplied values for the following parameters are neither null nor empty: wo_id, oper_id, cert_name.
- The supplied work order (wo_id) exists in the database when attempting to retrieve the process_id, only when the supplied process id is null.
- The supplied user has not already signed off on the supplied data.