Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 400
	Members: 0
	Total: 400

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

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

2 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

TRACY

Veteran Member Send Private Message

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 Send Private Message

Posts: 1498

1/30/2012 7:33 PM

PA67 only references 6 tables.

EMPLOYEE
HISTERR
HRSECLEV
PERSACTHST
PRRATEHIST
PRSYSTEM

Woozy

Veteran Member Send Private Message

Posts: 709

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.