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

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

View_StudentPrograms

This view of student fields that are available from the Student File > Activity Page > Programs Tab & Student File > Contact Info Page.

 

To see more about the specific fields in these tables there is a Data Dictionary in Cyber Train - Reports > Data Dictionary.



​
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
 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
 Student Email Home  Student File > Contact Info Page > Contact Details Tab  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
 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 
 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
 Student Status  Student File > Contact Info Page > Contact Tab
  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
 DateAdded  N/A  DateAdded
 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
 TermDate  Student File > Contact Info Page > Job Details Tab  TermDate
 PayRvwDate  Student File > Contact Info Page > Job Details Tab  PayRvwDate
 PerfRvwDate  Student File > Contact Info Page > Job Details Tab  PerfRvwDate
 PrimaryEmail  Student File > Contact Info Page > Job Details Tab  PrimaryEmail
 PrimaryPhone  Student File > Contact Info Page > Job Details Tab  PrimaryPhone
 IsEmp  Student File > Contact Info Page > Job Details Tab

 IsEmp
 IsSupervisor  Student File > Contact Info Page > Job Details Tab  IsSupervisor