vrpt_MonitoredConditionReadingListForArea

Updated December 24, 2025 14:13

Field Name	Field Description	Data Type	FK Join
fu_description	Area Description	nvarchar
fu_pk	Area Record Id	int	vr_area
fu_unitID	Area Location Id	nvarchar
Id	Monitored Condition Reading Id	int
MT_code	Monitored Condition Code	nvarchar
MT_Description	Monitored Condition Description	nvarchar
mtl_item_fk	Area Id	int	vr_area
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
wa_code	Area Type Code	nvarchar
wa_description	Area Type Description	nvarchar
wa_pk	Area Type Id	int	vr_areaType
wk_id	Technician Record Id	nvarchar	vrpt_Technician
WK_NAME	Technician Name	nvarchar