RQRLNTBLVW_LANG

(SQL View)
Index Back

Req Ref Line Table View

Use this view to read the Requirement Line Table by the logical key, Line Number, renaming Requirement.

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_RLN_TBL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    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