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 |