RecruitingCEJobRequisitionsrequisitionList

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId [KEY]	Long	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the job requisition list.
Title	String	Title of the requisition list.
ShortDescription	String	Short description of the requisition list.
PostedDate	Datetime	Date of posting of the requisition list.
MediaThumbURL	String	Media thumb URL for the job requisition list.
ShortDescriptionStr	String	Short description string of the requisition list.
PrimaryLocation	String	Primary location of the requisition list.
PrimaryLocationCountry	String	Country of the primary location of the requisition list.
GeographyId	Long	Geography ID of the job requisition list.
Distance	Double	Total distance from the center of a radius search.
HotJobFlag	Bool	Indicates whether the job requisition is considered a hot job.
TrendingFlag	Bool	Indicates whether the job requisition has a high number of job applications and should be displayed as trending.
BeFirstToApplyFlag	Bool	Indicates whether the job requisition has a low number of job applications and should invite candidates to be the first to apply.
Relevancy	Double	Relevancy score of the job requisition.
WorkplaceTypeCode	String	Code of the workplace type of the job requisition.
WorkplaceType	String	Label of the workplace type of the job requisition.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
SearchId	Long	SearchId
CandidateNumber	String	candidateNumber
CorrectedKeyword	String	correctedKeyword
ExecuteSpellCheckFlag	String	executeSpellCheckFlag
FacetsList	String	facetsList
Finder	String	finder
JobFamilyId	String	jobFamilyId
Keyword	String	keyword
LastSelectedFacet	String	lastSelectedFacet
Latitude	String	latitude
Limit	Long	limit
Location	String	location
LocationId	String	locationId
Longitude	String	longitude
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