SR_ENRADV_VW

(SQL View)
 Index Back

Enrollment Advisement View

This view is used to get the requirement groups on the bases of requirement usege as enrollment.

SELECT A.RQRMNT_GROUP, A.DESCR FROM PS_RQ_GRP_TBL A WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_RQ_GRP_TBL WHERE A.RQRMNT_GROUP = RQRMNT_GROUP AND EFFDT <=%CURRENTDATEIN) AND A.RQRMNT_USEAGE = 'ENR'

  • Related Language Record: SRENRADVVW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description