Examples of Loading Prospect

This topic provides examples that show how to load prospects.

Creating Prospect

This example Prospect.dat file creates a prospect record with the attributes ContextTypeCode, ProspectStatusCode, RequisitionNumber, CandidateNumber, AddedByPegrsonNumber, AddedFromPoolName, AddedFromPoolStatus and AddedFromRequisitionNumber.

METADATA|Prospect|ContextTypeCode|ProspectStatusCode|RequisitionNumber|CandidateNumber|AddedByPersonNumber|AddedFromPoolName|AddedFromPoolStatus|AddedFromRequisitionNumber|SendInviteFlag|InactivateFlagMERGE|Prospect|ORA_CANDIDATE_POOL|ORA_ACTIVE|ReqRB|263292|ZFRCE001_ZBEN|MU_Candidate_Pool_3|A|||MERGE|Prospect|ORA_CANDIDATE_SEARCH|ORA_ACTIVE|ReqRB|262384|ZFRCE001_ZBEN|||||MERGE|Prospect|ORA_REQUISITION|ORA_ACTIVE|ReqRB|263062|ZFRCE001_ZBEN|||DV-RQ-04||

This example Prospect.dat.file creates a prospect interaction record with the attributes InteractionDate, SourceSystemId, SourceSystemOwner, RequisitionNumber, CandidateNumber, AddedByPersonNumber, Text and InteractionTypeCode.

METADATA|ProspectInteraction|InteractionDate|SourceSystemId|SourceSystemOwner|RequisitionNumber|CandidateNumber|AddedByPersonNumber|Text|InteractionTypeCodeMERGE|ProspectInteraction|2021/08/06 00:00:00|ReqRB_263292_I1|HRC_SQLLOADER|ReqRB|263292|ZFRCE001_ZBEN|test3.txt|ORA_PHONEMERGE|ProspectInteraction|2021/08/06 00:00:00|ReqRB_262384_I1|HRC_SQLLOADER|ReqRB|262384|ZFRCE001_ZBEN|test2.txt|ORA_EMAILMERGE|ProspectInteraction|2021/08/06 00:00:00|ReqRB_263062_I1|HRC_SQLLOADER|ReqRB|263062|ZFRCE001_ZBEN|test1.txt|ORA_TEXT

Adding Prospect Interaction to an existing Prospect

This example Prospect.dat file adds the prospect interaction details for a prospect using the RequisitionNumber, CandidateNumber and AddedByPersonNumber attributes.

METADATA|Prospect|ContextTypeCode|ProspectStatusCode|RequisitionNumber|CandidateNumber|AddedByPersonNumber|AddedFromPoolName|AddedFromPoolStatus|AddedFromRequisitionNumber|SendInviteFlag|InactivateFlagMERGE|Prospect|ORA_CANDIDATE_SEARCH|ORA_ACTIVE|ReqRB|262384|ZFRCE001_ZBEN|||||

METADATA|ProspectInteraction|InteractionDate|SourceSystemId|SourceSystemOwner|RequisitionNumber|CandidateNumber|AddedByPersonNumber|Text|InteractionTypeCodeMERGE|ProspectInteraction|2021/08/06 00:00:00|ReqRB_262384_I1|HRC_SQLLOADER|ReqRB|262384|ZFRCE001_ZBEN|test2.txt|ORA_EMAILMERGE|ProspectInteraction|2021/08/06 00:00:00|ReqRB_262384_I2|HRC_SQLLOADER|ReqRB|262384|ZFRCE001_ZBEN|test1.txt|ORA_TEXT

Deleting Prospect

This example Prospect.dat file soft deletes the prospect record by setting the InactivateFlag to Y.

METADATA|Prospect|ContextTypeCode|ProspectStatusCode|RequisitionNumber|CandidateNumber|AddedByPersonNumber|AddedFromPoolName|AddedFromPoolStatus|AddedFromRequisitionNumber|SendInviteFlag|InactivateFlagMERGE|Prospect|ORA_CANDIDATE_POOL|ORA_ACTIVE|ReqRB|263292|ZFRCE001_ZBEN|MU_Candidate_Pool_3|A|||Y