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 |