HR_I9_EVERIFY_V

(SQL View)
 Index Back

Everify View

Everify View

SELECT EV.EMPLID , EV.EFFDT , EV.EFFSEQ , EV.SEQNUM , EV.CASE_IDENTIFIERN , EV.CLOSE_DT , EV.AS_OF_DATE , EV.LASTUPDDTTM , EV.LASTUPDOPRID , EV.STATUS , EV.CASE_CLOSED , EV.COMMENTS , EV.DESCRLONG , ST.DESCR100 FROM PS_HR_I9_EVERIFY EV , PS_HR_EVRFYSTS_TBL ST WHERE EV.SEQNUM = ( SELECT MAX(EV1.SEQNUM) FROM PS_HR_I9_EVERIFY EV1 WHERE EV1.EMPLID = EV.EMPLID AND EV1.EFFDT = EV.EFFDT AND EV1.EFFSEQ = EV.EFFSEQ) AND ST.STATUS = EV.STATUS

  • Related Language Record: HR_I9_EVERIFYLV

    • # 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 CASE_IDENTIFIERN Character(15) VARCHAR2(15) NOT NULL Case Identifier
    6 CLOSE_DT Date(10) DATE Date Closed

    Default Value: %date

    7 AS_OF_DATE Date(10) DATE As of Date

    Default Value: %date

    8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %date

    9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Prompt Table: HR_EVRFYSTS_TBL

    11 CASE_CLOSED Character(1) VARCHAR2(1) NOT NULL Case Closed ?
    12 COMMENTS Long Character CLOB Comment
    13 DESCRLONG Long Character CLOB Long Description
    14 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description