vrpt_MonitoredConditionReadingListForTools

Updated December 24, 2025 14:31

Field Name	Field Description	Data Type	FK Join
cr_code	Tool Code	nvarchar
cr_pk	Tool Id	int	vr_Tool
cr_toolName	Tool Name	nvarchar
Id	Monitored Condition Reading Id	int
MT_code	Monitored Condition Code	nvarchar
MT_Description	Monitored Condition Description	nvarchar
mtl_item_fk	Tool Id	int	vr_Tool
mtl_itemtype_fk	Item Type Id	int
mtreading_comment	Comment	nvarchar
mtreading_createdDate	Record Creation Date	datetime
mtreading_creator_fk	User Id (Record Creator)	int	vr_users
mtreading_date	Monitored Condition Reading Date	datetime
mtreading_modifiedDate	Last Modified Date	datetime
mtreading_modifier_fk	User Id (Record Modifier)	int	vr_users
mtreading_mtl_fk	Monitored Condition Reading Item Link Id	int
mtreading_pass	Monitored Condition Reading Pass	smallint
mtreading_pk	Monitored Condition Reading Id	int
mtreading_value	Monitored Condition Reading Value	decimal
mtreading_wk_fk	Monitored Condition Reading Technician Id	int	vrpt_Technician
mtreading_wonumber	Work Order Number	nvarchar
PassFail	Indicates if this record Passed or Failed	varchar
tt_code	Tool Type Code	nvarchar
tt_description	Tool Type Description	nvarchar
tt_pk	Tool Type Id	int	vr_ToolType
wk_id	Technician Record Id	nvarchar	vrpt_Technician
WK_NAME	Technician Name	nvarchar