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 |
|