UltiPro Historical Reports Fields

HRIS systems offer a cross-sectional view of the organization - and its history.

With HRIS data, Knoetic can power insights into workforce planning and attrition, diversity & inclusion, and compensation trends.

For the UltiPro integrations with Knoetic, please create a cutsom report for each of the endpoints below.

Each report should contain multiple records per employee representing historical changes in data for that employee.

Employees

  • Alternate Email
  • Company code
  • Gender
  • Ethnicity
  • Location
  • Address Line 1 + Address Line 2
  • Marital Status
  • Zip Code (Formatted)
  • State
  • City
  • Country
  • Company
  • Supervisor Employee Number
  • Employee Email
  • Employee Name (Last, Suffix, First MI)
  • Employee Number
  • Employee Status Code
  • Employment Status
  • Job Code
  • Job
  • Job Family Code
  • Org Level 1 Code
  • Org Level 1
  • Org Level 2 Code
  • Org Level 2
  • Org Level 3 Code
  • Org Level 3
  • Org Level 4 Code
  • Org Level 4
  • Pay Group Code
  • Pay Group
  • Supervisor Email
  • Supervisor Name (Unsecured)
  • Work Phone (Formatted)
  • Work Extension
  • Birth Date

Employment Status

  • Company Code
  • Employee Number
  • Termination Type
  • Termination Reason
  • Termination Date
  • Eligible to Rehire
  • Effective Date
  • Employment Status Code (History)
  • Employment Status (History)
  • Employment Type
  • Employment Type Code
  • FMLA (History)
  • LOA Reason Code (History)
  • LOA Reason (History)
  • Start Date (History)
  • Stop Date (History)

Positions

  • Company Code
  • Employee Number
  • Effective Date
  • Job
  • Alternate Title
  • Job Change
  • Supervisory Name (History)
  • Supervisor Employee Number (History)

Fixed Compensation (Non-Historical)

All fields below are point-in-time.

  • Employee Number
  • Company Code
  • Annual
  • Local Currency Code
  • Original Hire Date
  • Pay Frequency
  • Date In Job

Fixed Compensation (Historical)

All fields below are historical.

  • Company Code
  • Employee Number
  • Salary or Hourly
  • Scheduled Hours
  • Local Currency Code
  • Reason
  • Reason Code
  • Piece Pay Rate
  • Percent
  • Pay Frequency
  • Pay Frequency code
  • Other Rate 4
  • Other Rate 3
  • Other Rate 2
  • Other Rate 1
  • Job Family
  • Job Family Code
  • Job
  • Job Code
  • Hourly Rate
  • Effective Date
  • Annual Rate

Security Note

Knoetic explicitly does not require personal information about employees such as:

  • Social security numbers
  • Emergency contact information
  • Credit card or bank account numbers

Please exclude these fields from your custom report. Our data integration systems will strip highly sensitive employee attributes automatically - before they ever hit our servers.


How did we do?


Powered by HelpDocs (opens in a new tab)