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_USERTYPE_SUBSCRIP

Product:	JTF - CRM Foundation
Description:	Intersection table storing the enrollments that should be available to each usertype..
Implementation/DBA Data:	JTF.JTF_UM_USERTYPE_SUBSCRIP

Primary Key: JTF_UM_USERTYPE_SUBSCRIP_PK

USERTYPE_ID
SUBSCRIPTION_ID
EFFECTIVE_START_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_UM_USERTYPE_SUBSCRIP		JTF_UM_USERTYPES_B	JTF_UM_USERTYPE_SUBSCRIP.USERTYPE_ID
JTF_UM_USERTYPE_SUBSCRIP		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_ID