vr_Area

Updated November 14, 2025 17:35

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
ActualSquareFootage	Actual Square Footage	decimal
AreaFunctionCode	Area Function Code	nvarchar
AreaFunctionDescription	Area Function Description	nvarchar
AreaFunctionId	Area Function Id	int	vr_areaFunction
AreaSubTypeCode	Area SubType Code	nvarchar
AreaSubTypeDescription	Area SubType Description	nvarchar
AreaSubTypeId	Area SubType Id	int
AreaTypeCode	Area Type Code	nvarchar
AreaTypeDescription	Area Type Description	nvarchar
AreaTypeId	Area Type Id	int	vr_areaType
Asbestos	Asbestos	bit
AsbestosAmount	Asbestos Amount	decimal
AssignableSpace	Assignable Space	bit
BIMUniqueId	BIM Unqiue Id	nvarchar
BuildingActive	Indicates if the Building is Active or Not	bit
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
BuildingPopupMessage	Building Popup Message	nvarchar
CDTemplateActive	Custodial Template Active	bit
CDTemplateCode	Custodial Template Code	nvarchar
CDTemplateDescription	Custodial Template Description	nvarchar
CDTemplateId	Custodial Template Id	int
CDTemplateMinutes	Custodial Template Minutes	decimal
CDTemplateSubtypeCode	Custodial Template SubType Code	nvarchar
CDTemplateSubtypeDescription	Custodial Template SubType Description	nvarchar
CDTemplateSubtypeId	Custodial Template SubType Id	int
CDTemplateTypeCode	Custodial Template Type Code	nvarchar
CDTemplateTypeDescription	Custodial Template Type Description	nvarchar
CDTemplateTypeId	Custodial Template Type Id	int
CleanableSquareFeet	Cleanable Square Feet	int
CleanDrapeDate	Clean Drapes Date	datetime
Code	Area Code	nvarchar
ConfinedSpace	Confined Space	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Custodial	Custodial	bit
CustodialPriority	Custodial Priority	int
custodialRouteCount	Custodial Route Count	int
Description	Area Description	nvarchar
DistrictCode	Disctrict Code	nvarchar
DistrictId	District Id	int	vr_District
DistrictName	District Name	nvarchar
DivisionCode	Division Code	nvarchar
DivisionId	Division Id	int
DivisionName	Divison Name	nvarchar
ExcludeFromRequestor	Exclude From Requestor	bit
ExtinguisherCheckDate	Extinguisher Check Date	datetime
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	Facility Popup Message	nvarchar
FloorActive	Indicates if the Floor is Active or Not	bit
FloorCleanDate	Floor Clean Date	datetime
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
Flooring1Code	Flooring 1 Code	nvarchar
Flooring1Description	Flooring 1 Description	nvarchar
Flooring1Id	Flooring Id	int
Flooring2Code	Flooring 2 Code	nvarchar
Flooring2Description	Flooring 2 Description	nvarchar
Flooring2Id	Flooring Id	int
FloorNumber	Floor Number	nvarchar
FloorPopupMessage	Floor Popup Message	nvarchar
FloorReplaceDate	Floor Replace Date	datetime
FloorType	Floor Type	nvarchar
FullLocation	Full Location	nvarchar
Gender	Gender	int
GenderString	Gender String	varchar
GISUniqueId	GIS Unique Id	uniqueidentifier
GRNFlooring1	Grounds Flooring 1	nvarchar
GRNTemplateCode	Grounds Template Code	nvarchar
GRNTemplateDescription	Grounds Template Description	nvarchar
GRNTemplateId	Grounds Template Id	int
GRNTemplateSubtypeCode	Grounds Template SubType Code	nvarchar
GRNTemplateSubtypeDescription	Grounds Template SubType Description	nvarchar
GRNTemplateSubtypeId	Grounds Template SubType Id	int
GRNTemplateTypeCode	Grounds Template Type Code	nvarchar
GRNTemplateTypeDescription	Grounds Template Type Description	nvarchar
GRNTemplateTypeId	Grounds Template Type Id	int
HasPopupMessage	Has Popup Message	int
HazardousMaterial	Hazardous Material	bit
HVAC1	HVAC 1	nvarchar
HVAC2	HVAC 2	nvarchar
HVAC3	HVAC 3	nvarchar
Id	Area Id	int
Image	Image	nvarchar
InspectionRequired	Inspection Required	bit
IsCarpeted	Is Carpeted	bit
IsDefaultDescription	Is Default Description	bit
Latitude	Latitude	float
Lead	Lead	bit
LifeSafety1	Life Safety 1	nvarchar
LifeSafety2	Life Safety 2	nvarchar
LightBulb	Light Bulb	nvarchar
LightDate	Light Date	datetime
LightFixture	Light Fixture	nvarchar
LocationCode	Location Code	nvarchar
LockoutProcess	Lockout Process	nvarchar
Longitude	Longitude	float
MailStop	Mail Stop	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Mold	Mold	bit
Name	Area Name	nvarchar
NumberAndDescription	Area Number and Description	nvarchar
Occupancy	Occupancy	decimal
OffSite	Off Site	bit
PaintCeiling	Paint Ceiling	nvarchar
PaintDate	Paint Date	datetime
PaintTrim	Paint Trim	nvarchar
PaintWall	Paint Wall	nvarchar
ParentDescription	Parent Area Description	nvarchar
ParentId	Parent Area Id	int	vr_area
ParentLocationCode	Parent Area Location Code	nvarchar
ParentRoomNumber	Parent Area Room Number	nvarchar
ParkingCount	Parking Count	int
Phone	Phone #	nvarchar
Plumbing1	Plumbing 1	nvarchar
Plumbing2	Plumbing 2	nvarchar
Plumbing3	Plumbing 3	nvarchar
PopupMessage	Popup Message	nvarchar
PreventAPPAOverride	Prevent APPA Override	bit
PreventArchival	Prevent Archival	bit
RealPortfolio	Real Porfolio	bit
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_Region
RegionName	Region Name	nvarchar
ReplaceDrapeDate	Replace Drape Date	datetime
RoomNumber	Area Room Number	nvarchar
Shower	Show	nvarchar
Sink	Sink	nvarchar
SmokeDetector	Smoke Detector	bit
SmokeDetectorCheckDate	Smoke Detector Check Date	datetime
Sublet	Sublet	bit
TagNumber	Tag Number	nvarchar
TagoutCode	Tagout Code	nvarchar
TagoutId	Tagout Id	int
TagoutName	Tagout Name	nvarchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Toilet	Toilet	nvarchar
Urinal	Urinal	nvarchar
UsableSquareFootage	Usable Square Footage	decimal
Value	Value	nvarchar
WarrantyDate	Warranty Date	datetime

Articles in this section