GVT_PI_POMR_LNG

(SQL View)
Index Back

Gvt PI Position Master View


SELECT JC.JOBCODE ,98 ,JC.EFFDT ,0 ,JCL.LANGUAGE_CD ,JC.GVT_OFFICIAL_DESCR FROM PS_JOBCODE_TBL JC , PS_JOBCODE_LANG JCL WHERE JC.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE JOBCODE=JC.JOBCODE AND EFFDT<=%CurrentDateIn) AND JC.JOBCODE = JCL.JOBCODE AND JC.EFFDT = JCL.EFFDT

  • Related Language Record for GVT_PI_POMR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title