RecruitingCEJobRequisitionsrequisitionListworkLocation
RecruitingCEJobRequisitionsrequisitionListworkLocation
Columns
| Name | Type | Description |
| RecruitingCEJobRequisitionsSearchId [KEY] | Long | Finds job requisitions using a search ID and a primary key |
| LocationId [KEY] | Long | Location ID of work locations of the requisition template details previews. |
| LocationName | String | Location name of work locations of the requisition template details previews. |
| AddressLine1 | String | Address line 1 of work locations of the requisition template details previews. |
| AddressLine2 | String | Address line 2 of work locations of the requisition template details previews. |
| AddressLine3 | String | Address line 3 of work locations of the requisition template details previews. |
| AddressLine4 | String | Address line 4 of work locations of the requisition template details previews. |
| Building | String | Building of work locations of the requisition template details previews. |
| TownOrCity | String | Town or City of work locations of the requisition template details previews. |
| PostalCode | String | Postal code of work locations of the requisition template details previews. |
| Country | String | Country of work locations of the requisition template details previews. |
| Region1 | String | Region 1 of other locations of the requisition template details previews. |
| Region2 | String | Region 2 of other locations of the requisition template details previews. |
| Region3 | String | Region 3 of other locations of the requisition template details previews. |
| Latitude | Int | Latitude of work locations of the requisition template details previews. |
| Longitude | Int | Longitude of work locations of the requisition template details previews. |
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 |