HR_I9_EVERIFYLV

(SQL View)
Index Back

Everify Related Language

Everify Related Language

SELECT EV.EMPLID , EV.EFFDT , EV.EFFSEQ , EV.SEQNUM , EV.LANGUAGE_CD , EV.COMMENTS , EV.DESCRLONG , ST.DESCR100 FROM PS_HR_I9_EVERIFYLN EV ,PS_HR_I9_EVERIFY_V EVA ,PS_HR_EVRFYSTS_TBL ST WHERE EV.SEQNUM = ( SELECT MAX(EV1.SEQNUM) FROM PS_HR_I9_EVERIFYLN EV1 WHERE EV1.EMPLID = EV.EMPLID AND EV1.EFFDT = EV.EFFDT AND EV1.EFFSEQ = EV.EFFSEQ) AND EV.EMPLID = EVA.EMPLID AND EV.EFFDT = EVA.EFFDT AND EV.EFFSEQ = EVA.EFFSEQ AND EV.SEQNUM = EVA.SEQNUM AND ST.STATUS = EVA.STATUS

  • Related Language Record for HR_I9_EVERIFY_V
  • Parent record: HR_I9_PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 COMMENTS Long Character CLOB Comment
    7 DESCRLONG Long Character CLOB Long Description
    8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description