RQ_MAIN_2_VW

(SQL View)
 Index Back

Program Req Ignoring Effdt

This view of the Requirement Line table is used to select reqirement Usage ignoring effective date so that the current description displays.

SELECT A.REQUIREMENT , A.RQRMNT_USEAGE , A.DESCR , B.XLATLONGNAME FROM PS_RQ_MAIN_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'RQRMNT_USEAGE' AND B.FIELDVALUE = A.RQRMNT_USEAGE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEM B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE AND B1.EFFDT <= %CurrentDateIn AND B1.EFF_STATUS = 'A')

  • Related Language Record: RQMAIN2VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_MAIN_RQ Character(9) VARCHAR2(9) NOT NULL Reference Main Requirement
    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
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr