vrpt_TrainingAssignmentList

Updated January 20, 2026 15:55

Field Name	Field Description	Data Type	FK Join
CanceledBy	Cancelled By Name	nvarchar
class_AdditionalInfo	Class Additional Info	nvarchar
class_closeDate	Class Close Date	datetime
class_endDate	Class End Date	datetime
class_estimateCost	Class Estimate Cost	decimal
class_ID	Classs Unique Id	nvarchar
class_interval	Class Interval	int
class_interval_fk	Interval Id	int
class_location	Class Location	nvarchar
class_pk	Class Id	int	vrpt_ClassList
class_startDate	Class Start Date	datetime
fullclass	Full Class	nvarchar
Id	Training Assignment Id	int
prg_description	Program Description	nvarchar
prg_id	Program Record Id	nvarchar
prg_pk	Training Program Id	int	vr_TrainingProgram
tassgn_canceledBy	Cancelled By	int
tassgn_canceledDate	Cancelled Date	datetime
tassgn_cancellationReason	Cancellation Reason	nvarchar
tassgn_class_fk	Class Id	int	vrpt_ClassList
tassgn_closed	Indicates if the record is closed	bit
tassgn_closedDate	Closed Date	datetime
tassgn_createdDate	Record Creation Date	datetime
tassgn_creator_fk	User Id (Record Creator)	int	vr_users
tassgn_endDate	End Date	datetime
tassgn_expirationDate	Expiration Date	datetime
tassgn_location	Location	nvarchar
tassgn_modifiedDate	Last Modified Date	datetime
tassgn_modifier_fk	User Id (Record Modifier)	int	vr_users
tassgn_pass	Pass	smallint
tassgn_pk	Training Assignment Id	int
tassgn_startDate	Start Date	datetime
tassgn_treq_fk	Training Request Id	int	vrpt_trainingRequest
trainee_email	Trainee Email	nvarchar
trainee_id	Trainee Record Id	nvarchar
trainee_name	Trainee Name	nvarchar
trainee_pk	Trainee Id	int	vrpt_Technician
trainer_name	Trainer Name	varchar