vr_Building

Updated November 17, 2025 16:59

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
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
BaseCostDate	Base Cost Date	datetime
BenchmarkCost	Benchmark Cost	decimal
BenchmarkUtilization	Benchmark Utilization	decimal
BTURating	BTU Rating	decimal
BuildingNumber	Building Number	nvarchar
BuildingSubTypeCode	Building Sub Type Code	nvarchar
BuildingSubTypeDescription	Building Sub Type Description	nvarchar
BuildingSubTypeId	Building Sub Type Id	int
BuildingTypeCode	Building Type Code	nvarchar
BuildingTypeDescription	Building Type Description	nvarchar
BuildingTypeId	Building Type Id	int	vr_buildingType
Capacity	Capacity	decimal
CapitalCost	Capital Planning Building Replacement Cost	decimal
CapitalCostInflated	Capital Planning Building Replacement Cost Inflated	decimal
City	City	nvarchar
CleanoutProcess	Cleanout Process	nvarchar
Code	Building Code	nvarchar
Comment	Comments	nvarchar
CompletedDate	Completed Date	datetime
ContactName	Contact Name	nvarchar
CostPerSqft	Cost Per Square Foot	decimal
Country	Country	nvarchar
CPCondition	Capital Planning Condition	nvarchar
CPConstructionTypeCode	Capital Planning Construction Type Code	nvarchar
CPConstructionTypeDescription	Capital Planning Construction Type Description	nvarchar
CPConstructionTypeId	Capital Planning Construction Type Id	int
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Building Description	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
Email	Contact Email	nvarchar
EmergencyInformation	Emergency Information	nvarchar
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FacilityPopupMessage	Indicates Whether the Facility has a Popup Message or Not	nvarchar
Fax	Fax #	nvarchar
FloorCount	Floor Count	int
GISLatitude	GIS Latitude	float
GISLongitude	GIS Longitude	float
GISUniqueId	GIS Unique Id	uniqueidentifier
HasPopupMessage	Indicates if the Building has a Popup Message or Not	int
Id	Building Id	int	vr_building
Image	Image	nvarchar
InflationDate	Inflation Date	datetime
LastRenovationDate	Last Renovation Date	datetime
Leased	Indicates if the Building is Leased or Not	bit
MobilePhone	Contact Mobile Phone #	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Building Name	nvarchar
ObsoleteGISUniqueId	Obsolete Column (No Longer Used)	nvarchar
OfficePhone	Contact Office Phone #	nvarchar
OffSite	Indicates if the Building is an Off Site Property or Not	bit
OriginalContractor	Original Contractor	nvarchar
OriginalCost	Original Cost	decimal
ParentCode	Building Parent Code	nvarchar
ParentId	Building Parent Id	int	vr_building
ParentName	Building Parent Name	nvarchar
PopupMessage	Popup Message	nvarchar
PortfolioManagerCode	Portfolio Manager Code	nvarchar
PortfolioManagerId	Portfolio Manager Id (Technician Id)	int	vrpt_Technician
PortfolioManagerName	Portfolio Manager Name	nvarchar
PreventArchival	Prevent Archival	bit
RateScheduleActive	Indicates if the Rate Schedule is Active or Not	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RateScheduleWorkOrder	Indicates if the Rate Schedule is Used on Work Orders or Not	bit
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_Region
RegionName	Region Name	nvarchar
RenovationDate	Renovation Date	datetime
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
ReplacementCost	Replacement Cost	decimal
RoofArea	Roof Area	decimal
RoofInformation	Roof Information	nvarchar
RoofReplaced	Roof Replaced Date	datetime
RoofSlope	Roof Slope	nvarchar
RoofWarranty	Roof Warranty Date	datetime
SecondaryContractor	Secondary Contractor	nvarchar
ShutoffProcess	Shutoff Process	nvarchar
SquareFootage	Square Footage	decimal
State	State	nvarchar
Sublet	Sublet	bit
TagNumber	Tag Number	nvarchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Value	Value	nvarchar
WarrantyDate	Warranty Date	datetime
Website	Webiste	nvarchar
XCoordinate	X Coordinate	float
YCoordinate	Y Coordinate	float
Zip	Zip Code	nvarchar

Articles in this section