vrpt_TrainingAssignmentRequest

Updated January 20, 2026 15:59

Field Name	Field Description	Data Type	FK Join
assigned_class_description	Assigned Class Description	nvarchar
assigned_class_id	Assigned Class Id	nvarchar
class_description	Class Description	nvarchar
class_ID	Classs Unique Id	nvarchar
class_pk	Class Id	int	vrpt_ClassList
classDefaultTrainerName	Trainer Name	nvarchar
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
RejectedBy	Rejected By	nvarchar
tassgn_class_fk	Class Id	int	vrpt_ClassList
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_pk	Training Assignment Id	int	vrpt_trainingAssignmentList
tassgn_startDate	Training Assignment Start Date	datetime
traineelabor	Trainee Labor	decimal
trainer_id	Trainer Id	varchar
trainer_name	Trainer Name	varchar
trainerlabor	Trainer Labor	decimal
treq_class_fk	Class Id	int	vrpt_ClassList
treq_comment	Comment	nvarchar
treq_email	Email	nvarchar
treq_itemtype_fk	Item Type Id	int
treq_lookuptype_fk	Lookup Type Id	int
treq_pk	Training Request Id	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_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

Articles in this section