vrpt_CDInspectionAreaItemLink

Updated December 19, 2025 16:14

Field Name	Field Description	Data Type	FK Join
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AreaSubTypeCode	Area SubType Code	nvarchar
AreaSubTypeDescription	Area SubType Description	nvarchar
AreaTypeCode	Area Type Code	nvarchar
AreaTypeDescription	Area Type Description	nvarchar
BuildingCode	Building Code	nvarchar
BuildingName	Building Name	nvarchar
CDDeficiencyCode	Custodial Deficiency Code	nvarchar
CDDeficiencyDescription	Custodial Deficiency Description	nvarchar
CDDeficiencyId	Custodial Deficiency Id	int
CDInspectionId	Custodial Inspection Id	int
CDItemDescription	Custodial Item Description	nvarchar
CDItemId	Custodial Item Id	int
Comments	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
createRequest	Create Request	bit
CreatorId	User Id (Record Creator)	int	vr_users
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
Factor	Factor	decimal
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
HasLinkedDocument	Indicates if this record has a linked document	bit
Id	Custodial Inspection Area Item Link Id	int
InspectionAreaDate	Inspection Area Date	datetime
InspectionAreaLinkId	Inspection Area Link Id	int
InspectionDate	Inspection Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Quantity	Quantity	int
RatingCode	Rating Code	nvarchar
RatingDescription	Rating Description	nvarchar
RatingId	Rating Id	int
RatingScore	Rating Score	int
RequestId	Request Id	int	vr_Request
Score	Score	int
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TemplateQuantity	Template Quantity	int
UnitOfMeasureCode	Unit of Measure Code	nvarchar
UnitOfMeasureDescription	Unit of Measure Description	nvarchar
UnitOfMeasureId	Unit of Measure Id	int	vr_UnitMeasure

Articles in this section