LM_PRSNINTSA_VW

(SQL View)
 Index Back

Internal Person Search View

Internal Person Search View

SELECT A.LM_PERSON_ID , A.FIRST_NAME , A.LAST_NAME , A.NAME_AC , B.LM_ORGANIZATION_ID , C.LM_ORG_DESCR , C.LM_ORG_SDESCR , A.LM_LE_ID , E.LM_LE_LONG_NM , F.LM_HR_EMPLID , B.LM_JOBCODE_ID FROM PS_LM_PERSNMFUT_VW A , PS_LM_CURR_JOB_VW B , PS_LM_ORGANIZATION C , PS_LM_LE_VW E , PS_LM_PERSON F WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND %DateIn('9999-12-31') = B.LM_END_EFFDT AND C.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND B.EFFDT BETWEEN C.EFFDT AND C.LM_END_EFFDT AND E.LM_LE_ID = A.LM_LE_ID AND F.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_EXT_PERSON_FLG='N' AND B.LM_ACTIVE = 'Y'

  • Related Language Record: LM_PRSINTSH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Default Value: 999999999999999

    2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    4 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
    5 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Prompt Table: LM_INTDEPTSH_VW

    6 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    7 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    8 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Default Value: LM_LE_DFLT_TBL.LM_LE_ID

    Prompt Table: LM_LE_VW

    9 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name
    10 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
    11 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID

    Prompt Table: LM_JOBCODE_VW