vrpt_riInspectionAreaLink

Updated April 06, 2026 15:31

Field Name	Field Description	Data Type	FK Join
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_flooring1	Area Flooring 1	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
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
iph_rinp_fk	Room Inspection Id	int	vrpt_riInspectionList
iph_sequence	Sequence	int
isCustodial	Indicates if the record is custodial	bit
PK	Room Inspection Area Link Id	int
sig_item_fk	Signature Item Id	int
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