LM_ENRLMTMG_LVW

(SQL View)
 Index Back

Manager Enrollment Lang View

Manager Enrollment Language View

SELECT B.OPRID , B.LM_MANAGER_ID , A.LM_PERSON_ID , A.LM_ENRLMT_ID , F.LANGUAGE_CD , G.LM_GRADE_LABEL , F.LM_ENRLMT_DESCR FROM PS_LM_ENRLMT_VW A , PS_LM_MGR_SRCH_VW B , PS_LM_PERS_DTL_VW C , PS_LM_GRD_SCH_VAL E , PS_LM_PASS_SCH_VAL D , PS_LM_ENRLMT_LANG F , PS_LM_GRD_VAL_LANG G WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_STTS IN ('ENRL','INPO','PEAP','PLAN','WTLT','COMP','INCO','PEPA','PPYA','WAIV') AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_GRADE_VAL_ID = E.LM_GRADE_VAL_ID AND A.LM_PASS_VAL_ID = D.LM_PASS_VAL_ID AND C.LM_ACTIVE='Y' AND G.LM_GRADE_SCH_ID = E.LM_GRADE_SCH_ID AND G.LM_GRADE_VAL_ID = E.LM_GRADE_VAL_ID AND A.LM_ENRLMT_ID = F.LM_ENRLMT_ID AND G.LANGUAGE_CD = F.LANGUAGE_CD

  • Related Language Record for LM_ENRLMT_MG_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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_GRADE_LABEL Character(30) VARCHAR2(30) NOT NULL Grade
    7 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments