CS_CLS_GRP_VW (SQL View)	Index Back
Clause Group Detail

CS_CLS_GRP_VW

(SQL View)

Clause Group Detail

SELECT D.SETID , D.CS_OBJECT_ID , D.CS_CLAUSE_GROUP , D.CS_OBJECT_TYPE , H.LAST_DTTM_STAMP , H.LASTUPDOPRID FROM PS_CS_CLS_GRP_DTL D , PS_CS_CLS_GRP H WHERE D.SETID = H.SETID AND D.CS_CLAUSE_GROUP = H.CS_CLAUSE_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section

3 CS_CLAUSE_GROUP Character(10) VARCHAR2(10) NOT NULL Supplier contract Clause Group

4 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

5 LAST_DTTM_STAMP DateTime(26) TIMESTAMP Data Time Stamp - Old

6 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CS_OBJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Object id -- clause, section
3	CS_CLAUSE_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Supplier contract Clause Group
4	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
5	LAST_DTTM_STAMP	DateTime(26)	TIMESTAMP	Data Time Stamp - Old
6	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.