CS_LOG_BINDS_VW

(SQL View)

SELECT A.SETID , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , D.CS_BIND_VAR , D.CS_RULE_ID , B.CS_BIND_RECNAME , B.CS_SOURCE_TRANS , B.CS_LEVEL FROM PS_CS_OBJECTS_HDR A , PS_CS_OBJS_SOURCE B , PS_CS_OBJECTS_DTL C , PS_CS_BIND_USAGE D WHERE A.SETID = B.SETID AND A.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND A.CS_OBJECT_ID = B.CS_OBJECT_ID AND B.SETID = C.SETID AND B.CS_OBJECT_TYPE = C.CS_OBJECT_TYPE AND B.CS_OBJECT_ID = C.CS_OBJECT_ID AND C.SETID = D.SETID AND C.CS_OBJECT_TYPE = D.CS_OBJECT_TYPE AND C.CS_OBJECT_ID = D.CS_OBJECT_ID AND A.CS_OBJECT_TYPE IN ('0001','0002') AND C.CS_APPROVAL_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_CS_BIND_USAGE E WHERE D.SETID = E.SETID AND D.CS_OBJECT_ID = E.CS_OBJECT_ID AND D.CS_OBJECT_TYPE = E.CS_OBJECT_TYPE AND D.CS_RULE_ID = E.CS_RULE_ID AND E.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

5 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t

6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

7 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional

8 CS_LEVEL Number(2,0) SMALLINT NOT NULL Level

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	CS_BIND_VAR	Character(30)	VARCHAR2(30) NOT NULL	Bind Variable
5	CS_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	t
6	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
7	CS_SOURCE_TRANS	Character(2)	VARCHAR2(2) NOT NULL	Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring) 01=Ad Hoc 02=Purchasing Contracts 03=Purchase Orders 04=Sourcing Events 97=All Sources 98=Multiple Sources 99=Not Transactional
8	CS_LEVEL	Number(2,0)	SMALLINT NOT NULL	Level