vr_AreaOccupants

Updated September 10, 2026 14:03

Field Name	Field Description	Data Type	FK Join
Id	Area Occupants Id	int
RequestorId	Requestor Id	int	vr_Requestor
Name	Requestor Name	nvarchar
OccupantName	Occupant Name (Requestor Name)	nvarchar
Title	Title	nvarchar
Email	Email	nvarchar
WorkPhone	Work Phone	nvarchar
DepartmentName	Department Name	nvarchar
OccupantDepartmentName	Occupant Department Name	nvarchar
Organization	Organization	nvarchar
OccupantOrganization	Occupant Organization	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code	nvarchar
AreaDescription	Area Description	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AreaActualSquareFootage	Area Actual Square Footage	decimal
AreaMailStop	Area Mail Stop	nvarchar
AreaTypeId	Area Type Id	int	vr_areaType
AreaTypeDescription	Area Type Description	nvarchar
AreaSubTypeId	Area Sub Type Id	int	vr_AreaSubType
AreaSubTypeDescription	Area Sub Type Description	nvarchar
TotalPercentage	Total Percentage	decimal
FloorId	Floor Id	int	vr_floor
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
BuildingId	Building Id	int	vr_building
BuildingCode	Building Code	nvarchar
BuildingName	Building Name	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityCode	Facility Code	nvarchar
FacilityName	Facility Name	nvarchar
Percentage	Percentage	decimal
OccupantPercentage	Occupant Percentage	decimal
Preferred	Preferred	bit
CreatedDate	Created Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
ModifiedDate	Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users