RQENRL_SRCH_LNG

(SQL View)
 Index Back

Rqrmnt Enrollment Srch Upd

Use this view to search Requirements for Enrollment.

SELECT A.Institution ,A.Acad_Group ,A.Subject ,A.Catalog_Nbr ,B.Requirement ,B.LANGUAGE_CD ,B.Effdt ,B.Descr FROM PS_RQ_MAIN_TBL A , PS_RQ_MAIN_LANG B WHERE A.RQRMNT_USEAGE = 'ENR' AND A.REQUIREMENT = B.REQUIREMENT AND A.EFFDT = B.EFFDT

  • Related Language Record for RQ_ENRL_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Default Value: OPR_DEF_TBL_CS.ACAD_GROUP

    Prompt Table: ACAD_GROUP_TBL

    3 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    4 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Prompt Table: CRSE_CATL1_SRCH

    5 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description