LM_PERS_ADM_LVW

(SQL View)
 Index Back

Person Administrative Search

Person Administrative Search

SELECT B.LM_PERSON_ID ,E.LANGUAGE_CD , E.LM_ORG_DESCR ,G.LM_JOBCD_DESCR FROM PS_LM_PERS_NAME_VW B , PS_LM_CURR_JOB_VW C , PS_LM_ORGANIZATION D , PS_LM_ORG_LANG E ,PS_LM_JOBCODE_TBL F , PS_LM_JOBCODE_LANG G WHERE B.LM_PERSON_ID = C.LM_PERSON_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_ACTIVE = 'Y' AND D.LM_ORGANIZATION_ID = C.LM_ORGANIZATION_ID AND E.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID AND E.EFFDT = D.EFFDT AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND D.EFF_STATUS = 'A' AND F.LM_JOBCODE_ID = C.LM_JOBCODE_ID AND G.LM_JOBCODE_ID = F.LM_JOBCODE_ID AND F.EFFDT = G.EFFDT AND C.EFFDT BETWEEN F.EFFDT AND F.LM_END_EFFDT AND F.EFF_STATUS = 'A' AND E.LANGUAGE_CD=G.LANGUAGE_CD

  • Related Language Record for LM_PERS_ADM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    4 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title