PS Query & SQL

 View Only
  • 1.  Intro

    Posted 01-22-2025 03:17 PM

    Hello fellow Peoplesoft query and sql folks.

    I work for a community college in Washington state and look forward to learning more about query reporting and sql.

    Kathy



    ------------------------------
    Kathy Disney
    Business Systems Analyst Campus Solutions, HCM, FSCM
    Washington State Board for Community and Technical Colleges
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: Intro

    Posted 01-22-2025 04:04 PM

    Glad you can join us.  The knowledge we can share together as a group is tremendous. 



    ------------------------------
    Daniel Labrecque
    Senior 2 Business Systems Analyst/Functional Architect
    University of Nevada, Las Vegas
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 3.  RE: Intro

    Posted 01-23-2025 09:05 AM

    Hi All,

    I have about 15 years of experience with Campus Solutions and consider myself a PS Query enthusiast. :) I've blogged VERY inconsistently for many years. My PS Query posts are at https://geeksoncampus.wordpress.com/category/ps-query/.

    Cheers! John at Miami



    ------------------------------
    John Eggenton
    Senior Software Architect
    University of Miami
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 4.  RE: Intro

    Posted 01-23-2025 09:10 AM

    This is great, John. I will add this to the resource center!



    ------------------------------
    Daniel Labrecque
    Senior 2 Business Systems Analyst/Functional Architect
    University of Nevada, Las Vegas
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 5.  RE: Intro

    Posted 01-23-2025 09:14 AM

    Ooh, John!  I'm going to check out your blogs!

     




    Alliance 2026 Registration is Open!


  • 6.  RE: Intro

    Posted 01-23-2025 12:05 PM

    John, do you have these broken up separately so I can save them as pdfs?  I ask because if this site gets dropped or Wordpress goes away, then the link I put into the Resource Center will be a dead link.



    ------------------------------
    Daniel Labrecque
    Senior 2 Business Systems Analyst/Functional Architect
    University of Nevada, Las Vegas
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 7.  RE: Intro

    Posted 01-24-2025 10:31 AM

    Dan,

    I couldn't figure out how to do something within Wordpress to get this. So, I just copy all of the posts and pasted them into Word. I'm pleasantly surprised with how cleanly they seem to have copied. I'll share the PDF and Word doc in case you'd like to reformat the file before adding it to the library. Word separator lines always seem to flake out on me if I add more than a couple. Let me know if I can help with anything else.

    Cheers. John



    ------------------------------
    John Eggenton
    Senior Software Architect
    University of Miami
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Attachment(s)

    docx
    PS Query Blog Posts.docx   1.22 MB 1 version
    pdf
    PS Query Blog Posts.pdf   754 KB 1 version
    Alliance 2026 Registration is Open!


  • 8.  RE: Intro

    Posted 01-23-2025 10:14 AM

    Hi PS Query/SQL community. I work with the University of Colorado Denver | Anschutz Medical Campus, and have been working with SF query reporting for the last 8 years. 

    I am so excited to be a part of this group as I am a total geek when it comes to query/SQL - especially drilling URLs. 

    Elizabeth O'Connor



    ------------------------------
    Elizabeth O'Connor
    System Operations Manager
    University of Colorado
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 9.  RE: Intro

    Posted 01-24-2025 11:27 AM

    Welcome Elizabeth!  You can totally be a SQL geek in this discussion group. Let your freak flag fly!



    ------------------------------
    Daniel Labrecque
    Senior 2 Business Systems Analyst/Functional Architect
    University of Nevada, Las Vegas
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!