RecruitingICEJobApplications
RecruitingICEJobApplications
Columns
Name | Type | Description |
PersonId | Long | ID assigned to an internal candidate who submitted the application. |
CandidateNumber | String | Number assigned to each candidate who submits an internal job application. |
RequisitionNumber | String | Number assigned to each internal job requisition. |
ConfirmedFlag | Bool | Indicates if the internal candidate is confirmed. |
JobTitle | String | Job title of the internal candidate. |
JobLocation | String | Job location of the internal candidate. |
JobLocationName | String | Name of the job location where the internal candidate submitted the application. |
SubmissionDate | Date | Date of submission of the internal job application. |
Action | String | Action taken after each internal submission. |
SubmissionId [KEY] | Long | ID assigned for each internal job application submitted. |
Status | String | Status of the internal job application submission. |
PreferredLanguage | String | Preferred language in which the internal job application was submitted. |
ActiveFlag | Bool | Indicates if the internal submission is active. |
CurrentPhaseId | Long | ID assigned to the current phase of the internal job submission. |
CurrentStateId | Long | ID assigned to the current state of the internal job submission. |
PipelineSubmissionId | Long | ID assigned to an internal pipeline job requisition submission. |
PipelineRequisitionFlag | Bool | Indicates if the internal submission is a pipeline requisition. |
OfferId | Long | ID of the internal job offer extended for a specific job application. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |