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_REG

Product:	JTF - CRM Foundation
Description:	Stores the enrollments that a user has signed up for, whether approved, rejected, pending, removed.
Implementation/DBA Data:	JTF.JTF_UM_SUBSCRIPTION_REG

Primary Key: JTF_UM_SUBSCRIPTION_REG_PK

SUBSCRIPTION_REG_ID

Primary Key: JTF_UM_SUBSCRIPTION_REG_U1

SUBSCRIPTION_ID
USER_ID
EFFECTIVE_START_DATE

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_UM_SUBSCRIPTION_REG	JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_REG	FND_USER	JTF_UM_SUBSCRIPTION_REG.USER_ID
JTF_UM_SUBSCRIPTION_REG	WF_ITEMS	JTF_UM_SUBSCRIPTION_REG.WF_ITEM_TYPE JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID
JTF_UM_SUBSCRIPTION_REG	FND_USER	JTF_UM_SUBSCRIPTION_REG.APPROVER_USER_ID