Electronic Income Withholding Order Storage Table Structure

The contents of each incoming Electronic Income Withholding Order (e-IWO) file is stored in Payroll Interface inbound storage tables. These tables use extensible flexfield contexts to map e-IWO attributes to table columns.

Storage Tables

These Payroll Interface storage tables capture the e-IWO attributes.

Table name	What it does
HRY_PI_INBD_RECORDS	Base table storing e-IWO file identifying info, such as: File control number File creation date
HRY_PI_INBD_RECORD_INFORMATION	Extensible flexfield enabled child table

Extensible Flexfield

These Payroll Interface storage tables are enabled for the following extensible flexfield.

Name	Type	Code
Payroll Interface Inbound Record EFF	Extensible Flexfield	ORA_HRY_PI_INBD_RECORDS_INFO_EFF

e-IWO Attribute Mapping

Inbound File Information

The HRY_PI_INBD_RECORDS storage table stores the following e-IWO inbound file identifying info.

e-IWO attribute	Table column
File Control Number	ENTITY_IDENTIFIER
Creation Date	START_DATE
Creation Time	RECORD_IDENTIFIER

The e-IWO inbound file header and trailer attributes captured by the File Header Trailer flexfield context are stored in the HRY_PI_INBD_RECORD_INFORMATION storage table.

Flexfield segment	Table column
File Header Control Number	IRI_INFORMATION2
File Header Document Code	IRI_INFORMATION1
File Header EIN	IRI_INFORMATION4
File Header e-IWO Creation Date	IRI_INFORMATION_DATE1
File Header e-IWO Creation Time	IRI_INFORMATION6
File Header Error Field Name	IRI_INFORMATION7
File Header Primary EIN	IRI_INFORMATION5
File Header State FIPS Code	IRI_INFORMATION3
File Name	IRI_INFORMATION31
File Trailer Batch Count	IRI_INFORMATION_NUMBER1
File Trailer Control Number	IRI_INFORMATION9
File Trailer Document Code	IRI_INFORMATION8
File Trailer Error Field Name	IRI_INFORMATION10
File Trailer Employer Sent Count	IRI_INFORMATION_NUMBER3
File Trailer Record Count	IRI_INFORMATION_NUMBER2
File Trailer State Sent Count	IRI_INFORMATION_NUMBER4

Batch Info

The HRY_PI_INBD_RECORDS storage table stores the following e-IWO batch identifying info.

e-IWO attribute	Table column
File Control Number	BATCH_CODE
Batch Control Number	ENTITY_IDENTIFIER
Batch Creation Date	START_DATE
Batch Creation Time	RECORD_IDENTIFIER

The e-IWO batch header and trailer attributes captured by the e-IWO Batch Header Trailer flexfield context are stored in the HRY_PI_INBD_RECORD_INFORMATION storage table.

Flexfield segment	Table column
Batch Header Control Number	IRI_INFORMATION2
Batch Header Document Code	IRI_INFORMATION1
Batch Header EIN	IRI_INFORMATION4
Batch Header e-IWO Creation Date	IRI_INFORMATION_DATE1
Batch Header e-IWO Creation Time	IRI_INFORMATION6
Batch Header Error Field Name	IRI_INFORMATION7
Batch Header Primary EIN	IRI_INFORMATION5
Batch Header State FIPS Code	IRI_INFORMATION3
Batch Trailer Batch Count	IRI_INFORMATION_NUMBER1
Batch Trailer Control Number	IRI_INFORMATION9
Batch Trailer Document Code	IRI_INFORMATION8
Batch Trailer Error Field Name	IRI_INFORMATION10
Batch Trailer Employer Sent Count	IRI_INFORMATION_NUMBER3
Batch Trailer Record Count	IRI_INFORMATION_NUMBER2
Batch Trailer State Sent Count	IRI_INFORMATION_NUMBER4

e-IWO Order Info

The HRY_PI_INBD_RECORDS storage table stores the following e-IWO identifying info.

e-IWO attribute	Table column
Case Identifier	BATCH_CODE
SSN	ENTITY_IDENTIFIER
Document Image Text	RECORD_IDENTIFIER
File Creation Date	START_DATE

