vrpt_RIInspectionAreaPoint

Updated January 19, 2026 17:03

Field Name	Field Description	Data Type	FK Join
currentQuantity	Current Quantity	int
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fb_pk	Building Id	int	vr_building
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
fd_pk	Facility Id	int	vr_facility
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
ff_pk	Floor Id	int	vr_floor
fu_cdtp_fk	Custodial Template Id	int
fu_description	Area Description	nvarchar
fu_pk	Area Record Id	int	vr_area
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Room Inspection Area Link Id	int	vrpt_riInspectionAreaLink
iph_createdDate	Record Creation Date	datetime
iph_creator_fk	User Id (Record Creator)	int	vr_users
iph_date	Date	datetime
iph_fu_fk	Area Record Id	int	vr_area
iph_inspectorComments	Inspector Comments	nvarchar
iph_levelRating	Level Rating	decimal
iph_modifiedDate	Last Modified Date	datetime
iph_modifier_fk	User Id (Record Modifier)	int	vr_users
iph_occupant	Occupant	nvarchar
iph_occupantComments	Occupant Comments	nvarchar
iph_pk	Room Inspection Area Link Id	int	vrpt_riInspectionAreaLink
iph_rinp_fk	Room Inspection Id	int
iph_sequence	Sequence	int
irh_comments	Comments	nvarchar
irh_iph_fk	Room Inspection Area Link Id	int	vrpt_riInspectionAreaLink
irh_item_fk	Item Id	int
irh_itemType_fk	Item Type Id	int
irh_pk	Room Inspection Area Point Link Id	int	vrpt_riInspectionAreaPointLink
irh_pts_fk	Point Id	int
irh_quantity	Quantity	int
irh_wk_fk	Technician Id	int	vrpt_Technician
ivh_irh_fk	Room Inspection Area Point Link Id	int	vrpt_riInspectionAreaPointLink
ivh_quantity	Quantity	int
pts_description	Point Description	nvarchar
rat_code	Rating Code	nvarchar
rat_description	Rating Description	nvarchar
rat_pk	Rating Id	int
rat_score	Rating Score	int
val_description	Value Description	nvarchar
wa_code	Area Type Code	nvarchar
wa_description	Area Type Description	nvarchar
was_code	Area Sub Type Code	nvarchar
was_description	Area Sub Type Description	nvarchar
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wo_number	Work Order Number	nvarchar

Articles in this section