===Issue Positions Expectations=== The goal of this page is establish clear metrics for successful issue positions research. These are inexact estimations due to the variance in Issue Position research available for different candidates. ||||**Experienced Staff**||**Target Intern Production**||**Weeks 2-5**||**Training Period (2 weeks)**||**Max Time per Question**|| ||**Average Time Per Candidate (Challenger)**||15 Minutes||20 Minutes||25 - 35 Minutes||30 - 40 Minutes||5 - Minutes|| ||**Average Time Per Candidate (Incumbent)**||30 Minutes||35 Minutes||40 - 50 Minutes||50 - 60 Minutes||10 - Minutes|| ||**Errors Per 5 Candidates (For Candidates With IP Data)**||0||1||2||3|||| Percentage of Determinations Made represents how successful researchers are in finding evidence & making determinations. The figure calculated is ((Determinations Made / Total Possible Determinations) * 100). To keep track of this determination rate prior to database import, you can use the formulas described in Step 3 at [[BuildingResearchSheets Building A Research Sheet]]. This running formula can be matched to the target determination rates noted in the above table. In addition, This final figure can be found for a state after an issue position sheet is imported using the following query: //SELECT state_id, y.count AS Researched_Determinations_Made, p.count AS Number_of_VE_Questions, e.count AS candidates, (p.count*e.count) AS Possible_Answers, (100*y.count/(p.count*e.count)) AS Percent_Answered FROM (SELECT COUNT (DISTINCT ec.candidate_id), e.state_id FROM election e JOIN election_candidate ec USING (election_id) JOIN electionstage_candidate esd ON ec.election_candidate_id = esd.election_candidate_id WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND electioncandidatestatus_id IN (8,11,2) GROUP BY e.state_id) e FULL OUTER JOIN (SELECT COUNT (DISTINCT np.npatrow_id), e.state_id FROM election e JOIN election_candidate ec USING (election_id) JOIN npatcandidate nc USING (election_candidate_id) JOIN npatanswer na USING (npatcandidate_id) JOIN npatmatrix nm USING (npatmatrix_id) JOIN npatrow np USING (npatrow_id) JOIN npatrowtext nt USING (npatrowtext_id) LEFT JOIN npatcitation nct USING (npatrow_id, npatcandidate_id) WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND np.profile = 't' GROUP BY e.state_id) p USING (state_id) FULL OUTER JOIN (SELECT COUNT (DISTINCT na.npatanswer_id), e.state_id FROM election e JOIN election_candidate ec USING (election_id) JOIN npatcandidate nc USING (election_candidate_id) JOIN npatanswer na USING (npatcandidate_id) JOIN npatmatrix nm USING (npatmatrix_id) JOIN npatrow np USING (npatrow_id) JOIN npatrowtext nt USING (npatrowtext_id) LEFT JOIN npatcitation nct USING (npatrow_id, npatcandidate_id) JOIN npatstatus n ON nc.npatstatus_id = n.npatstatus_id WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND np.profile = 't'AND our_npatoption_id NOT IN (0, 71, 68) GROUP BY e.state_id) y USING (state_id)//