The e-IWO attributes stored in the HRY_PI_INBD_RECORD_INFORMATION storage table are captured in the following flexfield contexts.

• e-IWO Acknowledgment Information

• e-IWO Amount Information

• e-IWO Child Information

• e-IWO Employer-Initiated Acknowledgment Information

• e-IWO Order Information

• e-IWO Process Information

e-IWO Acknowledgment Info

Flexfield segment	Table column
Acknowledgment Time Stamp	IRI_INFORMATION10
Document Action Code	IRI_INFORMATION12
Exclude Order	IRI_INFORMATION13
Acknowledgment Control Number	IRI_INFORMATION33
Corrected EIN	IRI_INFORMATION34
Error Field Name1	IRI_INFORMATION31
Error Field Name2	IRI_INFORMATION32
Multiple Error Indicator	IRI_INFORMATION11
Document Code	IRI_INFORMATION1
Acknowledgment File Name	IRI_INFORMATION30
File Control Number	IRI_INFORMATION47
Batch Control Number	IRI_INFORMATION48

e-IWO Amount Info

Flexfield segment	Table column
Arrears Overdue more than 12 Weeks	IRI_INFORMATION10
Batch Control Number	IRI_INFORMATION48
File Control Number	IRI_INFORMATION47
Income Withholding Biweekly Amount	IRI_INFORMATION_NUMBER10
Income Withholding Monthly Amount	IRI_INFORMATION_NUMBER12
Income Withholding Semimonthly Amount	IRI_INFORMATION_NUMBER11
Income Withholding Weekly Amount	IRI_INFORMATION_NUMBER9
Lump Sum Payment Amount	IRI_INFORMATION_NUMBER13
Obligation Other Amount	IRI_INFORMATION_NUMBER7
Obligation Other Description Text	IRI_INFORMATION8
Obligation Other Frequency Code	IRI_INFORMATION7
Obligation Total Amount	IRI_INFORMATION_NUMBER8
Obligation Total Frequency Code	IRI_INFORMATION9
Support Current Child Amount	IRI_INFORMATION_NUMBER1
Support Current Child Frequency Code	IRI_INFORMATION1
Support Current Medical Amount	IRI_INFORMATION_NUMBER3
Support Current Medical Frequency Code	IRI_INFORMATION3
Support Current Spousal Amount	IRI_INFORMATION_NUMBER5
Support Current Spousal Frequency Code	IRI_INFORMATION5
Support Past Due Child Amount	IRI_INFORMATION_NUMBER2
Support Past Due Child Frequency Code	IRI_INFORMATION2
Support Past Due Medical Amount	IRI_INFORMATION_NUMBER4
Support Past Due Medical Frequency Code	IRI_INFORMATION4
Support Past Due Spousal Amount	IRI_INFORMATION_NUMBER6
Support Past Due Spousal Frequency Code	IRI_INFORMATION6

e-IWO Child Info

Flexfield segment	Table column
Child 1 Birth Date	IRI_INFORMATION_DATE1
Child 1 First Name	IRI_INFORMATION2
Child 1 Last Name	IRI_INFORMATION1
Child 1 Middle Name	IRI_INFORMATION3
Child 1 Name Suffix	IRI_INFORMATION4
Child 2 Birth Date	IRI_INFORMATION_DATE2
Child 2 First Name	IRI_INFORMATION6
Child 2 Last Name	IRI_INFORMATION5
Child 2 Middle Name	IRI_INFORMATION7
Child 2 Name Suffix	IRI_INFORMATION8
Child 3 Birth Date	IRI_INFORMATION_DATE3
Child 3 First Name	IRI_INFORMATION10
Child 3 Last Name	IRI_INFORMATION9
Child 3 Middle Name	IRI_INFORMATION11
Child 3 Name Suffix	IRI_INFORMATION12
Child 4 Birth Date	IRI_INFORMATION_DATE4
Child 4 First Name	IRI_INFORMATION14
Child 4 Last Name	IRI_INFORMATION13
Child 4 Middle Name	IRI_INFORMATION15
Child 4 Name Suffix	IRI_INFORMATION16
Child 5 Birth Date	IRI_INFORMATION_DATE5
Child 5 First Name	IRI_INFORMATION18
Child 5 Last Name	IRI_INFORMATION17
Child 5 Middle Name	IRI_INFORMATION19
Child 5 Name Suffix	IRI_INFORMATION20
Child 6 Birth Date	IRI_INFORMATION_DATE6
Child 6 First Name	IRI_INFORMATION22
Child 6 Last Name	IRI_INFORMATION21
Child 6 Middle Name	IRI_INFORMATION23
Child 6 Name Suffix	IRI_INFORMATION24
File Control Number	IRI_INFORMATION47
Batch Control Number	IRI_INFORMATION48

