O racle C ustom er R elationship M anagem ent Foundation - R elease 11i.

7
Logical D ata M odel
is of

PARTY INTERNAL ORGANIZATION

has has
BUSINESS BUSINESS
GROUP PARTY ORGANIZATION PARTY PERSON PARTY LEGAL has OPERATING belongs to BUSINESS APPLICATION defined for APPLICATION
ENTITY of UNIT owns GROUP TRANSACTION include

has has refer TYPE

has could be is a manages is located customer has
contact object subject of owner of assigned to referenced by assigned to
for for of

has object has

subject
managed by

CALENDAR SUPPLIER PARTY RELATIONSHIP

CALENDAR
EXCEPTION assigned to
CALENDAR CALENDAR CUSTOMER contains
EXCEPTION used by EXCEPTION references
(JTF) ACCOUNT involve
owned by
CATEGORY categorized by has ASSIGNMENT include include PARTY AGENT for has
include
has for has customer for TERRITORY ASSIGNMENT BUSINESS TERRITORY
is included in BUSINESS
include ORGANIZATION RULE APPLICATION APPLICATION TRANSACTION
used by is location for EMPLOYMENT TEMPLATE ESCALATION
belongs to
TERRITORY TERRITORY refer TERRITORY TERR TYPE TYPE ASSIGN
is a
CUSTOMER PARTY SITE involve ASSIGN ASSIGN
SUPPLIER ACCOUNT SITE is a CONSORTIUM used by used by
SITE MEMBER has for
has references references has
has secondary specialist
represented by
is located at have ORGANIZATION
APPLICATION(T STANDARD TERRITORY refer
is location for
SUBSIDIARY
for for
can do an for represents assigned to
LOCATION has involve has
CALENDAR PARTY CONTACT METHOD for external resource reference include
has CALENDAR SUPPLIER could be
SHIFT SHIFT CONTACT PARTY CONTACT POINT TERRITORY TERRITORY TERRITORY TYPE
use
ASSIGNMENT QUALIFIER TYPE has TRANSACTION
for
for TYPE ASSIGN
for
has has

PARTY SITE CONTACT TERRITORY

referenced by has
for customer POINT RESOURCE
has
ASSIGNMENT referenced by
is done by for
RESULT REASON
type of CUSTOMER
ASSIGNMENT for the result of CUSTOMER belongs to
assigned to INTERACTION for for
REASON for the result of has INTERACTION references is a is secondary
specialist for external resource for
has involve
CALENDAR CALENDAR
SALES refer TERRITORY TERRITORY TYPE
SHIFT DETAIL RESOURCE PERSON contact for SALES TERRITORY TERRITORY
for used for REPRESENTATIVE TASK RESOURCE QUALIFIER VALUE QUALIFIER
ASSIGNMENT ASSIGNMENT for TRANSACTION
references (AR) ASSIGNMENT
is a EMPLOYEE has QUALIFIER
has
is a is a
has
assigned by for for
has of an could be contacted has
has
has
CUSTOMER
of an member of parent of consist of
INTERACTION
RESULT for

used for is member is parent

belongs to contact for
TASK CONTACT TASK TYPE
CUSTOMER CUSTOMER RESOURCE involve APPLICATION used for
has SALES PHONE for APPLICATION APPLICATION
INTERACTION INTERACTION AVAILABILITY involve included in OBJECT VALID defined for has
REPRESENTATIVE NUMBER OBJECT OBJECT USAGE
GROUPING SCRIPT defined in TASK TYPE has
TERRITORY referenced by
has
has for for
used for has
contain has

for customer referenced by

account
belongs to
for of an identified by
assigned to
defined for
OUTCOME has for has is a has has
CUSTOMER CUSTOMER INTERACTION ACTIVITY for has involve has
RESULT has INTERACTION has
RESOURCE (JTF) is a TASK TEMPLATE
ASSIGNMENT OUTCOME uses TASK CONTACT TASK
assigned to
for has is a is a has has for TASK (JTF) PREDETERMINED has
assigned to
POINT subtask of TASK RESOURCE has TEMPLATE
CRM RESOURCE INDIVIDUAL RESOURCE has defined for for GROUP
RESOURCE GROUP has REQUIREMENT has
TEAM has
has has
SUPPLIER CONTACT PARTY PARTNER defined for
for for task current task used by
RESOURCE RESOURCE next task

has
has for
current task
has SALES
has for for for CRM PERSON
REPRESENTATIVE RESOURCE
next task
performed is for
by RESOURCE include
for has include
involve refer refer
for for has has refer include
owner of has assigned
TASK PRIORITY referenced by
CUSTOMER INTERACTION WRAP-UP has assigned to has owner of TASK ORDER TASK
has has
DEPENDENCY RECURRENCE
referenced by
has has RULE
include involve

include
for references

has has has

for

is resource team
is member
for defined in for belongs to for TASK STATUS referenced by
referenced ADDITIONAL TASK
is done for an has has by
TEAM USAGE RESOURCE ROLE RESOURCE GROUP RESOURCE RESOURCE TASK DATE
INTERACTION PREDEFINED MARKETING ASSIGNMENT MEMBER SKILL VALUE REFERENCE for
has is resource
ACTION ITEM INTERACTION CAMPAIGN ASSIGNMENT
performed by group contains
ACTION referenced by
CODE
has
references
for
has has for for
used by defines
allowable has has
action for

assigned include for defined for

belongs to to has has
for TASK ESCALATION TASK STATUS
belong to
ATTACHMENT
for customer
ITEM CATEGORY RESOURCE INFORMATION has TRANSITION RULE
belongs to RESOURCE RESOURCE DELIVERABLE ATTACHMENT
referenced by contacted by
CAMPAIGN has ROLE MEMBER ROLE PARAMETER
INTERACTION SCHEDULE involve references
ASSIGNMENT CAMPAIGN ATTACHMENT
executed for ACTION DETAIL has

has assigned to owned by references EVENT OFFER ATTACHMENT

an item by
include
contains
is for

assigns category contains

for has from
identified method of owned
by for
RESOURCE JOB SERVICE ITEM CATEGORY SALES LEAD reference
COLLATERAL COLLATERAL CUSTOMER INTERACTION TYPE has has
ROLE REQUEST ASSIGNMENT
FULFILLMENT FULFILLMENT individual owner
contents of references reference
TEMPLATE has
TEMPLATE INTERACTION MEDIA TYPE WEB contains for NOTE DOCUMENT
DETAIL COLLABORATION categorizes NOTE TYPE SOURCE ASSIGNMENT
for contains
QUOTE CREDIT INFORMATION
for LETTER
referenced by NOTE
for

INTERACTION INTERACTION for

MEDIA TYPE MEDIA TYPE FAX references FILE URL
reference contains is categorized by assigned to
POSTAL MAIL has
has uses ITEM is the base model for
DEFECT
JOB SALES includes identified by
WORK CENTER TEXT
COLLATERAL COLLATERAL has OPPORTUNITY for
INTERACTION INTERACTION STANDARD MODEL SETUP
FULFILLMENT for FULFILLMENT has ITEM INSTRUCTION
MEDIA TYPE ATM MEDIA TYPE
DOCUMENT has REQUEST contain
WEB FORM
ENGINEERING PRODUCT used by includes
has has a base model in for
has INTERACTION INTERACTION ITEM FAMILY
NOTE TYPE
MEDIA TYPE MEDIA TYPE NOTE CONTEXT
KIOSK VOICE MAIL MANUFACTURING ITEM

INTERACTION INTERACTION
for
MEDIA TYPE MEDIA TYPE
for
EMAIL PHONE CALL
COLLATERAL COLLATERAL
FULFILLMENT belongs to FULFILLMENT
INTERACTION INTERACTION
CONTENT has REQUEST
MEDIA TYPE MEDIA TYPE FILE
HISTORY HISTORY
WEB CALLBACK COLLATERAL

INTERACTION INTERACTION
MEDIA TYPE IN MEDIA TYPE
PERSON PRINTED COLL

ER Diagram Legend
Red entities – owned by application product shown in diagram title
Green entities – owned by other application products

Copyright © 2000, 2001, 2002, Oracle Corporation. All Rights Reserved

This logical data model is subject to change without notice.