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

Home > Reporting > Building Reports > Data Sources List > View_StudentRequirementsCoursesTaken

View_StudentRequirementsCoursesTaken

This view is a combination of several tables: Companies, Student, Course, Courses Needed and Courses Taken.  This view pulls together fields to help with reporting on student information as it relates to requirements and courses taken.

 

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 
Companies Table
Company ID Admin > Codes > Companies 
 CompanyCode
Company Name
Admin > Codes > Companies   Company Name
Student Table
Student ID In the URL at the top of the page when in the Student File
 StudentID
Employee Number
Student File > Contact Info Page > Job Details Tab
 Empno
Cyber Train Login Field
Student File > Contact Info Page > Personal Info Tab
 Login
Employee Type Student File > Contact Info Page > Job Details Tab
 EmpType
Student First Name Student File > Contact Info Page > Contact Details Tab
 First Name
Student Last Name Student File > Contact Info Page > Contact Details Tab
 Last Name
Student Full Name Student File > Contact Info Page > Contact Details Tab
 First Name + Last Name
Student Email Work Student File > Contact Info Page > Contact Details Tab
 WorkEmail
Student Email Home Student File > Contact Info Page > Contact Details Tab  Email
Student Code Misc Field 1-20 Student File > Student Misc Page > Misc 1-20 
 Misc1-Misc20
Student Description Misc Field 1-20 Student File > Student Misc Page > Misc 1-20  MiscStudentCaption 
Primary Job Code Student File > Contact Info Page > Job Details Tab  PrimaryJobCode
Primary Job Description Student File > Contact Info Page > Job Details Tab  PrimaryJobTitle
Primary Org Code 1-5 Student File > Contact Info Page > Job Details Tab  PrimaryOrg1-5
Org Title 1-5 Student File > Contact Info Page > Job Details Tab
 PrimaryOrg1-5Desc
Student Status Student File > Contact Info Page > Contact Details Tab
 Status
Supervisor Name Student File > Contact Info Page > Job Details Tab  SupervisorName
SupervisorID  N/A  Supervisor
Secondary Approver Name Student File > Contact Info Page > Job Details Tab  SupervisorName2
Secondary Approver ID  N/A  Supervisor2
DateAdded  N/A  DateAdded
Job Start Date Student File > Contact Info Page > Job Details Tab
 PrimaryJobStartDate 
Course Table
Course ID Course File > Main Page > General Tab  CourseID
Course Name Course File > Main Page > General Tab  CourseName
Course Type Course File > Main Page > General Tab  CourseType
Course Instructor N/A 
 Instructor
Course Code Misc Field 1 - 20
Course File > Main Page > Misc Tab    Misc1-20
Course Description Misc Field 1-20 Course File > Main Page > Misc Tab  MiscCourse1-20
Course Needed Table
Date Needed Student File > Activity Page > Requirement Tab  DateNeeded
JobRequirement Student File > Activity Page >  Requirement Tab 
 JobRequirement
 OrgStartDate Student File > Contact Info Page > Job Details Tab  JobRequirement
Course Taken Table
Date Needed Student File > Activity Page > Courses Taken Tab - Edit  DateNeeded
Date Completed
Student File > Activity Page > Courses Taken Tab - Edit  DateCompleted
Date Expires
Student File > Activity Page > Courses Taken Tab - Edit  DateExpires
Grade
Student File > Activity Page > Courses Taken Tab - Edit  Grade
Hours Student File > Activity Page > Courses Taken Tab - Edit  Hours
Credits Student File > Activity Page > Courses Taken Tab - Edit  Credits
CEU Student File > Activity Page > Courses Taken Tab - Edit  CEU