vrpt_ClassList

Field NameField DescriptionData TypeFK Join
class_activeIndicates if the Record is Active or Notbit 
class_AdditionalInfoAdditional Informationnvarchar 
class_availableIndicates if the class record is availablebit 
class_capacityCapacityint 
class_closedEnrollmentIndicates if the class record's enrollemnt is closedbit 
class_createdDateRecord Creation Datedatetime 
class_creator_fkUser Id (Record Creator)intvr_users
class_descriptionClass Descriptionnvarchar 
class_durationClass Durationdecimal 
class_endDateClass End Datedatetime 
class_enrollmentEndDateClass Enrollment End Datedatetime 
class_enrollmentStartDateClass Enrollement Start Datedatetime 
class_estimateCostClass Estimate Costdecimal 
class_IDClasss Unique Idnvarchar 
class_intervalClass Intervalint 
class_interval_fkInterval Idint 
class_locationClass Locationnvarchar 
class_modifiedDateLast Modified Datedatetime 
class_modifier_fkUser Id (Record Modifier)intvr_users
class_pkClass Idintvrpt_ClassList
class_prg_fkTraining Program Idintvr_TrainingProgram
class_rc_fkRepair Center Idintvr_RepairCenter
class_startDateClass Start Datedatetime 
class_surveyRequiredIndicates Whether a Survey is Required or Notbit 
class_t_fkTraining Course Idintvr_TrainingCourse
defaultTrainerIDDefault Trainer Idvarchar 
defaultTrainerNameDefault Trainer Namevarchar 
IdClass Idint 
prg_descriptionTraining Program Descriptionnvarchar 
prg_idTraining Program Record Idnvarchar 
prg_pkTraining Program Idintvr_TrainingProgram
rc_codeRepair Center Codenvarchar 
t_codeTraining Course Codenvarchar 
t_createdDateRecord Creation Datedatetime 
t_creator_fkUser Id (Record Creator)intvr_users
t_descriptionTraining Course Descriptionnvarchar 
t_modifiedDateLast Modified Datedatetime 
t_modifier_fkUser Id (Record Modifier)intvr_users
t_pkTraining Course Idintvr_TrainingCourse
TraineeHoursTrainee Hoursdecimal 
TrainerHoursTrainer Hoursdecimal 
validforValid fornvarchar 
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!