Child Support Addenda (DED) Record
From the NACHA Guide for Electronic Child Support Payments
Child Support Application Banking Convention
Within the 80 position Payment Related Information Field of the CCD+ Addenda Record, remittance information corresponding to the child support payment made by an employer to an SDU (State Disbursement Until) is presented in the following banking convention. This convention is referred to as the ‘DED’ Deduction data segment under ASC X12 syntax and is composed of ten fields:
- Segment Identifier
- Application Identifier
- Case Identifier
- Pay Date
- Payment Amount
- Non-Custodial Parent Social Security Number
- Medical Support Indicator
- Non-Custodial Parent Name
- FIPS Code
- Employment Termination Indicator
Each field is referred to as a data element, which is the smallest named item in a record. It can represent a qualifier, a value, or text. A data element has three primary attributes - length, field requirement, and type. Each data element is identified by an element identifier used for reference (e.g., DED01, DED02, etc.), and each element has a specific position within the record (segment).
In constructing the segment, each data element is preceded by the separator character. In the ACH, the data element separator is an asterisk (‘*’). Each segment must end with a terminator, which in the ACH is a backslash (‘\’).
The following is an example of the DED segment as used in the Payment Related Information field of the CCD+ Addenda Record:
DED*application identifier*case identifier*pay date*payment amount*noncustodial parent ssn*medical support indicator*non-custodial parent name*FIPS code*employment termination indicator\
Note the use of the asterisk (‘*’) and backslash (‘\’).
Data elements in a segment are either mandatory or optional. Data elements in a segment that are not mandatory as defined by the standard may be omitted. The omission of an optional element is noted by the placement of an asterisk in the place of that element. For example, if non-custodial parent name were to be omitted from the segment, it would look like this:
DED*application identifier*case identifier*pay date*payment amount*noncustodial parent ssn*medical support indicator**FIPS code*employment termination indicator\
Also, if an optional data element is the last data element in a segment and that field is not being used, the preceding asterisk is replaced by the backslash. For example, if the employment termination indicator is omitted from the segment, it would look like this:
DED*application identifier*case identifier*pay date*payment amount*noncustodial parent ssn*medical support indicator*non-custodial parent name*FIPS code\
The following grid delineates the format for the DED Convention for employers:
DED CHILD SUPPORT CONVENTION
|
Element
|
Comments
|
Content
|
Attributes
1 2 3 |
|
| |
Segment Identifier |
DED |
M ID 3/3 |
| DED01 |
Application Identifier |
CS |
M ID 2/2 |
| DED02 |
Case Identifier |
XXXXXXXXX |
M AN 1/20 |
| DED03 |
Pay Date |
YYMMDD |
M DT 6/6 |
| DED04 |
Payment Amount |
$$$$$$$$CC |
M N2 1/10 |
| DED05 |
Non-Custodial Parent Social Security Number |
XXXXXXXXX |
M AN 9/9 |
| DED06 |
Medical Support Indicator |
'U" - Yes, 'N' - No |
M AN 1/1 |
| DED07 |
Non-Custodial Parent Name |
XXXXXXXXXX |
O AN 1/10 |
| DED08 |
FIPS Code |
XXXXXXX |
O AN 5/7 |
| DED09 |
Employment Termination Indicator |
'Y" - Yes |
O AN 1/1 |
SAMPLE DED CONVENTION
DED*CS*ZC146*951024*13547*975348431*N*SMITH,HAR*19000*Y\
(Reminder: due to the one-addenda limitation of the CCD+ format, the DED segment is restricted to a maximum of 80 characters. Note the use of the asterisk and backslash.)
The column headings used on the grid are as follows:
- the Element defines the data element name;
- the Comments and Content define the data element, and
- the Attributes are defined as follows:
1. Field Requirement - The first column of the attributes is the field requirement for that data element. An ‘M’ denotes a mandatory element, whereas an ‘O’ denotes an optional field.
2. Data Type - The second column of the attributes specifies the field data type.
‘AN’ denotes a string type data element. Contents of string data elements are a sequence of letters, digits, spaces and/or special characters (with the exception of the asterisk). The contents shall be left justified. Trailing spaces should be suppressed unless they are necessary to satisfy a minimum length requirement.
‘DT’ denotes a date type data element. Format for the date is YYMMDD. YY is the last two digits of the year (00-99), MM is the numeric value of the month (1-12), and DD is the numeric value of the day (1-31). (This format does not support a 4-digit year.) The date field in the banking convention for the CCD+ is a 6/6 date field – the CCD+ does not support a 4 digit year.
‘ID’ denotes an identifier data element from a pre-defined list of values.
‘N2’ denotes a numeric type data element with 2 decimal places to the right of a fixed, implied decimal point. The decimal point is not transmitted. It is intended that this number will always be positive for the child support application banking convention. Thus the amount, $550.00 would appear as *55000*.
3. Length - The third column of the attributes signifies the minimum/maximum use of an element. This specifies the minimum and maximum length of a particular field. For example, 1/6 indicates that this data element must be at least one character, but not more than six.
ELEMENT DEFINITIONS
DED01 Application Identifier: Supported Code Value - ‘CS’ - Child Support
The application identifier indicates the type of deduction being withheld from an employee’s pay. If you are an employer withholding child support from an employee’s paycheck, use CS as the
application identifier. Child Support SDU’s should use one of the following application identifiers to identify their child support payments:
Interstate Payments
II Interstate Income Withholding
IT Interstate State Tax Offset
IO Interstate All Others
RI Interstate Cost-Recovery Income Withholding
RT Interstate Cost-Recovery State Tax Offset
RO Interstate Cost-Recovery All Others
Financial Institution Data Match Payments
FD FIDM funds from a financial institution
IF FIDM funds from a non-cost-recovery state to another state
RF FIDM funds from a cost-recovery state to another state
Payments from a Direct Payer
DP Child support payment from a direct payer
FD, IF, and RF may now be used to identify payments from financial institutions as part of the Office of Child Support Enforcement’s Financial Institution Data Match (FIDM) operation:
Code FD is used to indicate that a child support agency requested that a financial institution disburse monies (seized from an account holder/non-custodial parent obligor), and the requested
financial institution forwarded the monies to the child support agency's state disbursement unit (SDU). FD could also be used to indicate that a financial institution, upon request from one state
child support agency, was sending interstate FIDM payments to another SDU.
Code IF is used to notify the receiving state disbursement unit (SDU) of payments (received in full) going from the sending SDU to the receiving SDU. (The state sending the payments is not a "cost-recovery" state.)
Code RF is used to notify the receiving SDU that fees were deducted from collection activities before the sending SDU transferred the payments to the receiving SDU. (The state sending the payments is a "cost-recovery" state.)
DP may be used in the CCD+ format and in versions 5050 and higher of the CTX 820.
Code DP identifies a child support payment from a direct payer, either directly or via a third party provider. The direct payer could be self-employed and is typically not under an income withholding order
DED02 Case Identifier:
The case identifier element is the IV-D case number or court order number. The case identifier always refers to the identification number of the case in the state receiving the EFT/EDI transaction (e.g., the child support SDU). This is true whether the transaction is from an employer or another state. It is the responsibility of the SDU to provide the employer with the correct Case Identifier, typically during the case clean-up/reconciliation process before an employer sends the first electronic payments.
DED03 Pay Date:
The pay date element provides the obligor’s (non-custodial parent’s) pay date; the date the income was withheld from the employee’s paycheck.
DED04 Payment Amount:
The payment amount element indicates the non-custodial parent’s child support withheld for this pay period, which is being paid to the SDU.
DED05 Non-Custodial Parent Social Security Number:
The non-custodial parent’s Social Security number element provides the SDU with the noncustodial parent’s Social Security number.
DED06 Medical Support Indicator: Supported Code Values - ‘Y’, ‘N’
The medical support indicator indicates whether the employer offers family medical insurance coverage. If medical insurance coverage is available, a ‘Y’ is placed in the field; if there is no coverage available, an ‘N’ is placed in the field.
DED07 Non-Custodial Parent Name:
The non-custodial parent’s name element indicates the first seven letters of the obligor’s last name followed by the first three letters of his/her first name. A comma must be used to separate the last name from the first name of the non-custodial parent when the last name is less than seven characters. This field is not case-sensitive, i.e., mixed case letters are acceptable.
DED08 FIPS Code:
The Federal Information Process Standard (FIPS) code refers to the FIPS Code of the SDU receiving the transaction. It is 5 characters when indicating both the state and county codes. It is 7 characters when indicating state, county, and local codes. Most states no longer require the FIPS code for incoming payments.
DED09 Employment Termination Indicator: Supported Code Value - ‘Y’
The employment termination indicator is used to notify the child support enforcement agency that an individual’s employment has terminated. A ‘Y’ is placed in this field if the employee has terminated; otherwise the field is not used. The payment amount field may contain zero when this field is used. If an employer’s payroll system is unable to generate the employment termination indicator, the employer is required to notify the child support enforcement agency (by phone, e-mail or mail) when an employee with an obligation has left its employment.
Sample CCD+ and CTX
Sample CCD+ File
5200COMPANY NAME 1445556677CCDCHILD SUP 020301020301 1091000011229669
6220730002227007002 0000018000BROK01 STATE OF IOWA 1091000011229670
705DED*CS*111111*020301*0000018000*999999999*W*JONSEYKEV*19000\ 00011229670
6220730002227007002 0000004476COML01 STATE OF IOWA 1091000011229671
705DED*CS*222222*020301*0000004476*999999999*W*JOHNSONJOH*19000\ 00011229671
6220730002227007002 0000002538COML01 STATE OF IOWA 091000011229672
705DED*CS*333333*020301*0000002538*999999999*W*NAMELASFIR*19000\ 00011229672
820000004800000000000000000000000000000000025014004465 091000010000000
Sample CTX File, ASC X12 820 Transaction Set
5200DESMOINES PLANT 3005269527CTXPAYMENT 0003130731091000018186622
6220700002227007002 000011343500020877 0014COLLECTION SERVI 1021000028186652
705ISA*00* *00* *ZZ*DD90520 *01*100026753 *000508*20300018186652
7052**U**00401*000000001*0**P*>\GS*RA*005269527*100026752*000508*2032*X*004010\ST8200028186652
705*0**000000001**\BPR*D*1134.35*C*DXC*CTX*01*021309379*DA*0601228265*3005269527**000038186652
7051*070000222*DA*7007002*000512*PCS\DED*CS*111111*000508*2372*333333333*N*NAMES,FIR0048186652
705*019000\DED*CS*11111*2000508*6600*333333333*N*LSTNAMEFIR*19000\DED*CS*111111*20000058186652
7050805*31250*333333333*N*LSTNAMEFIR*19000\DED*CS*111111*2000508*31731*333333333*N*00068186652
705LNAMES,FIR*19000\DED*CS*11111*2000508*5000*333333333*N*LSTNAMEFIR*19000\DED*CS*100078186652
70511111*000508*9650*333333333*N*LSTNAMEFIR*19000\DED*CS*111111*2000508*9132*33333300088186652
705333*N*LNAME,FIR*19000\DED*CS*111111*2000508*17700*333333333*N*LNAMEFIR*19000\00000098186652
70500SE*11*0001\GE*1*1\IEA*1*000000001\ 00108186652
820000001100000000000000000000000000001587763005269527 091000010000000