Who's On?

	Membership:
	Latest: Chris Radcliffe
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5187

	People Online:
	Visitors: 347
	Members: 0
	Total: 347

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

Best Practice for PR12

Sort:

You are not authorized to post a reply.

Author

Messages

Mary Porter

Veteran Member

Posts: 337

4/25/2013 4:55 PM

What is the best practice for maintaining PR12? Our payroll department would like to see a history of each time a PR12 record was changed.
and EMACHDEPST only keeps the last change, and I can't find any other tables that would hold changes. Should they be using the Effective Date fields
if they want to make a change to an account number or Flat Amount or Percentage etc? Or is there another table that is holding all change history?

John Henley

Senior Member

Posts: 3348

4/29/2013 12:55 PM

Mary, there is no table (e.g. HRHISTORY) in v9 holding the history for the ACH distributions; only automated solution I have seen for this is similar to tracking history for employee dependents, which is to use Smart Notifications (LSN) to monitor data changes on the table. Since this table (EMACHDEPST) does have effective start/end dates, I think it is safe/sufficient to use those to track changes, thereby keeping a full history. Only caveat required is to change the default flag to 'N' when changing the default account for an employee. Hope that helps, and anyone with other ideas, please chime in...

Margie Gyurisin

Veteran Member

Posts: 538

4/29/2013 5:15 PM

Once you get to version 10 and it could be one of the newer point releases, that history will be available on a more granular level.

It was presented at Inforum.

John Henley

Senior Member

Posts: 3348

4/29/2013 6:32 PM

You think I'd have remembered that, since I reported an issue with the v10 upgrade documentation having incorrect instructions for loading those tables (PADICT, etc.) not adding the v10 records for HR10...

Mary Porter

Veteran Member

Posts: 337

4/29/2013 6:55 PM

Well that's cool to know it's out there. I think we are two years away from 10 my boss wants to wait until you all get all of the bugs worked out for us ;)
But at least we'll get to 9.1.9 this summer. Thanks Margie and John!

Shane Jones

Veteran Member

Posts: 460

5/14/2013 2:34 AM

Mary, we are one of the companies "working out the bugs" for you.... We are in the process of migrating to V10. I just changed data on PR12 and it looks like it is doing much better with the change history dating. version - 10.0.2

Mary Porter

Veteran Member

Posts: 337

8/8/2013 2:54 PM

I'm sure the answer to this is NO, but, I thought I'd ask anyway. If payroll deletes a record entirely, is there anywhere to look to see who deleted it?

stephanie

Veteran Member

Posts: 330

8/8/2013 3:31 PM

You are correct, Mary - unless your organization uses some kind of server auditing tool that captures all activity)

Mary Porter

Veteran Member

Posts: 337

8/8/2013 4:29 PM

Thanks Stephanie. We are remote hosted so I'll ask them.

You are not authorized to post a reply.