CNTRCT_SYNM_LVW

(SQL View)
 Index Back

Active Contract Style Lan View

11/15/2015 JOHAN PO0025 - Master contract fluid

SELECT A.CNTRCT_STYLE , B.LANGUAGE_CD , B.CNTRCT_STYLE_NAME , B.DESCR50 FROM PS_CNTRCT_STYLE A , PS_CNTRCT_STL_LNG B WHERE A.STYLE_STATUS = 'A' AND A.CNTRCT_PROC_OPT <> ' ' AND A.CNTRCT_STYLE = B.CNTRCT_STYLE

  • Related Language Record for CNT_STYNMACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50