jobRequisitions
The view that returns job requisition data for open or closed positions. It supports hiring pipeline management and alignment of workforce planning with organizational goals.
Table Specific Information
Select
No filters are supported server side for this table. All criteria will be handled client side within the component.
For example, the following query is processed server side:
SELECT * FROM JobRequisitions
Columns
| Name | Type | References | Description |
| ItemID | String | The unique identifier (Id) that represents each job requisition record. This Id distinguishes one requisition from another within ADP's recruiting and hiring system. | |
| PostingInstructionsCode | String | The code that identifies the posting instruction type (for example, Internal, External, or Both). This code determines how and where the job requisition is advertised. | |
| PostingInstructionsLongName | String | The long descriptive name that corresponds to the posting instruction code. This field provides a human-readable label for display in reports and recruiting dashboards. | |
| PostingInstructionsInternalIndicator | Boolean | The indicator that specifies whether the job posting is internal. A value of 'true' indicates that the posting is visible only to internal associates, while a value of 'false' indicates that it is open to external applicants. | |
| PostingChannelID | String | The Id that represents the posting channel through which the requisition is distributed, such as a career site, job board, or internal portal. This Id links the requisition to its posting source. | |
| PostingChannelCode | String | The code that identifies the posting channel associated with the job requisition. This code supports filtering and reporting by application source. | |
| PostingChannelShortName | String | The short descriptive name that represents the posting channel. This field provides a concise label for display in configuration interfaces and dashboards. | |
| PostingChannelLongName | String | The long descriptive name that corresponds to the posting channel code. This field provides a full, readable name for use in reports or recruiting exports. | |
| PostingChannelInternetAddress | String | The internet address (URL) of the posting channel. This field contains the web address through which applicants can access the job posting. | |
| PostingChannelExternalIndicator | Boolean | The indicator that specifies whether the posting channel is external. A value of 'true' indicates that the channel is publicly accessible, while a value of 'false' indicates that it is limited to internal audiences. | |
| PostingChannelDefaultIndicator | Boolean | The indicator that specifies whether the posting channel is the default channel for new job postings. A value of 'true' indicates that the channel is selected by default, while a value of 'false' indicates that it must be selected manually. | |
| PostingInstructionsExpireDate | Date | The date that indicates when the job posting expires. This date marks the final day the position is visible to job seekers. | |
| PostingInstructionsResumeRequiredIndicator | Boolean | The indicator that specifies whether a resume is required for the application. A value of 'true' indicates that applicants must submit a resume, while a value of 'false' indicates that it is optional. | |
| PostingInstructionsValidityAttestationIndicator | Boolean | The indicator that specifies whether the job posting requires validity attestation. A value of 'true' indicates that a validity statement is required, while a value of 'false' indicates that it is not. | |
| PostingInstructionsPostDate | Date | The date that indicates when the job requisition was posted. This date is used for tracking and reporting job-posting activity. | |
| LinksHref | String | The hyperlink reference (href) that provides a URL for accessing the job requisition or related API resource. | |
| LinksRel | String | The relationship type (such as self or parent) that defines how the linked resource relates to the current requisition. This field supports navigation within linked data structures. | |
| LinksTitle | String | The title or label of the linked resource. This field provides a descriptive name that is displayed in user interfaces or reports. | |
| SupportedLocaleCodes | String | The list of supported locale codes that are associated with the job posting. Each code represents a language or regional variant in which the requisition can be displayed. | |
| OpeningsNewPositionQuantity | Integer | The number of new positions that are created under the job requisition. This quantity indicates how many openings are to be filled through the requisition. | |
| WorkedInCountry | String | The code that identifies the country in which the position is located or worked. This code supports compliance and geographic reporting. | |
| WorkerTypeCode | String | The code that identifies the worker type for the position (for example, Full-Time, Part-Time, or Contractor). This code is used to categorize requisitions by employment type. | |
| WorkerTypeShortName | String | The short descriptive name that represents the worker type code. This field provides a readable label for display in dashboards and reports. | |
| CompanyName | String | The name of the company or legal entity that owns the job requisition. This value supports multi-company configuration and reporting. | |
| LocationVisibleIndicator | Boolean | The indicator that specifies whether the job location is visible to applicants. A value of 'true' indicates that the location is displayed on the posting, while a value of 'false' hides it from view. | |
| CompensationVisibleIndicator | Boolean | The indicator that specifies whether compensation information is displayed on the job posting. A value of 'true' indicates that compensation is visible to applicants, while a value of 'false' hides this information. | |
| OpeningsFilledQuantity | Integer | The number of positions that have been filled under this requisition. This quantity helps track progress toward fulfilling the total openings. | |
| OrganizationalUnits | String | The organizational units that are associated with the job requisition. These units define departmental ownership and reporting structure within ADP. | |
| OpeningsQuantity | Integer | The total number of openings that are available under this job requisition. This quantity reflects the total positions to be filled. | |
| EvergreenIndicator | Boolean | The indicator that specifies whether the job requisition is evergreen. A value of 'true' indicates that the requisition remains open for ongoing hiring, while a value of 'false' indicates that it has a defined closing date. | |
| ProjectedStartDate | Date | The projected start date for new hires under this requisition. This date provides hiring managers with a target onboarding timeline. | |
| ExternalIndicator | Boolean | The indicator that specifies whether the job requisition is external. A value of 'true' indicates that it is open to external applicants, while a value of 'false' indicates that it is internal only. | |
| VisibleToJobSeekerIndicator | Boolean | The indicator that specifies whether the job posting is visible to job seekers. A value of 'true' indicates that the posting is visible, while a value of 'false' indicates that it is hidden. | |
| LieDetectorAcknowledgementIndicator | Boolean | The indicator that specifies whether a lie detector acknowledgement is required for the job posting. A value of 'true' indicates that the acknowledgement is required, while a value of 'false' indicates that it is not. | |
| HiringManagerID | String | The hiring manager Id that identifies the individual that is responsible for overseeing the requisition. This Id links the requisition to the hiring manager's profile in ADP. | |
| HiringManagerWorkerID | String | The worker Id that corresponds to the hiring manager's worker profile. This Id connects the hiring manager to their employment record in the HR system. | |
| HiringManagerGivenName | String | The given name of the hiring manager that is associated with the requisition. This name appears in dashboards, reports, and communications. | |
| HiringManagerFamilyName | String | The family name of the hiring manager that is associated with the requisition. This name is displayed in reporting and applicant tracking interfaces. | |
| HiringManagerFormattedName | String | The formatted full name of the hiring manager. This field provides a standardized display name for communication and reporting. | |
| ClientRequisitionID | String | The client requisition Id that represents the external Id that is assigned by the client or external system. This Id supports data synchronization between systems. | |
| RequisitionEffectiveDate | Date | The date that indicates when the job requisition becomes effective. This date marks when the position is first valid for posting and recruiting activity. | |
| RequisitionShortName | String | The short name that represents the job requisition. This field provides a concise label that is used in dashboards, reports, and search results. | |
| RequisitionCode | String | The code that identifies the job requisition. This code supports cross-referencing and internal configuration management. | |
| JobCode | String | The code that identifies the job or position definition that is associated with the requisition. This code links the requisition to a standardized job catalog entry. | |
| JobShortName | String | The short name that represents the job code. This field provides a clear and readable label for reports and dashboards. | |
| JobTitle | String | The title of the job that is associated with the requisition. This title is displayed on postings, reports, and recruiting interfaces. | |
| OccupationalClassificationsCode | String | The code that identifies the occupational classification of the position (for example, a job family or role category). This code supports reporting and compliance tracking. | |
| OccupationalClassificationsShortName | String | The short descriptive name that represents the occupational classification code. This field provides a readable label for classification-based reports. | |
| RequisitionLocationsID | String | The Id that represents the location record that is associated with the job requisition. This Id links the requisition to the work location entry in ADP. | |
| RequisitionLocationsPostalCode | String | The postal code that corresponds to the requisition's work location. This code supports geographic reporting and applicant filtering. | |
| RequisitionLocationsCityName | String | The city name that identifies the location of the job posting. This name is displayed to applicants and used in reporting. | |
| RequisitionLocationsCountrySubdivisionLevel1Code | String | The code that identifies the first-level country subdivision (such as state or province) of the work location. This code ensures geographic accuracy in reporting. | |
| RequisitionLocationsAddressLine1 | String | The first line of the address for the requisition's work location. This field contains the primary street address or post-office box. | |
| RequisitionLocationsCountryCode | String | The code that identifies the country of the work location. This code ensures consistency in geographic reporting and compliance documentation. | |
| RequisitionLocationsCode | String | The code that identifies the work location record that is associated with the requisition. This code supports linking between requisition data and work location data. | |
| RequisitionLocationsShortName | String | The short descriptive name that represents the requisition's work location. This field provides a readable label for display in dashboards and reports. |