RecruitingCEJobRequisitionsrequisitionList
RecruitingCEJobRequisitionsrequisitionList
Columns
| Name | Type | Description |
| RecruitingCEJobRequisitionsSearchId [KEY] | Long | Finds job requisitions using a search ID and a primary key |
| Id | String | ID assigned to the job requisition list. |
| Title | String | Title of the requisition list. |
| ShortDescription | String | Short description of the requisition list. |
| PostedDate | Datetime | Date of posting of the requisition list. |
| MediaThumbURL | String | Media thumb URL for the job requisition list. |
| ShortDescriptionStr | String | Short description string of the requisition list. |
| PrimaryLocation | String | Primary location of the requisition list. |
| PrimaryLocationCountry | String | Country of the primary location of the requisition list. |
| GeographyId | Long | Geography ID of the job requisition list. |
| Distance | Double | Total distance from the center of a radius search. |
| HotJobFlag | Bool | Indicates whether the job requisition is considered a hot job. |
| TrendingFlag | Bool | Indicates whether the job requisition has a high number of job applications and should be displayed as trending. |
| BeFirstToApplyFlag | Bool | Indicates whether the job requisition has a low number of job applications and should invite candidates to be the first to apply. |
| Relevancy | Double | Relevancy score of the job requisition. |
| WorkplaceTypeCode | String | Code of the workplace type of the job requisition. |
| WorkplaceType | String | Label of the workplace type of the job requisition. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SearchId | Long | SearchId |
| CandidateNumber | String | candidateNumber |
| CorrectedKeyword | String | correctedKeyword |
| ExecuteSpellCheckFlag | String | executeSpellCheckFlag |
| FacetsList | String | facetsList |
| Finder | String | finder |
| JobFamilyId | String | jobFamilyId |
| Keyword | String | keyword |
| LastSelectedFacet | String | lastSelectedFacet |
| Latitude | String | latitude |
| Limit | Long | limit |
| Location | String | location |
| LocationId | String | locationId |
| Longitude | String | longitude |
| Offset | Long | offset |
| OrganizationId | String | organizationId |
| PostingEndDate | String | postingEndDate |
| PostingStartDate | String | postingStartDate |
| Radius | Long | radius |
| RadiusUnit | String | radiusUnit |
| RequisitionId | Long | requisitionId |
| SelectedCategoriesFacet | String | selectedCategoriesFacet |
| SelectedFlexFieldsFacets | String | selectedFlexFieldsFacets |
| SelectedLocationsFacet | String | selectedLocationsFacet |
| SelectedOrganizationsFacet | String | selectedOrganizationsFacet |
| SelectedPostingDatesFacet | String | selectedPostingDatesFacet |
| SelectedTitlesFacet | String | selectedTitlesFacet |
| SelectedWorkLocationsFacet | String | selectedWorkLocationsFacet |
| SelectedWorkplaceTypesFacet | String | selectedWorkplaceTypesFacet |
| SiteNumber | String | siteNumber |
| SortBy | String | sortBy |
| UseExactKeywordFlag | String | useExactKeywordFlag |
| UserTargetFacetInputTerm | String | userTargetFacetInputTerm |
| UserTargetFacetName | String | userTargetFacetName |
| WorkLocationCountryCode | String | workLocationCountryCode |
| WorkLocationZipCode | String | workLocationZipCode |