vrpt_TrainingRequest

Updated January 20, 2026 16:14

Field Name	Field Description	Data Type	FK Join
assigned_class_description	Assigned Class Description	nvarchar
assigned_class_id	Assigned Class Id	nvarchar
class_AdditionalInfo	Class Additional Information	nvarchar
class_description	Class Description	nvarchar
class_endDate	Class End Date	datetime
class_ID	Classs Unique Id	nvarchar
class_location	Class Location	nvarchar
class_rc_fk	Repair Center Id	int	vr_RepairCenter
class_startDate	Class Start Date	datetime
classDefaultTrainerName	Trainer Name	nvarchar
filterTech	Indicates if the record is set to filter technicians	bit
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fj_pk	Task Type Id	int	vr_TaskType
fo_code	Task Code	nvarchar
fo_pk	Task Id	int	vrpt_task
Id	Training Request Id	int
prg_description	Training Program Description	nvarchar
prg_id	Training Program Record Id	nvarchar
prg_pk	Training Program Id	int	vr_TrainingProgram
tassgn_canceledDate	Training Assignment Canceled Date	datetime
tassgn_closed	Indicates if the training assignment record is closed	bit
tassgn_closedDate	Training Assignment Closed Date	datetime
tassgn_endDate	Training Assignment End Date	datetime
tassgn_expirationDate	Training Assignment Expiration Date	datetime
tassgn_location	Training Assignment Location	nvarchar
tassgn_startDate	Training Assignment Start Date	datetime
trainer_name	Trainer Name	nvarchar
treq_class_fk	Class Id	int	vrpt_ClassList
treq_comment	Comment	nvarchar
treq_createdDate	Record Creation Date	datetime
treq_creator_fk	User Id (Record Creator)	int	vr_users
treq_email	Email	nvarchar
treq_itemtype_fk	Item Type Id	int
treq_lookuptype_fk	Lookup Type Id	int
treq_modifiedDate	Last Modified Date	datetime
treq_modifier_fk	User Id (Record Modifier)	int	vr_users
treq_pk	Training Request Id	int
treq_rejectedBy	Rejected By	int
treq_rejectedDate	Rejected Date	datetime
treq_rejectReason	Reject Reason	nvarchar
treq_requiredDate	Required Date	datetime
treq_wk_fk	Technician Id	int	vrpt_Technician
treq_wotask_fk	Work Order Task Id	int	vr_WorkOrderTask
typeDescription	Type Description	nvarchar
typeName	Type Name	nvarchar
wk_email	Technician Work Email	nvarchar
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter

Articles in this section