jobRequisitions
Returns a list of job requisitions.
Table Specific Information
Select
No filters are supported server side for this table. All criteria will be handled client side within the add-in.
For example, the following query is processed server side:
SELECT * FROM JobRequisitions
Columns
| Name | Type | References | Description |
| ItemID | String | ||
| PostingInstructionsCode | String | ||
| PostingInstructionsLongName | String | ||
| PostingInstructionsInternalIndicator | Boolean | ||
| PostingChannelID | String | ||
| PostingChannelCode | String | ||
| PostingChannelShortName | String | ||
| PostingChannelLongName | String | ||
| PostingChannelInternetAddress | String | ||
| PostingChannelExternalIndicator | Boolean | ||
| PostingChannelDefaultIndicator | Boolean | ||
| PostingInstructionsExpireDate | Date | ||
| PostingInstructionsResumeRequiredIndicator | Boolean | ||
| PostingInstructionsValidityAttestationIndicator | Boolean | ||
| PostingInstructionsPostDate | Date | ||
| LinksHref | String | ||
| LinksRel | String | ||
| LinksTitle | String | ||
| SupportedLocaleCodes | String | ||
| OpeningsNewPositionQuantity | Integer | ||
| WorkedInCountry | String | ||
| WorkerTypeCode | String | ||
| WorkerTypeShortName | String | ||
| CompanyName | String | ||
| LocationVisibleIndicator | Boolean | ||
| CompensationVisibleIndicator | Boolean | ||
| OpeningsFilledQuantity | Integer | ||
| OrganizationalUnits | String | ||
| OpeningsQuantity | Integer | ||
| EvergreenIndicator | Boolean | ||
| ProjectedStartDate | Date | ||
| ExternalIndicator | Boolean | ||
| VisibleToJobSeekerIndicator | Boolean | ||
| LieDetectorAcknowledgementIndicator | Boolean | ||
| HiringManagerID | String | ||
| HiringManagerWorkerID | String | ||
| HiringManagerGivenName | String | ||
| HiringManagerFamilyName | String | ||
| HiringManagerFormattedName | String | ||
| ClientRequisitionID | String | ||
| RequisitionEffectiveDate | Date | ||
| RequisitionShortName | String | ||
| RequisitionCode | String | ||
| JobCode | String | ||
| JobShortName | String | ||
| JobTitle | String | ||
| OccupationalClassificationsCode | String | ||
| OccupationalClassificationsShortName | String | ||
| RequisitionLocationsID | String | ||
| RequisitionLocationsPostalCode | String | ||
| RequisitionLocationsCityName | String | ||
| RequisitionLocationsCountrySubdivisionLevel1Code | String | ||
| RequisitionLocationsAddressLine1 | String | ||
| RequisitionLocationsCountryCode | String | ||
| RequisitionLocationsCode | String | ||
| RequisitionLocationsShortName | String |