vrpt_Technician

Updated January 20, 2026 15:37

Field Name	Field Description	Data Type	FK Join
AccountId	Account Id	int	vr_account
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
Allergies	Allergies	nvarchar
AllowSMS	Indicates if this technician record allows text messaging	bit
Badge	Badge	nvarchar
BarCoded	Bar Coded	bit
BaseDailyHour	Base Daily Hour	decimal
BloodType	Blood Type	nvarchar
BootSize	Boot Size	nvarchar
BudgetCodeId	Budget Code Id	int
ChargeRate	Charge Rate	decimal
CitizenStatusId	Citizen Status Id	int
City	City	nvarchar
CoatSize	Coat Size	nvarchar
Code	Technician Code	nvarchar
Comments	Comments	nvarchar
Comments2	Comments	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
CurrentPositionCode	Current Position Code	nvarchar
CurrentPositionDescription	Current Position Description	nvarchar
DateOfBirth	Date Of Birth	datetime
DistributionCode	Distribution Code	nvarchar
Driver	Indicates if this technician record is available as a driver	bit
EffortPercent	Effort Percent	decimal
Email	Email	nvarchar
EmergencyPhone	Emergency Phone	nvarchar
EmploymentTypeCode	Employment Type Code	nvarchar
EmploymentTypeDescription	Employment Type Description	nvarchar
EndDate	End Date	datetime
EthnicityId	Ethnicity Id	int
FirstName	First Name	nvarchar
Gender	Gender	int
GloveSize	Glove Size	nvarchar
HandHeldType	Hand Held Type	smallint
Height	Height	nvarchar
HourlyPay	Hourly Pay	decimal
Id	Technician Id	int
Image	Image	nvarchar
Immunization	Immunization	nvarchar
IsSupervisor	Inidcates if this technician record is a supervisor	bit
LastActionDate	Last Date	datetime
LastFirstName	Last Name	nvarchar
LastName	Last Name	nvarchar
LastPhysical	Last Physical	datetime
LicenseExpires	License Expires	datetime
LicenseNumber	License Number	nvarchar
MobileTMADays	Mobile TMA Days	int
MobileUserOnly	Mobile User Only	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Technician Name	nvarchar
NextOfKin	Next of Kin	nvarchar
OrganizationUnit	Organization Unit	nvarchar
OverTimeRate	Over Time Rate	decimal
PalmCode	Palm Code	nvarchar
PayCodeId	Pay Code Id	int
PayPeriodId	Pay Period Id	int
PhoneHome	Phone Home	nvarchar
PhoneMobile	Phone Mobile	nvarchar
PhonePager	Phone Pager	nvarchar
PhoneWork	Phone Work	nvarchar
PositionBaseSalary	Position Base Salary	decimal
PositionCode	Position Code	nvarchar
PositionDescription	Position Description	nvarchar
PositionId	Position Id	int
PositionPayRate	Position Pay Rate	decimal
proj_managerName	Project Manager Name	nvarchar
Relation	Relation	nvarchar
Salaried	Indicates if the technician record is on salary	bit
SalaryGradeId	Salary Grade Id	int
ShiftId	Shift Id	int	vr_Shift
SSN	Social Security Number	nvarchar
StartDate	Start Date	datetime
StateCode	State Code	nvarchar
Title	Title	nvarchar
user_login_ID	User Login Id	nvarchar
Veteran	Veteran	bit
Weight	Weight	decimal
wk_email	Technician Work Email	nvarchar
wk_fk	Technician Id	int	vrpt_Technician
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wk_phonePager	Pager Number	nvarchar
wk_phoneWork	Work Phone Number	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician
wk_supervisor_fk	Technicain Id	int	vrpt_Technician
wk_supervisorID	Technicain Code (Id)	nvarchar
wk_supervisorName	Technician Name	nvarchar
WorkGroupId	Work Group Id	int
WorkMobile	Work Mobile	nvarchar
Zip	Zip Code	nvarchar

Articles in this section