vrpt_keyAccessLockLocation

This view displays all keys in the application along with the Lock and Location data associated with them. It displays the same information as the Keys > Access Tab.

Field nameField descriptionData typeFK Join
KeyIdID for the Keyint 
KeyCodeCode assigned to the Keynvarchar 
KeyDescriptionDescription for the Keynvarchar 
LockCodeCode for the Lock that the Key has access tonvarcharf_keyLock
LockDescriptionDescription of the Lock that the Key has access tonvarchar 
LocationIdID of the  Lock Locationnvarcharf_area
LocationDescriptionDescription of the Lock Locationnvarchar 
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!