Tableau Connector for ADP

Build 26.0.9770

JobApplicationsEmploymentHistory

The view that returns the position history records that are associated with job applicant employment history. It supports candidate background review by exposing prior employer details, position titles, responsibilities, and reasons for leaving within the ADP recruiting module.

Columns

Name Type References Description
ApplicationItemID String The unique identifier that links the position history record back to its parent job application. This Id associates each position entry with the specific application in ADP recruiting.
EmployerName String The name of the employer where the applicant worked. This value is entered by the applicant as part of their employment history during the job application process.
EmploymentStartDate Date The date that marks the beginning of the applicant's tenure at the employer. This date is used to calculate the duration of employment and verify work history.
EmploymentEndDate Date The date that marks the end of the applicant's tenure at the employer. This date is empty when the employer is the applicant's current place of employment.
CurrentEmployerIndicator Boolean The indicator that specifies whether the employer is the applicant's current place of employment. A value of true means the applicant is presently employed at this organization.
EmployerCityName String The city name that is associated with the employer's address. This value identifies the geographic location of the employer within the applicant's employment history.
EmployerStateCode String The state or province code that identifies the first-level country subdivision of the employer's address. This code is used to determine the regional jurisdiction associated with the employment record.
EmployerCountryCode String The ISO country code that identifies the country in which the employer is located. This code supports international employment history records within ADP recruiting.
EmployerPostalCode String The postal code that is associated with the employer's address. This value narrows the geographic location of the employer to a specific mail delivery zone.
PositionTitle String The title of the position that the applicant held at the employer. This value is drawn from the position history within the applicant's employment record.
ReasonForLeaving String The reason that the applicant left the position at the employer. This value is sourced from the position history and is used during background review to assess employment transitions.
Responsibilities String The description of the job responsibilities that the applicant held in the position. This value is drawn from the position history entries and supports skills and experience evaluation during the candidate review process.
ReportsToFormattedName String The formatted name of the person that the applicant reported to in the position. This value identifies the reporting relationship within the position history record.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770