GVT_CURT_LNG_VW

(SQL View)
 Index Back

EE Current Employment Data Vw

EMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date. Many changes have been made for the US Federal Government. Related Language view for GVT_CURR_EMPLMT.

SELECT A.EMPLID, A.EMPL_RCD, A.EFFDT, A.EFFSEQ, AL.LANGUAGE_CD, A.BUSINESS_TITLE FROM PS_GVT_EMPLOYMENT A, PS_GVT_EMPLOY_LANG AL, PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.EFFDT = (SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT <= %CURRENTDATEIN AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND B.EFFSEQ = (SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND A.EMPLID = AL.EMPLID AND A.EMPL_RCD = AL.EMPL_RCD AND A.EFFDT = AL.EFFDT AND A.EFFSEQ = AL.EFFSEQ

  • Related Language Record for GVT_CURR_EMPLMT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    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 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title