Development of a National Adult Protective Services Data System: Namrs Pilot Final Report (volume 1). Appendix F. Namrs Pilot Validation Criteria

09/25/2015

F.1. Agency Component Validation

Data Type Validation

The following fields (or groups of fields) must be numeric:

  • FTE counts
  • Report counts
  • Completion of an investigation

     

Data Length Validation

All the Comments fields are validated to have a length of 5,000 characters or less.

Required Fields Validation

The following fields are required:

  • Agency name 1
  • Physical address--street 1, city, state, ZIP
  • Mailing address--street 1, city, state, ZIP
  • Contact--name, title, email address, phone

     

F.2. Case Component Data Rule Validation

N1010--A client must have at least one maltreatment.
Path: caseComponent/investigation/clients/client
Locators: investigationId, clientId
Action: This <client> element was removed. If there was a linked <relationship> element (relationship with perpetrator), it was removed as well.

 

N1020--If a maltreatment refers to a perpetrator, the maltreatment must be substantiated.
Path: caseComponent/investigation/maltreatments/maltreatment/perpetratorRefs
Locators: investigationId, clientId, maltxTypeVal
Action: This <perpetratorRefs> element was removed from the <maltreatment> element.

 

N1040--If the report date and investigation start date are both not empty, then the report date must be less than or equal to the investigation start date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <reportDate> element was removed.

 

N1050--If the report date and investigation disposition date are both not empty, then the report date must be less than or equal to the investigation disposition date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <reportDate> element was removed.

 

N1060--If the report date is not empty, then the report date must be less than or equal to the case closure date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <reportDate> element was removed.

 

N1070--If the investigation start date and investigation disposition date are not empty, then the investigation start date must be less than or equal to the investigation disposition date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <investStartDate> element was removed.

 

N1080--If the investigation start date is not empty, then the investigation start date must be less than or equal to the case closure date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <investStartDate> element was removed.

 

N1090--If the investigation disposition date is not empty, then the investigation disposition date must be less than or equal to the case closure date.
Path: caseComponent/investigation
Locators: investigationId
Action: This <dispDate> element was removed.

 

N1110--The race code value of 20 must not be used in conjunction with code values 21-27. The code value of 40 must not be used in conjunction with code values 41-44.
Path: caseComponent/investigation/clients/client/race
Locators: investigationId, clientId
Action: The <race> element was removed from this <client>.

 

N1120--The ethnicity code value of 10 must not be used in conjunction with code values 11-14. The code value of 20 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/ethnicity
Locators: investigationId, clientId
Action: The <ethnicity> element was removed from this <client>.

 

N1130--The disability code value of 8 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/disabilities
Locators: investigationId, clientId
Action: The <disabilities> element was removed from this <client>.

 

N1140--The behavior health screening code value of 10 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/behaviorHealthScrns
Locators: investigationId, clientId
Action: The <behaviorHealthScrns> element was removed from this <client>.

 

N1150--The behavior health diagnosis code value of 10 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/behaviorHealthDiags
Locators: investigationId, clientId
Action: The <behaviorHealthDiags> element was removed from this <client>.

 

N1160--The substitute decision maker code value of 30 must not be used in conjunction with code values 31 and 32. The code value of 50 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/subDecMkrsStart
Locators: investigationId, clientId
Action: The <subDecMkrsStart> element was removed from this <client>.

 

N1170--The substitute decision maker code value of 30 must not be used in conjunction with code values 31 and 32. The code value of 50 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/subDecMkrsClose
Locators: investigationId, clientId
Action: The <subDecMkrsClose> element was removed from this <client>.

 

N1180--The service code value of 19 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/servicesStart
Locators: investigationId, clientId
Action: The <servicesStart> element was removed from this <client>.

 

N1190--The service code value of 19 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/servicesAps
Locators: investigationId, clientId
Action: The <servicesAps> element was removed from this <client>.

 

N1200--The service code value of 19 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/servicesReferred
Locators: investigationId, clientId
Action: The <servicesReferred> element was removed from this <client>.

 

N1210--The service code value of 19 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/servicesClose
Locators: investigationId, clientId
Action: The <servicesClose> element was removed from this <client>.

 

N1220--The interagency code value of 7 must not be used in conjunction with other code values.
Path: caseComponent/investigation/clients/client/interagency
Locators: investigationId, clientId
Action: The <interAgency> element was removed from this <client>.

 

N1230--The race code value of 20 must not be used in conjunction with code values 21-27. The code value of 40 must not be used in conjunction with code values 41-44.
Path: caseComponent/investigation/perpetrators/perpetrator/race
Locators: investigationId, perpetratorId
Action: The <race> element was removed from this <perpetrator>.

 

N1240--The ethnicity code value of 10 must not be used in conjunction with code values 11-14. The code value of 20 must not be used in conjunction with other code values.
Path: caseComponent/investigation/perpetrators/perpetrator/ethnicity
Locators: investigationId, perpetratorId
Action: The <ethnicity> element was removed from this <perpetrator>.

 

N1250--The disability code value of 8 must not be used in conjunction with other code values.
Path: caseComponent/investigation/perpetrators/perpetrator/disabilities
Locators: investigationId, perpetratorId
Action: The <disabilities> element was removed from this <perpetrator>.

 

