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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。