CS_DOC_LOG_B_VW

(SQL View)
 Index Back

View on Document Logging

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

SELECT 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_QUESTGRP ,CS_WIZARD_ID ,1 ,CS_DISPLAY_SEQ ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,CS_AMENDMENT ,CS_BIND_CHG_TYP ,CS_BIND_TYPE ,CS_DISPLAYTYPE ,CS_VERSION ,DTTM_STAMP ,MESSAGE_SEVERITY ,RECNAME ,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 ,CS_STRING_LONG FROM PS_CS_DOC_LOG WHERE CS_LOG_GROUP IN ('250','650','510') AND CS_BIND_VAR <> ' ' AND CS_DOC_TYPE <> '007'

# 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_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
11 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
12 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
13 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
14 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
15 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
16 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
17 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
18 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
19 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
20 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
21 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
22 CS_BIND_CHG_TYP Character(1) VARCHAR2(1) NOT NULL Bind Change Type
1=Value Change
2=Row value inserted
3=Row value deleted
23 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
24 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
25 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
26 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.
27 MESSAGE_SEVERITY Number(5,0) INTEGER NOT NULL Message Severity
28 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
29 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
30 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
31 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
32 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
33 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
34 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
35 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
36 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
37 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
38 CS_NUMBER_238 Number(32,8) DECIMAL(31,8) NOT NULL Number 23 dot 8
39 CS_DATE Date(10) DATE Date Field
40 CS_DATETM DateTime(26) TIMESTAMP Date Time Field
41 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
42 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
43 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes
44 CS_STRING_LONG Long Character CLOB Long Response