FND Design Data [Home] [Help]

Table: JTF_UM_USERTYPE_REG

Product: JTF - CRM Foundation
Description: Stores what usertype a user has been registered as.
Implementation/DBA Data: TableJTF.JTF_UM_USERTYPE_REG
Primary Key: JTF_UM_USERTYPE_REG_PK
  1. ColumnUSERTYPE_REG_ID
Primary Key: JTF_UM_USERTYPE_REG_U1
  1. ColumnUSERTYPE_ID
  2. ColumnUSER_ID
  3. ColumnEFFECTIVE_START_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_UM_USERTYPE_REG FK Joins to TableJTF_UM_USERTYPES_B JTF_UM_USERTYPE_REG.USERTYPE_ID
JTF_UM_USERTYPE_REG FK Joins to TableFND_USER JTF_UM_USERTYPE_REG.USER_ID
JTF_UM_USERTYPE_REG FK Joins to TableWF_ITEMS JTF_UM_USERTYPE_REG.WF_ITEM_TYPE
JTF_UM_USERTYPE_REG.USERTYPE_REG_ID
JTF_UM_USERTYPE_REG FK Joins to TableFND_USER JTF_UM_USERTYPE_REG.APPROVER_USER_ID