HR_EH_SRCH

(SQL View)
 Index Back

Heaser ID Configuration Table

Heaser ID Configuration Table

SELECT A.HR_EH_HEADER_ID, A.EFFDT, A.DESCR100 FROM PS_HR_EH_TBL A WHERE A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_HR_EH_TBL C WHERE C.HR_EH_HEADER_ID = A.HR_EH_HEADER_ID AND ((C.EFFDT <= %CurrentDateIn) OR (A.EFFDT > %CurrentDateIn AND %CurrentDateIn < ( SELECT MIN(C2.EFFDT) FROM PS_HR_EH_TBL C2 WHERE C2.HR_EH_HEADER_ID = A.HR_EH_HEADER_ID ))))

  • Related Language Record: HR_EH_TBL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_EH_HEADER_ID Character(15) VARCHAR2(15) NOT NULL Mouse Over Data: Mouse Over ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description