FND Design Data [Home] [Help]

Table: JTF_UM_USERTYPE_ROLE

Product: JTF - CRM Foundation
Description: Stores what roles are assigned to each usertype.
Implementation/DBA Data: TableJTF.JTF_UM_USERTYPE_ROLE
Primary Key: JTF_UM_USERTYPE_ROLE_PK
  1. ColumnUSERTYPE_ID
  2. ColumnPRINCIPAL_NAME
  3. ColumnEFFECTIVE_START_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_UM_USERTYPE_ROLE FK Joins to TableJTF_UM_USERTYPES_B JTF_UM_USERTYPE_ROLE.USERTYPE_ID
JTF_UM_USERTYPE_ROLE FK Joins to TableJTF_AUTH_PRINCIPALS_B JTF_UM_USERTYPE_ROLE.PRINCIPAL_NAME