CNT_TYPEESP_LNG

(SQL View)
 Index Back

Contract Type ESP VW

This view identifies types of Contracts for ESP region.

SELECT A.CONTRACT_TYPE , A.EFFDT , A1.LANGUAGE_CD , A1.DESCR , A.CONTRACT_TYPE %Concat ' - ' %Concat A1.DESCR FROM PS_PERS_CNTRCT_TYP A , PS_PERS_CNTTYP_LNG A1 WHERE A.SETID = 'ESP' AND A.SETID= A1.SETID AND A.CONTRACT_TYPE = A1.CONTRACT_TYPE AND A.EFFDT = A1.EFFDT

  • Related Language Record for CNT_TYPE_VW_ESP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50