LM_FILTER_TBL

(SQL Table)
 Index Back

Filter Table

Fitler Table

  • Related Language Record: LM_FILTER_LNG

  • Parent Record Of LM_FILTER_SEQ LM_FILTER_SEQ2 LM_FILTER_SEQ3 LM_FILTER_SEQ4

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    2 LM_FILTER_NAME Character(30) VARCHAR2(30) NOT NULL Filter Name
    3 LM_SHORT_DESCR Character(15) VARCHAR2(15) NOT NULL Short Description
    4 LM_FILTER_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    5 LM_FROM_DT Date(10) DATE From Date
    6 LM_TO_DT Date(10) DATE To Date
    7 LM_DURN_DAYS Number(4,0) SMALLINT NOT NULL Length of Activity in Days
    8 LM_EXCL_ENRL_STTS Character(1) VARCHAR2(1) NOT NULL Exclude Other Enrollment Statuses
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 LM_MAND_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Flag

    Y/N Table Edit

    Default Value: N