RQLNTBLRVW_LNG

(SQL View)
 Index Back

Req Line Table Ref View

Use this view to relate display the description after renaming REQUIREMENT to REF_REQUIREMENT and using the "line key number" to read the table.

Select b.Requirement, b.Effdt, a.RQ_Line_Nbr, b.language_cd, b.Descr, b.Descrshort, B.Descr254A 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_LN_TBLR_VW

  • Parent record: RQ_MAIN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_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 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description