LM_ADMIN_LVW

(SQL View)
 Index Back

Admininistrator's LE Lang View

Gets the Learning Environment that the Administrator can administer.

SELECT A.LM_PERSON_ID , A.LM_LE_ID , B.LANGUAGE_CD , B.LM_LE_LONG_NM FROM PS_LM_PERSON_ADMIN A , PS_LM_LE_LANG B WHERE A.LM_LE_ID = B.LM_LE_ID

  • Related Language Record for LM_ADMIN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_PERS_NAME_VW

    2 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Prompt Table: LM_LE_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name