CS_OBJ_DTL_VW

(SQL View)
 Index Back

Objects details

Details on clauses and sections

SELECT D.SETID ,D.CS_OBJECT_TYPE ,D.CS_OBJECT_ID ,D.EFFDT ,D.EFF_STATUS ,D.NUM_CHILDREN ,D.ALTS_EXIST ,D.CS_APPROVAL_STATUS ,D.CS_TITLE ,D.CS_LIST_STYLE ,D.CS_CHLD_LIST_STYLE ,D.CS_PAGE_BREAK ,D.CS_NUMBERING_FLG ,D.CS_WORD_MODIFIED ,D.CHECKED_OUT_BY ,D.DATETIME_CHECKOUT ,D.SCM_ATTACH_ID ,D.ATT_VERSION ,D.LAST_DTTM_STAMP ,D.LASTUPDOPRID ,H.DESCR60 ,H.CS_SECTION_TYPE ,H.CS_CLASS ,H.CS_LIBRARY ,H.CS_NOTES FROM PS_CS_OBJECTS_DTL 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_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 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
7 ALTS_EXIST Character(1) VARCHAR2(1) NOT NULL cel - alternates exist flag in Contract Management

Y/N Table Edit

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

Default Value: I

9 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title
10 CS_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Section Style
11 CS_CHLD_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Child Style
12 CS_PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL Page Break

Y/N Table Edit

13 CS_NUMBERING_FLG Character(1) VARCHAR2(1) NOT NULL Numbering

Y/N Table Edit

Default Value: Y

14 CS_WORD_MODIFIED Character(1) VARCHAR2(1) NOT NULL Word Modified

Y/N Table Edit

Default Value: N

15 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
16 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
17 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
18 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
19 LAST_DTTM_STAMP DateTime(26) TIMESTAMP Data Time Stamp - Old
20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
21 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
22 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

23 CS_CLASS Character(20) VARCHAR2(20) NOT NULL Class
24 CS_LIBRARY Character(20) VARCHAR2(20) NOT NULL Library
25 CS_NOTES Long Character CLOB Notes