GPFR_EVT_CT_VWL

(SQL View)
 Index Back

DSN event EE cntr type lang

Contract types of selected employees for a DSN event. Related language.

SELECT L.SETID , L.CONTRACT_TYPE , L.LANGUAGE_CD , L.DESCR , L.DESCRSHORT FROM PS_PERS_CNTTYP_LNG L WHERE L.EFFDT = ( SELECT MAX(L2.EFFDT) FROM PS_PERS_CNTTYP_LNG L2 WHERE L2.SETID = L.SETID AND L2.CONTRACT_TYPE = L.CONTRACT_TYPE AND L2.EFFDT <= %CurrentDateIn)

  • Related Language Record for GPFR_EVT_CT_DVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description