cert_type
- Last UpdatedJan 21, 2025
- 3 minute read
The cert_type table lists what certification types are defined, how many levels exist for each, how long each lasts, and whether it is an audit-type certification, requiring sign-off.
The other Certification option tables allow these certification types to be linked as requirements to an item, an operation or an operation step.
Many Start and Audit certifications may be defined and linked to items, operations and steps.
The signoff_notes field is used to allow an optional string that is presented to the user when signing off this certification. It is usually used to articulate to the user exactly what they are signing off on. The num_signoffs_reqd field specifies the number of different users that must sign off on an audit-type certification.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
cert_name |
string40 |
Y |
N |
Unique name for certification |
|
max_level |
int32 |
N |
N |
How many levels of "capability", minimum 1 if yes/no |
|
duration |
int32 |
N |
N |
Certification lifetime in days; 0 if it is permanent. Used to set the expiry for new entries in cert_user_link using this cert. (Default = 0) |
|
cert_audit |
logical |
N |
N |
If Yes, certification not required to run, but sign-off required before completion. Default = No. |
|
signoff_notes |
string254 |
N |
Y |
Text to define to the user exactly what they are signing off on. Applies to auditable certifications only. Note: This field is currently not used. |
|
num_signoffs_reqd |
int32 |
N |
Y |
Default = null for certs with audit = No, or 1 where audit = Yes |
|
comments_reqd |
logical |
N |
N |
Are user-entered comments mandatory when signing off on this certification? Default = No. |
|
reqd_exp_to_renew |
int32 |
N |
N |
Number of hours of work required to retain a certification. Default = 0. Note: This field is currently not used. |
|
avail_to_oper |
logical |
N |
N |
Is this certification applicable to operations? Default = No. |
|
avail_to_oper_step |
logical |
N |
N |
Is this certification applicable to operation steps? Default = No. |
|
avail_to_prod_item |
logical |
N |
N |
Is this certification applicable to items to be produced? Default = No. |
|
avail_to_cons_item |
logical |
N |
N |
Is this certification applicable to items to be consumed? Default = No. |
|
avail_to_attr |
logical |
N |
N |
Is this certification applicable to changing attributes? Default = No. |
|
avail_to_grade_chg |
logical |
N |
N |
Is this certification applicable to changing item grades? Default = No. |
|
avail_to_state_chg |
logical |
N |
N |
Is this certification applicable to changing item states? Default = No. |
|
avail_to_log_data |
logical |
N |
N |
Is this certification applicable to confirming data log data? Default = No. |
|
up_to_experimental |
logical |
N |
N |
Is this certification needed to increase the status of a process to experimental? Default = No. Note: This field is currently not used. |
|
up_to_ approved |
logical |
N |
N |
Is this certification needed to increase the status of a process to approved? (Default = 0) Note: This field is currently not used. |
|
up_to_certified |
logical |
N |
N |
Is this certification needed to increase the status of a process to certified? (Default = 0) Note: This field is currently not used. |
|
down_to_disabled |
logical |
N |
N |
Is this certification needed to decrease the status of a process to experimental? (Default = 0) Note: This field is currently not used. |
|
down_to_experimental |
logical |
N |
N |
Is this certification needed to decrease the status of a process to approved? Default = No. Note: This field is currently not used. |
|
down_to_approved |
logical |
N |
N |
Is this certification needed to decrease the status of a process to certified? Default = No. Note: This field is currently not used. |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 1917 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 1918 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 1919 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 1920 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail |