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:
|
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 InformationThe 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 |
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 |
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 |
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 |
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 |