RQGRPTBLVW_LANG

(SQL View)
 Index Back

Requirement Group Table View

Use view to create display panels for the data in RQ_GRP_TBL where the Rowinit and FieldDefault Peoplecode in this record causes problems due to references to child records which are not available for the display applications in question.

SELECT RQRMNT_GROUP ,LANGUAGE_CD ,EFFDT ,DESCR ,DESCRSHORT ,DESCR254A FROM PS_RQ_GRP_LANG

  • Related Language Record for RQ_GRP_TBL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: RQ_GRP_TBL.DESCR

    6 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description