After you have configured this base object, you must complete the following tasks:
Configure foreign keys from this base object to the ROWID_OBJECT of the Employee base object.
Load this base object with data that describes the relationships between records.
ROWID_OBJECT
EMPLOYEE
REPORTS_TO
1
7
93
2
19
71
3
24
82
4
29
82
5
31
82
6
31
71
7
48
16
8
53
12
Note that you can define many-to-many relationships between records. For example, the employee whose ROWID_OBJECT is 31 reports to two different managers (ROWID_OBJECT=82 and ROWID_OBJECT=71), while this manager (ROWID_OBJECT=82) has three reports (ROWID_OBJECT=24, 29, and 31).
Use the EmplRepRel base object when configuring match column rules for the related records.
For example, you could create a match rule that takes into account the employee’s manager to produce more accurate matches.
This example used a REPORTS_TO field to define the relationship, but you could use piece of information to associate the records—even something more generic and flexible like RELATIONSHIP_TYPE.