PS Query & SQL

 View Only

  • 1.  Student Center - Course History - First Column

    Posted 08-28-2025 11:08 PM

    Hello all,

    I've been racking my brain (hard to do because it is the first week of the term!  Happy August, Everyone!) and I am trying to find the code in the first column of the course history selection in the student center.  The problem I have is that these are both coded as PSC UST, but one is an AP course and the other is a transfer course from another school.  And, fortunately, they both use a different Course ID.  Any thoughts on where I might find PSC UST so I can possibly match in that field?  The problem I am trying to solve is that our repeat job didn't find them (probably because they have two different course IDs).  Thank you in advance!

    Lee



    ------------------------------
    Lee Raubolt
    Associate Director of Admissions and Records
    Truckee Meadows Community College
    ------------------------------

    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: Student Center - Course History - First Column

    Posted 08-29-2025 09:30 AM
    If I am understanding your question TRNS_CRSE_DTL will have CRSE_ID associated with the transfer and TRNS_TEST_DTL will have the CRSE_ID associated with the AP test.

    Hope that helps,
    Bob
    --
    Bob Fogarty
    LionPATH - Reporting Team Lead
    The Pennsylvania State University



    Original Message
    Alliance 2026 Registration is Open!


  • 3.  RE: Student Center - Course History - First Column

    Posted 08-29-2025 11:09 AM
    I found it!  I had to do the TRNS_TEST_DTL and then the CRSE_OFFER.  Then, I did an "exists" subquery on TRNS_CRSE_DTL and CRSE_OFFER.  Then I joined the SUBJECT and CATALOG_NBR fields from the two CRSE_OFFER records.  I think it is working now; I just have to refine my criteria.

    Thank you for your help!
    Lee

    Thank you!
    Lee
     

    ----------------------------------------
    Lee Raubolt, M.S. 
    Truckee Meadows Community College
    Associate Director of Admissions & Enrollment Services
    7000 Dandini Blvd.
    RDMT 319
    Reno, NV 89512 USA
    775-674-7624




    On Fri, Aug 29, 2025 at 6:32 AM Robert Fogarty via Higher Education User Group <Mail@heug.org> wrote:
    If I am understanding your question TRNS_CRSE_DTL will have CRSE_ID associated with the transfer and TRNS_TEST_DTL will have the CRSE_ID... -posted to the "PS Query & SQL" group
    Higher Education User Group

    PS Query & SQL

    Post New Discussion
    Re: Student Center - Course History - First Column
    Reply to Thread
    Aug 29, 2025 9:30 AM
    Robert Fogarty
    If I am understanding your question TRNS_CRSE_DTL will have CRSE_ID associated with the transfer and TRNS_TEST_DTL will have the CRSE_ID associated with the AP test.

    Hope that helps,
    Bob
    --
    Bob Fogarty
    LionPATH - Reporting Team Lead
    The Pennsylvania State University
      Reply to Community   Reply to Sender via Email   View Thread   Recommend  

    Original Message



     
    You are receiving this notification because you followed the 'Student Center - Course History - First Column' message thread. If you do not wish to follow this, please click here.

    Update your email preferences to choose the types of email you receive

    Unsubscribe from all participation emails
    Alliance 2026 | March 8-11, 2026 | Orlando, FL



    Original Message:
    Sent: 8/29/2025 9:30:00 AM
    From: Robert Fogarty
    Subject: RE: Student Center - Course History - First Column

    If I am understanding your question TRNS_CRSE_DTL will have CRSE_ID associated with the transfer and TRNS_TEST_DTL will have the CRSE_ID associated with the AP test.

    Hope that helps,
    Bob
    --
    Bob Fogarty
    LionPATH - Reporting Team Lead
    The Pennsylvania State University


    Alliance 2026 Registration is Open!


Related Content