SAA_RQ_GRP_U_LN

(SQL View)
 Index Back

Rq Grp Search on Usage

This related language view is used to search for requirement groups based on the requirement usage. This view is used from the academic advisement side of the processing.

SELECT A.RQRMNT_USEAGE , A.RQRMNT_GROUP , A.EFFDT , L.LANGUAGE_CD , L.DESCR FROM PS_RQ_GRP_TBL A , PS_RQ_GRP_LANG L WHERE A.RQRMNT_GROUP = L.RQRMNT_GROUP AND A.EFFDT = L.EFFDT

  • Related Language Record for SAA_RQ_GRP_U_VW SSR_RQ_GRP_U_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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: %EDITTABLE8

    2 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description