SAA_STDGR_DTLVW

(SQL View)
 Index Back

Advising Student Groups

This view contains the valid student groups to be available in academic advising.

SELECT A.INSTITUTION , A.RQRMNT_USEAGE , A.EFFDT , A.STDNT_GROUP , B.DESCR FROM PS_SAA_STDGR_DETL A , PS_STDNT_GROUP_TBL B WHERE B.INSTITUTION = A.INSTITUTION AND B.STDNT_GROUP = A.STDNT_GROUP AND B.EFFDT <= ( SELECT MAX(B1.EFFDT) FROM PS_STDNT_GROUP_TBL B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.STDNT_GROUP = B.STDNT_GROUP AND B1.EFFDT <= %CurrentDateIn AND B1.EFF_STATUS = 'A')

  • Parent record: INSTITUTION_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 RQRMNT_USEAGE Character(4) VARCHAR2(4) NOT NULL This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
    ADV=Academic Advisement
    ENR=Requisite/Restriction
    PLNR=Student Planner Report
    SHR=Rq Course Share Restrictn
    SHR1=Entity Course Share Restrictn
    STD=Student Individualized Plan

    Prompt Table: RQRMNT_USE_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: STDNT_GROUP_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description