e-IWO Employer-Initiated Acknowledgment Info

Flexfield segment	Table column
Acknowledgment Time Stamp	IRI_INFORMATION10
Document Action Code	IRI_INFORMATION12
Exclude Order	IRI_INFORMATION13
Last Payment Amount	IRI_INFORMATION15
Acknowledgment Control Number	IRI_INFORMATION33
Termination Date	IRI_INFORMATION_DATE1
Last Payment Date	IRI_INFORMATION_DATE2
Document Code	IRI_INFORMATION1
Acknowledgment File Name	IRI_INFORMATION30
File Control Number	IRI_INFORMATION47
Batch Control Number	IRI_INFORMATION48

e-IWO Order Info

Flexfield segment	Table column
FIPS Code	IRI_INFORMATION31
First Error Field Name	IRI_INFORMATION44
Government Official Name	IRI_INFORMATION24
Issuing Jurisdiction Name	IRI_INFORMATION3
Issuing State, Tribe, or Territory Name	IRI_INFORMATION2
Issuing Tribunal Name	IRI_INFORMATION17
Issuing Official Title	IRI_INFORMATION25
Income Withholding CCPA Percentage	IRI_INFORMATION_NUMBER1
Income Withholding Start Date	IRI_INFORMATION_DATE3
Income Withholding Start Instruction	IRI_INFORMATION49
Multiple Errors Exist	IRI_INFORMATION46
Obligee First Name	IRI_INFORMATION14
Obligee Last Name	IRI_INFORMATION13
Obligee Middle Name	IRI_INFORMATION15
Obligee Name Suffix	IRI_INFORMATION16
Order Identifier	IRI_INFORMATION28
Payee Address	IRI_INFORMATION22
Payee Name	IRI_INFORMATION21
Payee Remittance FIPS Code	IRI_INFORMATION23
Penalty Liability Information Text	IRI_INFORMATION32
Remittance Identifier	IRI_INFORMATION29
Second Error Field Name	IRI_INFORMATION45
Send Employee a Copy	IRI_INFORMATION26
Specific Payee Withholding Limits Text	IRI_INFORMATION34
Send Payment Within Number of Days	IRI_INFORMATION20
State, Tribe, or Territory Name	IRI_INFORMATION18
Antidiscrimination Provisions Text	IRI_INFORMATION33
Batch Control Number	IRI_INFORMATION48
Begin Withholding Within Number of Days	IRI_INFORMATION19
Case Identifier	IRI_INFORMATION4
Document Action Code	IRI_INFORMATION1
Document Date	IRI_INFORMATION_DATE1
Document Image Text	IRI_INFORMATION30
Document Tracking Number	IRI_INFORMATION27
Employee Birth Date	IRI_INFORMATION_DATE2
Employee First Name	IRI_INFORMATION9
Employee Last Name	IRI_INFORMATION8
Employee Middle Name	IRI_INFORMATION10
Employee SSN	IRI_INFORMATION12
Employee State Contact Email Address	IRI_INFORMATION38
Employee State Contact Fax Number	IRI_INFORMATION37
Employee State Contact Name	IRI_INFORMATION35
Employee State Contact Phone Number	IRI_INFORMATION36
Employee Suffix	IRI_INFORMATION11
EIN	IRI_INFORMATION7
Employer Address	IRI_INFORMATION6
Employer Name	IRI_INFORMATION5
Employer State Contact Address	IRI_INFORMATION40
Employer State Contact Email Address	IRI_INFORMATION43
Employer State Contact Fax Number	IRI_INFORMATION42
Employer State Contact Name	IRI_INFORMATION39
Employer State Contact Phone Number	IRI_INFORMATION41
File Control Number	IRI_INFORMATION47

