Fast help needed:: Does anyone know what 'file' holds the percentage change shown on PA67?

Sort:
You are not authorized to post a reply.
Author
Messages
TRACY
Veteran Member
Posts: 58
Veteran Member
    I have found ISeries DBHRPRH holds the PA67 information, but what I am specifically looking for is the 'percentage shown' that is displayed on this file.  I am needing to dump 2011 information and can't find if there is a actual file with this percentage, or if I have to recompute in my SQL.  Thanks.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      PA67 only references 6 tables.

      EMPLOYEE
      HISTERR
      HRSECLEV
      PERSACTHST
      PRRATEHIST
      PRSYSTEM
      Woozy
      Veteran Member
      Posts: 709
      Veteran Member

        This value isn't stored in a table - it is a calculated value.  The value is calculated by comparing the current line PRRATEHIST.ANNUAL-SALARY with the previous effective dated (and/or seq num) record PRRATEHIST.ANNUAL-SALARY.

        The COBOL code looks like this:
             COMPUTE PA67WS-PCT-CHANGE ROUNDED = (((PA67F1-PRH-ANNUAL-SALARY (I1)
                                               -   PA67F1-PRH-ANNUAL-SALARY (I2))
                                               /   PA67F1-PRH-ANNUAL-SALARY (I2))
                                               *   100)

        Based on this, I think you're going to have to figure out how to do it in SQL.  Good Luck.

        Kelly Meade
        J. R. Simplot Company
        Boise, ID
        You are not authorized to post a reply.