CS_SECTION_VW (SQL View)	Index Back
Section search view 1/8/2008 CEL -- added new sla category section to exclude

CS_SECTION_VW

(SQL View)

Section search view

1/8/2008 CEL -- added new sla category section to exclude

SELECT SETID , CS_OBJECT_TYPE , CS_OBJECT_ID , DESCR60 , CS_SECTION_TYPE , CS_NOTES FROM PS_CS_OBJECTS_HDR WHERE CS_OBJECT_TYPE = '0002' AND CS_SECTION_TYPE <> 'SH' AND CS_SECTION_TYPE <> 'SL' AND CS_SECTION_TYPE <> 'SC'

Related Language Record: CS_SECTION_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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
Default Value: 0002

3 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

5 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

6 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 Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
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 Default Value: 0002
3	CS_OBJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Object id -- clause, section
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
5	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
6	CS_NOTES	Long Character	CLOB	Notes