SAA_RQMNT_U_LN

(SQL View)
 Index Back

Rq Grp Search on Usage

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

SELECT A.RQRMNT_USEAGE , A.REQUIREMENT , A.EFFDT , L.LANGUAGE_CD , L.DESCR FROM PS_RQ_MAIN_TBL A , PS_RQ_MAIN_LANG L WHERE A.REQUIREMENT = L.REQUIREMENT AND A.EFFDT = L.EFFDT

  • Related Language Record for SAA_RQMNT_U_VW SSR_RQMNT_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 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    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