vrpt_WebTMAUserGroupXref

Field NameField DescriptionData TypeFK Join
IdUser Group Xreference Idint 
sysrole_typeSystem Role Typenvarchar 
user_activeIndicates if the User is Active or Notbit 
user_deletedIndicates if the user record is deleted or notbit 
user_emailUser Emailnvarchar 
user_first_NameUser First Namenvarchar 
user_fkUser Idintvr_Users
user_initialsUser Initialsnvarchar 
user_last_NameUser Last Namenvarchar 
user_login_IDUser Login Idnvarchar 
user_phoneUser Phonenvarchar 
user_pkUser Idintvr_users
user_rq_fkRequestor Idintvr_Requestor
user_systemrole_fkSystem Role Idintvt_SystemRoles
user_ven_fkVendor Idintvr_Vendor
user_wk_fkTechnician Idintvrpt_Technician
userGroup_descriptionUser Group Descriptionnvarchar 
userGroup_fkUser Group Idintvr_UserGroup
userGroup_nameUser Group 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!