RQGSHRRPTVW_LNG

(SQL View)
 Index Back

RQ Share Set View

Use view to report on requirement groups contained in a course share set.

SELECT distinct b.CRSE_SHARE_SET ,a.RQRMNT_GROUP ,A.LANGUAGE_CD ,a.DESCR ,a.DESCRSHORT ,a.DESCR254A FROM PS_RQ_GRP_LANG a, PS_RQ_GRP_SHR_SET b where b.RQRMNT_GROUP = a.RQRMNT_GROUP and b.EFFDT = a.EFFDT and a.EFFDT = (Select max(c.Effdt) from PS_RQ_GRP_LANG c where c.RQRMNT_GROUP = a.RQRMNT_GROUP)

  • Related Language Record for RQ_GSHR_RPT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_SHARE_SET Character(9) VARCHAR2(9) NOT NULL Course Share Set

    Prompt Table: CRSE_SHARE_SET

    2 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description