cyber train powered by Visibility Software
Help & Support Center
Search:
Contents
:
IndexBookmarkPrint

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