LM_LPLN_MGR_LG

(SQL View)
Index Back

Team Member Learning Plan Rel

Team Member Learning Plan Related Language

SELECT LRN.LM_LPLN_ID , LRN.LM_PERSON_ID , MGR.LM_MANAGER_ID , LG.LANGUAGE_CD , LG.LM_LPLN_NAME FROM PS_LM_LPLN PLN , PS_LM_LPLN_LNG LG , PS_LM_LPLN_LRN LRN , PS_LM_MGR_VW MGR WHERE PLN.LM_LPLN_ID = LG.LM_LPLN_ID AND PLN.LM_LPLN_ID = LRN.LM_LPLN_ID AND LRN.LM_PERSON_ID = MGR.LM_PERSON_ID

  • Related Language Record for LM_LPLN_MGR_CUR LM_LPLN_MGR_HST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_LPLN_NAME Character(30) VARCHAR2(30) NOT NULL Learning Plan Code or Title