Campus Solutions - PSFT (MOSC)

MOSC Banner

How exactly is the PERSONAL_DATA table populated these days?

edited Oct 19, 2018 11:29AM in Campus Solutions - PSFT (MOSC) 4 commentsAnswered ✓

A user has requested that I create a view based on a query he had written in the query tool.  A good bit of the data in the query is being retrieved from the delivered SCC_PERDATA_QVW view.  When I looked at the SQL for that view's record definition, I saw that it was retrieving data from PERSONAL_DATA.

I've been a PeopleSoft developer long enough to recall when PERSONAL_DATA was an actual transaction table, and the resistance they met with when they tried to get rid of it after splitting it into several tables to normalize the data it held (mainly because so many user-developed queries were built around it). 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center