vr_AreaDepartment

Updated February 03, 2026 15:26

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AreaTypeCode	Area Type Code	nvarchar
AreaTypeDescription	Area Type Description	nvarchar
AreaTypeId	Area Type Id	int	vr_areaType
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DepartmentCode	Department Code	nvarchar
DepartmentContact	Department Contact	nvarchar
DepartmentDetailCode	Department Detail Code	nvarchar
DepartmentDetailContact	Department Detail Contact	nvarchar
DepartmentDetailId	Department Detail Id	int
DepartmentDetailName	Department Detail Name	nvarchar
DepartmentDetailPhone	Department Detail Phone	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DepartmentPhone	Department Phone	nvarchar
DepartmentUsage	Department Usage	decimal
EndDate	End Date	datetime
FloorCode	Floor Code	nvarchar
FloorId	Floor Id	int	vr_floor
Id	Area Department Line Id	int
IsOccupied	Is Occupied	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
SfOccupied	Square Footage Occupied	int
SquareFootage	Square Footage	decimal
StartDate	Start Date	datetime
Usage	Usage	decimal
ValueDate	Value Date	datetime
ValueOfContent	Value Of Content	decimal