CertSignOffAllowed(String,String,Int32,Nullable<Int32>,Nullable<Int32>,String,String,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The CertSignOffAllowed() method determines whether the user is allowed to sign off on a job/job_step or a data log.
This overload of the method uses the group ID to identify the data log group for the method.
'Declaration
Public Overloads Shared Sub CertSignOffAllowed( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Integer, _
ByVal stepNo As Nullable(Of Integer), _
ByVal grpId As Nullable(Of Integer), _
ByVal processId As String, _
ByVal certName As String, _
ByVal userId As String _
)
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim stepNo As Nullable(Of Integer)
Dim grpId As Nullable(Of Integer)
Dim processId As String
Dim certName As String
Dim userId As String
JobExec.CertSignOffAllowed(woId, operId, seqNo, stepNo, grpId, processId, certName, userId)
public static void CertSignOffAllowed(
string woId,
string operId,
int seqNo,
Nullable<int> stepNo,
Nullable<int> grpId,
string processId,
string certName,
string userId
)
Parameters
- 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 sequence number.
- stepNo
- Optional. Holds the job step number.
- grpId
- Optional. Holds the ID of the data log group.
- processId
- Optional. Holds the process ID.
- certName
- Required. Holds the certification name.
- userId
- Required. Holds the ID of the user who is signing off on this certification.
The purpose of this method is to verify a certification can be signed off by a user against the specified job/job_step or a data log group that is linked to a job.
If the supplied processId, operId and groupId are null, then this method does not verify any certification signoffs.
If a non-null value for grpId and a null value for stepNo are supplied, then the Middleware verifies the certification signoff against a data log group that is linked to the supplied job (data_log_grp_job_link). The certification signoff is verified against the data log group that are linked to a step (data_log_grp_job_step_link) if the supplied stepNo contains a non-null value.
If a null value for the grpId is supplied, but a non-null value for stepNo is supplied, then the certification sign-off is validated against a job. That is, for the method to succeed, the user must have a valid certification (cert_user_link) for the operation ID of the job and the process linking the job (cert_oper_link.
If a null value for grpID and stepNo are supplied, then the certification signoff is against a job step. That is, for the method to succeed, the user must have a valid certification (cert_user_link) for the operation ID of the job, step_no, and the process linking the job step (cert_oper_step_link.
On all the cases described above, only those certifications that require signoff/audit (cert_type.cert_audit is turned on) before the completion of a job/job step/data log are verified. Otherwise, the verification process is ignored.
Note that any error from below prevents the user to signoff on a certification. Otherwise, the user is allowed to sign off.
For the method to succeed, the following must be true:
- The supplied values for the following parameters are neither null nor empty: cert_name.
- The supplied user has a valid certification.
- The user’s certification level is greater or equal to the required certification level.
- The user’s certification has not is expired.
- The supplied data log group/step is attached to the supplied certification.