LM_ACT_CIML_LVW

(SQL View)
 Index Back

Mandatory Learning View

Mandatory Learning language view

SELECT A.LM_ACT_CD , B.LANGUAGE_CD , B.LM_CS_LONG_NM , B.LM_CS_DESCR FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW B WHERE LM_ACT_STATUS = '1' AND A.LM_ACT_ID = B.LM_ACT_ID AND EXISTS ( SELECT 'X' FROM PS_LM_ACT_ML B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND NOT (LM_LRNR_GROUP_ID=0 AND LM_PERSON_ID=0))

  • Related Language Record for LM_ACT_CI_ML_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    4 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail