Examples of Loading Candidate Pool
This topic provides examples that show how to load candidate pools.
Creating Candidate Pools
This example CandidatePool.dat file creates private, shared, and global candidate pools and adds candidates to it.
METADATA|CandidatePool|PoolName|PoolTypeCode|Description|Status|SourceSystemOwner|SourceSystemId|OwnerPersonNumber|JobSetCode|JobCode|DepartmentName|OwnershipType|SourceSystemId|SourceSystemOwner
MERGE|CandidatePool|POOL-1|CANDIDATE|POOL_Private|A|HRC_SQLLOADER|POOL-ID1|POOLOWNER01|COMMON|ZFRCE ZB Analyst|ZFRCE Executive Office|ORA_PRIVATE|POOL-1|HRC_SQLLOADER
MERGE|CandidatePool|POOL-2|CANDIDATE|POOL_Shared|A|HRC_SQLLOADER|POOL-ID2|POOLOWNER01|COMMON|ZFRCE ZB Analyst|ZFRCE Executive Office|ORA_SHARED|POOL-2|HRC_SQLLOADER
MERGE|CandidatePool|POOL-3|CANDIDATE|POOL_Global|A|HRC_SQLLOADER|POOL-ID3|POOLOWNER01|COMMON|ZFRCE ZB Analyst|ZFRCE Executive Office|ORA_PUBLIC|POOL-3|HRC_SQLLOADER
METADATA|CandidatePoolOwner|FavoriteFlag|OwnerPersonNumber|PoolName|PoolStatus|SourceSystemId|SourceSystemOwner
MERGE|CandidatePoolOwner|Y|ZFRCE071_ZBEN|POOL-2|A|POOLOWNER01|HRC_SQLLOADER
METADATA|CandidatePoolMember|CurrentPhaseId|CurrentStateId|CandidateNumber|PoolName|Status|PoolMemberStatus|SourceSystemId|SourceSystemOwner
MERGE|CandidatePoolMember|55|551|CAN001|POOL-1|A|ACTIVE|POOL-MEMID-1|HRC_SQLLOADER
MERGE|CandidatePoolMember|66|662|CAN002|POOL-1|A|ACTIVE|POOL-MEMID-2|HRC_SQLLOADER
MERGE|CandidatePoolMember|55|551|CAN002|POOL-2|A|ACTIVE|POOL-MEMID-3|HRC_SQLLOADER
MERGE|CandidatePoolMember|66|662|CAN003|POOL-2|A|ACTIVE|POOL-MEMID-4|HRC_SQLLOADER
MERGE|CandidatePoolMember|55|551|CAN003|POOL-3|A|ACTIVE|POOL-MEMID-5|HRC_SQLLOADER
Adding Candidates to an existing Candidate Pool
This example CandidatePool.dat file adds a candidate to an existing candidate pool.
METADATA|CandidatePoolMember|CurrentPhaseId|CurrentStateId|CandidateNumber|PoolName|Status|PoolMemberStatus|SourceSystemId|SourceSystemOwner
MERGE|CandidatePoolMember|55|551|CAN001|POOL-3|A|ACTIVE|POOL-MEMID-6|HRC_SQLLOADER
Deleting Candidates from Candidate Pool
This example CandidatePool.dat file deletes a candidate from a candidate pool.
METADATA|CandidatePoolMember|CurrentPhaseId|CurrentStateId|CandidateNumber|PoolName|Status|PoolMemberStatus|SourceSystemId|SourceSystemOwner
DELETE|CandidatePoolMember|55|551|CAN002|POOL-1||ACTIVE|POOL-MEMID-2|HRC_SQLLOADER