e-IWO Validation Process

Once you have loaded an Electronic Income Withholding Order (e-IWO) into the storage tables, use this flow to validate the data.

The e-IWO Process flow automatically runs this flow for you. However, you can run it manually.

This flow:

1. Checks the data loaded into the e-IWO storage tables.

2. Validates each order according to Office of Child Support Services (OCSS) criteria and sets the status.

3. Issues the appropriate warning messages if needed in the Audit Report.

This flow assigns each order with one of these statuses.

Order status	What it means
VALID	Represents orders that were successfully processed. This includes orders that generated the following OCSS error codes. B: Employee Name Mismatch S: e-IWO Obligor Is Suspended Employee W: Employee Is Associated with Incorrect Employer Orders with this status are considered Accepted on the Acknowledgment file once they have been transferred to the Involuntary Deductions card.
INVALID	Represents orders processed and deemed invalid with the following error codes. B: Employee Name Mismatch D: Duplicate IWO N: Noncustodial Parent No Longer an Employee S: e-IWO Obligor Is Suspended Employee U: Noncustodial Parent Not an Employee W: Incorrect FEIN X: Unable to Process Record Z: Unable to Terminate Order Orders with this status are considered Rejected on the Acknowledgment file.
FAILED	Represents orders that failed to process due to internal errors, such as service unavailability. You must correct the error and repeat the processing. Orders with this status aren't included on the Acknowledgment file.
NULL	Represents orders the validation process was unable to process, regardless of reason. Orders with this status aren't included on the Acknowledgment file.

Run this flow to validate:

• New e-IWOs after the main e-IWO Process flow failed due to an error, such as a system failure

• Manual changes you made to data in the storage tables, such as after correcting errors in the Audit Report or changing an order's status

To run this flow:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Enter your US legislative data group (LDG).

4. Search for and select e-IWO Validation Process.

Before You Start

Retrieve the inbound order file from your secure FTP server.

Convert the e-IWO file into a .dat format supported by HDL.

Use HDL to load the .dat file into the e-IWO storage tables.

For further info, see Set Up Processing of e-IWOs in the Help Center.

Report Parameters

Legislative Data Group

Your US LDG.

Start Date

Start date on the inbound e-IWO file. The flow includes any unprocessed e-IWOs received within this range.

End Date

End of the date range for e-IWO processing. The flow includes any unprocessed e-IWOs received within this range.

Post Processing

When this flow completes:

1. Run the e-IWO Involuntary Deductions Card Load flow to update the obligor Involuntary Deductions cards.

2. Run the e-IWO Inbound Audit Report flow to generate the audit report, and review any errors. To be included in the Acknowledgment file, each order must be in either VALID or INVALID status.

3. Review the updated Involuntary Deductions cards for accuracy.

4. If additional changes are necessary, rerun the validation, card update, and audit report flows.

5. Run the e-IWO Employee Notification Report.

6. Run the e-IWO Acknowledgment flow.