CS_DOC_LOG_VW

(SQL View)
 Index Back

Doc Logging

08/02/07 TBG F-AHAYT-X0ES6 Add CS_STRING_LONG

SELECT DISTINCT CS_DOC_ID ,CS_DOC_TYPE ,CS_DOC_LOG_SEQ ,CS_LOG_GROUP ,CS_DISPLAY_SEQ ,CS_OBJECT_TYPE ,CS_OBJECT_ID ,CS_BIND_VAR ,SEQ_NBR ,CS_OBJECT_TYPE_SRC ,CS_OBJECT_ID_SRC ,CS_OBJ_GROUP ,CS_OBJ_GROUP_TYPE ,CS_QUESTGRP ,CS_WIZARD_ID ,LEVEL1 ,LEVEL2 ,LEVEL3 ,LEVEL4 ,LEVEL5 ,LEVEL6 ,LEVEL7 ,LEVEL8 ,LEVEL9 ,CS_ALT_USED ,CS_AMENDMENT ,CS_CLAUSE_LEAD ,CS_BIND_CHG_TYP ,CS_BIND_TYPE ,CS_DISPLAYTYPE ,CS_RULE_ID ,CS_RULE_TYPE ,CS_RULE_USED ,CS_VERSION ,DTTM_STAMP ,MESSAGE_NBR ,MESSAGE_SET_NBR ,MESSAGE_SEVERITY ,RECNAME ,SEQ_NBR_LINK ,CS_FIELD_TYPE ,VALUE_CHAR ,VALUE_DT ,VALUE_DTTM ,VALUE_NBR ,CS_STRING_2 ,CS_STRING_5 ,CS_STRING_12 ,CS_STRING_30 ,CS_NUMBER_238 ,CS_DATE ,CS_DATETM ,CS_INTEGER ,CS_STRING_254 ,CS_YESNO FROM PS_CS_DOC_LOG WHERE CS_LOG_GROUP NOT IN ('250','650','510') AND MESSAGE_SEVERITY <> 100

# 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_OBJ_GROUP Character(20) VARCHAR2(20) NOT NULL Object Group
13 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
14 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
15 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
16 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
17 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
18 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
19 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
20 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
21 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
22 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
23 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
24 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
25 CS_ALT_USED Character(1) VARCHAR2(1) NOT NULL Alternate Used
26 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
27 CS_CLAUSE_LEAD Character(30) VARCHAR2(30) NOT NULL Lead Clause ID
28 CS_BIND_CHG_TYP Character(1) VARCHAR2(1) NOT NULL Bind Change Type
1=Value Change
2=Row value inserted
3=Row value deleted
29 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
30 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
31 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t
32 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
A=Alternate
S=Standard
33 CS_RULE_USED Character(1) VARCHAR2(1) NOT NULL Rule was used

Y/N Table Edit

34 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
35 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.
36 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
37 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
38 MESSAGE_SEVERITY Number(5,0) INTEGER NOT NULL Message Severity
39 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
40 SEQ_NBR_LINK Number(15,0) DECIMAL(15) NOT NULL Sequence Number Link
41 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
42 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
43 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
44 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
45 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
46 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
47 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
48 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
49 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
50 CS_NUMBER_238 Number(32,8) DECIMAL(31,8) NOT NULL Number 23 dot 8
51 CS_DATE Date(10) DATE Date Field
52 CS_DATETM DateTime(26) TIMESTAMP Date Time Field
53 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
54 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
55 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes