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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Finder | String | finder |