LM_LPLN_HST_LVW

(SQL View)
Index Back

Learning Plan History Rel Lang

Related Language Learning Plan History

SELECT LRN.LM_LPLN_ID , LRN.LM_PERSON_ID , PLNLG.LANGUAGE_CD , PLNLG.LM_LPLN_NAME FROM PS_LM_LPLN PLN , PS_LM_LPLN_LNG PLNLG , PS_LM_LPLN_LRN LRN WHERE PLN.LM_LPLN_ID = LRN.LM_LPLN_ID AND LRN.LM_LPLN_STATUS = 'C' AND PLN.LM_LPLN_ID = PLNLG.LM_LPLN_ID

  • Related Language Record for LM_LPLN_HST_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_LPLN_NAME Character(30) VARCHAR2(30) NOT NULL Learning Plan Code or Title