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_UM_SUBSCRIPTION_ROLE

Product:	JTF - CRM Foundation
Description:	Intersection table which defines what roles are attached to each enrollment.
Implementation/DBA Data:	JTF.JTF_UM_SUBSCRIPTION_ROLE

Primary Key: JTF_UM_SUBSCRIPTION_ROLE_PK

SUBSCRIPTION_ID
PRINCIPAL_NAME
EFFECTIVE_START_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_UM_SUBSCRIPTION_ROLE		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_ROLE.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_ROLE		JTF_AUTH_PRINCIPALS_B	JTF_UM_SUBSCRIPTION_ROLE.PRINCIPAL_NAME