CS_CLAUSE_SVW

(SQL View)
Index Back

Clauses View for PTSF

Clauses View for PTSF

SELECT A.SETID , A.CS_OBJECT_ID , A.CS_OBJECT_TYPE , A.DESCR60 , A.CS_CLAUSE_TYPE , A.CS_CLASS , A.CS_APPROVAL_TYPE , A.CS_LIBRARY , A.LAST_DTTM_STAMP , A.LASTUPDOPRID , A.CS_NOTES FROM PS_CS_OBJECTS_HDR A WHERE CS_OBJECT_TYPE = '0001'

  • Related Language Record: CS_CLAUSE_SLNG
  • # 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_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    3 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
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 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

    Default Value: G

    6 CS_CLASS Character(20) VARCHAR2(20) NOT NULL Class

    Prompt Table: CS_CLS_CLASS

    7 CS_APPROVAL_TYPE Character(30) VARCHAR2(30) NOT NULL Approval Type

    Prompt Table: CS_CLASS_APP_VW

    8 CS_LIBRARY Character(20) VARCHAR2(20) NOT NULL Library

    Prompt Table: CS_LIBRARY

    9 LAST_DTTM_STAMP DateTime(26) TIMESTAMP Data Time Stamp - Old
    10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 CS_NOTES Long Character CLOB Notes