For the last 17 years I have worked at this job, we have had access to specific data that we have built queries and reports based on this data and make hiring and leave decisions on. Somewhere along the way we now have Data Stewards that have decided to take this data away. Even though it can be seen in PeopleSoft. I guess these data stewards after 17+ years have decided to do their job and deem these columns too sensitive for eyes in a table but not in PeopleSoft. This change is happening pretty quickly so I am really nervous that I will be without data soon.
My question now is with 15 databases that I support, how do I find out where these fields are in every query and report? I download the data using Alteryx into Excel and then import the data into Access and then send the updated tables to each of the respective databases.
I could use the documenter and do a search on the PDF but if there is another way to find these fields, I am listening, intently to others for guidance.
Thank You
Jim Wagner
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116316) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar