Query Case Tab Data Fields of cases where the reason for the referral Presenting Tab Reason for the Referral (allegation of is 'allegation of abuse', and the age of the People Tab Role (alleged victim), alleged victim is <=18, where the LE investigation Age at time of Referral (alleged victim’s age closed date is during the reporting period, and <=18) the ‘charges filed’ radio button is ‘yes’. LE Tab Date Closed (within reporting period) Charges (yes) Cases accepted for prosecution Query Case Tab Data Fields Count of cases where the reason for the Presenting Tab Reason for the Referral (allegation of abuse) referral is 'allegation of abuse', and the age of People Tab Role (alleged victim), the alleged victim is <=18, where the prosecution Age at time of Referral (alleged victim’s age ‘review decision date’ is within the reporting <=18) ‘accepted’. period and the status is Prosecution Tab - Review Date (within reporting period) Prosecution Decision Status (accepted) Convictions, Acquittals Query Case Tab Data Fields Count of cases where the reason for the Presenting Tab Reason for the Referral (allegation of abuse) referral is 'allegation of abuse', and the age of People Tab Role (alleged victim), the alleged victim is <=18, where the prosecution Age at time of Referral (alleged victim’s age ‘outcome date’ is within the reporting period, <=18) grouped by prosecution ‘outcome’. Prosecution Tab - Outcome Date (within reporting period) Prosecution Outcome Outcome Other services provided by CAC (tracked in NCAtrak)
Query Case Tab Data Fields of cases where the reason for the referral is 'allegation of abuse', and the age of the alleged victim is <=18, where the LE investigation closed date is during the reporting period, and the ‘charges filed’ radio button is ‘yes’. Presenting Tab Reason for the Referral (allegation of People Tab Role (alleged victim), Age at time of Referral (alleged victim’s age <=18) LE Tab Date Closed (within reporting period) Charges (yes) Cases accepted for prosecution Query Case Tab Data Fields Count of cases where the reason for the referral is 'allegation of abuse', and the age of the alleged victim is <=18, where the prosecution decision ‘review date’ is within the reporting period and the status is ‘accepted’. Presenting Tab Reason for the Referral (allegation of abuse) People Tab Role (alleged victim), Age at time of Referral (alleged victim’s age <=18) Prosecution Tab - Prosecution Decision Review Date (within reporting period) Status (accepted) Convictions, Acquittals Query Case Tab Data Fields Count of cases where the reason for the referral is 'allegation of abuse', and the age of the alleged victim is <=18, where the prosecution ‘outcome date’ is within the reporting period, grouped by prosecution ‘outcome’. Presenting Tab Reason for the Referral (allegation of abuse) People Tab Role (alleged victim), Age at time of Referral (alleged victim’s age <=18) Prosecution Tab - Prosecution Outcome Outcome Date (within reporting period) Outcome Other services provided by CAC (tracked in NCAtrak)
ncatrakotNCAReport.docx