Home > Reporting > Building Reports > Data Sources List > View_Credential
View_Credential
This view is a combination of two tables: Certifications and Code Tables. This view pulls together fields to help with reporting on credential information (Admin > Curriculum > Credentials.)
NOTE: The reason it is referenced as View_Certification and not View_Credential is because the original table and view created as Certification. Thus, any logic, reports, etc... that is using View_Certification would be impacted and stopped working if name was changed. In an effort to not have everyone rewriting reports, Visibility Software decided to keep the name.
To see more about the specific fields in these tables there is a Data Dictionary in Cyber Train - Reports > Data Dictionary.
Field Name This is the Field as seen in the Report Writer Tool for this view
Screen / Field / Note This is to give context and reference to where this field is seen in the product.
Field Name in Database This is what the field is actually called in the table. It important for situations where the name changes on the screen but not in the database.
Field Name |
Screen / Field / Note |
Field Name in Database |
Certification Table |
CertCode |
Admin > Curriculum > Credentials
|
CertCode |
CertName
|
Admin > Curriculum > Credentials |
CertName |
CertDesc |
Admin > Curriculum > Credentials |
CertDesc |
IssuedBy
|
Admin > Curriculum > Credentials |
IssuedBy |
RenewalFreq
|
Admin > Curriculum > Credentials |
RenewalFreq |
BasedOn |
Admin > Curriculum > Credentials |
BasedOn |
RenewalCost |
Admin > Curriculum > Credentials |
RenewalCost |
Exams |
Admin > Curriculum > Credentials |
Exams |
ExpirationWarning |
Admin > Curriculum > Credentials |
ExpirationWarning |
CredType |
Admin > Curriculum > Credentials |
CredType |
Code Table |
_CredType |
Admin > Curriculum > Credentials
NOTE: The underscore in front of the field name indicates this option is the data label and not code. Use 'CredType' to pull the code and '_CredType' to pull the data label. To get this data label option, this view is connected to the Code Tables.
|
_CredType |
|