LM_ADMIN_VW

(SQL View)
 Index Back

Admininistrator's LE View

Gets the Learning Environment that the Administrator can administer.

SELECT A.LM_PERSON_ID , A.LM_LE_ID , B.LM_LE_LONG_NM , A.LM_PRIMARY FROM PS_LM_PERSON_ADMIN A , PS_LM_LE_TBL B WHERE A.LM_LE_ID = B.LM_LE_ID

  • Related Language Record: LM_ADMIN_LVW

    • # 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 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name
    4 LM_PRIMARY Character(1) VARCHAR2(1) NOT NULL Primary Contact Method
    N=No
    Y=Yes

    Default Value: N