RQMAINADVVW2LNG

(SQL View)
 Index Back

Advisement Requirement View

Use this view to prompt for student override requirements

SELECT DISTINCT B.RQRMNT_GROUP ,A.REQUIREMENT ,A.EFFDT ,C.LANGUAGE_CD ,C.DESCR ,C.DESCRSHORT ,C.DESCR254A FROM PS_RQ_MAIN_TBL A , PS_RQ_GRP_DETL_TBL B , PS_RQ_MAIN_LANG C WHERE A.RQRMNT_USEAGE = 'ADV' AND A.REQUIREMENT = B.REQUIREMENT AND A.REQUIREMENT = C.REQUIREMENT AND A.EFFDT = C.EFFDT AND A.EFFDT <= ( SELECT MAX(A1.EFFDT) FROM PS_RQ_MAIN_TBL A1 WHERE A1.REQUIREMENT = B.REQUIREMENT )

  • Related Language Record for RQ_MAIN_ADV_VW2

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

    Default Value: 000000000

    Prompt Table: RQ_MAIN_TBL

    3 EFFDT Date(10) DATE NOT NULL 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
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description