GVT_NID_PUSH_VW

(SQL View)
 Index Back

PERS_NID Record

PERS_NID is the child record of PERSONAL_DATA and hold the NID_SBR which contains information about National ID.

SELECT A.EMPLID ,%subrec(NID_SBR , A) FROM PS_GVT_PERS_NID A , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPL_RCD = 0 AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.GVT_STATUS_TYPE IN ('COR', 'COM') AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GVT_JOB D WHERE D.EMPLID = B.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND D.EFFDT <= %CurrentDateIn AND D.GVT_STATUS_TYPE IN ('COR', 'COM')) AND B.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_GVT_JOB C WHERE C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND C.EFFDT = B.EFFDT AND C.GVT_STATUS_TYPE IN ('COM', 'COR'))

  • Parent record: PERSON

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

    Prompt Table: NID_TYPE_VW

    3 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE

    Prompt Table: NID_TYPE1_VW

    4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    5 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security # Key
    6 PRIMARY_NID Character(1) VARCHAR2(1) NOT NULL Primary ID

    Y/N Table Edit

    Default Value: N