vrpt_MonitoredConditionReadingListForEquipment

Updated December 24, 2025 14:29

Field Name	Field Description	Data Type	FK Join
fc_code	Equipment Type Code	nvarchar
fc_description	Equipment Type Description	nvarchar
fc_pk	Equipment Type Id	int	vr_equipmentType
fm_description	Equipment Description	nvarchar
fm_pk	Equipment Id	int	vr_equipment
fm_tagNumber	Equipment Tag Number	nvarchar
id	Monitored Condition Reading Id	int
MT_code	Monitored Condition Code	nvarchar
MT_Description	Monitored Condition Description	nvarchar
mtl_item_fk	Equipment Id	int	vr_equipment
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
wk_id	Technician Record Id	nvarchar	vrpt_Technician
WK_NAME	Technician Name	nvarchar