LM_CLASS_LVW

(SQL View)
 Index Back

Active Class Values

Contains the Active Class Chartt Field Values

SELECT A.SETID , A.LM_CLASS_FLD , B.LANGUAGE_CD , B.LM_CF_CLASS_DESCR , B.LM_CF_CLASS_SDESCR FROM PS_LM_CF_CLASS A , PS_LM_CLASS_LANG B WHERE A.SETID = B.SETID AND A.LM_CLASS_FLD = B.LM_CLASS_FLD AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.EFF_STATUS = 'A'

  • Related Language Record for LM_CLASS_CF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_CF_CLASS_DESCR Character(50) VARCHAR2(50) NOT NULL Class Chart Field Description
    5 LM_CF_CLASS_SDESCR Character(10) VARCHAR2(10) NOT NULL Class Chart Field short Description