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 本製品.
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 |