CS_LOG_RULE_VW

(SQL View)
Index Back

SELECT A.SETID , A.CS_RULE_ID , A.CS_RULE_TYPE , '0004' , A.CS_RULE_ID , B.CS_SOURCE_TRANS , B.CS_BIND_RECNAME FROM PS_CS_RULES A , PS_CS_RULE_SOURCE B WHERE A.SETID = B.SETID AND A.CS_RULE_ID = B.CS_RULE_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_CS_RULE_SOURCE C WHERE B.SETID = C.SETID AND B.CS_RULE_ID = C.CS_RULE_ID AND C.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t
3 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
A=Alternate
S=Standard
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 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
6 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
7 CS_BIND_RECNAME Character(15) VARCHAR2(15) NOT NULL Binds Recordname