web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Data cleanse, TSQL rem...
Microsoft Dynamics GP (Archived)

Data cleanse, TSQL removing all HR and Payroll from database

(0) ShareShare
ReportReport
Posted on by dbirdsall 5

I have been asked to provide a copy of our GP company database to an outside developer.  I had planned to use a copy of a recent SQL backup for this purpose.  However, I want to be able to remove HR and Payroll data prior to doing so.  I could easily drop all UPRxxx and DDxxx tables.  However, I am not able to find documentation that clearly shows where other sensitive data may be stored.  Searching the db, I have found other references to UPR (AuditTrail, or SourcDoc) in CM20100, CM20200, CM20300, CM20502, GL20000 and GL30000. 

Are there scripts for this scenario, or is this a matter of searching the database manually (like I have done here)?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I do not remember ever seeing something that will remove HR/Payroll information. If you are posting payroll in detail, you might also have information in the general ledger. You can consolidate those numbers into summary if you like. A problem usually present is that the checkbook register from which payroll is disbursed contains information about the paychecks written. It looks like you have found some of the CM tables, but there are others. Look in the CM30... tables, those are the transaction history tables. Another thing you'll want to look at is the SmartLists. It may be easier for you to remove all of the SmartLists than to pick through the detail for Payroll related information.

    All of this deleting will result in many errors if the recipient of your database is trying to access it through the Dynamics client. Do you know if they plan on using the Dynamics client?

    Kind regards,

    Leslie

  • dbirdsall Profile Picture
    dbirdsall 5 on at

    Thank you Leslie,

    I have also found the CM30xxx tables and included those in my 'cleansing' scripts.  In this scenario, no they will not be using a Dynamics client to access the data.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Have you looked in the GL20..and GL30.. tables? If you post payroll in detail, they will be able to see the payroll data in the transaction detail tables. If you want, you might post a list of tables you have identified. We'd need to know which products you have installed and whether you post in detail or in summary.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans