STAT_ALL_LANG

(SQL View)
 Index Back

All Statistics Codes RLR


select A.setid ,A.statistics_code ,A.LANGUAGE_CD ,A.descr from PS_STAT_TBL_LANG A where A.effdt = ( select max(B.effdt) from PS_STAT_TBL_LANG B where B.setid = A.setid and B.statistics_code = A.statistics_code AND B.LANGUAGE_CD = A.LANGUAGE_CD )

  • Related Language Record for STAT_ALL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description