e-IWO Process Info

Flexfield segment	Table column
Historical Data	IRI_INFORMATION10
Validation Status	IRI_INFORMATION25
Validation Rejection Code	IRI_INFORMATION26
All Validation Rejection Codes	IRI_INFORMATION28
Transfer Status	IRI_INFORMATION29
Validation Message	IRI_INFORMATION31
Transfer Message 1	IRI_INFORMATION32
Transfer Message 2	IRI_INFORMATION33
Comments	IRI_INFORMATION36
Employee Payroll Frequency	IRI_INFORMATION2
Employee Work State	IRI_INFORMATION3
File Control Number	IRI_INFORMATION47
Notification Time Stamp	IRI_INFORMATION1
Batch Control Number	IRI_INFORMATION48

Calculation Card Attributes

Involuntary Deductions Card Fields

The following table illustrates how the e-IWO attributes map to values on the employee Involuntary Deductions card.

Storage table flexfield context	Storage table flexfield segment	Storage table column	Card attribute
e-IWO Order Information	Payee Name	IRI_INFORMATION21	Order Amount Payee
e-IWO Order Information	Payee Remittance FIPS Code	IRI_INFORMATION23	FIPS Code
e-IWO Order Information	Issuing Jurisdiction Name	IRI_INFORMATION3	Issuing Jurisdiction Name
e-IWO Order Information	Remittance Identifier	IRI_INFORMATION29	Remittance Identifier
e-IWO Order Information	Income Withholding Start Date	IRI_INFORMATION_DATE3	Start Date
e-IWO Order Information	Issuing State, Tribe, or Territory Name	IRI_INFORMATION2	Issuing Authority Name
e-IWO Order Information	Order Identifier	IRI_INFORMATION28	Involuntary Deduction Number
e-IWO Order Information	Case Identifier	IRI_INFORMATION4	CSE Agency Case Identifier
e-IWO Order Information	Document Date	IRI_INFORMATION_DATE1	Received Date
e-IWO Order Information	Document Tracking Number	IRI_INFORMATION27	Document Tracking Number
e-IWO Amount Information	Arrears Overdue more than 12 Weeks	IRI_INFORMATION10	Arrears Overdue More Than 12 Weeks
e-IWO Amount Information	Obligation Total Frequency Code	IRI_INFORMATION9	Frequency
e-IWO Child Information	Child 1 Birth Date	IRI_INFORMATION_DATE1	Date of Birth of Child 1
e-IWO Child Information	Child 1 First Name	IRI_INFORMATION2	First Name of Child 1
e-IWO Child Information	Child 1 Last Name	IRI_INFORMATION1	Last Name of Child 1
e-IWO Child Information	Child 1 Middle Name	IRI_INFORMATION3	Middle Name of Child 1
e-IWO Child Information	Child 1 Name Suffix	IRI_INFORMATION4	Suffix of Child 1
e-IWO Child Information	Child 2 Birth Date	IRI_INFORMATION_DATE2	Date of Birth of Child 2
e-IWO Child Information	Child 2 First Name	IRI_INFORMATION6	First Name of Child 2
e-IWO Child Information	Child 2 Last Name	IRI_INFORMATION5	Last Name of Child 2
e-IWO Child Information	Child 2 Middle Name	IRI_INFORMATION7	Middle Name of Child 2
e-IWO Child Information	Child 2 Name Suffix	IRI_INFORMATION8	Suffix of Child 2
e-IWO Child Information	Child 3 Birth Date	IRI_INFORMATION_DATE3	Date of Birth of Child 3
e-IWO Child Information	Child 3 First Name	IRI_INFORMATION10	First Name of Child 3
e-IWO Child Information	Child 3 Last Name	IRI_INFORMATION9	Last Name of Child 3
e-IWO Child Information	Child 3 Middle Name	IRI_INFORMATION11	Middle Name of Child 3
e-IWO Child Information	Child 3 Name Suffix	IRI_INFORMATION12	Suffix of Child 3
e-IWO Child Information	Child 4 Birth Date	IRI_INFORMATION_DATE4	Date of Birth of Child 4
e-IWO Child Information	Child 4 First Name	IRI_INFORMATION14	First Name of Child 4
e-IWO Child Information	Child 4 Last Name	IRI_INFORMATION13	Last Name of Child 4
e-IWO Child Information	Child 4 Middle Name	IRI_INFORMATION15	Middle Name of Child 4
e-IWO Child Information	Child 4 Name Suffix	IRI_INFORMATION16	Suffix of Child 4
e-IWO Child Information	Child 5 Birth Date	IRI_INFORMATION_DATE5	Date of Birth of Child 5
e-IWO Child Information	Child 5 First Name	IRI_INFORMATION18	First Name of Child 5
e-IWO Child Information	Child 5 Last Name	IRI_INFORMATION17	Last Name of Child 5
e-IWO Child Information	Child 5 Middle Name	IRI_INFORMATION19	Middle Name of Child 5
e-IWO Child Information	Child 5 Name Suffix	IRI_INFORMATION20	Suffix of Child 5
e-IWO Child Information	Child 6 Birth Date	IRI_INFORMATION_DATE6	Date of Birth of Child 6
e-IWO Child Information	Child 6 First Name	IRI_INFORMATION22	First Name of Child 6
e-IWO Child Information	Child 6 Last Name	IRI_INFORMATION21	Last Name of Child 6
e-IWO Child Information	Child 6 Middle Name	IRI_INFORMATION23	Middle Name of Child 6
e-IWO Child Information	Child 6 Name Suffix	IRI_INFORMATION24	Suffix of Child 6

