CANDIDATE_CODE is a mandatory field which provides a code to identify the candidate. Candidates may be external to the company (i.e. job applicants) or internal (employees). This field is automatically filled in with an 'X' and the ID of the record for external candidates and the person code for internal candidates.
Gaps in the chain of 'Xnnnn' candidate codes can happen for several reasons including the use of records/IDs for internally hired people.
