JobApplications
The view that returns job-application records that are captured through the ADP recruiting module. It provides applicant data that is used for candidate tracking, evaluation, and onboarding workflows.
Table Specific Information
Select
No filters are supported server side for this table. All criteria will be handled client side within the driver.
For example, the following query is processed server side:
SELECT * FROM JobApplications
Columns
| Name | Type | References | Description |
| ItemID | String | The unique identifier (Id) that is assigned to each job application record. This Id distinguishes each application within the ADP recruiting and hiring system. | |
| RequisitionID | String | The requisition Id that identifies the job opening to which the application belongs. This Id links the application record to the corresponding job requisition in ADP. | |
| RequisitionTitle | String | The title of the job requisition that is associated with the application. This title describes the position that the applicant has applied for. | |
| ClientRequisitionID | String | The client-specific requisition Id that represents the external or customer-facing identifier of the job posting. This Id is used for cross-referencing applications in integrated recruiting systems. | |
| InternalIndicator | Boolean | The indicator that specifies whether the application was submitted through an internal job posting. A value of 'true' indicates that the application was internal, while a value of 'false' indicates that it was external. | |
| ExternalIndicator | Boolean | The indicator that specifies whether the application was submitted through an external job posting. A value of 'true' indicates that the application was external, while a value of 'false' indicates that it was internal. | |
| HiringManagerID | String | The hiring manager Id that identifies the individual responsible for overseeing the job requisition. This Id links the job application to the hiring manager's record. | |
| HiringManagerWorkerID | String | The worker Id that corresponds to the hiring manager's worker profile. This Id connects the hiring manager to the broader Human Resources (HR) data within ADP. | |
| HiringManagerGivenName | String | The given name of the hiring manager who is associated with the job application. This name is used in recruiting reports and communication workflows. | |
| HiringManagerFamilyName | String | The family name of the hiring manager who is associated with the job application. This value appears in recruiting dashboards and application tracking records. | |
| HiringManagerFormattedName | String | The formatted full name of the hiring manager. This field provides a standardized name format that is used in reporting and communication templates. | |
| ApplicationEffectiveDate | Date | The date that indicates when the job application became effective in the system. This date marks when the record was first considered valid for processing. | |
| ApplicationShortName | String | The short name that represents the job application entry. This field provides a concise label used in dashboards and internal tracking. | |
| ApplicationCode | String | The code that identifies the job application type or category. This code supports reporting, grouping, and configuration of application data. | |
| ApplicationPostingChannelID | String | The Id that represents the posting channel through which the application was submitted, such as a career site or internal portal. This Id links the application to its submission source. | |
| ApplicationPostingChannelCode | String | The code that identifies the posting channel that is associated with the job application. This code supports reporting by application source. | |
| ApplicationPostingChannelShortName | String | The short descriptive name that corresponds to the posting channel code. This field provides a human-readable label for display in reports and dashboards. | |
| ApplicationSubmittedByAssociateOID | String | The associate Id that identifies the person who submitted the application. This Id links the submission to the submitting worker's profile, if applicable. | |
| ApplicationSubmittedByGivenName | String | The given name of the person who submitted the application. This value is used for internal audit and reporting purposes. | |
| ApplicationSubmittedByFamilyName | String | The family name of the person who submitted the application. This value complements the given name for reporting and recordkeeping. | |
| ApplicationSubmittedDate | Date | The date that indicates when the application was submitted to ADP. This date is used for tracking application timelines and status metrics. | |
| ApplicantID | String | The applicant Id that identifies the individual who submitted the job application. This Id links the application record to the applicant's personal and contact information. | |
| ApplicantInternalIndicator | Boolean | The indicator that specifies whether the applicant is an internal candidate. A value of 'true' indicates that the applicant is an internal worker, while a value of 'false' indicates that the applicant is external. | |
| ApplicantWotcScreeningShortName | String | The short name that represents the applicant's Work Opportunity Tax Credit (WOTC) screening status. It provides a concise label for use in eligibility and compliance reports. | |
| ApplicantWotcScreeningLongName | String | The long name that provides the full description of the applicant's WOTC screening result. This value supports compliance reporting and audit review. | |
| ApplicantWotcScreeningCode | String | The code that identifies the WOTC screening outcome or category. This code ensures consistent classification across applicant screening data. | |
| ApplicantBackgroundScreeningLongName | String | The long name that describes the applicant's background screening result. This field provides a human-readable description for compliance or HR review. | |
| ApplicantBackgroundScreeningCode | String | The code that identifies the applicant's background screening status or category. This code supports tracking and regulatory reporting. | |
| ApplicantCountryCode | String | The code that identifies the applicant's country of residence. This code supports geographic reporting and compliance validation. | |
| ApplicantCityName | String | The name of the city where the applicant resides. This information supports workforce planning and demographic analysis. | |
| ApplicantCountrySubdivisionType | String | The type of country subdivision, such as state, province, or region, that is associated with the applicant's address. This value standardizes location reporting. | |
| ApplicantCountrySubdivisionShortName | String | The short name that represents the applicant's country subdivision. It provides an abbreviated label used in reports and dashboards. | |
| ApplicantCountrySubdivisionCode | String | The code that identifies the specific country subdivision associated with the applicant's address. This code is used for location-based reporting and analysis. | |
| ApplicantAddressLine1 | String | The first line of the applicant's address. This field captures the primary street address or post-office (PO) box that is associated with the applicant's residence. | |
| ApplicantPostalCode | String | The postal code that corresponds to the applicant's address. This code supports mailing validation and geographic reporting. | |
| CommunicationLandlines | String | The applicant's landline phone number that is associated with the job application. This field stores contact details for direct communication. | |
| CommunicationMobiles | String | The applicant's mobile phone number that is associated with the job application. This field is used for messaging, verification, and recruiter contact. | |
| ApplicantGivenName | String | The applicant's given name. This name is stored as part of the personal information associated with the job application. | |
| ApplicantFamilyName | String | The applicant's family name. This value complements the given name to provide the applicant's full legal name. | |
| ApplicantFormattedName | String | The formatted full name of the applicant. This field provides a standardized name format used for communication and reporting. | |
| AppliedLocationItemID | String | The Id that represents the location to which the applicant applied. This Id links the application to the corresponding work location record in ADP. | |
| AppliedLocationCode | String | The code that identifies the work location for the applied position. This code supports reporting and location-based analytics. | |
| AppliedLocationShortName | String | The short descriptive name that represents the applied location. This field provides a human-readable label for display in reports and dashboards. |