RecruitingOppMktGigDetails
RecruitingOppMktGigDetails
Columns
Name | Type | Description |
GigId [KEY] | Long | Gig ID of a gig in opportunity marketplace. |
GigNumber | String | Gig number of a gig in opportunity marketplace. |
CreatorPersonId | Long | Person ID of the gig creator in opportunity marketplace. |
GeographyNodeId | Long | Geographical node ID of the gig location in opportunity marketplace. |
StartDate | Datetime | Start date of a gig in opportunity marketplace. |
EndDate | Datetime | End date of a gig in opportunity marketplace. |
PublishDate | Datetime | Publish date of a gig in opportunity marketplace. |
TimeCommitment | Int | Time commitment of a gig in opportunity marketplace. |
RemoteOpportunityFlag | Bool | Indicates whether the gig in opportunity marketplace is a remote opportunity. The default value is 0 |
StatusCode | String | Status code of a gig in opportunity marketplace. |
OrganizationId | Long | Organization ID of a gig in opportunity marketplace. |
Title | String | Title of a gig in opportunity marketplace. |
Description | String | Description of the gig in opportunity marketplace. |
DescriptionStr | String | Description details of a gig in opportunity marketplace. |
Location | String | Location of a gig in opportunity marketplace. |
CreatorName | String | Name of the gig creator in opportunity marketplace. |
CreatorEmail | String | Email of the gig creator in opportunity marketplace. |
CreatorPhoneNumber | String | Phone of the gig creator in opportunity marketplace. |
CreatorPosition | String | Position of the gig creator in opportunity marketplace. |
BookmarkFlag | Bool | Indicates whether a gig is bookmarked in opportunity marketplace. The default value is 0 |
HasAppliedFlag | Bool | Indicates whether someone applied to a gig in opportunity marketplace. The default value is 0. |
GigValidFlag | Bool | Indicates whether a gig is valid in opportunity marketplace. No default value. |
ProfileId | Long | Profile ID of a gig in opportunity marketplace. |
FilledCount | Int | Number filled applications for a gig in opportunity marketplace. |
OpeningsCount | Int | Number of openings for a gig in opportunity marketplace. |
PendingApprovalAppsCount | Int | Number of applications pending approval for a gig in opportunity marketplace. |
NewApplicationsCount | Int | Number of new applications for a gig in opportunity marketplace. |
NotSelectedApplicationsCount | Int | Number of applications not selected for a gig in opportunity marketplace. |
CanceledApplicationsCount | Int | Number of canceled applications for a gig in opportunity marketplace. |
CompletedApplicationsCount | Int | Number of completed applications for a gig in opportunity marketplace. |
TotalApplicationsCount | Int | Number of all the applications for a gig in opportunity marketplace. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |