"Job Requisition - Basic Information"."Requisition Number" "Job Requisition - Basic Information"."Requisition Title" "Candidate Details"."Candidate Person Type" "Candidate Details"."Candidate Full Name" "Candidate Details"."Candidate Number" CAST("Job Requisition - Basic Information"."Requisition Number" AS CHAR)|| CAST("Candidate Details"."Candidate Number" AS CHAR) Candidate Details JRNCN "Job Application - Prescreening Responses"."Question Text" CAST( IFNULL(IFNULL("Job Application - Prescreening Responses"."Question Answer Text", "Job Application - Prescreening Responses"."Question Response Long Description"), "Job Application - Prescreening Responses"."Question Response Short Description") AS CHAR(400)) Job Application - Prescreening Responses Question Answer Text "Source Tracking - Source Information"."Source Name" "Source Tracking - Source Information"."Source Medium" "Job Requisition - Basic Information"."Requisition Number" "Candidate Details"."Candidate Full Name" "Job Application - Prescreening Responses"."Question Text" How did you find out about this vacancy? Pivot View