RecruitingOppMktOpportunitiesopportunityList

Columns


Name	Type	Description
RecruitingOppMktOpportunitiesSearchId [KEY]	Long	Finds opportunities in opportunity marketplace using a unique ID and a search ID.
OpportunityId [KEY]	Long	Opportunity ID in the opportunity list in opportunity marketplace.
OpportunityType	String	Opportunity type in the opportunity list in opportunity marketplace.
OpportunityNumber	String	Opportunity number in the opportunity list in opportunity marketplace.
Title	String	Title in the opportunity list in opportunity marketplace.
Location	String	Location in the opportunity list in opportunity marketplace.
PostedDate	Date	Posted date in the opportunity list in opportunity marketplace.
RemoteOpportunityFlag	Bool	Indicates whether the opportunity is a remote working opportunity in opportunity marketplace. Default value is 0.

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