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
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Identity Governance & Lifecycle Attribute Synchronization fails with Access Fulfillment Express (AFX) error
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.