vr_Facility

Updated November 24, 2025 16:19

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Acre	Acre	decimal
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
City	City	nvarchar
Code	Facility Code	nvarchar
Comment	Comments	nvarchar
Contact	Contact	nvarchar
ContactDescription	Contact Description	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CustodialTaskLocationCode	Custodial Task Location Code	int
CustodialTaskLocationDescription	Custodial Task Location Description	int
CustodialTaskLocationId	Custodial Task Location Id	int
Description	Facility 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
Email	Email	nvarchar
FacilitySubTypeCode	Facility Sub Type Code	nvarchar
FacilitySubTypeDescription	Facility Sub Type Description	nvarchar
FacilitySubTypeId	Facility Sub Type Id	int
FacilityTypeCode	Facility Type Code	nvarchar
FacilityTypeDescription	Facility Type Description	nvarchar
FacilityTypeId	Facility Type Id	int	vr_facilityType
Fax	Fax	nvarchar
GISUniqueId	GIS Unique Id	uniqueidentifier
HasPopupMessage	Has Popup Message	int
Id	Facility Id	int
Image	Image	nvarchar
Latitude	Latitude	float
Longitude	Longitude	float
Manager	Manager	nvarchar
MobilePhone	Contact Mobile Phone #	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Facility Name	nvarchar
Phone	Phone	nvarchar
PopupMessage	Popup Message	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Prevent Archival	bit
RateScheduleActive	Rate Schedule Active	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RateScheduleWorkOrder	Rate Schedule Work Order	bit
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_region
RegionName	Region Name	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
State	State	nvarchar
TagNumber	Tag Number	nvarchar
Url	URL	nvarchar
Value	Value	nvarchar
Zip	Zip Code	nvarchar

Articles in this section