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

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

View_Class

 

This view is a combination of several tables: Classes, Course, Code Tables, and Login.  This view pulls together fields to help with reporting on class information (Class List > Class File.)  

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 
 Classes Table
Seq  In the URL at the top of the page when in the Class File Seq
StartDate
Class File > Class Details Page > Location/Schedule/Content Tab StartDate
StartTime Class File > Class Details Page > Location/Schedule/Content Tab
StartTime
EndDate Class File > Class Details Page > Location/Schedule/Content Tab
EndDate
EndTime
Class File > Class Details Page > Location/Schedule/Content Tab
EndTime
EnrollmentEnds Class File > Class Details Page > Location/Schedule/Content Tab
EnrollmentEnds
Location Class File > Class Details Page > Location/Schedule/Content Tab
Location
Capacity Class File > Class Details Page > Location/Schedule/Content Tab
Capacity
EnrollStatus Class File > Roster Page > Attendees Tab EnrollStatus
StatusDate Class File > Class Details Page > General Tab
StatusDate
GradeType Class File > Class Details Page > General Tab GradeType
TimeZone Class File > Class Details Page > Location/Schedule/Content Tab TimeZone
OpenSeats Class File > Roster Page > Availability Calculation  OpenSeats
ConferenceID Class File > Class Details Page > Location/Schedule/Content Tab ConferenceID
MeetingID Class File > Class Details Page > Location/Schedule/Content Tab MeetingID
WebMeetingConnection   Class File > Class Details Page > Location/Schedule/Content Tab WebMeetingConnection  
LocationDetails Class File > Class Details Page > Location/Schedule/Content Tab LocationDetails
OnDemand Class File > Class Details Page > General Tab CBT
Fee Class File > Class Details Page > General Tab Fee
Misc1-20 Class File > Class Details Page > Misc Tab Misc1-20
 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
Credits Course File > Main Page > General Tab Credits
CEU Course File > Main Page > General Tab CEU
CourseDescription Course File > Main Page > General Tab InternalDesc
Hours Course File > Main Page > General Tab Hours
RenewalFreq Course File > Main Page > General Tab RenewalFreq
BasedOn Course File > Main Page > General Tab BasedOn
PassingScore Course File > Main Page > General Tab PassingScore
Codes Tables Table
_EnrollStatus Class File > Roster Page > Attendees Tab 

 

NOTE: The underscore indicates this option is the data label and not code.  Use 'EnrollStatus' to pull the code and '_EnrollStatus' to pull the data label.  To get this data label option, this view is connected to the Code Tables table. 

_EnrollStatus
_CourseType

Course File > Main Page > General Tab

 

NOTE: The underscore indicates this option is the data label and not code.  Use 'CourseType' to pull the code and '_CourseType' to pull the data label.  To get this data label option, this view is connected to the Code Tables and Course Tables. 

_CourseType
_ClassMisc1-20

Class File > Class Details Page > Misc Tab

 

NOTE: The underscore indicates this option is the data label and not code.  Use 'Misc1-20' to pull the code for these fields and '_ClassMisc1-20' to pull the data label.  To get this data label option, this view is connected to the Code Tables table. 

_ClassMisc1-20
 Login Table
Instructor Admin > Security > User Security Instructor
TrainingAdmin Admin > Security > User Security TrainingAdmin