GPBR_E_P_LNG_VW

(SQL View)
 Index Back

Periodic Events View Rel Lng.

eSocial Periodic Events View Related Language.

SELECT A.GPBR_EVENT_CD , LNG.LANGUAGE_CD , B.DESCR100 FROM PS_GPBR_EVNT_ACTV A , PS_GPBR_EVNT_SETUP B , PS_GPBR_EVNT_S_LNG LNG WHERE A.GPBR_EVENT_CD = B.GPBR_EVENT_CD AND B.GPBR_EVNT_CATEGORY = 'P' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GPBR_EVNT_ACTV C WHERE C.GPBR_EVENT_CD = A.GPBR_EVENT_CD) AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GPBR_EVNT_SETUP D WHERE D.GPBR_EVENT_CD = B.GPBR_EVENT_CD AND D.EFFDT <= A.EFFDT AND D.EFF_STATUS = 'A') AND B.GPBR_EVENT_CD = LNG.GPBR_EVENT_CD AND B.EFFDT = LNG.EFFDT

  • Related Language Record for GPBR_ES_P_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description