RecruitingMyJobApplications
RecruitingMyJobApplications
Columns
| Name | Type | Description |
| ConfirmedFlag | Bool | Indicates whether the job application is confirmed in opportunity marketplace. No default value. |
| SubmissionDate | Date | Job application submission date in opportunity marketplace. |
| SubmissionId [KEY] | Long | Job application ID in opportunity marketplace. |
| Status | String | Job application status in opportunity marketplace. |
| PreferredLanguage | String | Preferred language of the job application in opportunity marketplace. |
| ActiveFlag | Bool | Indicates whether the job application is active in opportunity marketplace. Default value is 1. |
| PipelineSubmissionId | Long | Pipeline job application ID in opportunity marketplace. |
| ShowWithdrawActionFlag | Bool | Indicates whether the withdraw job application action is displayed in opportunity marketplace. Default value is 1. |
| PipelineRequisitionFlag | Bool | Indicates whether the job application is a pipeline job application. Default value in 0. |
| RequisitionNumber | String | Job requisition number in opportunity marketplace. |
| Title | String | Job title in opportunity marketplace. |
| ShowJobActionFlag | Bool | Indicates whether the view job details action is displayed in opportunity marketplace. Default value is 1. |
| PrimaryJobLocation | String | Primary job location in opportunity marketplace. |
| OtherJobLocationCount | Int | Count of the other job locations in opportunity marketplace. |
| HiringManager | String | Hiring manager in opportunity marketplace. |
| Organization | String | Organization name in opportunity marketplace. |
| ActionResponseMessage | String | Response message for a job application in opportunity marketplace. |
| OfferId | Long | Job offer ID in opportunity marketplace. |
| StartDate | Date | Candidate start date in opportunity marketplace. |
| ShowOfferActionFlag | Bool | Indicates whether the view offer action is displayed in opportunity marketplace. Default value is 0. |
| HiringManagerPersonId | String | Hiring manager person ID in opportunity marketplace. |
| Action | String | Action performed on the job application in opportunity marketplace. |
| ProposedStartDateLabelFlag | Bool | Indicates whether the proposed start date is displayed in opportunity marketplace. No default value |
| JobFunction | String | Job function of the employee in Opportunity Marketplace. |
| RemoteOpportunity | String | Remote opportunity indicator in Opportunity Marketplace. |
| PrimaryWorkLocation | String | Primary work location in Opportunity Marketplace. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Active | Bool | active |
| Finder | String | finder |