FND Design Data [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: TableJTF.JTF_UM_SUBSCRIPTION_REG
Primary Key: JTF_UM_SUBSCRIPTION_REG_PK
  1. ColumnSUBSCRIPTION_REG_ID
Primary Key: JTF_UM_SUBSCRIPTION_REG_U1
  1. ColumnSUBSCRIPTION_ID
  2. ColumnUSER_ID
  3. ColumnEFFECTIVE_START_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_UM_SUBSCRIPTION_REG FK Joins to TableJTF_UM_SUBSCRIPTIONS_B JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_REG FK Joins to TableFND_USER JTF_UM_SUBSCRIPTION_REG.USER_ID
JTF_UM_SUBSCRIPTION_REG FK Joins to TableWF_ITEMS JTF_UM_SUBSCRIPTION_REG.WF_ITEM_TYPE
JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID
JTF_UM_SUBSCRIPTION_REG FK Joins to TableFND_USER JTF_UM_SUBSCRIPTION_REG.APPROVER_USER_ID