List of Contributions

Hi Kim, Thanks for that clarification. I'm wondering if we can diagnose the issue as coming from the setup of the Consolidate Academic Statistics process (i.e., in the configuration of academic statistics periods, typically defined by a list of distinct term/career combinations) or from the setup ...

Hi Carmen! Are you still having this issue? I assume you're using the report generated by PeopleSoft's delivered NSC report via its Consolidate Academic Statistics Process? Can you clarify what you mean by two "profiles"--are you referring to duplicate records for the same student identifier? When you ...

Hi Renato! I just completed your survey--good luck in reaching the finish line! Having just reached that line myself last year after an extended hiatus, I congratulate you on being nearly there! ------------------------------ Robert Lang Business Systems Analyst Duke University ------------------------------ ...

Hi Frances--thanks for that note about the changes made by Oracle! If the change with respect to the trimming of CATALOG_NBR occurred since Jill's queries had been last updated, then I think that would certainly explain it. Here's the SQL for the security table, with the relevant bit highlighted: ...

I've also used windowing functions to "flatten" results in a manner similar to the one described here, and I thought it might be useful for folks unfamiliar with this technique to know that the "Distinct" box should be checked in the query properties (or however the user would add the DISTINCT keyword ...