vr_Requestor

Updated November 27, 2025 14:38

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
AllowAuthorization	Allow Authorization	bit
AllowChangePersonalInfo	Allow Change Personal Info	bit
AllowEvent	Allow Event	bit
AllowSMS	Allow SMS	bit
AreaActualSquareFootage	Area Square Footage	decimal
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaMailStop	Area Mail Stop	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AreaSubtypeCode	Area SubType Code	nvarchar
AreaSubtypeDescription	Area SubType Description	nvarchar
AreaSubtypeId	Area SubType Id	int
AreaTypeCode	Area Type Code	nvarchar
AreaTypeDescription	Area Type Description	nvarchar
AreaTypeId	Area Type Id	int	vr_areaType
AutoLogin	Auto Login	bit
BadgeNumber	Badge Number	nvarchar
BirthCountry	Birth Country	nvarchar
Birthdate	Birthdate	datetime
BrowseDisabled	Indicates if this record is disabled for browse windows	bit
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CanViewAnyRequest	Can View Any Request	bit
CellNumber	Cell Number	nvarchar
City	City	nvarchar
ClearInfoOnLogin	Clear Infor On Login	bit
Code	Requestor Code	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Description	nvarchar
Email	Email	nvarchar
EmergencyContact	Emergency Contact	nvarchar
EmergencyNumber	Emergency Number	nvarchar
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
Fax	Fax	nvarchar
FirstName	First Name	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FullName	Full Name	nvarchar
Gender	Gender	nvarchar
HomeCell	Home Cell	nvarchar
HomeMessageServicesId	Home Message Services Id	float
HomePhone	Home Phone	nvarchar
Id	Requestor Id	int
Intial	Intial	nvarchar
JobClass	Job Class	nvarchar
LastFirstName	Last First Name	nvarchar
LastName	Last Name	nvarchar
LicenseNumber	License Number	nvarchar
Location	Location	nvarchar
MailStop	Mail Stop	nvarchar
MaritalStatus	Marital Status	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Requestor Name	nvarchar
OpenMyPageWhileLogin	Indicates if this record is set to open to My Page on login	bit
Organization	Organization	nvarchar
PagerMessageServicesId	Pager Message Services Id	float
PagerNumber	Pager Number	nvarchar
Phone	Phone	nvarchar
PhoneExtension	Phone Extension	nvarchar
PositionCode	Position Code	nvarchar
PositionDescription	Position Description	nvarchar
PositionId	Position Id	int	vr_Position
Relationship	Relationship	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RequestorEmail	Requestor Email	nvarchar
RequestorTypeCode	Requestor Type Code	nvarchar
RequestorTypeDescription	Requestor Type Description	nvarchar
RequestorTypeId	Requestor Type Id	int
Reservations	Indicates if the requestor record is eligible to make reservations	bit
State	State	nvarchar
Status	Status	nvarchar
SystemRoleId	System Role Id	int	vt_SystemRoles
SystemRoleType	System Role Type	nvarchar
Title	Title	nvarchar
URLLogin	URL Login	nvarchar
UserAutologin	Indicates if the requestor record utilizes user auto login	bit
UserId	User Id	int	vr_users
UserLdap	Indicates if the associated user record utilizes LDAP	bit
UserLdapId	User LDAP Id	int
UserLockedOut	Indicates if the user record is locked out	bit
UserLoginID	User Login Id	nvarchar
UserPassword	User Password	nvarchar
UserPasswordChangedById	User Password Changed By Id	int	vr_users
UserPasswordChangedDate	User Password Changed Date	datetime
Value	Value	nvarchar
ViewTechComment	View Tech Comment	bit
WorkMessageServicesId	Work Message Services Id	float
Zip	Zip Code	nvarchar

Articles in this section