RecruitingCEJobRequisitionsrequisitionLocationsCoordinateslocationCoordinates
RecruitingCEJobRequisitionsrequisitionLocationsCoordinateslocationCoordinates
Columns
| Name | Type | Description |
| RecruitingCEJobRequisitionsSearchId [KEY] | Long | Finds job requisitions using a search ID and a primary key |
| LocationId | Long | Location ID of the requisition locations coordinates. |
| LocationType | String | Location type of the requisition locations coordinates. |
| Latitude | String | Latitude of the requisition locations coordinates. |
| Longitude | String | Longitude of the requisition locations coordinates. |
| AddressLine1 | String | Address line 1 of the requisition locations coordinates. |
| Building | String | Building of the requisition locations coordinates. |
| Country | String | Country of the requisition locations coordinates. |
| Name | String | Name of the requisition locations coordinates. |
| PostalCode | String | Postal code of the requisition locations coordinates. |
| Region1 | String | Region 1 of the requisition locations coordinates. |
| Region2 | String | Region 2 of the requisition locations coordinates. |
| Region3 | String | Region 3 of the requisition locations coordinates. |
| TownOrCity | String | Town or city of the requisition locations coordinates. |
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 |
| 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 |