RQLINETBLVW_LNG

(SQL View)
 Index Back

Req Line Table View

Use this view to read the Requirement Line Table by the logical key. The line number (logical) key is the one to use when examining the logical relationship between records in the Requirement Line Table. The real key of the table is the "line key number" - it is used only by the database.

SELECT B.Requirement , B.Effdt , A.RQ_Line_Nbr , B.language_cd , B.Descr , B.Descrshort , B.SAA_Descr80 , B.Descr254A , B.SAA_Descr254 , B.SAA_Descrlong FROM PS_RQ_LINE_TBL A , PS_RQ_LINE_LANG B WHERE A.REQUIREMENT = B.REQUIREMENT AND A.RQ_LINE_KEY_NBR = B.RQ_LINE_KEY_NBR AND A.EFFDT = B.EFFDT

  • Related Language Record for RQ_LINE_TBL_VW

  • Parent record: RQ_MAIN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    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

    Default Value: RQ_LINE_TBL.DESCR

    7 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    8 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
    9 SAA_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    10 SAA_DESCRLONG Long Character CLOB This field is used to display information in the new student view for academic advisement reports.