Supported Entities and Operations

The entities are of two types:
  • 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 features of Join tables are:
  • 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 which User is the parent entity and Hr is the child entity. This join represents all the users and their respective HR representatives. The join table User#HR, therefore, has the parent table User's primary key UserId, which is mapped to the columns of the child table HR, such as hr_userId, hr_username, and hr_email.
  • In case of Join tables, the insert and update functions work like the upsert 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 or update 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.