RecruitingCandidateDuplicates

Columns


Name	Type	Description
DupChkLogId [KEY]	Long	Unique identifier for the candidate duplicate check.
PersonId	Long	Person ID of the candidate for which a duplicate candidate check was done.
DupStrength	String	Match score obtained for the candidate duplicate check.
DupStrengthCount	Long	Number of duplicate candidates that have the highest match score.
RequestedBy	String	User who initiated the candidate duplicate check.
RequestedOn	String	Date and time when the candidate duplicate check was initiated.
SubmissionId	Long	Job application ID for which a candidate duplicate check was automatically triggered.
StateId	Long	State ID when the candidate duplicate check was automatically triggered.
PhaseId	Long	Phase ID when the candidate duplicate check was automatically triggered.

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