LM_ENRLT_MGD_LG

(SQL View)
 Index Back

Manager Enrollment Rel Lang

Related Language for Manager Enrollment The following related language tables used are: PS_LM_ENRLMT_VW view of table PS_LM_ENRLMT. This uses related language PS_LM_ENRLMT_LANG. Key is LM_ENRLMT_ID PS_LM_CI_VW2 uses related language PS_LM_CI_VW_LNG2 Key is LM_CI_ID PS_LM_ACT_PLN_VW uses related language PS_LM_ACT_PLN_LVW Key is LM_ACT_ID

SELECT B1.OPRID , B1.LM_MANAGER_ID , A1.LM_PERSON_ID , A1.LM_ENRLMT_ID , AL1.LANGUAGE_CD , FL1.LM_DM_LONG_NM , GL1.LM_CS_LONG_NM , C1.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A1 , PS_LM_ENRLMT_LANG AL1 , PS_LM_MGR_SRCH_VW B1 , PS_LM_PERS_DTL_VW C1 , PS_LM_ACT_PLN_VW F1 , PS_LM_ACT_PLN_LVW FL1 , PS_LM_CI_VW2 G1 , PS_LM_CI_VW_LNG2 GL1 WHERE A1.LM_ENRLMT_ID = AL1.LM_ENRLMT_ID AND B1.LM_PERSON_ID = A1.LM_PERSON_ID AND A1.LM_PERSON_ID = C1.LM_PERSON_ID AND C1.LM_ACTIVE = 'Y' AND F1.LM_ACT_ID = FL1.LM_ACT_ID AND FL1.LANGUAGE_CD = AL1.LANGUAGE_CD AND A1.LM_ACT_ID = F1.LM_ACT_ID AND G1.LM_CI_ID = GL1.LM_CI_ID AND GL1.LANGUAGE_CD = AL1.LANGUAGE_CD AND A1.LM_CI_ID = G1.LM_CI_ID UNION SELECT B2.OPRID , B2.LM_MANAGER_ID , A2.LM_PERSON_ID , A2.LM_ENRLMT_ID , AL2.LANGUAGE_CD , FL2.LM_DM_LONG_NM , G2.LM_CS_LONG_NM , C2.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A2 , PS_LM_ENRLMT_LANG AL2 , PS_LM_MGR_SRCH_VW B2 , PS_LM_PERS_DTL_VW C2 , PS_LM_ACT_PLN_VW F2 , PS_LM_ACT_PLN_LVW FL2 , PS_LM_CI_VW2 G2 WHERE A2.LM_ENRLMT_ID = AL2.LM_ENRLMT_ID AND B2.LM_PERSON_ID = A2.LM_PERSON_ID AND A2.LM_PERSON_ID = C2.LM_PERSON_ID AND C2.LM_ACTIVE = 'Y' AND F2.LM_ACT_ID = FL2.LM_ACT_ID AND FL2.LANGUAGE_CD = AL2.LANGUAGE_CD AND A2.LM_ACT_ID = F2.LM_ACT_ID AND A2.LM_CI_ID = G2.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_VW_LNG2 GL2 WHERE G2.LM_CI_ID = GL2.LM_CI_ID AND GL2.LANGUAGE_CD = AL2.LANGUAGE_CD) UNION SELECT B3.OPRID , B3.LM_MANAGER_ID , A3.LM_PERSON_ID , A3.LM_ENRLMT_ID , AL3.LANGUAGE_CD , F3.LM_DM_LONG_NM , GL3.LM_CS_LONG_NM , C3.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A3 , PS_LM_ENRLMT_LANG AL3 , PS_LM_MGR_SRCH_VW B3 , PS_LM_PERS_DTL_VW C3 , PS_LM_ACT_PLN_VW F3 , PS_LM_CI_VW2 G3 , PS_LM_CI_VW_LNG2 GL3 WHERE A3.LM_ENRLMT_ID = AL3.LM_ENRLMT_ID AND B3.LM_PERSON_ID = A3.LM_PERSON_ID AND A3.LM_PERSON_ID = C3.LM_PERSON_ID AND C3.LM_ACTIVE = 'Y' AND A3.LM_ACT_ID = F3.LM_ACT_ID AND G3.LM_CI_ID = GL3.LM_CI_ID AND GL3.LANGUAGE_CD = AL3.LANGUAGE_CD AND A3.LM_CI_ID = G3.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_ACT_PLN_LVW FL3 WHERE F3.LM_ACT_ID = FL3.LM_ACT_ID AND FL3.LANGUAGE_CD = AL3.LANGUAGE_CD) UNION SELECT B4.OPRID , B4.LM_MANAGER_ID , A4.LM_PERSON_ID , A4.LM_ENRLMT_ID , AL4.LANGUAGE_CD , F4.LM_DM_LONG_NM , G4.LM_CS_LONG_NM , C4.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A4 , PS_LM_ENRLMT_LANG AL4 , PS_LM_MGR_SRCH_VW B4 , PS_LM_PERS_DTL_VW C4 , PS_LM_ACT_PLN_VW F4 , PS_LM_CI_VW2 G4 WHERE A4.LM_ENRLMT_ID = AL4.LM_ENRLMT_ID AND B4.LM_PERSON_ID = A4.LM_PERSON_ID AND A4.LM_PERSON_ID = C4.LM_PERSON_ID AND C4.LM_ACTIVE = 'Y' AND A4.LM_ACT_ID = F4.LM_ACT_ID AND A4.LM_CI_ID = G4.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_VW_LNG2 GL4 WHERE G4.LM_CI_ID = GL4.LM_CI_ID AND GL4.LANGUAGE_CD = AL4.LANGUAGE_CD) AND NOT EXISTS ( SELECT 1 FROM PS_LM_ACT_PLN_LVW FL4 WHERE F4.LM_ACT_ID = FL4.LM_ACT_ID AND FL4.LANGUAGE_CD = AL4.LANGUAGE_CD) UNION SELECT B5.OPRID , B5.LM_MANAGER_ID , A5.LM_PERSON_ID , A5.LM_ENRLMT_ID , FL5.LANGUAGE_CD , FL5.LM_DM_LONG_NM , GL5.LM_CS_LONG_NM , C5.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A5 , PS_LM_MGR_SRCH_VW B5 , PS_LM_PERS_DTL_VW C5 , PS_LM_ACT_PLN_VW F5 , PS_LM_ACT_PLN_LVW FL5 , PS_LM_CI_VW2 G5 , PS_LM_CI_VW_LNG2 GL5 WHERE B5.LM_PERSON_ID = A5.LM_PERSON_ID AND A5.LM_PERSON_ID = C5.LM_PERSON_ID AND C5.LM_ACTIVE = 'Y' AND F5.LM_ACT_ID = FL5.LM_ACT_ID AND A5.LM_ACT_ID = F5.LM_ACT_ID AND G5.LM_CI_ID = GL5.LM_CI_ID AND GL5.LANGUAGE_CD = FL5.LANGUAGE_CD AND A5.LM_CI_ID = G5.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_ENRLMT_LANG AL5 WHERE A5.LM_ENRLMT_ID = AL5.LM_ENRLMT_ID AND AL5.LANGUAGE_CD = FL5.LANGUAGE_CD) UNION SELECT B6.OPRID , B6.LM_MANAGER_ID , A6.LM_PERSON_ID , A6.LM_ENRLMT_ID , FL6.LANGUAGE_CD , FL6.LM_DM_LONG_NM , G6.LM_CS_LONG_NM , C6.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A6 , PS_LM_MGR_SRCH_VW B6 , PS_LM_PERS_DTL_VW C6 , PS_LM_ACT_PLN_VW F6 , PS_LM_ACT_PLN_LVW FL6 , PS_LM_CI_VW2 G6 WHERE B6.LM_PERSON_ID = A6.LM_PERSON_ID AND A6.LM_PERSON_ID = C6.LM_PERSON_ID AND C6.LM_ACTIVE = 'Y' AND F6.LM_ACT_ID = FL6.LM_ACT_ID AND A6.LM_ACT_ID = F6.LM_ACT_ID AND A6.LM_CI_ID = G6.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_ENRLMT_LANG AL6 WHERE A6.LM_ENRLMT_ID = AL6.LM_ENRLMT_ID AND AL6.LANGUAGE_CD = FL6.LANGUAGE_CD) AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_VW_LNG2 GL6 WHERE G6.LM_CI_ID = GL6.LM_CI_ID AND GL6.LANGUAGE_CD = FL6.LANGUAGE_CD) UNION SELECT B7.OPRID , B7.LM_MANAGER_ID , A7.LM_PERSON_ID , A7.LM_ENRLMT_ID , GL7.LANGUAGE_CD , F7.LM_DM_LONG_NM , GL7.LM_CS_LONG_NM , C7.LM_JOB_TITLE FROM PS_LM_ENRLMT_VW A7 , PS_LM_MGR_SRCH_VW B7 , PS_LM_PERS_DTL_VW C7 , PS_LM_ACT_PLN_VW F7 , PS_LM_CI_VW2 G7 , PS_LM_CI_VW_LNG2 GL7 WHERE B7.LM_PERSON_ID = A7.LM_PERSON_ID AND A7.LM_PERSON_ID = C7.LM_PERSON_ID AND C7.LM_ACTIVE = 'Y' AND A7.LM_ACT_ID = F7.LM_ACT_ID AND G7.LM_CI_ID = GL7.LM_CI_ID AND A7.LM_CI_ID = G7.LM_CI_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_ENRLMT_LANG AL7 WHERE A7.LM_ENRLMT_ID = AL7.LM_ENRLMT_ID AND AL7.LANGUAGE_CD = GL7.LANGUAGE_CD) AND NOT EXISTS ( SELECT 1 FROM PS_LM_ACT_PLN_LVW FL7 WHERE F7.LM_ACT_ID = FL7.LM_ACT_ID AND FL7.LANGUAGE_CD = GL7.LANGUAGE_CD)

  • Related Language Record for LM_ENRLT_MGD_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_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    7 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    8 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title