The Benefit Code is missing on lookup

The Benefit Code is missing on lookup


Issue: On the company setup the look up does not show a benefit code.  Verification was completed to determine the benefit code is marked within the ACA Code Setup window and the Benefit Code was setup in the ACA plan setup window.  We can enter the benefit code into the company setup window but the look up is blank.

Resolution: Run the select statement:


Select * from UPR40800

where BENEFIT=’ ‘


Select * from PJUPR40800

where BENEFIT=’ ‘

if you have blank records then run the delete statement


DELETE from UPR40800

where BENEFIT=’ ‘



Where BENEFIT=’ ‘




If you would like to search for information and resources for Integrity Data products check out the following site:

If you have any questions or comments please email

Last Review:       November 13, 2015 – Revision: 1.0

Applies To:  ACA Compliance Solution

2016-07-08T11:20:35+00:00November 18th, 2015|0 Comments

Leave A Comment