Supported Entities and Operations
- Entity: Table representing a business entity
- Join: A mapping between any two Entity type tables, a parent table
and any of its child tables.Note: Links are not present between tables in the physical model schema derived from a SuccessFactors connection. This is because foreign keys are not present in SuccessFactors tables, and joins between tables are indicated by Join type tables in the Spectrumâ„¢ Technology Platform.
- The name of a Join table indicates the two Entity tables which have been mapped together.
- Each record of a Join table contains the primary key from the parent
entity and the columns of the respective child entity. Thus the particular parent
entity's primary key is mapped to the child entity's details. For example,
User#HR
is a Join table in whichUser
is the parent entity andHr
is the child entity. This join represents all the users and their respective HR representatives. The join tableUser#HR
, therefore, has the parent tableUser
's primary keyUserId
, which is mapped to the columns of the child tableHR
, such ashr_userId
,hr_username
, andhr_email
. - In case of Join tables, the
insert
andupdate
functions work like theupsert
function. This is because Join tables are not actual entities in SuccessFactors, but are mappings between entities and their navigation properties or child tables.To
insert
orupdate
any Join table, the parent entity is updated, while in child table, a new record is inserted or the existing record is updated corresponding to the parent record.Note: While updating, the mapping between a parent and a child is modified. It is also possible to modify the individual attributes of the child as required.