RecruitingOppMktGigDetailsgigApplications

Columns


Name	Type	Description
RecruitingOppMktGigDetailsGigId [KEY]	Long	Finds gig details in opportunity marketplace using a unique ID and the gig ID.
ApplicationId [KEY]	Long	Application ID of a gig application in opportunity marketplace.
PersonId	Long	Person ID in a gig application in opportunity marketplace.
StatusCode	String	Status code of an application for a gig in opportunity marketplace.
ApplicationDate	Datetime	Application date of opportunities in Opportunity Marketplace.
Name	String	Name in a gig application in opportunity marketplace.
JobName	String	Job name in a gig application in opportunity marketplace.
OrganizationName	String	Organization name of the candidate in opportunity marketplace.
LocationName	String	Location name of the candidate in opportunity marketplace.
CompletedGigCount	Int	Number of gigs completed by a candidate in opportunity marketplace.
IsRecommendedFlag	Bool	Flag denoting whether this candidate was a recommended candidate in opportunity marketplace.

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