bi_AreaDepartmentFunctionLink

Updated May 21, 2026 14:16

Field Name	Field Description	Data Type	FK Join
FacilityID	Facility ID	int	vr_facility
Facility Code	Facility Code	nvarchar
Facility Name	Facility Name	nvarchar
BuildingID	Building ID	int	vr_building
Building Code	Building Code	nvarchar
Building Name	Building Name	nvarchar
FloorID	Floor ID	int	vr_floor
Floor Code	Floor Code	nvarchar
Floor Unique ID	Floor Unique ID	nvarchar
AreaID	Area ID	int	vr_area
Room Number	Room Number	nvarchar
Location ID	Location ID	nvarchar
Area Description	Area Description	nvarchar
DepartmentID	Department ID	int	vr_Department
Department Code	Department Code	nvarchar
Department Name	Department Name	nvarchar
Departement Link Active	Indicates if the Department Link is Active	bit
Departement Link Distribution	Departement Link Distribution	decimal
Departement Link isOccupied	Indicates if the Department Link is Occupied	bit
Departement Link Start Date	Departement Link Start Date	datetime
Departement Link End Date	Departement Link End Date	datetime
Occupied SF	Occupied Square Feet	int
Departement Link Value	Departement Link Value	decimal
Departement Link Value Date	Departement Link Value Date	datetime
Area Department Function Code	Area Department Function Code	nvarchar
Area Department Function Description	Area Department Function Description	nvarchar
Area Department Function Distribution	Area Department Function Distribution	decimal