Involuntary Deductions Card Overrides

The following table illustrates how the e-IWO attributes map to values on the employee Involuntary Deductions card overrides.

Storage table flexfield context	Storage table flexfield segment	Storage table column	Card attribute	Value type
e-IWO Amount Information	Obligation Total Amount	IRI_INFORMATION_NUMBER8	Total Withholding Amount	Total Amount
e-IWO Amount Information	Support Current Child Amount	IRI_INFORMATION_NUMBER1	Proration Child Support Current Amount	Total Amount
e-IWO Amount Information	Support Current Medical Amount	IRI_INFORMATION_NUMBER3	Proration Medical Support Current Amount	Total Amount
e-IWO Amount Information	Support Current Spousal Amount	IRI_INFORMATION_NUMBER5	Proration Spousal Support Current Amount	Total Amount
e-IWO Amount Information	Support Past Due Child Amount	IRI_INFORMATION_NUMBER2	Proration Child Support Arrears Amount	Total Amount
e-IWO Amount Information	Support Past Due Medical Amount	IRI_INFORMATION_NUMBER4	Proration Medical Support Arrears Amount	Total Amount
e-IWO Amount Information	Support Past Due Spousal Amount	IRI_INFORMATION_NUMBER6	Proration Spousal Support Arrears Amount	Total Amount
e-IWO Amount Information	Obligation Other Amount	IRI_INFORMATION_NUMBER7	Proration Other Amount	Total Amount
e-IWO Order Information	Income Withholding CCPA Percentage	IRI_INFORMATION_NUMBER1	Exemption Percentage	Rate

Involuntary Deductions Card Component Contexts

The following table illustrates how the e-IWO attributes map to values on the employee Involuntary Deductions card component contexts.

Storage table flexfield context	Storage table flexfield segments	Storage table columns	Card attribute
e-IWO Order Information	Case Identifier Issuing State Remittance ID	IRI_INFORMATION4 DECODE(IRI_INFORMATION31) IRI_INFORMATION29	Reference Code
e-IWO Order Information	Issuing State	DECODE( IRI_INFORMATION31 )	State
e-IWO Process Information	Employee Work State	IRI_INFORMATION3	State