CertSignOffsCompleted Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function CertSignOffsCompleted( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Integer, _
ByVal stepNo As Nullable(Of Integer), _
ByVal certName As String, _
ByVal lotNo As String, _
ByVal subLotNo As String, _
ByVal prodLogId As Nullable(Of Integer), _
ByVal consLogId As Nullable(Of Integer), _
ByVal processId As String, _
ByVal processStatus As Nullable(Of Integer), _
ByVal active As Nullable(Of Boolean) _
) As Boolean
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim stepNo As Nullable(Of Integer)
Dim certName As String
Dim lotNo As String
Dim subLotNo As String
Dim prodLogId As Nullable(Of Integer)
Dim consLogId As Nullable(Of Integer)
Dim processId As String
Dim processStatus As Nullable(Of Integer)
Dim active As Nullable(Of Boolean)
Dim value As Boolean
value = JobExec.CertSignOffsCompleted(woId, operId, seqNo, stepNo, certName, lotNo, subLotNo, prodLogId, consLogId, processId, processStatus, active)
public static bool CertSignOffsCompleted(
string woId,
string operId,
int seqNo,
Nullable<int> stepNo,
string certName,
string lotNo,
string subLotNo,
Nullable<int> prodLogId,
Nullable<int> consLogId,
string processId,
Nullable<int> processStatus,
Nullable<bool> active
)
Parameters
- woId
- Required. Holds the work order ID of the job.
- operId
Required. Holds the operation ID of the job.
- seqNo
- Required. Holds the job sequence number.
- stepNo
- Optional. Holds the job step number.
- certName
- Required. Holds the certification name.
- 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.
- processId
- Optional. Holds the process ID.
- processStatus
- Optional. Holds an enumeration that specifies the process status.
- active
- Optional. Holds a flag that specifies whether or not this record relevant to a pending change. Default is true.
Return Value
There might be any number of signoff certifications defined at each of the operation and step levels, including none. If a non-null value for the stepNo parameter is supplied, then it is considered that the signoff is against a step; otherwise, the sign off is considered for a job.
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.
Then, this method queries the Cert_Type table to determine the number of signoffs required for this certification. If the configured value is null, then it defaults to 1. That is, a minimum of one signoff is required.
Finally, it queries the Cert_Audit_Log table using the supplied parameters to count the number of signoffs for this certification. The method returns true if the signed-off count is greater or equal to the required number of signoffs; otherwise, the method returns false.
For this method to succeed, if the supplied step number is not null, then the supplied lot number must not be null.