vrpt_ToolCheckout

Updated January 20, 2026 15:52

Field Name	Field Description	Data Type	FK Join
cr_tt_fk	Tool Type Id	int	vr_ToolType
fullTechName	Technician Name	nvarchar
Id	Tool Checkout Id	int
itemcode	Item Code	nvarchar
itemName	Item Name	nvarchar
itemTypePK	Item Type Id	int
serialNumber	Serial Number	nvarchar
th_active	Indicates if the Record is Active or Not	smallint
th_ce_fk	Biomed Equipment Id	int	vr_CEEquipment
th_checkedIn	Checked In Date	datetime
th_checkedOut	Checked Out Date	datetime
th_cr_fk	Tool Id	int	vr_Tool
th_createdDate	Record Creation Date	datetime
th_creator_fk	User Id (Record Creator)	int	vr_users
th_currentJob	Current Job	nvarchar
th_dist_fk	District Id	int	vr_district
th_dueBack	Due Back Date	datetime
th_dvsn_fk	Division Id	int
th_fd_fk	Facility Id	int	vr_Facility
th_fm_fk	Equipment Id	int	vr_equipment
th_fu_fk	Area Record Id	int	vr_area
th_fug_fk	Obsolete Column	int
th_fv_fk	Vehicle Id	int	vr_Vehicle
th_itemtype_fk	Item Type Id	int
th_itfm_fk	IT Equipment Id	int	vr_ITEquipment
th_modifiedDate	Last Modified Date	datetime
th_modifier_fk	User Id (Record Modifier)	int	vr_users
th_ns_fk	Entity Id	int	vr_Entity
th_p_fk	Asset Id	int	vr_asset
th_pk	Tool Checkout Id	int
th_rg_fk	Region Id	int	vr_region
th_timeCheckedIn	Time Checked In Date	datetime
th_timeCheckedOut	Time Checked Out Date	datetime
th_timeDueBack	Time Due Back Date	datetime
th_wk_fk	Technician Id	int	vrpt_Technician
tt_description	Tool Type Description	nvarchar