vrpt_InspectionFinding

Updated December 24, 2025 12:41

Field Name	Field Description	Data Type	FK Join
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Inspection Findings Id	int
ignored	Indicates if this record has been ignored	bit
inspFinding_acceptedDate	Accepted Date	datetime
inspFinding_ACCEPTOR_fk	Acceptor Id	int	vr_users
inspFinding_AddressedInInsp	Addressed in Inspeciton	bit
inspFinding_AUTHORIZED	Authorized flag	bit
inspFinding_COMMENTS	Comments	nvarchar
inspFinding_createdDate	Record Creation Date	datetime
inspFinding_CREATOR_FK	User Id (Record Creator)	int	vr_users
inspFinding_CST_FK	Account Id	int	vr_account
inspFinding_DP_FK	Department Id	int	vr_Department
inspFinding_Email	Email	nvarchar
inspFinding_estimateCost	Estimate Cost	decimal
inspFinding_exposureFreq	Exposure Frequency	nvarchar
inspFinding_FB_FK	Building Id	int	vr_building
inspFinding_FD_FK	Facility Id	int	vr_Facility
inspFinding_FF_FK	Floor Record Id	int	vr_floor
inspFinding_findingCost	Finding Cost	decimal
inspFinding_fo_fk	Task Id	int	vrpt_task
inspFinding_FU_FK	Area Record Id	int	vr_area
inspFinding_ignoredDate	Ignored Date	datetime
inspFinding_LT_FK	Request Type Id	int	vr_RequestType
inspFinding_modifiedDate	Last Modified Date	datetime
inspFinding_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
inspFinding_NotifyMe	Indicates if this record is set to notify the requestor via email	bit
inspFinding_NUMBER	Inspection Findings Number	nvarchar
inspFinding_peopleExposed	People Exposed	int
inspFinding_PK	Inspection Findings Id	int
inspFinding_rb_fk	Regulatory Body Id	int
inspFinding_RC_FK	Repair Center Id	int	vr_RepairCenter
inspFinding_rcs_fk	Regulatory Code Sections Id	int
inspFinding_rcss_fk	Repair Center Survey Section Id	int
inspFinding_rejectedDate	Rejected Date	datetime
inspFinding_rejectedReason	Rejected Reason	nvarchar
inspFinding_REJECTOR_fk	Rejector Id	int	vr_users
inspFinding_REQUEST	Request	nvarchar
inspFinding_requestDate	Request Date	datetime
inspFinding_REQUESTOR	Requestor	nvarchar
inspFinding_requestorPhone	Requestor Phone	nvarchar
inspFinding_resolution	Resolution	nvarchar
inspFinding_riskLevel	Risk Level	int
inspFinding_scheduledCompDate	Scheduled Completion Date	datetime
ItemDescription	Item Description	nvarchar
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
locationfk	Location Id	int
locationtype_fk	Location Type Id	int
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar

Articles in this section