CS_RULE_OBJ_VW

(SQL View)

SELECT A.SETID ,'0004' ,A.CS_RULE_ID ,A.EFFDT ,A.CS_OBJ_TYPE_CHILD ,A.CS_CHILD_OBJID ,A.SORT_SEQ_NBR ,A.CS_BODY_TYPE ,A.SEQ_NUMBER ,B.DESCR60 ,B.CS_RULE_TYPE FROM PS_CS_RULE_OBJ A ,PS_CS_RULES B WHERE A.SETID = B.SETID AND A.CS_RULE_ID = B.CS_RULE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CS_CONTENT_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 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options

3 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 CS_OBJ_TYPE_CHILD Character(4) VARCHAR2(4) NOT NULL Clause/section dependent
0001=Clause
0002=Section
0004=Rule
Prompt Table: CS_OBJ_TYPE_VW3

6 CS_CHILD_OBJID Character(20) VARCHAR2(20) NOT NULL Child Object
Prompt Table: CS_OBJECTS3_VW

7 SORT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sort Sequence Number

8 CS_BODY_TYPE Character(1) VARCHAR2(1) NOT NULL indicates body type -- full or by ref for clause/section
F=Full Text
R=By Reference Text
Default Value: F

9 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number

10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

11 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
A=Alternate
S=Standard
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CS_CONTENT_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 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options. 0001=Clause 0002=Section 0003=Ad Hoc Clause 0004=Rule 0005=Bind Variables 0006=Wizard Definition 0007=Document Configurator 0008=Document 0009=Contract Agreement 0010=Bid Factor 0011=Contract 0012=Sourcing Event 0013=Question Group 0014=Document Type 0015=Word Template 0016=Document Format and Options
3	CS_CONTENT_ID	Character(30)	VARCHAR2(30) NOT NULL	Content ID
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	CS_OBJ_TYPE_CHILD	Character(4)	VARCHAR2(4) NOT NULL	Clause/section dependent 0001=Clause 0002=Section 0004=Rule Prompt Table: CS_OBJ_TYPE_VW3
6	CS_CHILD_OBJID	Character(20)	VARCHAR2(20) NOT NULL	Child Object Prompt Table: CS_OBJECTS3_VW
7	SORT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sort Sequence Number
8	CS_BODY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	indicates body type -- full or by ref for clause/section F=Full Text R=By Reference Text Default Value: F
9	SEQ_NUMBER	Number(3,0)	SMALLINT NOT NULL	Expense Sequence Number
10	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
11	CS_RULE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rule Type A=Alternate S=Standard Default Value: S