GVT_CURV_LNG_VW

(SQL View)
Index Back

GVT CURRENT Personal Data Vw

PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person. Related Language view for GVT_CURR_PERS_V.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , AL.LANGUAGE_CD , A.BIRTHPLACE FROM PS_GVT_PERS_DATA A , PS_GVT_PERS_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.EFFDT = AL.EFFDT AND A.EMPL_RCD = AL.EMPL_RCD AND A.EFFSEQ = AL.EFFSEQ

  • Related Language Record for GVT_CURR_PERS_V
  • Audit Record: AUDIT_PERSONAL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location