vrpt_RIInspectionList

Updated January 19, 2026 17:05

Field Name	Field Description	Data Type	FK Join
averageRating	Average Rating	decimal
Id	Room Inspection Id	int
ifm_code	Room Inspection Form Code	nvarchar
ifm_description	Room Inspection Form Description	nvarchar
ift_code	Room Inspection Form Type Code	nvarchar
ift_description	Room Inspection Form Type Description	nvarchar
ift_pk	Room Inspection Form Type Id	int
ifts_code	Room Inspection Form Sub Type Code	nvarchar
ifts_description	Room Inspection Form Sub Type Description	nvarchar
ifts_pk	Room Inspection Form Sub Type Id	int
irt_code	Room Inspection Result Type Code	nvarchar
irt_description	Room Inspection Result Type Description	nvarchar
irt_pk	Room Inspection Result Type Id	int
irts_code	Room Inspection Result Sub Type Code	nvarchar
irts_description	Room Inspection Result Sub Type Description	nvarchar
irts_pk	Room Inspection Result Sub Type Id	int
pk	Room Inspection Id	int
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rinp_closeDate	Close Date	datetime
rinp_createdDate	Record Creation Date	datetime
rinp_creator_fk	User Id (Record Creator)	int	vr_users
rinp_custodial	Custodial	int
rinp_description	Description	nvarchar
rinp_ifm_fk	Room Inspection Form Id	int
rinp_inspectionDate	Inspection Date	datetime
rinp_irt_fk	Room Inspection Form Type Id	int
rinp_lapsedDays	Lapsed Days	int
rinp_manualClose	Manual Close	bit
rinp_modifiedDate	Last Modified Date	datetime
rinp_modifier_fk	User Id (Record Modifier)	int	vr_users
rinp_number	Room Inspection Number	int
rinp_pk	Room Inspection Id	int
rinp_rc_fk	Repair Center Id	int	vr_RepairCenter
rinp_wk_fk	Technician Id	int	vrpt_Technician
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar

Articles in this section