RecruitingJobApplications
RecruitingJobApplications
Columns
| Name | Type | Description |
| JobApplicationId [KEY] | Long | Unique ID of job application. |
| CandidatePersonId | Long | ID assigned to the candidate who applied for the job. |
| CandidateName | String | Name of the candidate in the job application. |
| RequisitionId | Long | Requisition ID for a job application. |
| PhaseId | Long | ID for phase of job application. |
| PhaseName | String | Name of each phase of the job application. |
| StateId | Long | State ID for a job application. |
| StateName | String | Name of the state of a job application. |
| AppliedToOtherJobs | String | Indicates if the candidate has applied to other jobs. |
| ConfirmedFlag | Bool | Indicates confirmation of the job application. |
| DisqualifiedFlag | Bool | Indicates that the candidate is disqualified. |
| JobApplicationDate | Datetime | Date of the job application. |
| CreationDate | Datetime | Date of creation of the job application. |
| CreatedBy | String | Name of the person who created the job application. |
| LastUpdateDate | Datetime | Date when the application was last updated |
| LastUpdatedBy | String | Name of individual who last updated the job application. |
| ProfileId | Long | Profile ID of an application. |
| ApplyFlowVersionId | Long | A unique ID for each job application flow. |
| ConfirmedByPersonId | Long | ID assigned to the person who has confirmed the job application. |
| EsignDescriptionVersionId | Long | ID assigned to each electronic signature of the candidate. |
| InternalFlag | Bool | Indicates that it's an internal job application. |
| LegalDescriptionVersionId | Long | ID for legal description. |
| ProcessId | Long | Process ID of an application. |
| LastModifiedDate | Datetime | Date when the application was last modified. |
| ConfirmedDate | Datetime | Date when the job application changed from Unconfirmed to Confirmed. |
| LanguageCode | String | Code assigned for each language. |
| PublicStateId | Long | Public state ID of an application. |
| PublicStateName | String | Name of the public state of a job application. |
| SiteNumber | String | Site number of a job application. |
| HiringManagerId | Long | Hiring manager ID for a job application. |
| RequisitionIdRest | Long | Requisition ID 1 for a job application. |
| RequisitionUsageCode | String | Requisition usage code for a job application. |
| RecruiterId | Long | Recruiter ID for a job application. |
| RequisitionNumber | String | Requisition number of the job application. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EmailAddress | String | EmailAddress |
| Finder | String | finder |