LM_CRT_HIST_LNG

(SQL View)
 Index Back

Certification History Lang Rec

Displays the Certification History of a learner. Related Language table for the Certification History View

SELECT A.LM_PRG_REG_ID , D.LANGUAGE_CD , D.LM_PRG_LONG_NM FROM PS_LM_PRG_REG_VW A , PS_LM_LRNR_CERT_VW B , PS_LM_PRG C , PS_LM_PRG_LANG D WHERE A.LM_PRG_ID = C.LM_PRG_ID AND C.LM_PRG_ID = D.LM_PRG_ID AND C.EFFDT = D.EFFDT AND C.LM_PRG_TYPE = 'CE' AND (A.LM_PRG_STTS = 'COMP' OR A.LM_PRG_STTS = 'WAIV') AND A.LM_ENRL_DT BETWEEN C.EFFDT AND C.LM_END_EFFDT AND B.LM_PRG_REG_ID = A.LM_PRG_REG_ID

  • Related Language Record for LM_CERT_HIST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name