pamelabowne (Catholic Health Initiatives) asked a question.
How does the T_AV_CRSUBMISSION_FIELDS table join to the V_APPLICATIOS view?
Is there a db map or data dictionary
Is there a db map or data dictionary
Related Questions
Nothing found
Loading
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.4.3 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.8 Setup and Configuration Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
Check the Public Database Schema Reference. for example - https://community.rsa.com/s/article/RSA-Governance-Lifecycle-Public-Database-Schema-Reference-Guide-8-0
If you want to join between the mentioned tables, use the ID.
In T_AV_CRSUBMISSION_FIELDS, you will have the ID of the application (when OBJECT_TYPE is A, then OBJECT_ID is application's ID)
In V_APPLICATIONS use the ID column.
Thank you. This was a great help. Is there a data dictionary that includes the views and all of the tables?
Other than the guide that Boris linked, there is no other documentation mostly because these tables/views are normally not intended to be used publicly.