CS_OBJ_ALTS_VW (SQL View)	Index Back
Alternates

CS_OBJ_ALTS_VW

(SQL View)

Alternates

SELECT D.SETID ,'0001' ,D.CS_OBJECT_ID ,D.EFFDT ,D.CS_ALT_OBJID ,D.PRIORITY_NBR ,D.CS_BODY_TYPE ,D.CS_RULE_ID ,H.DESCR60 ,H.CS_SECTION_TYPE ,H.CS_CLASS ,H.CS_LIBRARY ,H.CS_NOTES FROM PS_CS_OBJECT_ALTS D , PS_CS_OBJECTS_HDR H WHERE D.SETID = H.SETID AND D.CS_OBJECT_TYPE = H.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = H.CS_OBJECT_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_ALT_OBJID Character(30) VARCHAR2(30) NOT NULL Alternate ID
Prompt Table: CS_OBJECTS1_VW

6 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

7 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

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

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

10 CS_SECTION_TYPE Character(2) VARCHAR2(2) NOT NULL CEL 01/2008 Adding SLA category placeholders RMK 12/11/2007 Amendment Placeholder - enhancement to update 2nd amendment file with changes in amended document. Indicator to the system where to drop the changes in the amendment file CEL 5/1/2005 SH and SL types are hidden from all pages/etc. Purely used internally in the table. So that is why they are marked inactive here .. to stop them from showing up on the pages. BUT we still need them as codes cause we use internally in code .. just didn't want to remove them and have them get accidentally used.
A=Amendment Placeholder
G=General
SC=Placeholder-Category Agreement
SH=Placeholder-Header Agreement
SL=Placeholder-Line Agreement
T=Introduction/Title
Default Value: G

11 CS_CLASS Character(20) VARCHAR2(20) NOT NULL Class

12 CS_LIBRARY Character(20) VARCHAR2(20) NOT NULL Library

13 CS_NOTES Long Character CLOB Notes

#	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_ALT_OBJID	Character(30)	VARCHAR2(30) NOT NULL	Alternate ID Prompt Table: CS_OBJECTS1_VW
6	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
7	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
8	CS_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	t
9	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
10	CS_SECTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	CEL 01/2008 Adding SLA category placeholders RMK 12/11/2007 Amendment Placeholder - enhancement to update 2nd amendment file with changes in amended document. Indicator to the system where to drop the changes in the amendment file CEL 5/1/2005 SH and SL types are hidden from all pages/etc. Purely used internally in the table. So that is why they are marked inactive here .. to stop them from showing up on the pages. BUT we still need them as codes cause we use internally in code .. just didn't want to remove them and have them get accidentally used. A=Amendment Placeholder G=General SC=Placeholder-Category Agreement SH=Placeholder-Header Agreement SL=Placeholder-Line Agreement T=Introduction/Title Default Value: G
11	CS_CLASS	Character(20)	VARCHAR2(20) NOT NULL	Class
12	CS_LIBRARY	Character(20)	VARCHAR2(20) NOT NULL	Library
13	CS_NOTES	Long Character	CLOB	Notes