LM_FILT_SRC_LNG

(SQL View)
Index Back

Filter Lang table

Filter Lang table

SELECT B.OPRID , A.LM_FILTER_NAME , A.LM_LE_ID , A.LANGUAGE_CD , A.LM_FILTER_DESCR FROM PS_LM_FILTER_LNG A , PS_LM_OPRID_LE_VW B WHERE A.LM_LE_ID = B.LM_LE_ID

  • Related Language Record for LM_FILT_SRCH_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_FILTER_NAME Character(30) VARCHAR2(30) NOT NULL Filter Name
    3 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_FILTER_DESCR Character(50) VARCHAR2(50) NOT NULL Description