| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| ActualSquareFootage | Actual Square Footage | decimal | |
| BIMUniqueId | BIM Unique 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 | |
| CADDrawingFile | CAD Drawing File | nvarchar | |
| Code | Floor Code | nvarchar | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| Description | Floor 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 | |
| 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 | Popup Message | nvarchar | |
| FloorElevation | Floor Elevation | decimal | |
| FloorSubTypeCode | Floor SubType Code | nvarchar | |
| FloorSubTypeDescription | Floor SubType Description | nvarchar | |
| FloorSubTypeId | Floor SubType Id | int | |
| FloorTypeCode | Floor Type Code | nvarchar | |
| FloorTypeDescription | Floor Type Description | nvarchar | |
| FloorTypeId | Floor Type Id | int | vr_FloorType |
| FloorUniqueId | Floor Unique Id | nvarchar | |
| GISFeatureClassId | GIS Feature Class Id | int | |
| HasPopupMessage | Indicates if the Floor Record has a Popup Message or Not | int | |
| Id | Floor Id | int | |
| Image | Image | nvarchar | |
| Latitude | Latitude | float | |
| LegacyCode | Legacy Code | nvarchar | |
| Longitude | Longitude | float | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| Name | Floor Name | nvarchar | |
| Number | Floor Number | nvarchar | |
| PopupMessage | Popup Message | nvarchar | |
| PreventArchival | Indicates if the Prevent Archival Checkbox is checked or Not | bit | |
| RegionCode | Region Code | nvarchar | |
| RegionId | Region Id | int | vr_region |
| RegionName | Region Name | nvarchar | |
| TagNumber | Tag Number | nvarchar | |
| UniqueId | Floor Unique Id | nvarchar | |
| UsableSquareFootage | Usable Square Footage | decimal | |
| Value | Value | nvarchar |