LM_CNT_TMPL_PT

(SQL View)
 Index Back

SELECT B.LM_LE_ID , A.LM_TMPL_ID , A.LM_TMPL_NAME , C.LM_TMPL_FOR_EDIT FROM PS_LM_TMPL A , PS_LM_TMPL_SEC B , PS_LM_TMPL_OPTIONS C WHERE A.LM_TMPL_ID=B.LM_TMPL_ID AND A.LM_TMPL_ID=C.LM_TMPL_ID AND A.LM_TMPL_STATUS='10'

  • Parent record: LM_CNT_TMPL_LPT

    • # 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_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Template ID
    3 LM_TMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    4 LM_TMPL_FOR_EDIT Character(1) VARCHAR2(1) NOT NULL For Editing

    Y/N Table Edit