CS_DOCLOGH_CDVW

(SQL View)
 Index Back

Doc Copy Log History


SELECT DISTINCT L.CS_DOC_ID ,L.CS_DOC_TYPE ,L.CS_DOC_LOG_SEQ ,L.CS_LOG_GROUP ,L.CS_DISPLAY_SEQ ,L.CS_OBJECT_TYPE ,L.CS_OBJECT_ID ,L.CS_BIND_VAR ,L.SEQ_NBR ,L.CS_OBJECT_TYPE_SRC ,L.CS_OBJECT_ID_SRC ,L.CS_DOC_LOG_VER ,L.CS_OBJ_GROUP ,L.CS_OBJ_GROUP_TYPE ,L.CS_QUESTGRP ,L.CS_WIZARD_ID ,L.LEVEL1 ,L.LEVEL2 ,L.LEVEL3 ,L.LEVEL4 ,L.LEVEL5 ,L.LEVEL6 ,L.LEVEL7 ,L.LEVEL8 ,L.LEVEL9 ,L.CS_ALT_USED ,L.CS_AMENDMENT ,L.CS_CLAUSE_LEAD ,L.CS_BIND_CHG_TYP ,L.CS_BIND_TYPE ,L.CS_DISPLAYTYPE ,L.CS_RULE_ID ,L.CS_RULE_TYPE ,L.CS_RULE_USED ,L.CS_VERSION ,L.DTTM_STAMP ,L.MESSAGE_NBR ,L.MESSAGE_SET_NBR ,L.MESSAGE_SEVERITY ,L.RECNAME ,L.SEQ_NBR_LINK ,L.CS_FIELD_TYPE ,L.VALUE_CHAR ,L.VALUE_DT ,L.VALUE_DTTM ,L.VALUE_NBR ,L.CS_STRING_2 ,L.CS_STRING_5 ,L.CS_STRING_12 ,L.CS_STRING_30 ,L.CS_NUMBER_238 ,L.CS_DATE ,L.CS_DATETM ,L.CS_INTEGER ,L.CS_STRING_254 ,L.CS_YESNO ,OH.DESCR60 ,OD.CS_TITLE FROM PS_CS_DOC_LOG_HIST L , PS_CS_OBJECTS_HDR OH , PS_CS_OBJECTS_DTL OD WHERE L.CS_LOG_GROUP = '700' AND OH.SETID = L.CS_STRING_5 AND OH.CS_OBJECT_TYPE = L.CS_OBJECT_TYPE AND OH.CS_OBJECT_ID = L.CS_OBJECT_ID AND OD.SETID = OH.SETID AND OD.CS_OBJECT_TYPE = OH.CS_OBJECT_TYPE AND OD.CS_OBJECT_ID = OH.CS_OBJECT_ID AND OD.EFFDT = L.CS_DATE

# 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_DOC_LOG_SEQ Number(5,0) INTEGER NOT NULL Logging Sequence

Default Value: 1

4 CS_LOG_GROUP Character(3) VARCHAR2(3) NOT NULL Logging Message Group Type
010=Critical Error
110=Bind Not Found
120=Alternate Not Resolved
130=Rule Not Resolved
150=Bind Not Resolved
160=Wizard Bind Not Found
170=Content Excluded
210=Alternate Considered
220=Rule Evaluated
230=Include
240=Include Repeating
250=Bind Resolved
510=Bind Changed
600=Wizard Navigation
650=Wizard Bind Variable
700=Newer Version Exists
5 CS_DISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Display Sequence
6 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
7 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
8 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
10 CS_OBJECT_TYPE_SRC Character(4) VARCHAR2(4) NOT NULL Source Object Type
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0010=All
11 CS_OBJECT_ID_SRC Character(30) VARCHAR2(30) NOT NULL Source Object Name
12 CS_DOC_LOG_VER Number(3,0) SMALLINT NOT NULL Logging Version
13 CS_OBJ_GROUP Character(20) VARCHAR2(20) NOT NULL Object Group
14 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
15 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
16 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
17 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
18 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
19 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
20 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
21 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
22 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
23 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
24 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
25 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
26 CS_ALT_USED Character(1) VARCHAR2(1) NOT NULL Alternate Used
27 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
28 CS_CLAUSE_LEAD Character(30) VARCHAR2(30) NOT NULL Lead Clause ID
29 CS_BIND_CHG_TYP Character(1) VARCHAR2(1) NOT NULL Bind Change Type
1=Value Change
2=Row value inserted
3=Row value deleted
30 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
31 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
32 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t
33 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
A=Alternate
S=Standard
34 CS_RULE_USED Character(1) VARCHAR2(1) NOT NULL Rule was used

Y/N Table Edit

35 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
36 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
37 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
38 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
39 MESSAGE_SEVERITY Number(5,0) INTEGER NOT NULL Message Severity
40 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
41 SEQ_NBR_LINK Number(15,0) DECIMAL(15) NOT NULL Sequence Number Link
42 CS_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Field Type 5/11/07 F-AHAYT-X0ES6 - Added new field type of Prompt
1=String
3=Date
4=Date/Time
5=Yes/No
6=Integer
7=Decimal
8=Prompt Table
9=Checkbox
43 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
44 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
45 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
46 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
47 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
48 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
49 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
50 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
51 CS_NUMBER_238 Number(32,8) DECIMAL(31,8) NOT NULL Number 23 dot 8
52 CS_DATE Date(10) DATE Date Field
53 CS_DATETM DateTime(26) TIMESTAMP Date Time Field
54 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
55 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
56 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes
57 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
58 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title