vr_KeyHolder

Field NameField DescriptionData TypeFK Join
ActiveIndicates if the Record is Active or Notbit 
CodeKey Holder Codenvarchar 
CommentsCommentsnvarchar 
CreatedDateRecord Creation Datedatetime 
CreatorIdUser Id (Record Creator)intvr_users
DepartmentCodeDepartment Codenvarchar 
DepartmentIdDepartment Idintvr_Department
DepartmentNameDepartment Namenvarchar 
EmailEmailnvarchar 
FirstNameFirst Namenvarchar 
IdKey Holder Idint 
IsAuthorizerIndicates if the Key Holder is an authorizerbit 
KeyHolderNameKey Holder Namenvarchar 
LastNameLast Namenvarchar 
ModifiedDateLast Modified Datedatetime 
ModifierIdUser Id (Record Modifier)intvr_users
NameKey Holder Namenvarchar 
PhonePhonenvarchar 
PositionPositionnvarchar 
RepairCenterCodeRepair Center Codenvarchar 
RepairCenterIdRepair Center Idintvr_RepairCenter
RepairCenterNameRepair Center Namenvarchar 
SSNSocial Security Numbernvarchar 
TechnicianCodeTechnician Codenvarchar 
TechnicianFirstNameTechnician First Namenvarchar 
TechnicianIdTechnician Idintvrpt_Technician
TechnicianLastNameTechnician Last Namenvarchar 
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!