CS_OBJ_CURR_VW

(SQL View)
 Index Back

Objects details

View used within the MS Word integration .. research pane messages. 9/2007 cel 1696468000 -- changing the view to join to cs_body for some of the platforms.

SELECT D.SETID ,D.CS_OBJECT_TYPE ,D.CS_OBJECT_ID ,D.EFFDT , D.EFF_STATUS , D.CS_APPROVAL_STATUS , D.CS_TITLE ,H.DESCR60 , T.CS_BODY FROM PS_CS_OBJECTS_DTL D , PS_CS_OBJECTS_HDR H , PS_CS_OBJECT_TEXT T WHERE D.SETID = H.SETID AND D.CS_OBJECT_TYPE = H.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = H.CS_OBJECT_ID AND D.SETID = T.SETID AND D.CS_OBJECT_TYPE = T.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = T.CS_OBJECT_ID AND T.CS_BODY_TYPE = 'F' AND D.EFFDT = T.EFFDT AND D.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_CS_OBJECTS_DTL X WHERE X.SETID = D.SETID AND X.CS_OBJECT_TYPE = D.CS_OBJECT_TYPE AND X.CS_OBJECT_ID = D.CS_OBJECT_ID AND X.EFFDT <= %CurrentDateIn AND X.CS_APPROVAL_STATUS = 'A') AND d.eff_status = 'A'

# 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 CS_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
I=Initial
P=Pending Approval

Default Value: I

7 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 CS_BODY Long Character CLOB stores the body text for clause/section.