For more information, please refer to this announcement explaining best practices for getting answers to questions.
value = ‘-999999999' is getting stored in table = PAY_RANGE_ITEMS_F for column value1federal tax car
Summary:
value = ‘-999999999' is getting stored in table = PAY_RANGE_ITEMS_F for column value1 for federal tax card information for "Filing Status "
When we checked the corresponding back end /database value for ‘Filing Status’ for given employees then it is found that value = ‘-999999999' is stored in the database table for that record .
these employees do not have any Federal Tax card information Except 'Filing Status' rest of the information if blank.
Although in the UI 'Filing Status' is 'Single or Married filing separately' its corresponding database value = ‘-999999999' for that record .
As per oracle note we are using lookup = 'HRX_US_FEDERAL_FILING_STATUS' to get 'Filing Status' meaning in the report .