vr_LinearAsset

Updated November 26, 2025 17:05

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
CalibratedThrough	Calibrated Through	datetime
Code	Linear Asset Code	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Description	nvarchar
direction_name	Direction Name	nvarchar
DistrictCode	District Code	nvarchar
DistrictId	District Id	int	vr_District
DistrictName	District Name	nvarchar
DivisionCode	Division Code	nvarchar
DivisionId	Division Id	int
DivisionName	Division Name	nvarchar
EndMeasure	End Measure	decimal
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
GISUniqueId	GIS Unique Id	uniqueidentifier
Id	Linear Asset Id	int
Image	Image	nvarchar
LastCalibrationDate	Last Calibration Date	datetime
Latitude	Latitude	float
LinearAssetSubTypeCode	Linear Asset Sub Type Code	nvarchar
LinearAssetSubTypeDescription	Linear Asset Sub Type Description	nvarchar
LinearAssetSubTypeId	Linear Asset Sub Type Id	int
LinearAssetTypeCode	Linear Asset Type Code	nvarchar
LinearAssetTypeDescription	Linear Asset Type Description	nvarchar
LinearAssetTypeId	Linear Asset Type Id	int	vr_LinearAssetType
LinearFeatureTypeCode	Linear Feature Type Code	nvarchar
LinearFeatureTypeDescription	Linear Feature Type Description	nvarchar
LinearFeatureTypeId	Linear Feature Type Id	int
Longitude	Longitude	float
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Linear Asset Name	nvarchar
ParentCode	Parent Code	nvarchar
ParentId	Parent Id	int	vr_LinearAsset
ParentName	Parent Name	nvarchar
PreferredRepairCenter	Preferred Repair Center	int
PreventArchival	Prevent Archival	bit
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_region
RegionName	Region Name	nvarchar
StartMeasure	Start Measure	decimal
TagNumber	Tag Number	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Xcoordinate	X Coordinate	float
Ycoordinate	Y Coordinate	float

Articles in this section