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

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

View_StudentCoursesTaken

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

 

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 
Student Table
 Student ID  In the URL at the top of the page when in the Student File
 StudentID
 DateAdded  N/A  DateAdded
 Employee Number
 Student File > Contact Info Page > Job Details Tab
 Empno
 StudentType  Student File > Contact Info Page > Job Details Tab  StudentType
 EmployeeType  Student File > Contact Info Page > Job Details Tab
 EmpType
 Login  Student File > Contact Info Page > Personal Details Tab  Login
 FirstName  Student File > Contact Info Page > Contact Details Tab
 First Name
 LastName  Student File > Contact Info Page > Contact Details Tab
 Last Name
 MiddleName-  Student File > Contact Info Page > Contact Details Tab  MiddleName
 FullName-  Student File > Contact Info Page > Contact Details Tab
 First Name + Last Name
 PreferredName  Student File > Contact Info Page > Contact Details Tab > Nickname  PreferredName
 HomeStreet1  Student File > Contact Info Page > Contact Details Tab  HomeStreet1
 HomeStreet2  Student File > Contact Info Page > Cotntact Details Tab  HomeStreet2
 HomeCity  Student File > Contact Info Page > Cotntact Details Tab  HomeCity
 HomeState  Student File > Contact Info Page > Cotntact Details Tab  HomeState
 HomeZip  Student File > Contact Info Page > Cotntact Details Tab  HomeZip
 HomeCountry  Student File > Contact Info Page > Cotntact Details Tab  HomeCountry
 WorkStreet1  Student File > Contact Info Page > Cotntact Details Tab  WorkStreet1
 WorkStreet2  Student File > Contact Info Page > Cotntact Details Tab  WorkStreet2
 WorkCity  Student File > Contact Info Page > Cotntact Details Tab  WorkCity
 WorkState  Student File > Contact Info Page > Cotntact Details Tab  WorkState
 WorkZip  Student File > Contact Info Page > Cotntact Details Tab  WorkZip
 WorkCountry  Student File > Contact Info Page > Cotntact Details Tab  WorkCountry
 Email  Student File > Contact Info Page > Contact Details Tab - Home Email  Email
 WorkEmail  Student File > Contact Info Page > Contact Details Tab  WorkEmail
 HomePhoneNumber  Student File > Contact Info Page > Contact Details Tab  HomePhone
 WorkPhoneNumber  Student File > Contact Info Page > Contact Details Tab  WorkPhone
 WorkCellPhone  Student File > Contact Info Page > Contact Details Tab   WorkCellPhone
 CellPhoneNumber  Student File > Contact Info Page > Contact Details Tab  CellPhone
 FaxNumber  Student File > Contact Info Page > Contact Details Tab  Fax
 WorkExt  Student File > Contact Info Page > Contact Details Tab  WorkExt
 WorkFax  Student File > Contact Info Page > Contact Details Tab  WorkFax
 StudentMisc1-20  Student File > Student Misc Page > Misc 1-20 
 Misc1-Misc20
 PrimaryJobCode  Student File > Contact Info Page > Job Details Tab  PrimaryJobCode
 PrimaryJobTitle  Student File > Contact Info Page > Job Details Tab  PrimaryJobTitle
 PrimaryJobStartDate  Student File > Contact Info Page > Job Details Tab  PrimaryJobStartDate
 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
 Status  Student File > Contact Info Page > Contact Tab (Active/Inactive)
 Status
 SupervisorName  Student File > Contact Info Page > Job Details Tab  SupervisorName
 Supervisor  N/A  Supervisor
 SupervisorName2  Student File > Contact Info Page > Job Details Tab  SupervisorName2
 Supervisor2  N/A  Supervisor2
 SSN  Student File > Contact Info Page > Personal Details Tab  SSN
 BirthDate  Student File > Contact Info Page > Personal Details Tab  BirthDate
 HireDate  Student File > Contact Info Page > Job Details Tab  HireDate
 PrimaryEmail  Student File > Contact Info Page > Job Details Tab  PrimaryEmail
 IsEmp  Student File > Contact Info Page > Job Details Tab

 IsEmp

 IsSupervisor  Student File > Contact Info Page > Job Details Tab  IsSupervisor
 Course Table
 CourseName  Course File > Main Page > General Tab  CourseName
 CourseID  Course File > Main Page > General Tab  CourseID
 CourseType  Course File > Main Page > General Tab  CourseType
 Active  Course File > Main Page > General Tab  Active
 Fee  Course File > Main Page > General Tab  Fee
 Credits  Course File > Main Page > General Tab  Credits
 CEU  Course File > Main Page > General Tab  CEU
 CourseDesc  Course File > Main Page > General Tab  ExternalDesc
 CourseMisc1-20  Course File > Main Page > Misc Tab  Misc1-20
 CourseHours  Course File > Main Page > General Tab  Hours
 GradeType  Course File > Main Page > General Tab  GradeType
 Instructor  N/A - There is not an instructor field in the Courses Tab - placeholder  N/A
 Location  N/A - While this is pulling from the Classes Table, the view is not connected to the Classes Table and therefore will not display information when used.   Location
 Courses Taken Table
 Date Needed  Student File > Activity Page > Courses Taken Tab  DateNeeded
 Date Completed  Student File > Activity Page > Courses Taken Tab  JobRequirement
 Date Expires  Student File > Activity Page > Courses Taken Tab  
 Grade  Student File > Activity Page > Courses Taken Tab  Priority
 Hours  Student File > Activity Page > Courses Taken Tab  
 Note  Student File > Activity Page > Courses Taken Tab  Note
 Manual Course  Not being Used  
 Manual Provider  Not being Used  
Company Table
Company Admin > Codes > Companies (Code Only) Company
CompanyName Admin > Codes > Companies (Data Description Only) CompanyName