CS_CLAUSE_VW2

(SQL View)
 Index Back

Clause View for Wizard

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

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

# 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

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

Default Value: 0001

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_NOTES Long Character CLOB Notes