CS_SECTION_LVW

(SQL View)
 Index Back

Section search view


SELECT A.SETID , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , b.language_cd , b.descr60 FROM PS_CS_OBJECTS_HDR A , ps_CS_OBJS_HDR_LNG B WHERE A.SETID = B.SETID AND A.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND A.CS_OBJECT_ID = B.CS_OBJECT_ID AND A.CS_OBJECT_TYPE = '0002'

  • Related Language Record for CS_SECTION_VW CS_SECT_NSL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CS_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
    0001=Clause
    0002=Section
    0003=Ad Hoc Clause
    0004=Rule
    0005=Bind Variables
    0006=Wizard Definition
    0007=Document Configurator
    0008=Document
    0015=Word Template
    1000=All
    3 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description