CNTRCT_STL_LVW

(SQL View)
 Index Back

Contract Style Language 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.CNTRCT_PROC_OPT IN ('SPP', 'GRPM', 'GRPS') AND A.CNTRCT_STYLE = B.CNTRCT_STYLE

  • Related Language Record for CNTRCT_STYLE_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