RecruitingCEJobRequisitionsrequisitionListsecondaryLocations
RecruitingCEJobRequisitionsrequisitionListsecondaryLocations
Columns
Name | Type | Description |
RecruitingCEJobRequisitionsSearchId [KEY] | Long | Finds job requisitions using a search ID and a primary key |
RequisitionLocationId [KEY] | Long | Name for other work locations of the requisition template details previews. |
GeographyNodeId | Long | Geography node ID for the secondary location of the requisition template details previews. |
GeographyId | Long | Geography ID for the secondary location of the requisition template details previews. |
Name | String | Name for other work locations of the requisition template details previews. |
CountryCode | String | Country code for the secondary location of the requisition template details previews. |
Latitude | Int | Latitude of other work locations of the requisition details. |
Longitude | Int | Longitude of other work locations of the requisition details. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SearchId | Long | SearchId |
CandidateNumber | String | candidateNumber |
CorrectedKeyword | String | correctedKeyword |
ExecuteSpellCheckFlag | String | executeSpellCheckFlag |
FacetsList | String | facetsList |
Finder | String | finder |
HotJobFlag | String | hotJobFlag |
JobFamilyId | String | jobFamilyId |
Keyword | String | keyword |
LastSelectedFacet | String | lastSelectedFacet |
Limit | Long | limit |
Location | String | location |
LocationId | String | locationId |
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 |