CRSESHRSETVWLNG

(SQL View)
 Index Back

Course Share Set view

This view is used to display course share set regardless of effective date

Select Distinct B.Crse_Share_Set ,B.language_cd ,B.Descr ,B.DescrShort from PS_CRSE_SHARE_SET A, PS_CRSE_SHRSET_LNG B Where A.CRS_SHR_SET_TYPE = 'REQG' AND A.CRSE_SHARE_SET = B.CRSE_SHARE_SET AND A.EFFDT = B.EFFDT

  • Related Language Record for CRSE_SHR_SET_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_SHARE_SET Character(9) VARCHAR2(9) NOT NULL Course Share Set
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CRSE_SHARE_SET.DESCR