RecruitingCEJobRequisitions
RecruitingCEJobRequisitions
Columns
| Name | Type | Description |
| SearchId [KEY] | Long | Name for other work locations of the requisition template details previews. |
| Keyword | String | Keyword used to search for job requisitions. |
| CorrectedKeyword | String | Corrected keyword used for searching, based on the spell check result. |
| UseExactKeywordFlag | Bool | Indicates whether the exact keyword is used for searching or if the keyword is automatically spell checked and corrected. |
| SuggestedKeyword | String | Suggested keyword based on spell check result. |
| ExecuteSpellCheckFlag | Bool | Indicates whether a spell check was requested for the keyword. |
| Location | String | Location of the job requisition |
| LocationId | String | ID assigned to the location of the job requisition. |
| Radius | Long | Radius of the job requisition. |
| RadiusUnit | String | Unit of the radius of the job requisition. |
| SelectedTitlesFacet | String | Facet of the selected title of job requisitions. |
| SelectedCategoriesFacet | String | Facet of the selected categories of the job requisitions. |
| SelectedPostingDatesFacet | String | Facet of the selected dates of job posting. |
| SelectedLocationsFacet | String | Facet of the selected locations of the job requisitions. |
| LastSelectedFacet | String | Last selected facet for retrieving job requisitions. |
| Facets | String | Facets of the job requisitions. |
| Offset | Long | Offset of the job requisition |
| Limit | Long | Limit of the job requisition. |
| SortBy | String | Sort by attribute for the job requisition. |
| TotalJobsCount | Long | Total job count for the job requisition. |
| Latitude | Double | Latitude of the location of job requisition. |
| Longitude | Double | Longitude of the location of the job requisition |
| SiteNumber | String | Site number of the job requisition. |
| JobFamilyId | String | ID assigned to the job family. |
| PostingStartDate | String | Start date of the job posting. |
| PostingEndDate | String | End date of the job posting. |
| SelectedWorkLocationsFacet | String | Facet of the selected work locations. |
| RequisitionId | Long | ID assigned to the similar job |
| CandidateNumber | String | ID assigned to each candidate |
| WorkLocationZipCode | String | ZIP code of the work location. |
| WorkLocationCountryCode | String | Country code of the work location. |
| SelectedFlexFieldsFacets | String | Facets of the selected job requisitions flexfields. |
| OrganizationId | String | Organization ID for a job requisition. |
| SelectedOrganizationsFacet | String | Facet of the selected organizations of the job requisitions. |
| UserTargetFacetName | String | Name of the facet for which the value list must be filtered by the input term. |
| UserTargetFacetInputTerm | String | Term used to filter facet values. |
| HotJobFlag | Bool | Indicates whether the job requisition is considered a hot job and pertains to a published job. |
| SelectedWorkplaceTypesFacet | String | Facet of the selected workplace type. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FacetsList | String | facetsList |
| Finder | String | finder |