Business Object Relationship Model - BORM technical details

Peoplesoft Customer Relationship Management - CRM
Customer Data Model/ BORM Tables - Transaction Data:

PS_BO
All the BOs are stored in this table irrespective of their roles,relationships

PS_BO_NAME
Name for any BO can be queried here

PS_BO_ROLE
CRM role for different Business objects (BO).e.g. Role Type 1 represents BO of type 'Person'Role Type 4 represents BO of type 'Worker'Role Type 8 represents BO of type 'Customer contact'

PS_BO_REL
This table stores the relationship between different BOs
It also store the role each BO is going to have in each relationship typee.g. Relationship Type 10 represents customer(Role 2) and customer contact(Role 8) relationshipRelationship Type 9 represents customer(Role 2) and customer Primary contact(Role 8) relationship

PS_BC
Store the customer details like start date, status date.

PS_BO_CM
This table stores the relationship between BO_ID and CM_ID. BO can have any number of contact methods like e-mail, Address, Phone - These are called Contact Method Types
Each contact mehotd may have different purpose types like Home,Business,Fax,Mobile are different purpose types under "Phone"
Actual values for the contact method purpose type is stored in the PS_CM table. This does not have BO_ID, only CM_ID

Customer Data Model/ BORM Tables - Master or Setup Data:

PS_BO_REL_TYPE
BORM relationships

PS_BO_REL_CATEGORY
This has high level identifier "Category" for grouping different relationship types together.This is an important table which is used in some delivered SQL views

PS_BO_ROLE_TYPE
BORM Roles like 1 for 'Person' , 4 for 'Worker', 17 for Account contact

PS_CM_TYPEContact Typese.g. Address/Phone/E-mail

PS_CM_PURP_TYPEe.g. Home/Business/Fax under CM_TYPE Phone

3 comments:

  1. The BORM Model relates states inside objects to the communications and sequencing. So you need for each Business Object a state/role and the the transition entity that causes a new state/role to be assumed.

    ReplyDelete
  2. Hi im eva peoplesoft consultant. I was just browsing blogs there I found your blog is interesting.. thanks for posting… keep on posting.

    ReplyDelete