RecruitingCEJobRequisitionsrequisitionListprimaryLocationCoordinates

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId [KEY]	Long	Finds job requisitions using a search ID and a primary key
Latitude	Int	Latitude of primary location coordinates of the requisition details.
Longitude	Int	Longitude of primary location coordinates of the requisition details.
CountryCode	String	Country code of the primary location coordinates of the requisition details.
GeographyId [KEY]	Long	Geography ID of primary location coordinates of the requisition details.
GeographyNodeId [KEY]	Long	Geography ID of primary location coordinates of the requisition details.

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