LM_MULTI_JOB_VW

(SQL View)
 Index Back

Person Job Data

Contains Job Data for multiple jobs.

SELECT A.LM_PERSON_ID , A.LM_EMPL_RCD , A.EFFDT , A.LM_END_EFFDT , A.LM_JOBCODE_ID , A.LM_POSITION_NBR , A.LM_JOB_INDICATOR , B.LM_HR_JOBCODE , B.LM_HR_SETID , B.LM_JOBCD_DESCR , A.LM_LE_ID , A.LM_HR_COMPANY , A.LM_ORGANIZATION_ID , A.BUSINESS_UNIT FROM PS_LM_PERSON_ATTRB A , PS_LM_JOBCODE_TBL B WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.EFFDT BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_JOBCODE_ID = B.LM_JOBCODE_ID AND A.LM_ACTIVE = 'Y'

  • Related Language Record: LM_MULTI_JOB_LW

    • # 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 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    5 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID

    Prompt Table: LM_JOBCODE_VW

    6 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number

    Prompt Table: LM_POSITION

    7 LM_JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Job Indicator
    N=Not Applicable
    P=Primary Job
    S=Secondary Job
    8 LM_HR_JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code in Human Resources
    9 LM_HR_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    10 LM_JOBCD_DESCR Character(50) VARCHAR2(50) NOT NULL Job Code Description
    11 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    12 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
    13 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit