LM_SETJOBLAN_VW

(SQL View)
 Index Back

SETID Department Lang View

Related Language View for Setid Department View

SELECT A.SETID , A.LM_JOBCODE_ID , B.LANGUAGE_CD , B.LM_JOBCD_DESCR FROM PS_LM_SETID_JOB_VW A , PS_LM_JOBCODE_LANG B WHERE A.LM_JOBCODE_ID = B.LM_JOBCODE_ID

  • Related Language Record for LM_SETID_JOB_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_JOBCD_DESCR Character(50) VARCHAR2(50) NOT NULL Job Code Description