vrpt_RoomInspectionBrowse

Updated April 06, 2026 15:34

Field Name	Field Description	Data Type	FK Join
dist_pk	District Id	int	vr_district
dvsn_pk	Division Id	int
fb_name	Building Name	nvarchar
fb_pk	Building Id	int	vr_building
fd_pk	Facility Id	int	vr_facility
ff_pk	Floor Id	int	vr_floor
fu_unitID	Area Location Id	nvarchar
Id	Room Inspection Area Point Link Id	int	vrpt_riInspectionAreaPointLink
ifm_description	Room Inspection Form Description	nvarchar
ifm_ift_fk	Room Inspection Form Type Id	int	vr_RoomInspectionFormType
ift_description	Room Inspection Form Type Description	nvarchar
ift_pk	Room Inspection Form Type Id	int	vr_RoomInspectionFormType
ifts_description	Room Inspection Form Sub Type Description	nvarchar
iph_date	Inspection Area Link Date	datetime
irh_pk	Room Inspection Area Point Link Id	int	vrpt_riInspectionAreaPointLink
irh_wk_fk	Technician Id	int	vrpt_Technician
irt_description	Room Inspection Result Type Description	nvarchar
irts_description	Room Inspection Result Sub Type Description	nvarchar
itfs_pk	Room Inspection Result Sub Type Id	int
pts_description	Room Inspeciton Points Description	nvarchar
rat_description	Room Inspeciton Rating Description	nvarchar
rat_pk	Room Inspeciton Rating Id	int
rg_pk	Region Id	int	vr_region
rinp_closeDate	Close Date	datetime
rinp_description	Room Inspection Description	nvarchar
rinp_ifm_fk	Room Inspection Form Id	int	vr_riform
rinp_inspectionDate	Insepction Date	datetime
rinp_irt_fk	Room Inspection Result Type Id	int	vr_RIResultType
rinp_number	Room Inspection Number	int
rinp_pk	Room Inspection Id	int	vrpt_riInspectionList
rinp_rc_fk	Repair Center Id	int	vr_RepairCenter
rinp_wk_fk	Technician Id	int	vrpt_Technician
wa_description	Area Type Description	nvarchar
was_description	Area Sub Type Description	nvarchar
wk_name	Technician Name	nvarchar

Articles in this section