eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: JTF_RS_ROLE_RELATIONS

Product:	JTF - CRM Foundation
Description:	This table stores the association between resources and roles. Primary key is Resource_id and Role_id. Each resource can be assigned to multiple roles.
Implementation/DBA Data:	JTF.JTF_RS_ROLE_RELATIONS

Primary Key: JTF_RS_ROLE_RELATIONS_PK

ROLE_RELATE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_RS_ROLE_RELATIONS	JTF_RS_ROLES_B	JTF_RS_ROLE_RELATIONS.ROLE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_RESOURCE_EXTNS	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_TEAMS_B	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_TEAM_MEMBERS	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_GROUPS_B	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_GROUP_MEMBERS	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_OBJECTS_B	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE
JTF_RS_ROLE_RELATE_AUD	JTF_RS_ROLE_RELATIONS	JTF_RS_ROLE_RELATE_AUD.ROLE_RELATE_ID