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