GetReqdCertSignOffs Method
- Last UpdatedNov 06, 2025
- 2 minute read
'Declaration
Public Shared Function GetReqdCertSignOffs( _
ByVal woId As String, _
ByVal operId As String, _
ByVal stepNo As Nullable(Of Integer) _
) As DataSet
'Usage
Dim woId As String
Dim operId As String
Dim stepNo As Nullable(Of Integer)
Dim value As DataSet
value = JobExec.GetReqdCertSignOffs(woId, operId, stepNo)
Parameters
- woId
- Required. Holds the work order ID of the job.
- operId
- Required. Holds the operation ID of the job.
- stepNo
- Optional. Holds a job step number. Required if the certification to be signed off is for a step. If not specified, only certifications required for the operation are returned. If specified, then only certifications required for this step are returned, and no operation specific certifications are returned.
Return Value
Returns a DataSet that contains records for all the signoff certifications that satisfy the specified filters. If no matching signoff certifications are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
process_id |
A string that is the process ID, from the cert_oper_link.process_id column. |
|
oper_id |
A string that is the operation ID, from the cert_oper_link.oper_id column. |
|
cert_name |
A string that is the unique name for certification, from the cert_type.cert_name column. |
|
step_no |
An integer that is the step number, from the cert_oper_step_link.step_no column. |
|
num_signoffs_reqd |
An integer that is the number of signoffs required if audit-type, from the cert_type. num_signoffs_reqd column. |
|
signoff_notes |
A string that is the text that defines to the user exactly what he is signing off on, from the cert_type.signoff_notes column. |
|
comments_reqd |
A Boolean that is a flag that specifies whether a comment is required, from the cert_type. comments_reqd column. |
|
avail_to_oper |
A Boolean that is a flag that specifies whether user-entered comments are mandatory when signing off on this certification, from the cert_type. avail_to_oper column. |
|
avail_to_oper_step |
A Boolean that is a flag that specifies whether this certification is applicable to operation steps, from the cert_type.avail_to_oper_step column. |
The method first retrieves the process ID for the supplied work order. If the supplied step number is null, then this method returns all sign-off certifications that are associated with the process ID and the supplied operation ID. If the process ID of supplied work order is null, an empty DataSet is returned.
If the supplied step number is -1, then the DataSet will contain all sign-off (cert_audit =1) certifications of the all the steps that are associated in the supplied work order ID and operation ID.
If the supplied step number is not null and not equal -1, then the DataSet will contain all the certifications for the process ID of the supplied work order, operation, and step number. If the process ID of the supplied work order is null, an empty DataSet is returned.