Navigating Employee Central Data

Advanced Reporting consists of categories, tables, and columns:

• Categories consist of tables and columns grouped around a particular subject or concept - for example, employment, compensation, and person. A category is selected from the upper-left dropdown list on the Query Designer.
• Tables can be blocks, sections within blocks, Foundation Objects, or Metadata Framework Objects. Tables are identified by a > , which helps you expand and view all the columns under it. Choose the arrow to the right to continue navigating to related tables.
• Columns are fields or cells contained within the table.

Navigate to the Employment category by selecting it from the top dropdown. Alternatively, start typing employment into the dropdown. Select this category and its main table will appear, Global Job Information:

The Global Job Information table contains data typically found in the Job Information section of the Job Information block:

Additionally, the Global Job Information table contains the employees most current name (first, middle, last) found in the Personal Information section of the Personal Information block:

Opening Global Job Information will reveal more tables that contain data relating to an employee’s employment. Bold type indicates a group of tables.

• Foundation Objects: Contains the foundation objects that are relevant to the employee's Employment (for example, cost center, business unit, division, event)
• Incumbent Position: Contains the Position details that are relevant if the employee is nominated as a Position Incumbent
• Position: Contains the Position details that are relevant to the employee's current position
• Benefit, Compensation, Advances, Deduction: Contains the different compensation details that are relevant to the employee
• Person: Contains the personal details for the employee (for example, date of birth, gender)
• Time Off: Contains the absence/time off details for the employee

• Address: Contains the address details that are relevant to the employee
• Employment Details: Contains the standard assignment details that are relevant to the employee
• Global Assignment: Contains the global assignment details that are relevant to the employee
• Supervisor Global Job Information: Contains the employee's supervisor employment details
• Job Information (): Contains the country specific information for the employee's job (for example, EEO, FLSA)
• Job Relationships: Contains the relationships that are defined for an employee (for example, HR Manager)
• Pension Payments: Contains the pension details for the employee

Drilling deeper into the Global Job Information tree will reveal more tables and columns. These tables and columns will contain information relating to their parent table - for example, expanding related tables on the Global Job Information will reveal the Global Job Information for the supervisor, and opening the Global Job Information for the supervisor will reveal the Global Job Information for the supervisor’s supervisor:

Consider the following example: expand related tables on the Global Job Information, which will reveal the employee's accompanying dependent. Opening the Accompanying Dependent will reveal the biographical and personal information about the Accompanying Dependent - as shown in this figure:

Consider the following example: Expand related tables on Global Job Information, which will reveal the employee's position. Opening the position will reveal the positions parent details:

Person stores all information about an employee that relates to them as a person - including their name, date of birth, and gender. Other personal information includes (for example):

• Nationality and birthplace
• Marital status
• Preferred language
• Title (if applicable)
• Citizenship, visa and/or national ID information
• Emergency contacts
• Work eligibility information
• Phone, address, and email information

As with the Employment category, the Person category will allow users to "drill through" to information about the employee that is found in other categories, such as hire date, employment status (found in the Employment category) , and compensation details like advances and spot bonuses (found in the Compensation category).

Person - Main Tables

Navigate to the Person category by selecting it from the top dropdown list. Alternatively, start typing person into the dropdown list. Select this category and its main tables will appear:

Person > Personal Information

The Personal Information table contains data typically found in the Personal Information and Biographical Information sections of the Personal Information block:

Opening Personal Information will reveal more tables that contain data relating to an employee’s Person. Bold type indicates a group of tables.

• Foundation Objects: Contains the foundation objects that are relevant to the employee's Person (for example, Territory)
• Employment: Contains the employment details that are relevant to the employee (refer to further detail in the Employment Category section of this document)

• Corporate/Home Address: Contains employee details about the corporate/business, home, vacation address, and so on
• Dependents/Emergency Contacts: Contains the details of any dependents and emergency contacts the employee may have
• Email/Phone Information: Contains the employee's email addresses and phone numbers
• Global Information: Contains the employee's global "person" information (for example, Person ID, User ID, Territory)
• National ID/Document Information ()/Work Permit Info: Contains visa, citizenship and any other documents relating to the employee
• Social Accounts: Contains the details for any social media accounts the employee might hold (for example, Twitter, Instagram, and so on)

Where applicable, drilling deeper into some tables will reveal country-specific tables – identifiable by the country code in parentheses. Expanding related tables on the Global Information (Global) table (for example), will reveal the country-specific tables for the same. Here, we can see that the country-specific columns for Brazil (Global Info (BRA)) are Naturalized Citizen and Race; whereas for the USA (Global Info (USA), they are for Veterans data: