LM_MGR_CERT_LNG

(SQL View)
 Index Back

Manager Certifications Lang

Lists all Certifications (any status) for a learner associated with a Manager. Joins to the program table to bring in the program long name. Related Language table

SELECT D.OPRID , D.LM_MANAGER_ID , B.LM_PRG_REG_ID , F.LANGUAGE_CD , F.LM_PRG_LONG_NM FROM PS_LM_PRG_REG_VW A , PS_LM_LRNR_CERT_VW B , PS_LM_PRG C , PS_LM_MGR_SRCH_VW D , PS_LM_PERS_NAME_VW E , PS_LM_PRG_LANG F WHERE A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_PERSON_ID = E.LM_PERSON_ID AND A.LM_PRG_ID = C.LM_PRG_ID AND C.LM_PRG_ID = F.LM_PRG_ID AND C.EFFDT = F.EFFDT AND C.LM_PRG_TYPE = 'CE' 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_MGR_CERT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    3 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.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name