Organization Levels Data Mapping

Vantagepoint organization settings are mapped to Talent Management organization levels (Company, Division, and Department).

Data initialization will populate the organizational structure in Talent Management with the organization codes and subcodes from Vantagepoint.

The organization that is selected for an employee record in Talent Management must match an existing organization in Vantagepoint. If it does not, Vantagepoint will reject the record.

After the initial import of organization data from Vantagepoint into Talent Management, make sure to select a fully-qualified organization (a lowest-level organization) in Vantagepoint for the employee. Changes on the organizational structure will be reflected in Talent Management on the next data transfer.

Talent Management Destination Vantagepoint Source
org_level_code Top Level (Company) is mapped to the company that is designated as the Orglevel=1 in CFGOrgCodesData table.

Fully qualified organizations, or those lower-level organizations that have a parent organization, are mapped to the level-2 organizations, level-3 organizations, and so on in the Vantagepoint Organization table. When the data is passed on to the Talent Management application, Vantagepoint determines the parent relationship based on the organizational code and the delimiter.

For example, 0A:01:02 means that in Vantagepoint, 0A is the organizational code of Orglevel =1, 01 is the organizational code of the level-2 organization, and 02 is the organizational code of the level-3 organization.

org_level_name
  • For organizations that use the multicompany feature:

    Top Level (Company) is mapped to the label of the company designated as Orglevel = 1 with the organization code appended. For example, Company A (0A).

    Fully qualified organizations are mapped to the name of the organization with the organizational code appended. For example, Accounting Department (0A:01:02)

  • For organizations that do not use the multicompany feature and that have organizations:

    Top Level (Company) is populated with 00 and the Firm Name in the Vantagepoint CFGMainData table. The organization designated as Orglevel=1 becomes the organization designated for Orglevel=2; the organization designated as Orglevel=2 becomes the organization for Orglevel=3 and so on.

  • For organizations that do not use the multicompany feature and that have no organizations:

    Top Level (Company) is populated with 00 and the Firm Name in the Vantagepoint CFGMainData table.

org_level_active Top Level (Company) and higher-level organizations are mapped to the Status of the organization in CFGOrgCodesData table.

Fully-qualified organizations are mapped to the status of the organization in Organization table.

org_level_parent_code Top Level (Company) is populated with top_level.

Fully qualified organizations are mapped to level-2, -3, and so on organizations in the Vantagepoint Organization table.

Org_level_parent_code is mapped to the organization code of the parent of the organization.