CS_CLAUSE_VW

(SQL View)
 Index Back

Clause Search view

Clause Search view

SELECT SETID , CS_OBJECT_TYPE , CS_OBJECT_ID , DESCR60 , CS_CLASS , CS_LIBRARY , CS_CLAUSE_TYPE , CS_NOTES FROM PS_CS_OBJECTS_HDR WHERE CS_OBJECT_TYPE = '0001'

  • Related Language Record: CS_CLAUSE_LVW

    • # 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

    Default Value: 0001

    3 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 CS_CLASS Character(20) VARCHAR2(20) NOT NULL Class
    6 CS_LIBRARY Character(20) VARCHAR2(20) NOT NULL Library
    7 CS_CLAUSE_TYPE Character(2) VARCHAR2(2) NOT NULL New with 9.1 to indicate if Table Clause or other
    G=General Clause
    T=Table Clause
    8 CS_NOTES Long Character CLOB Notes