Who's On?

	Membership:
	Latest: sakkatan
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5216

	People Online:
	Visitors: 35
	Members: 0
	Total: 35

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

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

2 Replies

0 Subscribed to this topic

69 Subscribed to this forum

Sort:

Author

Messages

TRACY

Veteran Member

Posts: 58

1/30/2012 2:45 PM

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

MVP

New Poster

Engaged Reader

Avid Reader

1/30/2012 7:33 PM

PA67 only references 6 tables.

EMPLOYEE
HISTERR
HRSECLEV
PERSACTHST
PRRATEHIST
PRSYSTEM

Woozy

Veteran Member

Posts: 709

New Poster

1/30/2012 8:04 PM

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.