Skip ACF banner and navigation
Department of Health and Human Services logo
Questions?
Privacy
Site Index
Contact Us
Home| Services|Working with ACF|Policy/Planning|About ACF|ACF News Search
Administration for Children and Families US Department of Health and Human Services
The Office of Child Support Enforcement Giving Hope and Support to America's Children
Federal Parent Locator Service Home Page Logo   Federal Parent Locator Service
Main Menu
skip to primary page content
 
Library

National Interstate Case Reconciliation Project
Technical Data Guide for Extract File and
Matching Results



APPENDICES

  1. ICR State Extract File Record Format
  2. ICR Case Discrepancies Reason Code Table
  3. ICR Reconciliation Matching Results File Record Format
  4. ICR Reconciliation Report Format

C. ICR RECONCILIATION MATCHING RESULTS FILE RECORD FORMAT


Field Name
Pos.
Len.
A/N
 Comments
Case ID 1-15 15 A/N Your state's case ID
Initiating/Responding Indicator 16 1 A/N Your state's I/R Indicator
I – Initiating
R – Responding
FIPS Code 17-21 5 A/N Your state and county FIPS Code
FIPS Code
Positions 6-7 		22-23 2 A/N Positions 6-7 of the FIPS Code for states that use them (if they are not used, the positions will be blank)
SSN 24-32 9 A/N Your state's SSN
Member ID 33-47 15 A/N Your state's Member ID
Participant Type 48-49 2 A/N Your state's Participant Type:
NP – Noncustodial Parent
CP – Custodial Party
PF – Putative Father
CH – Child
Case Status 50 1 A/N Your state's Interstate Case Status:
O – Open
C – Closed
Last Name 51-80 30 A/N Your state's participant Last Name
First Name 81-96 16 A/N Your state's participant First Name
Middle Name 97-112 16 A/N Your state's participant Middle Name
Date of Birth 113-120 8 A/N Your state's participant Date of Birth in CCYYMMDD format
Sex 121 1 A/N Your state's participant Sex Code:
M – Male
F – Female
O – Other
Other State Case ID 122-136 15 A/N The Other State Case ID stored on your state's system
Filler 137 1 A/N Future use
Other State FIPS Code 138-144 7 A/N The FIPS Code for the other state's case stored on your state's system
Filler 145-159 15 A/N Future use
Filler 160-161 2 A/N Future use
Contact Name
  		162-201 40 A/N The contact name or worker ID for the person assigned to this case in your state
Contact Phone Number 202-211 10 A/N The phone number for the contact or caseworker assigned to this case in your state
Contact E-Mail 212-241 30 A/N The e-mail address for the contact or caseworker assigned to this case in your state
FCR-Supplied Indicator 242 1 A/N Indicates that the other state did not participate in the ICR project and the FCR was used to provide the information in this record:
Y – FCR record match, State not participating in ICR
N – Extract record match, State participating in ICR
1 st Reason Code 243-244 2 A/N First code for explanation of the match results
2 nd Reason Code 245-246 2 A/N Second code for explanation of the match results
3 rd Reason Code 247-248 2 A/N Third code for explanation of the match results
4 th Reason Code 249-250 2 A/N Fourth code for explanation of the match results
5 th Reason Code 251-252 2 A/N Fifth code for explanation of the match results
6 th Reason Code 253-254 2 A/N Sixth code for explanation of the match results
7 th Reason Code 255-256 2 A/N Seventh code for explanation of the match results
8 th Reason Code 257-258 2 A/N Eight code for explanation of the match results.
9 th Reason Code 259-260 2 A/N Future use. This field will not be used for the initial case-based ICR
10 th Reason Code 261-262 2 A/N Future use. This field will not be used for the initial case-based ICR
11 th Reason Code 263-264 2 A/N Future use. This field will not be used for the initial case-based ICR
12 th Reason Code 265-266 2 A/N Future use. This field will not be used for the initial case-based ICR
Case ID (from Other State) 267-281 15 A/N This field contains the case ID from the other state
FIPS Code (from Other State) 282-288 7 A/N This field contains the FIPS Code from the other state
SSN (from Other State) 289-297 9 A/N This field contains the SSN for this participant from the other state
Member ID (from Other State) 298-312 15 A/N Future use. This field will not be used for the initial case-based ICR
Participant Type (from Other State) 313-314 2 A/N This field contains the Participant Type from the other state.
Last Name (from Other State) 315-344 30 A/N This field contains the Last Name for this participant from the other state.
First Name (from Other State) 345-360 16 A/N This field contains the First Name for this participant from the other state.
Middle Name (from Other State) 361-376 16 A/N This field contains the Middle Name for this participant from the other state.
Date of Birth (from Other State) 377-384 8 A/N This field contains the Date of Birth for this participant from the other state.
Sex (from Other State) 385 1 A/N This field contains the Sex for this participant from the other state.
Number of Adults From Your State 386-387 2 N This field contains the number of participants in your state's case that have a participant type of NP, CP or PF
Number of Adults From Other State 388-389 2 N This field contains the number of participants in the other state's case that have a participant type of NP, CP or PF
Number of Adults Matched 390-391 2 N This field contains the number of participants that matched and have a participant type of NP, CP or PF
Number of Children from Your State 392-393 2 N This field contains the number of participants in your state's case that have a participant type of CH
Number of Children from Other State 394-395 2 N This field contains the number of participants in the other state's case that have a participant type of CH
Number of Children Matched 396-397 2 N This field contains the number of participants that matched and have a participant type of CH
Other State Contact Name 398-437 40 A/N This field contains the contact name or worker ID for the person assigned to this case in the other state
Other State Contact Phone Number 438-447 10 A/N This field contains the phone number for the contact or caseworker assigned to this case in the other state
Other State Contact E-Mail 448-477 30 A/N This field contains the e-mail address for the contact or caseworker assigned to this case in the other state
Other State FIPS Code Verification Indicator 478 1 A/N Verification indicator for the five-byte Other State FIPS Code that your state submitted
Y – Your Other State FIPS Code is valid
N – Your Other State FIPS Code is invalid
FIPS Code Verification Indicator (from Other State) 479 1 A/N Verification indicator for the five-byte FIPS code submitted by the other state
Y – The FIPS Code from the other state is valid
N – The FIPS Code from the other state is invalid
CP Match Indicator 480 1 A/N Match indicator for participant information (SSN and participant type match) on the CP.
Y - The person was submitted as a CP on both cases, based on SSN match.
N - The person was not submitted as a CP on both cases, based on SSN match.
NP Match Indicator 481 1 A/N Match indicator for participant information (SSN and participant type match) on the NCP.
Y - The person was submitted as an NCP on both cases, based on SSN match.
N - The person was not submitted as an NCP on both cases, based on SSN match.
Other State I/R Indicator 482 1 A/N This field will contain the Initiating/Responding indicator if submitted by the other state.
Submitting State SSN Verification Indicator 483 1 A/N This field indicates whether or not the SSN submitted in position 24-32 is verified if a Reason Code ‘08' is assigned.
Y – The SSN submitted is verified.
N – The SSN submitted is not verified.
Other State SSN Verification Indicator 484 1 A/N This field indicates whether the Other State SSN provided in position 289-297 is verified (if a Reason Code ‘07' or ‘08' is assigned).
Y – The SSN provided by the Other State is verified.
N – The SSN provided by the Other State is not verified.
Filler 485-550 66 A/N Future use

Top of Page

Last modified: January 5, 2007