GetAvailableCertifications Method
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAvailableCertifications() method retrieves all the certifications that are marked as available to log data.
'Declaration
Public Shared Function GetAvailableCertifications() As DataSet
'Usage
Dim value As DataSet
value = DataLogGrp.GetAvailableCertifications()
public static DataSet GetAvailableCertifications()
Return Value
Returns a DataSet that contains all the records in the Cert_Type table that are available to log data. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
cert_name |
A string that is the name of the certification. |
|
max_level |
An integer that is the maximum level of the certification. |
|
duration |
An integer that is the number of days the certification is valid (0 = permanent). |
|
cert_audit |
A flag which indicates whether or not this is an audit certification. |
|
signoff_notes |
A string that is the notes that explain what the user is signing off on (only applies to audit certifications). |
|
num_signoffs_reqd |
An integer that indicates the number of signoffs required (only applies to audit certifications). |
|
reqd_exp_to_renew |
An integer that is the number of hours of work required to retain the certification. |
|
comments_reqd |
A flag that indicates whether or not comments are required when signing off (only applies to audit certifications). |
|
avail_to_oper |
A flag that indicates whether or not the certification is applicable to operations. |
|
avail_to_oper_step |
A flag that indicates whether or not the certification is applicable to operation steps. |
|
avail_to_prod_item |
A flag that indicates whether or not the certification is applicable to produced items. |
|
avail_to_cons_item |
A flag that indicates whether or not the certification is applicable to consumed items. |
|
avail_to_attr |
A flag that indicates whether or not the certification is applicable to attributes. |
|
avail_to_grade_chg |
A flag that indicates whether or not the certification is applicable to item grade changes. |
|
avail_to_state_chg |
A flag that indicates whether or not the certification is applicable to item state changes. |
|
avail_to_log_data |
A flag that indicates whether or not the certification is applicable to logging data. |
|
up_to_experimental |
A flag that indicates whether or not the certification is needed to increase the status of a process to experimental. |
|
up_to_approved |
A flag that indicates whether or not the certification is needed to increase the status of a process to approved. |
|
up_to_certified |
A flag that indicates whether or not the certification is needed to increase the status of a process to certified. |
|
down_to_disabled |
A flag that indicates whether or not the certification is needed to decrease the status of a process to disabled. |
|
down_to_experimental |
A flag that indicates whether or not the certification is needed to decrease the status of a process to experimental. |
|
down_to_approved |
A flag that indicates whether or not the certification is needed to decrease the status of a process to approved. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |
|
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 datetime that indicates when the record was added or last updated. |