This article provides an overview of how to run the one-click NCA report, definitions and rules for how the data in each table is calculated, and instructions for how to access the mappings used for the report.
TABLE OF CONTENTS
- Report Definitions
- Table Explanations
- Section 1: Victim and Offender Demographics
- Question 1: New Child Victims - Total
- Question 2: New Child Victims - Assigned Sex at Birth/Biological Sex
- Question 3: New Child Victim - Gender Identities (Optional)
- Question 4: New Child Victim - Self-identified Pronouns (Optional)
- Question 5: New Child Victim - Race/Ethnicity
- Question 6: All Victims - Age Groups
- Question 7: Alleged Offenders - Total
- Question 8: Alleged Offenders - Relationships to New Child victims
- Question 9: Alleged Offenders - Totals by Age Group
- Question 10: New Child Victims - Types of Abuse
- Question 11: New Child Victims with Multiple Victimization Types
- Question 12: New Child Victims - Special Populations Served
- Section 2: Services and Dispositions
- Question 13: Medical Evaluations
- Question 13: Mental Health Treatment
- Question 13: Mental Health Referrals (Internal and External)
- Question 13: Victim Advocacy
- Question 13: Mental Health Screenings/Assessments
- Question 13: Forensic Interviewing
- Question 14: Number of Case Review Meetings
- Question 15: CPS Dispositions
- Question 16: Cases Accepted for Prosecution
- Question 16: Prosecution Dispositions
- Section 3: CAC Information Area of Report
- Reviewing the Lookup Mappings
Report Definitions
New Child Victim - Refers to all Collaborate cases that meet all of the below criteria. This definition is used to identify eligible client cases and associated alleged offender cases for Section 1 of the report and is used for every table except Question 6.
Case Type is one of the following:
Client
Case not Invalid
Age at Intake ≤ 18
At least one valid Allegation:
Allegation mapped to an NCA Abuse Type value
At least one Core NCA Service:
Appointment Status is Attended or NA
Service Type mapped to a NCA Service Type value
Child Victim - Refers to Collaborate cases that meet criteria for inclusion in sections 2 and 3 of the report.
Case Type is one of the following:
Client
Case not Invalid
Age at Intake ≤ 18
At least one valid Allegation:
Allegation mapped to an NCA Abuse Type value
Intake Date in the reporting period
At least one Core NCA Service:
Appointment Status is Attended or NA
Service Type mapped to a NCA Service Type value
Service date within the reporting period
All Victims - Refers to Collaborate cases that meet the criteria for inclusion in “Question 6: All Victims - Age Groups”.
Case Type is one of the following:
Client
Case not Invalid
At least one valid Allegation:
Allegation mapped to an NCA Abuse Type value
At least one Core NCA Service:
Appointment Status is Attended or NA
Service Date in the reporting period
Service Type mapped to a NCA Service Type value
Alleged Offender - Refers to alleged offender cases that meet the following criteria and are that counted in Questions 7, 8, and 9.
Case Type is one of the following:
CAC-Alleged Perpetrator
Case not Invalid
Associated to a case meeting New Child Victim criteria
Table Explanations
Section 1: Victim and Offender Demographics
Question 1: New Child Victims - Total
Reporting Population and Criteria
Total number of new child victims
Counting Unit
Unique case id #’s with no duplicates
Question 2: New Child Victims - Assigned Sex at Birth/Biological Sex
Reporting Population and Criteria
Total number of new child victims by biological sex
NCA Biological Sex Values
Female
Male
Intersex
Unknown
Decline to Answer
Counting Unit
Unique case id #’s with no duplicates
Missing Values
Missing values will be counted under the Unknown option
Question 3: New Child Victim - Gender Identities (Optional)
Reporting Population and Criteria
Total number of new child victims by gender identity
NCA Gender Identity Values
Female
Male
Transgender Female
Transgender Male
Non-Binary
Another Gender Identity
Unknown
Decline to Answer
Counting Unit
Unique case id #’s with no duplicates
Missing Values
Missing values will be counted under the Unknown option
Question 4: New Child Victim - Self-identified Pronouns (Optional)
Reporting Population and Criteria
Total number of new child victims by preferred pronouns
NCA Preferred Pronoun Values
He/Him
She/Her
They/Them
Ze/Hir
Other
Unknown
Decline to Answer
Counting Unit
Unique case id #’s with no duplicates
Missing Values
Missing values will be counted under the Unknown option
Question 5: New Child Victim - Race/Ethnicity
Reporting Population and Criteria
Total number of new child victims by race/ethnicity
NCA Race/Ethnicity Values
American Indian/Alaska Native
Asian East or Southeast Asian
South Asian
Black/African American
Hispanic or Latino
Native Hawaiian/Other Pacific Islander
White Non-Latino Caucasian
Another Racial Identity not listed above
Multiple Racial Identities
Not Reported
Not Tracked
Counting Unit
Unique case id #’s with no duplicates
Missing Values
Missing values will be counted under the Unknown option
Question 6: All Victims - Age Groups
Reporting Population and Criteria
Total number of all victims by age at intake
NCA Victim Age Groups
0-5
6-10
11 to 17
18 to 24
25+
Undisclosed
Counting Unit
Unique case id #’s with no duplicates
Missing Values
Missing values will be counted under the Unknown option
Question 7: Alleged Offenders - Total
Reporting Population and Criteria
Total number of alleged offenders
Counting Unit
Each alleged offender case id # is counted once per associated client
Question 8: Alleged Offenders - Relationships to New Child victims
Reporting Population and Criteria
Total number of alleged offenders by relationship to associated new child victims
NCA Relationship Values
Biological Parent
Stepparent
Other relative
Parent's Significant Other
Other known person
Unknown relationship
Adoptive Parent
Foster Parent
Stranger Unknown Offender
Stranger/Unknown Internet Crime
School Personnel or Volunteer
Coach/Sport Personnel or Volunteer
Medical Professional
Daycare
Babysitter
Counting Unit
Each alleged offender case id # is counted once per associated client by the relationship to that client
Question 9: Alleged Offenders - Totals by Age Group
Reporting Population and Criteria
Total number of alleged offenders by age at intake
NCA Offender Age Groups
11 and Under
12-17 Years
18-24 Years
25+ Years
Not disclosed
Unknown
Counting Unit
Each alleged offender case id # is counted once per associated client
Question 10: New Child Victims - Types of Abuse
Reporting Population and Criteria
Total number of new child victims by unique NCA abuse type
NCA Abuse Types
Sexual abuse
Physical abuse
Neglect
Witness to violence
Drug endangered
Mass Violence
Interpersonal Violence/Family Violence
Community Violence
Child Labor Trafficking
Child Sex Trafficking
Commercial Sexual Exploitation of Children (CSEC)
Child Sexual Abuse Material
Sextortion
Teen Dating Victimization
Adult Survivor
Other
Counting Unit
Unique NCA abuse types by case id #
If a case has two allegations mapped to the same NCA abuse type then that NCA abuse type would be counted as 1 not 2
Question 11: New Child Victims with Multiple Victimization Types
Reporting Population and Criteria
Total number of new child victims that have more than one unique NCA abuse type
Counting Unit
Unique case id #’s with no duplicates
Question 12: New Child Victims - Special Populations Served
Reporting Population and Criteria
Total number of new child victims by unique NCA special populations
NCA Special Populations
Deaf/Hard of Hearing
Unstably Housed/Unhoused
Immigrants/Refugee or Asylum Seeking
LGBTQIA+
Military-Dependent
Cognitive, Physical, or Mental Disability
Limited English Proficiency
Vision Impaired
Indigenous/Tribal Community
Other
Counting Unit
Unique NCA special populations by case id #
Section 2: Services and Dispositions
Question 13: Medical Evaluations
Reporting Population and Criteria
Total child victims receiving at least one service in the reporting period that is mapped to the NCA value Medical Evaluations with an appointment status of attended or N/A
Counting Unit
Unique case id #’s with no duplicates
Question 13: Mental Health Treatment
Reporting Population and Criteria
Total child victims receiving at least one service in the reporting period that is mapped to the NCA value Mental Health Treatment with an appointment status of attended or N/A
Counting Unit
Unique case id #’s with no duplicates
Question 13: Mental Health Referrals (Internal and External)
Reporting Population and Criteria
Total child victims receiving at least one service in the reporting period that is mapped to the NCA value Mental Health Referrals with an appointment status of attended or N/A
Counting Unit
Unique case id #’s with no duplicates
Question 13: Victim Advocacy
Reporting Population and Criteria
Total child victims receiving at least one service in the reporting period that is mapped to the NCA value Victim Advocacy with an appointment status of attended or N/A
Counting Unit
Unique case id #’s with no duplicates
Question 13: Mental Health Screenings/Assessments
Reporting Population and Criteria
Total child victims receiving at least one service in the reporting period that is mapped to the NCA value Mental Health Screening/Assessments with an appointment status of attended or N/A
Counting Unit
Unique case id #’s with no duplicates
Question 13: Forensic Interviewing
Reporting Population and Criteria
- Total child victims who received a service mapped to Forensic interviewing
- Onsite forensic interviews are those where the Location Type = On-site
- Offsite forensic interviews are those where the Location Type = On-site
Counting Unit
Unique case id #’s with no duplicates
Question 14: Number of Case Review Meetings
Reporting Population and Criteria
Total number of MDT Meetings that occurred in the reporting period
Counting Unit
Unique number of Case Review Staffings
Question 15: CPS Dispositions
Reporting Population and Criteria
Total child victims who received a Disposition - CPS service where the service date falls within the reporting period and the CPS Disposition field has been mapped to an NCA value
NCA CPS Dispositions
Substantiated/Indicated/Founded
Administrative closure
Moved/Transferred
Unable to determine
Unsubstantiated/Unfounded
Screened Out
Differential Response
Unable to Complete
Child with Sexual Behavior Problem
Other reason for closure
Counting Unit
Each case is counted once per unique progress update
Question 16: Cases Accepted for Prosecution
Reporting Population and Criteria
Total child victims who received a Disposition - Prosecution service where the service date fell within the reporting period and the Case Accepted for Prosecution = Yes
Counting Unit
Each case is counted once per unique nca progress update
Question 16: Prosecution Dispositions
Reporting Population and Criteria
Total child victims who received a Disposition - Prosecution service where the Prosecution Outcome Date fell within the reporting period and the Disposition Type was mapped to any of the NCA prosecution update values
NCA Prosecution Dispositions
Convictions
Pleas
Acquittals
Referred for Prosecution
Charges Dismissed
Diversion Response
Counting Unit
Each case is counted once per unique nca progress update
Section 3: CAC Information Area of Report
Number of individuals receiving Case Management/Coordination services
Reporting Population and Criteria
The total number of all victims who received a service:
Mapped to case management/case coordination
With an appointment status of attended or N/A
And the service date fell within the reporting period
Counting Unit
Unique case id #’s
Number of Other services provided
Reporting Population and Criteria
The total number of all services received by all victims where the service met the following criteria:
Mapped to an NCA Service Type and that service type has an NCA Other Service? Is marked as Yes
With an appointment status of attended or N/A
And the service date fell within the reporting period
Counting Unit
Unique service id #’s
Prevention Services
Reporting Population and Criteria
Total number of Prevention Services Activities Participants
- Participants count for activities during the reporting period that have been mapped to any Prevention Services activities
Counting Unit
Unique number of activities mapped to any Prevention Services activities
Number of Awareness Campaigns
Reporting Population and Criteria
The total number of Awareness Campaign Activities
Activities count during the reporting period that have been mapped to any Awareness Campaign activities
Counting Unit
Unique number of activities mapped to any Awareness Campaign activities
Number of Impressions
Reporting Population and Criteria
The total number of Awareness Campaign Activities Participants
Participants count for activities during the reporting period that have been mapped to any Awareness Campaign activities
Counting Unit
Sum of registered participants for activities mapped to Awareness Campaign activities
Reviewing the Lookup Mappings
If you ever have questions about how a particular field (Biological sex, Gender, Pronouns, Relationships, Abuse Types, or Services) are mapped, you may use the following steps to access the mappings:
In the top right of your screen, click on the bell icon with “Help” next to it and then click “View Application Catalog”
On the Application Catalog page, click view next to “Custom Reports”
On the Custom Reports catalog page, click “Manage” next to the NCA report page
On this page, you can see all lookups that are being used in the report and what the mapping values are for that lookup
The lookups that have mapped for the NCA report may include the following fields:
Biological Sex
Gender Identity
Preferred Pronouns
Race/Ethnicity
Relationships
Abuse Types
CPS Dispositions
Prosecution Dispositions
Services