|
|
|---|
|
|
|||||
|---|---|---|---|---|---|
|
|
|
||||
| ACF Home | Services | Working with ACF | Policy/Planning | About ACF | ACF News | HHS Home | |||||
Questions?
|
Privacy
|
Site Index
|
Contact Us
|
Download Reader™
|
Print
|
|---|
Technical Bulletin #8AFCARS State Data Compliance Utility Version 3.0 |
This technical bulletin provides guidance for installing and executing the AFCARS Data Compliance Utility (DCU), version 3.0. It also provides information to the States on how to properly use the utility and interpret the data reports generated by the utility.
This utility is made available to States to assist them in assessing the compliance of their data with AFCARS standards prior to submission of the data to ACF.
| Section I | General Information:background, overview, utility files, options for using the utility, and C source code and executable files. |
| Section II | Using the Data Compliance Utility:installing the software and checking State data files. |
| Section III | Interpreting AFCARS Data Reports:summary reports, and detailed edit reports. |
| Section IV | Additional Information |
| Appendix A | Sample Reports |
| Appendix B | Internal Consistency Checks |
| Appendix C | Programming Logic Diagram |
GENERAL INFORMATION
Background
The Data Compliance Utility (DCU) was created as a way to provide technical assistance to States. The DCU incorporates only those edit checks required to assess the States compliance with the standards in 45 CFR 1355.40. The Children's Bureau developed the utility in order to inform the States of their compliance status on the data being submitted in the Adoption and Foster Care Analysis and Reporting System (AFCARS). The utility is also on the Federal AFCAR system and is what is used to assess the data's compliance with each of the required standards.
ACF encourages the States to use this utility prior to submitting the data to ACF. In order to optimize the usefulness of this utility, States should incorporate this utility as a routine task in quality control of the AFCARS data and assess the data on a regular basis, such as quarterly.
Overview
This technical bulletin provides guidance for installing and executing the AFCARS State Data Compliance Utility (DCU) version 3.0. The utility uses the same logic as the Federal AFCAR system. A diagram of the programming logic has been included in Appendix C. The utility will only work on an AFCARS data file that has been formatted according to Technical Bulletin #2: AFCARS File Format.
The utility will create two files that contain the same four reports that a State receives from the Federal system:
Directions on how to interpret these reports are included in this document in Section 3.
Utility Files
Software has been distributed to all States and the District of Columbia. The software can also be downloaded from the Children's Bureau's AFCARS web site at http://www.acf.hhs.gov/programs/cb/systems/afcars/resources.htm. The utility source code file is available in the C programming language and a PC-compatible executable in C.
Following is a complete listing of the utility files:
C Files:
CHKDAT3.EXE (executable)
CHKDAT3.C (source code)
ASCII file:
FIPS.LST (contains a list of valid local agency FIPS codes)
Options for Using the Utility
ACF is providing both source code and executable files to allow the States to select their own approach for checking their AFCARS data. Two options are listed below:
C Source Code and Executable Files
The executable written in C follows the logical diagram included in Appendix C of this bulletin.
To compile the source code (with or without making modifications) either on a PC or another platform, a C compiler should be available. The C code requires a compiler that meets the ANSI-C standard.
USING THE DATA COMPLIANCE UTILITY
Installing the Software
Copy the executable file for the AFCARS State DCU file and the "FIPS.LST" file to an IBM 386 (or higher), or a compatible personal computer running DOS 3.0 or higher.
When using the source code, copy the source code and the "FIPS.LST" files to the platform where the C compiler is located. Then make any modifications and compile the source code.
IMPORTANT NOTICE: The "FIPS.LST" file contains a list of valid local agency FIPS codes which the AFCARS Data Compliance Utility uses to validate foster care element #3. When executing the utility, the "FIPS.LST" file must be contained in the same directory as the executable. Otherwise, the utility will not work properly.
Checking State Data Files
IMPORTANT NOTICE: The AFCARS State DCU executable will process only files formatted as specified in "AFCARS Technical Bulletin #2: File Format" and will not process files in EBCDIC and/or other non-ASCII formats.
Execute the command by typing, or selecting, the name of the executable that has been copied or compiled (i.e.,CHKDAT3.exe).
The program will then prompt the user for four things:
The program will then process the data file. If the file is not formatted correctly, the utility will not run properly so it is important that the directions are followed as listed in AFCARS Technical Bulletin #2 when creating the file.
After the program has completed processing, the two report files generated may be viewed or printed by using any text editor. A word processing software package such as WordPerfect or Microsoft Word may also be used to view the file. If a word processor is used, be sure to use a non-scalable font (we suggest Courier 12 cpi) when printing the file. Otherwise, the reports will not print properly.
INTERPRETING AFCARS DATA REPORTS
Overview
This section provides guidance on how to interpret the AFCARS data compliance reports generated by the AFCARS State DCU. These reports are exactly the same as the reports generated by the Federal AFCAR system and sent to the State after any AFCARS data file is submitted and processed.
There are two types of reports for foster care and adoption data. The "Data Compliance Detailed Report" gives a breakdown of errors for each record. The "Data Compliance Summary Report" is a summary report that gives the total of each type of error for each element. Examples of both reports are included in Appendix A.
Special Information
In order to interpret the AFCARS data compliance reports there are a few caveats that need to be kept in mind regarding the AFCARS data requirements.
Subject Records
You will note that in the data compliance summary report the number of records in the "subject records" column will differ from element to element. This is because every element is not subject to compliance assessment. This could be due to the relationship/dependence of one element on another, or because the element is not a core element (see below for discussion on core elements).
Foster Care
In the AFCARS foster care data set there are "core" data elements (see Appendix A of 45 CFR 1355 for core elements). Core data elements are the only elements that are assessed for errors in one of two situations:
If a record meets one of the above criteria, then only those core elements listed in the Federal regulation will be considered for compliance purposes. The Children's Bureau recommends that the State complete as much of the remaining information as possible.
For either of these criteria to be accounted for by the DCU, the "date of latest removal" (foster care element #21) must have no errors. Therefore, any record in which foster care element #21 fails the missing check (see section III.D.1 below), the out-of-range check (see section III.D.2, below), or any internal consistency check (see section III.D.3 below) will require ALL foster care elements to be completed.
Adoption
All data elements are required for adoption if the record meets one of the three criteria for State agency involvement in Appendix B of 45 CFR 1355. If the response to adoption element #4 is "no", then only elements #1-4 are required. The Children's Bureau encourages the submission of information on all voluntary adoptions.
Any record in which adoption element #4 fails the missing check, the out-of-range check, or any internal consistency check will require ALL adoption elements to be completed.
Data Compliance Detailed Reports
The data compliance detailed report lists all of the errors found by the utility. The first column in the report gives the record number, which is element #4 for foster care and element #3 for adoption.
This column may contain different information in the report generated by the utility than the report that is received back from the Federal system if the file on which the utility is run contained the actual State client identifier. The file that is submitted to the Federal system must contain either sequential numbers or encrypted versions of the State identifier.
The remaining columns represent the element numbers (sixty-six for foster care, thirty-seven for adoption). If there is a "." in a column, the element had no errors in it. If there is not a "." there has been one of several errors. These errors are described below. Note that within a record, no element will be marked with more than one error. Therefore, if an element is found to be out of range it will not be subject to any further edit checks. Elements will be tested for the following errors:
C.1 Missing
A "1" in the detailed report indicates the element was found to be missing. This means that the element was required, but was left blank in the record and, in the case of race elements, all blanks. While there are certain elements that are allowed to be left blank, if they are not applicable to the record, most require that some value be entered.
C.2 Out-of-Range
A "2" in the detailed report indicates the element in that record was out-of-range (i.e., not an allowable value). Allowable values for coded elements are those values that are given in the Appendices A and B of 45 CFR 1355. Allowable values for data elements are formatted according to Appendices A and B of 45 CFR 1355. With the exception of the record number (element #4 in foster care, element #3 in adoption), all elements must contain only digits or blanks and no other characters.
C.3 Internal Consistency Error
An uppercase letter ("A", "B", "C", etc.) in the detailed report indicates that an internal consistency check has failed. There are nine adoption consistency checks and eighteen foster care consistency checks enumerated in Appendix E of 45 CFR 1355. These are the only consistency checks performed by this utility. The letter in the report corresponds to the legend, printed at the end of the detailed report, which indicates which elements were involved in the inconsistency.
Also, these checks will be performed exactly as they appear in Appendix E, 45 CFR 1355. For example, foster care Internal Consistency Check #4 states:
"If a child is identified as having a disability(ies) (foster care element #10), at least one "type of disability condition" (foster care elements #11-#15) must be indicated..."
In this case, the record will only fail this check if foster care element #10 indicates the child has a disability but none of foster care elements #11-#15 indicates any type of disability. If, however, the record indicates that the child has a particular type of disability (in foster care elements #11-#15) but foster care element #10 indicates that the child has no disability, the record willnotfail the internal consistency check.
There are three other important points to keep in mind about internal consistency checks:
A full list of the internal consistency checks is included in Appendix B.
C.4 Timeliness
In the detailed data compliance report, a "3" for foster care elements #22 and #57 (transaction date of latest removal and transaction date of discharge, respectively) indicate that the element failed the timeliness standard as described in 45 CFR 1355 (i.e., the date entered is more than 60 days after the date of the actual occurrence).
These elements should reflect thedate of data entryof the associated data element. For example, if the "date of latest removal" (foster care element #21) for a child is March 1, 1995, and that date is entered into the systemfor the first timeon March 20, 1995, then foster care element #22 should be 19950320 (March 20, 1995).
IMPORTANT NOTICE: These elements should not change when a date is corrected in the system. In the example above, if the worker realizes that the "date of latest removal" for the current episode was actually March 2, 1995 and makes that modification to the system on April 20, 1995, the transaction date (foster care element #22) should still remain 19950320 (March 20, 1995), the date that the "date of latest removal" for the current episode was first entered.
Since it is impossible for a State to change a transaction date, it will only be considered as a timeliness error in the first report that it occurs. For example, if a record indicates that a child's "date of latest removal" is January 1, 1995 and the transaction date indicates that this information was not entered into the system until March 20, 1995 (more than 60 days later), the transaction date will be subject to penalty for the period ending March 31, 1995.
If, however, that same child is still in the same removal episode during the next reporting period (and, therefore, the date of latest removal has not changed) then the transaction date will not be subject to penalty in that reporting period.
The transaction dates are used to ensure that these dates are being entered into the State information system in a timely manner. To that end, there is a requirement that no more that 10% of the cases can have a transaction date of latest removal that is more than 60 days beyond the actual date latest removal. Also, no more than 10% of the cases can have a transaction date of discharge that is more than 60 days beyond the actual date of discharge.
Data Compliance Summary Reports
The data compliance summary report is provided for two reasons: 1) to allow the user to evaluate whether the data would exceed the standard (10%), as stated in the AFCARS regulation (45 CFR 1355), if it were submitted to the Federal AFCAR system; and 2) to assist the user in determining problems/errors in the data.
There are three types of errors that may appear in the foster care and adoption reports: late submission, format errors, and data errors. In addition to these two, the foster care report also contains timeliness errors.
D.1 Format Errors
In order for a file to be received and processed, it must meet the format standards set forth in the regulations, Technical Bulletin #2 (AFCARS File Format)and any other ACF memorandum describing proper file format.
Format errors appear in the top section of the Data Report.Anyformat error that occurs in a data file submitted could result in the file being found out of compliance.
The most common type of format error is when the summary file created by the State does not match the summary file that the Federal AFCARS creates using the data in the detail file. This file will be compared with the submitted summary file record. The summary file is included with each detail file for the purpose of ensuring that no error has occurred during transmission, or that the file was not formatted properly by the State. If the number of records do not match, the detail data file will not be validated and the State will be out of compliance for the file. The summary file also lists the number of records for each of the 19 age groups. Another common type of format error is when the number of records in the detail file for these age groups is found inconsistent with the summary file. Therefore, it is very important that the State ensure that the information in the summary file matches the information in the detail file.
An example of the language that will appear in the data compliance summary report for the age group inconsistencies is given in the sample reports in Appendix A. Below is the language that will be displayed when the number of records in the detailed file does not equal the number of records in the summary file.
"Foster Care # of Records Not Equal to Summary #
# of Records in summary file: 1321
Actual # of records in file: 1322"
Other "fatal" format errors, which will cause the Federal system and the utility not to process the data, are no file delimiters3and no summary file included. A new format error message has been added due to the change in record length resulting from adding reporting of multi-racial information. If the State does not submit a file in the proper file length, the detailed file will not be validated and the State will be out of compliance for the file. The following error message will appear:
"Incorrect foster care detailed record length. The file contained 182 characters, the correct record length for new race format is 197 characters for foster care."
If any of these errors exist in the file, neither the Federal system nor the utility will be able to properly process the file.
D.2 Data ErrorsData errors are those errors that exist in the data records. This section is a summary of the errors that appear in the data compliance detailed report. Remember, only those elements in records where that element is required will appear in the AFCARS data reports. The data errors appear in the second half of the data report, below the format errors. The data error section has eight columns:
Errors for elements that are not required for a particular record will not appear in columns 2-5. Likewise, the number of subject records (column 6) will not include any records in which an element is not required.
D.3 Timeliness Errors
Only the AFCARS foster care data compliance summary file contains a "Timeliness Error" section. This section summarizes the number of timeliness errors that appeared for foster care elements #22 and #57. The Subject Records for this section will include:
For a detailed discussion of the timeliness standard, please see the discussion in section III.C.4.
ADDITIONAL INFORMATION
If additional information is required on installing and executing the AFCARS State Data Compliance Utility, please contact the ACF Office of Information Services at (202) 401-1462.
SAMPLE REPORTS
Date: 3/3/2000
File: Test_File.dat
AFCARS Foster Care
Data Compliance Detailed Report (Version 3)
Report Period: March, 2000
| 0 | 10 | 20 | 30 | 40 | 50 | 60 | |
| 0123456 | 123456789 | 0123456789 | 0123456789 | 0123456789 | 0123456789 | 0123456789 | |
| Record # -------- |
|||||||
| 1 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 3 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 4 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 5 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 6 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 7 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 8 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 9 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 10 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 11 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 17 | . . . . . . 1 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 18 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 19 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 20 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 21 | . . . . . . 1 | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 22 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 23 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 24 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . 2 | . . . . . . . | . . . . . . . |
| 25 | . . . . . 1 . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 26 | . . . . . . 1 | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . 2 . . . . . | . . . . . . . |
| 27 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . 222 . . . . | . . . . . . . |
| 28 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . R2 . . | . . . . . . . |
| 29 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . R . R2. . . | . . . . . . . |
| 30 | . . . . . 1 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 31 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 32 | . . . . . . 1 | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 33 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 33 | . . . . . . 2 | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 35 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 36 | . . . . . . 2 | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 37 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 38 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 39 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 40 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 41 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 42 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 43 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 44 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 45 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 46 | . . . . .12 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 47 | . . . . . 12. | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 48 | . . . . . 2 . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 49 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 50 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . R . . . . . | . . . . . . . |
| 51 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . R . . . . . | . . . . . . . |
| 52 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 53 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 54 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 55 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . 2 . . . . | . . . . . . . |
| 56 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . R . . . . | . . . . . . . |
| 57 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 58 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 59 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . J . . . . J | J J J J J J . | . . . . . . . |
| 60 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 61 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 62 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . 1 . . . . . | . . . . . . . | . . . . . . . |
| 63 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . 2 . . . . . | . . . . . . . | . . . . . . . |
| 64 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . 1 . . . . . | . . . . . . . | . . . . . . . |
| 65 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . |
| 66 | . . . . . R . | . . . . . . . | . . . . . . . | . . . . . . . | . . . . . . . | . . . R . . . | . . . . . . . |
<--------------------------- Field Number ----------------------------->
Legend:
1 = Missing.
2 = Out of range.
3 = Timeliness error.
A = Foster care data internal consistency #1.
B = Foster care data internal consistency #2.
C = Foster care data internal consistency #3.
D = Foster care data internal consistency #4.
E = Foster care data internal consistency #5.
F = Foster care data internal consistency #6.
G = Foster care data internal consistency #7.
H = Foster care data internal consistency #8.
I = Foster care data internal consistency #9.
J = Foster care data internal consistency #10.
K = Foster care data internal consistency #11.
L = Foster care data internal consistency #12.
M = Foster care data internal consistency #13.
N = Foster care data internal consistency #14.
O = Foster care data internal consistency #15.
P = Foster care data internal consistency #16.
Q = Foster care data internal consistency #17.
R = Foster care data internal consistency #18.
AFCARS Foster Care
Data Compliance Summary Report
Report Period: March, 2000
Format Errors
| Error Description | Error |
|---|---|
| Inconsistent Summary File: Age 7 | X |
| Inconsistent Summary File: Age 8 | X |
| Inconsistent Summary File: Age 9 | X |
| Inconsistent Summary File: Age 10 | X |
| Inconsistent Summary File: Age 12 | X |
| Inconsistent Summary File: Age 13 | X |
| Inconsistent Summary File: Age 14 | X |
| Inconsistent Summary File: Age 15 | X |
| Inconsistent Summary File: Age 17 | X |
| Inconsistent Summary File: Age 18 | X |
| Inconsistent Summary File: Age over 18 years old | X |
Data Errors
| Data Element | Missing Data | Out-of-Range | Internal Consistency | Total Errors | Subject Records | Percent Failing | Exceeded Standard |
|---|---|---|---|---|---|---|---|
| 1 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 2 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 3 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 4 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 5 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 6 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 7 | 2 | 0 | 0 | 5 | 66 | 3.03 | |
| 8 | 6 | 16 | 27 | 49 | 66 | 74.24 | X |
| 9 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 10 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 11 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 12 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 13 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 14 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 15 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 16 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 17 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 18 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 19 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 20 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 21 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 22 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 23 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 24 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 25 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 26 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 27 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 28 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 29 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 30 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 31 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 32 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 33 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 34 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 35 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 36 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 37 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 38 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 39 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 40 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 41 | 2 | 7 | 23 | 32 | 66 | 48.48 | X |
| 42 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 43 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 44 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 45 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 46 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 47 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 48 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 49 | 0 | 1 | 23 | 24 | 66 | 36.36 | X |
| 50 | 0 | 0 | 23 | 23 | 66 | 34.85 | X |
| 51 | 0 | 0 | 23 | 23 | 66 | 34.85 | X |
| 52 | 0 | 3 | 27 | 30 | 66 | 45.45 | X |
| 53 | 0 | 1 | 23 | 24 | 66 | 36.36 | X |
| 54 | 0 | 2 | 26 | 28 | 66 | 42.42 | X |
| 55 | 0 | 2 | 23 | 25 | 66 | 37.88 | X |
| 56 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 57 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 58 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 59 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 60 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 61 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 62 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 63 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 64 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 65 | 0 | 0 | 0 | 0 | 66 | 0.00 | |
| 66 | 0 | 0 | 0 | 0 | 66 | 0.00 |
Total Data Errors: 260
Timeliness Errors
| Data Element | Total Errors | Subject Records | Percent Failing | Exceeded Standard |
|---|---|---|---|---|
| 22 | 0 | 66 | 0.00 | |
| 57 | 0 | 66 | 0.00 |
* * * * * *
As reflected in this report, data submitted by the State does not meet the AFCARS standards specified in 45 CFR 1355.40 (e).
* * * * * *
Date: 3/3/2000
File: Test_File.dat
AFCARS Adoption
Data Compliance Detailed Report (Version 3)
Report Period: March, 2000
<------------ Field Number ------------>
| 0 | 10 | 20 | 30 | |
| Record # | 123456789 | 0123456789 | 0123456789 | 01234567 |
| 000000000002 | . . . . . . . . . | . . . . . . . . . | . . H H H H H H H | . . . . . . . . . |
| 000000000003 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000004 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000005 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000006 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000007 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000008 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000014 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000015 | . . . . . . . . . | . . . . . . . . . | . . . . I . . . . | . . . . . . . . . |
| 000000000016 | . . . . . . . . . | . . . . . . . . . | . . . . . . I . . | . . . . . . . . . |
| 000000000017 | . . . . . . 1 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000018 | . . . . . I . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000019 | . . . . . . I . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000020 | . . . . . I . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000021 | . . . . I . . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000022 | . . . . . 1 . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000023 | . . I . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000024 | . . . . . I . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000025 | . . . . . . I . . | . . . . . . . . . | . . 2 . . . . . . | . . . . . . . . . |
| 000000000026 | . . . . . . . 1 . | . . . . . . . . . | . . 2 . . . . . . | . . . . . . . . . |
| 000000000027 | . . . . . I . . . | . . . . . . . . . | . . . . . . . . . | . . 1 . . . . . . |
| 000000000028 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000029 | . . . . . . 1 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000030 | . . . . . . 1 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000031 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . I . . . . |
| 000000000032 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . . . I . . |
| 000000000033 | . . . . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000034 | . . . . . . . 2 . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000035 | . . . . . . . 2 . | . . . . . . . . . | . . . . . . . 2 . | . . . . . . . . . |
| 000000000036 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000037 | . . . . . . 2 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000038 | . . . . . . 2 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000039 | . . . . . . . 2 . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000040 | . . . . . . 2 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000041 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000042 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000043 | . . . . . . 2 . . | . . . . . . . . . | . . . . . 2 . 2 . | . . . . . . . . . |
| 000000000044 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000045 | . . . . . 2 . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000046 | . . . . . . 2 . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000047 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000048 | . . . . . . 2 . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000049 | . . I . . . . . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000050 | . . I . . . . . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000051 | . . . . . . . I . | . . . . . . . . . | . . . . . . . 2 . | . . . . . . . . . |
| 000000000052 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000053 | . . . . . . I . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000054 | . . . . . . I . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000055 | . . . . . . I . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000056 | . . . . . . I . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000057 | . . . . . . I . . | . . . . . . . . . | . . . . . 2 . . . | . . . . . . . . . |
| 000000000058 | . . . . . . I . . | . . . . . . . . . | . . . . . 2 . . . | . . . . . . . . . |
| 000000000059 | . . . . . . I . . | . . . . . . . . . | . . . . 2 . 2 . . | . . . . . . . . . |
| 000000000060 | . . . . . . I . . | . . . . . . . . . | . . . . . 2 . . . | . . . . . . . . . |
| 000000000061 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
| 000000000062 | . . . . . . I . . | . . . . . . . . . | . H H H H H H H . | . . . . . . . . . |
| 000000000063 | . . . . . . I . . | . . . . . . . . . | . . . . . . 2 . . | . . . . . . . . . |
| 000000000064 | . . . . . . I . . | . . . . . . . . . | . . . . . . . . . | . . . . . . . . . |
Legend:
1 = Missing.
2 = Out of range.
3 = Timeliness error.
A = Adoption data internal consistency #1.
B = Adoption data internal consistency #2.
C = Adoption data internal consistency #3.
D = Adoption data internal consistency #4.
E = Adoption data internal consistency #5.
F = Adoption data internal consistency #6.
G = Adoption data internal consistency #7.
H = Adoption data internal consistency #8.
I = Adoption data internal consistency #9.
AFCARS Adoption
Data Compliance Summary Report
Report Period: March, 2000
Format Errors
| Error Description | Error |
|---|---|
| Inconsistent Summary File: Age 6 | X |
| Inconsistent Summary File: Age 7 | X |
| Inconsistent Summary File: Age 8 | X |
| Inconsistent Summary File: Age 9 | X |
| Inconsistent Summary File: Age 11 | X |
| Inconsistent Summary File: Age 12 | X |
| Inconsistent Summary File: Age 13 | X |
| Inconsistent Summary File: Age 15 | X |
| Inconsistent Summary File: Age 16 | X |
| Inconsistent Summary File: Age 17 | X |
| Inconsistent Summary File: Age 18 | X |
| Inconsistent Summary File: Age over 18 years old | X |
Data Errors
| Data Element | Missing Data | Out-of-Range | Internal Consistency | Total Errors | Subject Records | Percent Failing | Exceeded Standard |
|---|---|---|---|---|---|---|---|
| 1 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 2 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 3 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 4 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 5 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 6 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 7 | 5 | 15 | 27 | 47 | 64 | 73.44 | X |
| 8 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 9 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 10 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 11 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 12 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 13 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 14 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 15 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 16 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 17 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 18 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 19 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 20 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 21 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 22 | 1 | 3 | 25 | 29 | 64 | 45.31 | X |
| 23 | 0 | 0 | 25 | 25 | 64 | 39.06 | X |
| 24 | 0 | 0 | 25 | 25 | 64 | 39.06 | X |
| 25 | 0 | 8 | 28 | 36 | 64 | 56.25 | X |
| 26 | 0 | 0 | 25 | 25 | 64 | 39.06 | X |
| 27 | 0 | 8 | 27 | 35 | 64 | 54.69 | X |
| 28 | 0 | 0 | 25 | 25 | 64 | 39.06 | X |
| 29 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 30 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 31 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 32 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 33 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 34 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 35 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 36 | 0 | 0 | 0 | 0 | 64 | 0.00 | |
| 37 | 0 | 0 | 0 | 0 | 64 | 0.00 |
