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 |