Federal Parent Locator Service Record Layouts
Electronic Income Withholding Order (e-IWO) Document Version 1.0
OMB Control No.: 0970-0154 Expiration Date: xx/xx/xxxx
Chart D-1 is the universal header record layout established for the e-IWO system.
Chart D-2 is the universal trailer record layout established for the e-IWO system.
Chart D-3 is the e-IWO Detail record layout established for the e-IWO system.
Chart D-4 is the Employer Acknowledgement record layout established for the e-IWO system.
Public reporting burden for this collection of information is estimated to average 5 minutes per response for Non-IV-D CPs; 2 minutes per response for employers; 3 seconds for e-IWO employers, including the time for reviewing instructions, gathering and maintaining the data needed, and reviewing the collection of information.
An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number.
Chart D-1: Universal Header (File And Batch)
|
||||||
Element Name |
Definition |
Location |
Length |
Type |
Req./ Opt. |
Data Element Rules |
Document Code |
A code that indicates whether the header is for a file or a batch and the type of record that follows. |
1-3 |
3 |
A |
R |
Required for all headers. First two characters indicate header type. FH always indicates a File Header. BH always indicates a Batch Header. Third character indicates the record type. The record types are: A – Acknowledgement: file sent from an employer to a state (FHA, BHA) I – IWO Detail: file sent from a state to an employer (FHI, BHI) K – Acknowledgement Result: file sent from the portal to an employer (FHK, BHK). Used by the portal. S – IWO Result: file sent from the portal to a state (FHS, BHS). Used by the portal. |
Control Number |
An identifier assigned by the state, tribe or territory, employer or payroll processor that uniquely identifies a file or group of records in a batch. |
4-25 |
22 |
A/N |
R |
Required for all headers. A unique, alphanumeric element that identifies a specific file or a batch within a file. You cannot reuse previously submitted control numbers. The File Header (FH) will have a unique control number to identify a file. The state must assign a unique control number for each employer batch (BHI) contained in a file. Recommended format: 5 Digit FIPS – 21000 (two-digit state FIPS Code number followed by three zeroes) Date – YYMMDD Time – HHMMSSS Sequence # – 0000 For Acknowledgements, employers may enter an identifier of their choosing. |
State FIPS Code |
The state/tribe/ territory state FIPS Code. |
26-30 |
5 |
A/N |
CR |
Format: 21000 (two-digit state FIPS Code number followed by three zeroes) IWO Detail sent by states: FHI – Required – Input own FIPS Code BHI – Required – Input own FIPS Code Acknowledgement sent by an employer or their payroll processor: FHA – Fill with spaces BHA – Required – Input state, tribe or territory for which the batch is intended |
EIN Text |
The Employer’s Identification Number (EIN). |
31-39 |
9 |
A/N |
CR |
IWO Detail sent by states: FHI – Fill with spaces BHI – Required – Employer FEIN Acknowledgement sent by employers: FHA – Required – Employer FEIN BHA – Required – Employer FEIN Acknowledgement sent by the primary employer with multiple FEINs or third party: FHA – Fill with spaces BHA – Optional – Can input primary FEIN |
Primary EIN Text |
The federal EIN of the parent company that is processing IWOs for its subsidiaries or a third party processing IWOs for an employer. |
40-48 |
9 |
A/N |
CR |
Acknowledgement sent by an employer with one FEIN: FHA – Fill with spaces BHA – Fill with spaces Acknowledgement sent by the primary employer with multiple FEINs or a third party processor: FHA – Required – Input Primary FEIN BHA – Required – Input Primary FEIN IWO Detail sent by states: FHI – Fill with spaces BHI – Fill with spaces |
Creation Date |
The date the header was generated. |
49-56 |
8 |
A/N |
R |
Required for all headers. Must be a valid date in CCYYMMDD format. |
Creation Time |
The time the header was generated. |
57-62 |
6 |
A/N |
R |
Required for all headers. Must be a valid time in HHMMSS format. |
Error Field Name Text |
The list of fields that did not pass the e-IWO edits. |
63-80 |
18 |
A/N |
O |
Used only by the portal to return the abbreviated version of field names in error. Each code will be separated by a comma. Valid values: FPS – State FIPS Code field EIN – EIN Text field DOC – Document Code field CNM – Control Number field PPE – Payroll Processor EIN Text field CDT – Creation Date field CTM – Creation Time field DUP – File Already Received |
Filler
|
Reserved for future use. |
81 |
Varies based on record
|
A/N |
O |
The filler length varies according to the file that it is associated with. Append the following number of spaces to complete the record.
IWO Detail (FHI and BHI) – 2326 spaces Acknowledgement (FHA and BHA) – 493 spaces IWO Result (FHS and BHS) – 2326 Acknowledgement Result (FHK and BHK) – 493 |
Chart D-2: Universal Trailer (File And Batch)
|
||||||
Element Name |
Definition |
Location |
Length |
Type |
Req./ Opt. |
Data Element Rules |
Document Code |
A code that indicates whether the trailer is for a file or a batch and the type of record(s). |
1-3 |
3 |
A |
R |
Required for all trailers. First two characters indicate trailer type. FT always indicates a File Trailer, BT always indicates a Batch Trailer. Third character indicates the record type. The record types are: A – Acknowledgement: file sent from an employer to a state (FTA, BTA). I – IWO Detail: file sent from a state to an employer (FTI, BTI). K – Acknowledgement Result: file sent from the portal to an employer (FTK, BTK). Used by the portal. S – IWO Result: file sent from the portal to a state (FTS, BTS). Used by the portal. |
Control Number |
An identifier assigned by the state, tribe or territory that uniquely identifies a file or group of records in a batch. |
4-25 |
22 |
A/N |
R |
Required for all trailers. A unique alphanumeric element that identifies a specific file or a batch within a file. This must be the same number specified in the corresponding File or Batch Header Control Number. |
Batch Count |
Indicates the number of batches contained in the file. |
26-30 |
5 |
N |
R |
Used with file trailers (FTI, FTA, FTS, and FTK). Zero fill if batch trailers (BTI, BTA, BTS and BTK). |
Record Count |
Indicates the number of records contained in a batch. |
31-35 |
5 |
N |
R |
Used with batch trailers (BTI, BTA, BTS, and BTK). Zero fill if file trailers (FTI, FTA, FTS, and FTK). |
Employer Sent Count |
Indicates the number of valid records sent to an employer after the editing process. |
36-40 |
5 |
N |
CR |
Used for IWO Results File (BTS). Only used by the portal. Always fill with zeroes. |
State Sent Count |
Indicates the number of valid records sent to a state after the editing process. |
41-45 |
5 |
N |
CR |
Used for Acknowledgement Results File (BTK). Only used by the portal. Always fill with zeroes. |
Error Field Name Text |
The list of fields that did not pass the e-IWO edits. |
46-63 |
18 |
A/N |
O |
Used only by the portal to return the abbreviated version of field names in error. Each code will be separated by a comma. Valid Values: DOC – Document Code field CNM – Control Number field BCT – Batch Count field RCT – Record Count field REC – Invalid file structure ECT – Employer Sent Count field SCT – State Sent Count field |
Filler
|
Reserved for future use. |
64 |
Varies base on record |
A/N |
O |
The filler length varies according to the file that it is associated with. Append the following number of spaces to complete the record.
IWO Detail (FTI and BTI) – 2343 Acknowledgement (FTA and BTA) – 510 spaces IWO Result (FTS and BTS) – 2343 Acknowledgement Result (FTK and BTK) – 510 |
Chart D-3: e-IWO Detail Record
|
|||||||
Element Name |
Definition |
Location |
Length |
Type |
Req/ Opt |
Data Element Rules |
Form XRef |
Document Code |
A code that indicates the primary e-IWO record follows. |
1-3 |
3 |
A/N |
R |
Value must always be DTL. |
N/A |
Filler |
For future use |
4-6 |
3 |
A/N |
O |
|
N/A |
Document Action Code |
A code that indicates the type of IWO document. |
7-9 |
3 |
A/N |
R |
Valid Values: AMD – Amended: any change for the submitted case number/identifier by the submitting state, except termination to the original order. LUM – Lump Sum: sent when a state, tribe, or territory is notified, or made aware, that a lump sum payment will be made and they are requesting a deduction be made from this lump sum. ORG – Original: new order for the submitted case number/identifier by the submitting state. TRM – Termination: closure of an order, stoppage of wage withholding for the submitted case number/identifier by the submitting state. |
1a 1b 1c 1d
|
Document Date |
The date the record was generated. |
10-17 |
8 |
A/N |
R |
Must be a valid date in CCYYMMDD format. |
1e |
Issuing State-Tribe-Territory Name |
The name of the jurisdiction (state, tribe, territory, etc.) issuing the document. |
18-52 |
35 |
A/N |
R |
State, tribe, or territory full name. The first character must not be a space. |
1g
|
Issuing Jurisdiction Name |
The name of the county, city, district or tribe issuing the document. |
53-87 |
35 |
A/N |
O |
If entered, should be a full name. |
1i |
Case Identifier |
A value assigned by a state to uniquely identify each IV-D case in the state. |
88-102 |
15 |
A/N |
R |
Must be the IV-D Case ID submitted for all external FPLS sources, FCR, etc. |
1l |
Employer Name |
Name of the employer/ withholder to whom the withholding order is being sent. |
103-159 |
57 |
A/N |
R |
The first character must not be a space. |
2a |
Employer Address Line 1 Text |
Line 1 of the employer/withholder’s address. |
160-184 |
25 |
A/N |
R |
The first character must not be a space. |
2b |
Employer Address Line 2 Text |
Line 2 of the employer/withholder’s address. |
185-209 |
25 |
A/N |
O |
The first character must not be a space. |
2b |
Employer Address City Name |
Employer/withholder’s city name. |
210-231 |
22 |
A/N |
R |
The first character must not be a space. |
2b |
Employer Address State Code |
Employer/withholder’s state code. |
232-233 |
2 |
A |
R |
Valid two-character alphabetic state or territory code. |
2b |
Employer Address ZIP Code |
Employer/withholder’s ZIP Code. |
234-238 |
5 |
N |
R |
|
2b |
Employer Address Ext ZIP Code |
Employer/withholder’s extension ZIP Code. |
239-242 |
4 |
A/N |
O |
|
2b |
EIN Text |
Employer/withholder’s FEIN. |
243-251 |
9 |
N |
R |
Must contain a FEIN of an employer participating in the e-IWO project. This FEIN must match the FEIN in the Batch Header. |
2c |
Employee Last Name |
Obligor’s last name. |
252- 271 |
20 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3a |
Employee First Name |
Obligor’s first name. |
272-286 |
15 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3a |
Employee Middle Name |
Obligor’s middle name or initial. |
287-301 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3a |
Employee Suffix |
Obligor’s name suffix. |
302-305 |
4 |
A/N |
O |
|
3a |
Employee SSN |
Obligor’s Social Security number. |
306-314 |
9 |
N |
R |
|
3b |
Employee Birth Date |
Obligor’s date of birth. |
315-322 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill with spaces. |
33 |
Obligee Last Name |
Obligee’s last name. |
323-379 |
57 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3c |
Obligee First Name |
Obligee’s first name. |
380-394 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3c |
Obligee Middle Name |
Obligee’s middle name or initial. |
395-409 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3c |
Obligee Name Suffix |
Obligee’s name suffix. |
410-413 |
4 |
A/N |
O |
|
3c |
Issuing Tribunal Name |
The name of the state, tribe or territory that issued the support or withholding order. |
414-448 |
35 |
A/N |
R |
Must contain full name. |
4 |
Support Current Child Amount |
The dollar amount to be withheld for payment of current child support. |
449-459 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
5a |
Support Current Child Frequency Code |
The interval the support current amount is required to be paid. |
460 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Current Child Amount field (449-459), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
5b |
Support Past Due Child Amount |
The dollar amount to be withheld for payment of past-due child support. |
461-471 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
6a |
Support Past Due Child Frequency Code |
The interval the past-due child support amount is required to be paid. |
472 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Past Due Child Amount field (461-471), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
6b |
Support Current Medical Amount |
The dollar amount to be withheld for payment of current medical support. |
473-483 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
7a |
Support Current Medical Frequency Code |
The interval the current medical support amount is required to be paid. |
484 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Current Medical Amount field (473-483), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
7b |
Support Past Due Medical Amount |
The dollar amount to be withheld for payment of past-due medical support. |
485-495 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
8a |
Support Past Due Medical Frequency Code |
The interval the past-due medical support amount is required to be paid. |
496 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Past Due Medical Amount field (485-495), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
8b |
Support Current Spousal Amount |
The dollar amount to be withheld for payment of current spousal support. |
497-507 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
9a |
Support Current Spousal Frequency Code |
The interval the spousal support is required to be paid. |
508 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Current Spousal Amount field (497-507), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
9b |
Support Past Due Spousal Amount |
The dollar amount to be withheld for payment of past-due spousal support. |
509-519 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
10a |
Support Past Due Spousal Frequency Code |
The interval the past-due spousal support amount is required to be paid. |
520 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Support Past Due Spousal Amount field (509-519), this field is required. Valid values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
10b |
Obligation Other Amount |
The dollar amount to be withheld for payment of miscellaneous obligations. |
521-531 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
11a |
Obligation Other Frequency Code |
The interval the miscellaneous obligations amount is required to be paid. |
532 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Obligation Other Amount field (521-531), this field is required. Valid Values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
11b |
Obligation Other Description Text |
Description of the miscellaneous obligations. |
533-567 |
35 |
A/N |
CR |
If there is a dollar amount other than zero in the Obligation Other Amount field (521-531), this field is required. |
11c |
Obligation Total Amount |
The sum of the current child support, the past-due child support, the current cash medical support, the past-due cash medical support, the current spousal support, the past-due spousal support, and the miscellaneous obligations. |
568-578 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
12a |
Obligation Total Frequency Code |
The interval the total obligation is required to be paid. |
579 |
1 |
A/N |
CR |
If there is a dollar amount other than zero in the Obligation Total Amount field (568-578), this field is required. Valid Values: A – Annually B – Bi-Weekly M – Monthly Q – Quarterly S – Semi-Monthly W – Weekly X – Semi-Annually Space Fill if N/A |
12b |
Arrears 12wk Overdue Code |
Indicates whether past due child support is in arrears for a period longer than 12 weeks. |
580 |
1 |
A/N |
O |
Valid values: Y – Greater than 12 weeks N – Not Greater than 12 weeks Space allowed. |
6c |
Income Withholding Deduction Weekly Amount |
The amount the employer should withhold if the employee is paid weekly. |
581-591 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
13a |
Income Withholding Deduction Bi-Weekly Amount |
The amount the employer should withhold if the employee is paid every two weeks. |
592-602 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
13b |
Income Withholding Semimonthly Amount |
The amount the employer should withhold if the employee is paid twice a month. |
603-613 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
13c |
Income Withholding Monthly Amount |
The amount the employer should withhold if the employee is paid once a month. |
614-624 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A |
13d |
State Tribe Territory Name |
The state, tribe or territory sending the document. |
625-659 |
35 |
A/N |
O |
|
15, 20 |
Begin Withholding Within Days Number |
The number of days within which the employer must commence income withholding. |
660-661 |
2 |
N |
R |
|
16 |
Income Withholding Start Date |
The effective date of the income withholding. |
662-669 |
8 |
A/N |
R |
Must be a valid date in CCYYMMDD format. |
17 |
Send Payment Within Days Number |
Number of days within which an employer or other withholder of income must remit amounts withheld pursuant to the issuing state’s law. |
670-671 |
2 |
N |
R |
|
18 |
Income Withholding CCPA Percent Rate |
The highest percentage of income that can be withheld from the employee or obligor’s wages. |
672-673 |
2 |
N |
R |
|
19 |
Payee Name |
The name of the state disbursement unit, individual, tribunal/court, or tribal child support enforcement agency to which payments are required to be sent. |
674-730 |
57 |
A/N |
R |
The first character must not be a space. |
23 |
Payee Address Line 1 Text |
Line 1 of the payee’s address. |
731-755 |
25 |
A/N |
O |
|
24 |
Payee Address Line 2 Text |
Line 2 of the payee’s address. |
756-780 |
25 |
A/N |
O |
|
24 |
Payee Address City Name |
Payee’s city address. |
781-802 |
22 |
A/N |
O |
|
24 |
Payee Address State Code |
Payee’s state code. |
803-804 |
2 |
A |
O |
Valid two-character alphabetic state or territory code. |
24 |
Payee Address ZIP Code |
Payee’s ZIP Code. |
805-809 |
5 |
N |
O |
|
24 |
Payee Address Ext ZIP Code |
Payee’s extension ZIP Code. |
810-813 |
4 |
A/N |
O |
|
24 |
Payee Remittance FIPS Code |
State and county FIPS Code for remitting payments via EFT/EDI. |
814-820 |
7 |
N |
R |
Either state and county FIPS or tribal place code. The first two characters are the state code. The next three are the county code. The last two are filled by the user. Only the first five characters (state code and county code) are required. |
22 |
Government Official Name |
Name of government official authorizing the document. |
821-890 |
70 |
A/N |
R |
The first character must not be a space. |
27 |
Issuing Official Title Text |
Title of governmental official authorizing the document. |
891-940 |
50 |
A/N |
R |
The first character must not be a space. |
28 |
Filler |
Future Use |
941 |
1 |
A/N |
O |
Future use |
|
Send Employee Copy Indicator |
Indicates if employer is required to provide a copy of the notice to the employee. |
942 |
1 |
A/N |
R |
Valid values: Y – Yes N – No |
30 |
Penalty Liability Info Text |
Describes additional/ specific state, tribal, or territory penalties or liabilities regarding the employer’s failure to obey the notice. |
943-1102 |
160 |
A/N |
O |
States should insert the citation for the appropriate Penalty Liability text from their state law. |
31 |
Anti- discrimination Provisions Text |
Describes additional/specific information if the employer discharges, fails to employ, or disciplines the employee as a result of the notice. |
1103-1262 |
160 |
A/N |
O |
States should insert the citation for the appropriate anti-discrimination text from their state law. |
32 |
Specific Payee Withholding Limits Text |
Additional information regarding withholding limitations. |
1263-1422 |
160 |
A/N |
O |
|
33 |
Employee State Contact Name |
Contact name. |
1423-1479 |
57 |
A/N |
O |
|
47 |
Employee State Contact Phone Number |
Contact phone number. |
1480-1489 |
10 |
A/N |
O |
|
48 |
Employee State Contact Fax Number |
Contact fax number. |
1490-1499 |
10 |
A/N |
O |
|
49 |
Employee State Contact Email Address Text |
Contact email address. |
1500-1547 |
48 |
A/N |
O |
|
50 |
Document Tracking Number |
A number assigned by the entity sending the document that uniquely identifies the document. |
1548-1577 |
30 |
A/N |
R |
First two digits must begin with the numeric FIPS state code. |
21 |
Order Identifier |
A unique identifier that is associated with a specific child support obligation within a case. |
1578-1607 |
30 |
A/N |
O |
|
1j |
Employer State Contact Name |
Employer outreach or customer service contact name. |
1608-1664 |
57 |
A/N |
O |
|
42 |
Employer State Contact Address Line 1 Text |
Line 1 of the employer outreach or customer service contact’s address. |
1665-1689 |
25 |
A/N |
O |
|
46 |
Employer State Contact Address Line 2 Text |
Line 2 of the employer outreach or customer service contact’s address. |
1690-1714 |
25 |
A/N |
O |
|
46 |
Employer State Contact Address City Name |
Employer outreach or customer service contact’s city address. |
1715-1736 |
22 |
A/N |
O |
|
46 |
Employer State Contact Address State Code |
Employer outreach or customer service contact’s state code. |
1737-1738 |
2 |
A |
O |
Valid two-character alphabetic state or territory code. |
46 |
Employer State Contact Address ZIP Code |
Employer outreach or customer service contact ZIP Code. |
1739-1743 |
5 |
N |
O |
|
46 |
Employer State Contact Address Ext ZIP Code |
Employer outreach or customer service contact’s ZIP Code extension. |
1744-1747 |
4 |
A/N |
O |
|
46 |
Employer State Contact Phone Number |
Employer outreach or customer service contact phone number. |
1748-1757 |
10 |
A/N |
O |
|
43 |
Employer State Contact Fax Number |
Employer outreach or customer service contact fax number. |
1758-1767 |
10 |
A/N |
O |
|
44 |
Employer State Contact Email Address Text |
Employer outreach or customer service contact e-mail address. |
1768-1815 |
48 |
A/N |
O |
|
45 |
Child 1 Last Name |
Child’s last name. |
1816-1835 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 1 First Name |
Child’s first name. |
1836-1850 |
15 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 1 Middle Name |
Child’s middle name or initial. |
1851-1865 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 1 Suffix Name |
Child’s name suffix. |
1866-1869 |
4 |
A/N |
O |
|
3d |
Child 1 Birth Date |
Child’s date of birth. |
1870-1877 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Child 2 Last Name |
Child’s last name. |
1878-1897 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 2 First Name |
Child’s first name. |
1898-1912 |
15 |
A/N |
CR |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. If there is any other data present for Child 2, this field is required. |
3d |
Child 2 Middle Name |
Child’s middle name or initial. |
1913-1927 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 2 Suffix Name |
Child’s name suffix. |
1928-1931 |
4 |
A/N |
O |
|
3d |
Child 2 Birth Date |
Child’s date of birth. |
1932-1939 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Child 3 Last Name |
Child’s last name. |
1940-1959 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 3 First Name |
Child’s first name. |
1960-1974 |
15 |
A/N |
CR |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. If there is any other data present for Child 3, this field is required. |
3d |
Child 3 Middle Name |
Child’s middle name or initial. |
1975-1989 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 3 Suffix Name |
Child’s name suffix. |
1990-1993 |
4 |
A/N |
O |
|
3d |
Child 3 Birth Date |
Child’s date of birth. |
1994-2001 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Child 4 Last Name |
Child’s last name. |
2002-2021 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 4 First Name |
Child’s first name. |
2022-2036 |
15 |
A/N |
CR |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. If there is any other data present for Child 4, this field is required. |
3d |
Child 4 Middle Name |
Child’s middle name or initial. |
2037-2051 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 4 Suffix Name |
Child’s name suffix. |
2052-2055 |
4 |
A/N |
O |
|
3d |
Child 4 Birth Date |
Child’s date of birth. |
2056-2063 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Child 5 Last Name |
Child’s last name. |
2064-2083 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 5 First Name |
Child’s first name. |
2084-2098 |
15 |
A/N |
CR |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. If there is any other data present for Child 5, this field is required. |
3d |
Child 5 Middle Name |
Child’s middle name or initial. |
2099-2113 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 5 Suffix Name |
Child’s name suffix. |
2114-2117 |
4 |
A/N |
O |
|
3d |
Child 5 Birth Date |
Child’s date of birth. |
2118-2125 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Child 6 Last Name |
Child’s last name. |
2126-2145 |
20 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 6 First Name |
Child’s first name. |
2146-2160 |
15 |
A/N |
CR |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. If there is any other data present for Child 6, this field is required. |
3d |
Child 6 Middle Name |
Child’s middle name or initial. |
2161-2175 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
3d |
Child 6 Suffix Name |
Child’s name suffix. |
2176-2179 |
4 |
A/N |
O |
|
3d |
Child 6 Birth Date |
Child’s date of birth. |
2180-2187 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If unknown, fill this field with spaces. |
3e |
Lump Sum Payment Amount |
The dollar amount that should be withheld from a “Lump Sum” payment. |
2188-2198 |
11 |
N |
R |
If the Document Action Code (7-9) is ‘LUM,’ this field is required. Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A If the Document Action Code (7-9) is ‘TRM,’ ‘ORG,’ or ‘AMD,’ fill this field with zeroes. |
14 |
Filler |
For Future Use |
2199-2207 |
9 |
A/N |
O |
For Future Use |
|
Remittance Identifier |
The identifier that employers must include when sending payments for this IWO. |
2208-2227 |
20 |
A/N |
R |
The identifier that states want the employer to use so the state or tribe can identify and apply the payment correctly. This identifier may, but is not required to be, the case identifier designated by the state, tribe, or territory. |
1h
|
Document Image Text |
Uniquely identifies and associates cover letters, or other documents with an e-IWO to a data file. |
2228-2252 |
25 |
A/N |
O |
First two positions must be the state FIPS Code. |
N/A |
First Error Field Name |
Name of the first field that did not pass the |
2253-2284 |
32 |
A/N |
O |
Used only by the portal to return the first element that did not pass the portal edits. |
N/A |
Second Error Field Name |
Name of the second field that did not pass the e-IWO edits. |
2285-2316 |
32 |
A/N |
O |
Used only by the portal to return the second element that did not pass the portal edits. |
N/A |
Multiple Error Indicator |
Indicates that a record has more than two errors. |
2317 |
1 |
A/N |
O |
Valid values used only by the portal: T – True F – False If more than two errors exist in the record, this field will be set to ‘T.’ If less than two errors exist, it will be set to ‘F.’ |
|
Filler |
Future Use |
2318-2404 |
87 |
A/N |
O |
|
N/A |
FIPS Code |
Two digit numeric code for the state sending the order. |
2405-2406 |
2 |
N |
R |
The portal will fill in the state two digit numeric code. |
|
Chart D-4: e-IWO Acknowledgement Record
|
||||||
Element Name |
Definition |
Location |
Length |
Type |
Req./ Opt. |
Data Element Rules |
Document Code |
Indicates the acknowledgement record follows. |
1-3 |
3 |
A/N |
R |
Value must be ‘ACK’. |
Document Action Code |
Indicates the type of document. |
4-6 |
3 |
A/N |
R |
Valid Values: AMD – Amended: the value input by the state, tribe, or territory (pos. 7-9 in the Detail Record). EMP – Employer Initiated: for example, if the NCP is no longer employed, ‘EMP’ would be input and a value of ‘T’ would be placed in the Record Disposition Code (154-155). If an employer is notifying a state, tribe, or territory about a pending Lump Sum, they would input EMP and put an ‘L’ in the Record Disposition Code (154-155). LUM – Lump Sum: the value input by the state, tribe, or territory (7-9 in the Detail Record). ORG – Original: the value input by the state, tribe, or territory (7-9 in the Detail Record). TRM – Termination: the value input by the state, tribe, or territory (7-9 in the Detail Record). |
Case Identifier |
A case identifier is a value assigned by a state to uniquely identify each IV-D case in the state. |
7-21 |
15 |
A/N |
R |
This is the Case Identifier as input by the state in positions 88-102 of the e-IWO Detail record. |
EIN Text |
The Employer/ Withholder’s FEIN. |
22-30 |
9 |
N |
R |
|
Employee Last Name |
The Obligor’s Last Name. |
31-50 |
20 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
Employee First Name |
The Obligor’s First Name. |
51-65 |
15 |
A/N |
R |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
Employee Middle Name |
The Obligor’s Middle Name or Initial. |
66-80 |
15 |
A/N |
O |
Letters A-Z or spaces. No special characters except period, hyphens, apostrophes, and embedded spaces are allowed. The first character must not be a space. |
Employee Name Suffix |
The Obligor’s Name Suffix. |
81-84 |
4 |
A/N |
O |
|
Employee SSN |
The Obligor’s Social Security number. |
85-93 |
9 |
N |
R |
|
Document Tracking Number |
Assigned by the entity sending the document that uniquely identifies the document. |
94-123 |
30 |
A/N |
R |
This is the Document Tracking Number as input by the state in position 1548-1577 of the e-IWO Detail record. |
Order Identifier |
A unique identifier that is associated with a specific child support obligation within a case. |
124-153 |
30 |
A/N |
O |
This is the Order Identifier as input by the state in position 1578-1607 of the e-IWO Detail record. |
Record Disposition Status Code |
Indicates whether a record was accepted or rejected by the employer. |
154-155 |
2 |
A/N |
R |
Values are: A – Record Accepted L – Lump Sum R – Record Rejected S – Suspension T – Termination |
Disposition Reason Code |
The reason an e-IWO record is being accepted or rejected by an employer. |
156-158 |
3 |
A/N |
CR |
If the value in the Record Disposition Status equals ‘R,’ a reason code is required to be completed. Rejected Values are: B – Name Mismatch D – Duplicate IWO M – IWO received from multiple states N – NCP no longer at the employer O – Other Reason S – Employee is in a suspense status at employer U – NCP not known to employer W – Incorrect FEIN received for employee X – Employer could not electronically process this record. Z – Termination cannot be processed; no current IWO in place If the value in Record Disposition Status equals ‘A’ and it is for one of the following reasons, the code is required. Accepted Values are: B – Name Mismatch S – Employee is in a suspense status at employer W – Incorrect FEIN received for employee |
Filler |
Reserved for future use. |
159 |
1 |
A/N |
O |
|
Termination Date |
Date that an employee left or was terminated by an employer. |
160-167 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If not applicable, fill this field with spaces. |
NCP Last Known Address Line 1 Text |
Line 1 of the NCP’s last known address. |
168-192 |
25 |
A/N |
O |
|
NCP Last Known Address Line 2 Text |
Line 2 of the NCP’s last known address. |
193-217 |
25 |
A/N |
O |
|
NCP Last Known Address City Name |
NCP’s last known city address. |
218-239 |
22 |
A/N |
O |
|
NCP Last Known Address State Code |
NCP’s last known state code. |
240-241 |
2 |
A |
O |
Valid two-character alphabetic state or territory code. |
NCP Last Known Address ZIP Code |
NCP’s last known five-digit ZIP Code. |
242-246 |
5 |
N |
O |
|
NCP Last Known Address Ext ZIP Code |
NCP’s last known four-digit ZIP Code extension. |
247-250 |
4 |
A/N |
O |
|
Final Payment Made Date |
Date of the final payment sent to the SDU. |
251-258 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If not applicable, fill this field with spaces. |
Final Payment Amount |
Amount of the final payment sent to the SDU. This only applies when an employee has been terminated or left his/her employer. |
259-269 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A The last payment/wages that were paid to an NCP that has left or been terminated. |
New Employer Name |
Name of NCP’s new employer. |
270-326 |
57 |
A/N |
O |
|
New Employer Address Line 1 Text |
Line 1 of New Employer’s address. |
327-351 |
25 |
A/N |
O |
|
New Employer Address Line 2 Text |
Line 2 of New Employer’s address. |
352-376 |
25 |
A/N |
O |
|
New Employer Address City Name |
New Employer’s city name. |
377-398 |
22 |
A/N |
O |
|
New Employer State Code |
New Employer’s state code. |
399-400 |
2 |
A |
O |
Valid two-character alphabetic state or territory code |
New Employer Address ZIP Code |
New Employer’s five-digit ZIP Code. |
401-405 |
5 |
N |
O |
|
New Employer Address Ext ZIP Code |
New Employer’s four-digit ZIP Code extension. |
406-409 |
4 |
A/N |
O |
|
Payment Lump Sum Date |
The date an employer anticipates that a Lump Sum Payment will be disbursed to an employee. |
410-417 |
8 |
A/N |
O |
Must be a valid date in CCYYMMDD format. If there is a dollar amount other than zero in the Payment Lump Sum Amount (418-428), this field should be filled. If the Document Action Code (7-9) is ‘EMP’ and the Record Disposition Status Code (pos. 154-155) equals ‘T,’ this field must be blank. If unknown or not applicable, fill this field with spaces. |
Payment Lump Sum Amount |
The amount an employer intends to issue as a Lump Sum Payment to the employee. |
418-428 |
11 |
N |
R |
Numeric Decimal Assumed Unsigned No Rounding Right Justify Zero Fill to Left Zero Fill if N/A If the Document Action Code (7-9) is ‘EMP’ and the Record Disposition Status Code (pos. 154-155) equals ‘L,’ the dollar amount in this field must be filled with an amount greater than $0.00. If the Document Action Code (7-9) is ‘EMP’ and the Record Disposition Status Code (154-155) equals ‘T,’ this field must be zero filled. |
Payment Lump Sum Type Text |
The type of Lump Sum Payment that will be disbursed to an employee. Examples of a Lump Sum Payment include bonus, severance, commission, etc. |
429-463 |
35 |
A/N |
O |
Possible values are bonus, severance, or other unique identifiers. If the Document Action Code (7-9) is ‘EMP’ and the Record Disposition Status Code (154-155) equals ‘L,’ this field must be filled. If the Document Action Code (7-9) is ‘EMP’ and the Record Disposition Status Code (154-155) equals ‘T,’ this field must be blank. |
NCP Last Known Phone Number |
Last known phone number for the NCP. |
464-473 |
10 |
A/N |
O |
|
First Error Field Name |
Name of the first field that did not pass the |
474-505 |
32 |
A/N |
O |
Used only by the portal to return the first element that did not pass the portal edits. |
Second Error Field Name |
Name of the second field that did not pass the e-IWO edits. |
506-537 |
32 |
A/N |
O |
Used only by the portal to return the second element that did not pass the portal edits. |
Multiple Error Indicator |
Indicates that a record has more than two errors. |
538 |
1 |
A/N |
O |
Valid Values used only by the portal: T – True F – False If more than two errors exist in the record, this field will be set to ‘T.’ If less than two errors exist, this field will be set to ‘F.’ |
Correct FEIN |
The actual FEIN under which the employee is working. |
539-547 |
9 |
N |
CR |
If the Record Disposition Code is “W,” this field is required. |
Multi IWO State Code |
The state code for which an employer already has an IWO in place for the employee and the IWO just received is a duplicate. |
548-549 |
2 |
A |
CR |
If the Record Disposition Code is “M,” this field is required. |
Filler |
Future Use |
550-573 |
24 |
A/N |
O |
|
Appendix D: e-IWO Record
Layouts D-
File Type | application/msword |
File Title | e-IWO SIS_2 0_Appendix_D |
Subject | e-IWO SIS_2 0_Appendix_D |
Author | Office of Child Support Enforcement |
Last Modified By | Sargis, Robert A (ACF) |
File Modified | 2014-04-02 |
File Created | 2014-04-02 |