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 |