N1260--The behavior health screening code value of 10 must not be used in conjunction with other code values.
Path: caseComponent/investigation/perpetrators/perpetrator/behaviorHealthScrns
Locators: investigationId, perpetratorId
Action: The <behaviorHealthScrns> element was removed from this <perpetrator>.

 

N1270--The behavior health diagnosis code value of 10 must not be used in conjunction with other code values.
Path: caseComponent/investigation/perpetrators/perpetrator/behaviorHealthDiags
Locators: investigationId, perpetratorId
Action: The <behaviorHealthDiags> element was removed from this <perpetrator>.

 

N1310--The substitute decision maker code value of 30 must not be used in conjunction with code values 31 and 32. The code value of 50 must not be used in conjunction with other code values.
Path: caseComponent/investigation/relationships/relationship/perpSubDecMkrsStart
Locators: investigationId, clientId, perpetratorId
Action: The <perpSubDecMkrsStart> element was removed from this <relationship>.

 

N1320--The substitute decision maker code value of 30 must not be used in conjunction with code values 31 and 32. The code value of 50 must not be used in conjunction with other code values.
Path: caseComponent/investigation/relationships/relationship/perpSubDecMkrsClose
Locators: investigationId, clientId, perpetratorId
Action: The <perpSubDecMkrsClose> element was removed from this <relationship>.

 

N1330--The legal remedy code value of 6 must not be used in conjunction with other code values.
Path: caseComponent/investigation/relationships/relationship/perpLegalRem
Locators: investigationId, clientId, perpetratorId
Action: The <perpLegalRem> element was removed from this <relationship>.

 

N2010--A perpetrator must be related to at least one substantiated maltreatment.
Path: caseComponent/investigation/perpetrators/perpetrator
Locators: investigationId, perpetratorId
Action: The <perpetrator> element was removed. If there was a linked <relationship> element (relationship with client), it was removed as well.

 

N2020--Each relationship must have at least one non-unknown attribute specified.
Path: caseComponent/investigation/relationships/relationship
Locators: investigationId, clientId, perpetratorId
Action: The <relationship> element was removed.

 

N2030--An investigation must be related to at least one client.
Path: caseComponent/investigation
Locators: investigationId
Action: The <investigation> element was removed.

 

N2040--The case closure date must be within the reporting period.
Path: caseComponent/investigation
Locators: investigationId
Action: The <investigation> element was removed.

F.3. Key Indicators Component Validation

Data Type Validation

The following fields (or groups of fields) must be numeric:

  • Clients who received an investigation
  • Clients who received interagency coordination
  • Clients by case closure reason
  • Clients found to be victims
  • Victims by age
  • Victims by race
  • Victims by ethnicity
  • Victims by gender identity
  • Victims who received one or more benefits
  • Victims with one or more disabilities
  • Victims with one or more screened behavioral conditions
  • Victims by maltreatment type
  • Victims with guardian or conservator at start of investigation
  • Victims who received services or were referred for services by aps
  • Perpetrators by age
  • Perpetrators by gender identity
  • Perpetrators who had a kinship relationship to the victim
  • Perpetrators who had one or more associations to victim
  • Perpetrators for whom one or more legal remedies on behalf of the victim were sought

     

Data Length Validation

All comment fields are validated to have a length of 5,000 characters or less.

Required Fields Validation

The following fields are required:

  • Clients who received an investigation
  • Clients found to be victims

     

Data Rules Validation

The following fields have data rules

  • Clients who received interagency coordination <= clients who received an investigation
  • Clients by case closure reason total <= clients who received an investigation
  • Clients found to be victims <= clients who received an investigation
  • Victims by age total <= clients found to be victims
  • Victims by race total <= clients found to be victims
  • Victims by ethnicity total <= clients found to be victims
  • Victims by gender identity total <= clients found to be victims
  • Victims who received one or more benefits total <= clients found to be victims
  • Victims with one or more disabilities total <= clients found to be victims
  • Victims with one or more screened behavioral conditions total <= clients found to be victims
  • Victims by maltreatment type abandonment <= clients found to be victims
  • Victims by maltreatment type emotional abuse <= clients found to be victims
  • Victims by maltreatment type financial exploitation <= clients found to be victims
  • Victims by maltreatment type neglect <= clients found to be victims
  • Victims by maltreatment type physical abuse <= clients found to be victims
  • Victims by maltreatment type sexual abuse <= clients found to be victims
  • Victims by maltreatment type suspicious death <= clients found to be victims
  • Victims by maltreatment type self-neglect <= clients found to be victims
  • Victims by maltreatment type other <= clients found to be victims
  • Victims by maltreatment type unknown <= clients found to be victims
  • Victims by maltreatment type total >= clients found to be victims
  • Victims with guardian or conservator at start of investigation <= clients found to be victims
  • Victims who received services or were referred for services by APS <= clients found to be victims

View full report

Preview
Download

"NAMRSpilot-V1.pdf" (pdf, 2.72Mb)

Note: Documents in PDF format require the Adobe Acrobat Reader®. If you experience problems with PDF documents, please download the latest version of the Reader®