CS_DOC_REPL_SVW

(SQL View)
 Index Back

SELECT DISTINCT CS_DOC_ID , CS_DOC_TYPE , CS_KEYVALUE , LEVEL1 , LEVEL2 , LEVEL3 , LEVEL4 , LEVEL5 , LEVEL6 , LEVEL7 , LEVEL8 , LEVEL9 , CS_BODY_TYPE , CS_CHLD_LIST_STYLE , CS_DUMMY_CD , CS_LIST_STYLE , CS_NUMBERING_FLG , CS_NUM_FLG_PAR , CS_OBJECT_ID , CS_OBJECT_TYPE , CS_OBJ_GROUP , CS_OBJ_GROUP_TYPE , CS_PAGE_BREAK , LEVEL_NUM FROM PS_CS_DOC_REPL_SEC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL stores the file type -- main file, amendment, preview, throwaway Date Initials Issue Description ========================================== 06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types 7/2008 cel Added new executive summary file type. 9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
005=Document Attachment
006=Transaction Attachment
007=Config Selector
008=Main Signature Document
009=Amendment Signature File
010=Executive Summary
011=Exec-Sign
095=Document Attachment
096=Transaction Attachment
101=Main Document
102=Amendment Document
998=Main Document - ext collab
999=Amendment External Collab
3 CS_KEYVALUE Character(30) VARCHAR2(30) NOT NULL SCC 09/01/04
4 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
5 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
6 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
7 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
8 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
9 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
10 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
11 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
12 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
13 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
14 CS_CHLD_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Child Style
15 CS_DUMMY_CD Character(1) VARCHAR2(1) NOT NULL Dummy code used for contract document explosion
1=Repeating Section
2=Rule Section
3=SLA Header Section
4=SLA Line Section
5=Alternate Section
N=Not a dummy record
16 CS_LIST_STYLE Character(20) VARCHAR2(20) NOT NULL Override Section Style
17 CS_NUMBERING_FLG Character(1) VARCHAR2(1) NOT NULL Numbering
18 CS_NUM_FLG_PAR Character(1) VARCHAR2(1) NOT NULL Parent Numbering Flag
19 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
20 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
21 CS_OBJ_GROUP Character(20) VARCHAR2(20) NOT NULL Object Group
22 CS_OBJ_GROUP_TYPE Character(4) VARCHAR2(4) NOT NULL Working doc object grouping type
0001=Repeating Clause
0002=Repeating Section
0004=Rule
0005=SLA Header
0006=SLA Line
23 CS_PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL Page Break
24 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level