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

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

View_ClassCosts

 

This view is a combination of several tables: Classes, Class Costs, Course, Code Tables, and Login.  This view pulls together fields to help with reporting on class information as it relates to class costs.

 ​

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 
 Class Costs Table
CostItem Class File > Class Details Page > Costs Tab CostItem
CostDate Class File > Class Details Page > Costs Tab  CostDate
Amount Class File > Class Details Page > Costs Tab
 Amount
CostNote Class File > Class Details Page > Costs Tab
 Note
 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
 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
Misc Code 1-20 Course File > Main Page > Misc Tab Misc Code 1-20
Codes Tables Table
_CostItem

Class File > Class Details Page > Costs Tab

 

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

 _CostItem 
_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 Table. 

 _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