LM_VER_DRV_LVW

(SQL View)
 Index Back

Verity Index Build Driver Lng

This is the main driver view for the Verity Index Build Application Engine process. (Multi-Languages)

SELECT ACTVW.LM_ACT_ID ,CILNG.LANGUAGE_CD ,DMTLNG.LM_DM_LONG_NM ,DMTLNG.LM_DM_SHRT_NM ,CILNG.LM_CS_LONG_NM ,CILNG.LM_CS_DESCR FROM PS_LM_ACT_VW ACTVW , PS_LM_CI_VW CIVW , PS_LM_DMTHD_ALL_VW DMALL , PS_LM_DMTH_TYP_VW DMTYP , PS_LM_CI_VW_LNG CILNG , PS_LM_DTYP_VW_LNG DMTLNG WHERE ACTVW.LM_CI_ID = CIVW.LM_CI_ID AND ACTVW.LM_DMTHD_ID = DMALL.LM_DMTHD_ID AND ACTVW.LM_DMTHD_TYPE_ID = DMALL.LM_DMTHD_TYPE_ID AND ACTVW.LM_CI_ID = DMALL.LM_CI_ID AND ACTVW.LM_DMTHD_TYPE_ID = DMTYP.LM_DMTHD_ID AND CIVW.LM_CI_ID = CILNG.LM_CI_ID AND DMTYP.LM_DMTHD_ID = DMTLNG.LM_DMTHD_ID AND CILNG.LANGUAGE_CD = DMTLNG.LANGUAGE_CD AND %CurrentDateIn BETWEEN DMALL.EFFDT AND DMALL.LM_END_EFFDT AND DMALL.LM_DM_STATUS = '10'

  • Related Language Record for LM_VER_DRV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    4 LM_DM_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Short Name of a Delivery Method Type
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail