Data Element: Overflow Indicator

Data Overflow Indicator (XX:OVERFLOW) is a defined field in the EH and PY extract files and identifies employees whose volume of history exceeds the maximum record length allowed (31748 bytes).  Typically, this occurs when you are extracting history for a large range of dates.   

 

Employees with data overflow have a value of X for the field, XX:OVERFLOW and will be missing data for the specified time-frame. Always check your extract files for employees with data overflow before using the file for reporting purposes.  For example, the following report can be used to identify the name and SSN of employees with data overflow in an EH extract file:  

 

EX EH

TABLE FILE EH

PRINT EH:SSA EH:WNAME

IF EH:OVERFLOW EQ X

END

 

Additional items to note:

  • If you identify an employee with data overflow, create another extract file for that SSN using a smaller time-frame.

  • The status message and system notification message you receive for your extract job will NOT indicate employees with data overflow. The only way to identify employees with data overflow is to check the value of the field XX:OVERFLOW.

  • Even if your extract file contains employees with data overflow, it can still be used to test for syntax errors and formatting.

 

Related Topic: Employment History Data Overflow