LM_MGR_FLT_VW

(SQL View)
 Index Back

Manager Filter View

Manager Filter View

SELECT A.LM_OPRID , A.LM_LE_ID , A.LM_FILTER_NAME , A.LM_ORDER , A.LM_SELECT , B.LM_FILTER_DESCR , B.LM_SHORT_DESCR , A.LM_DEFAULT_FILTER FROM PS_LM_MGR_FLT_TBL A , PS_LM_FILTER_TBL B WHERE A.LM_LE_ID = B.LM_LE_ID AND A.LM_FILTER_NAME = B.LM_FILTER_NAME

  • Related Language Record: LM_MGR_FLT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_OPRID Character(30) VARCHAR2(30) NOT NULL Operator ID Used for Announcements
    2 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    3 LM_FILTER_NAME Character(30) VARCHAR2(30) NOT NULL Filter Name
    4 LM_ORDER Number(4,0) SMALLINT NOT NULL Order of Completion
    5 LM_SELECT Character(1) VARCHAR2(1) NOT NULL Selection Flag
    N=No
    Y=Yes

    Default Value: N

    6 LM_FILTER_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    7 LM_SHORT_DESCR Character(15) VARCHAR2(15) NOT NULL Short Description
    8 LM_DEFAULT_FILTER Character(1) VARCHAR2(1) NOT NULL Default
    N=No
    Y=Yes