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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center