CS_DOC_LOG_W_VW

(SQL View)
 Index Back

Log join to Wizard Binds Table

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

SELECT A.CS_DOC_ID , A.CS_DOC_TYPE , A.SETID , A.CS_WIZARD_ID , A.CS_QUESTGRP , A.CS_BIND_VAR , A.SEQ_NBR , A.CS_DISPLAY_SEQ , A.CS_BIND_TYPE , A.CS_QUEST_SEQ , A.CS_DISPLAYTYPE , A.CS_FIELD_TYPE , A.CS_STRING_2 , A.CS_STRING_5 , A.CS_STRING_12 , A.CS_STRING_30 , A.CS_NUMBER_238 , A.CS_DATE , A.CS_DATETM , A.CS_YESNO , A.CS_INTEGER , L.MESSAGE_SET_NBR , L.MESSAGE_NBR , L.VALUE_CHAR , L.VALUE_DT , L.VALUE_DTTM , L.VALUE_NBR , A.CS_WIZ_NAVIGATE , A.CS_GOTO_SEQ , A.CS_DISPLAY_GRP_SEQ , L.CS_QUESTION , A.CS_STRING_254 , A.CS_STRING_LONG FROM PS_CS_WIZARD_BIND A , PS_CS_DOC_LOG L WHERE A.CS_DOC_ID = L.CS_DOC_ID AND A.CS_BIND_VAR = L.CS_BIND_VAR AND A.CS_QUESTGRP = L.CS_QUESTGRP AND A.CS_DISPLAY_SEQ = L.CS_DISPLAY_SEQ AND A.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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
5 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
6 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CS_DISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Display Sequence
9 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
10 CS_QUEST_SEQ Number(15,0) DECIMAL(15) NOT NULL Sequence Number
11 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
12 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
13 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
14 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
15 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
16 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
17 CS_NUMBER_238 Number(32,8) DECIMAL(31,8) NOT NULL Number 23 dot 8
18 CS_DATE Date(10) DATE Date Field
19 CS_DATETM DateTime(26) TIMESTAMP Date Time Field
20 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes
21 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
22 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
23 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
24 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
25 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
26 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
27 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
28 CS_WIZ_NAVIGATE Character(1) VARCHAR2(1) NOT NULL Navigate
C=Specific Configurator
G=Next Group
N=None
Q=Next Question
S=Specific Sequence

Default Value: N

29 CS_GOTO_SEQ Number(3,0) SMALLINT NOT NULL Navigate to Sequence
30 CS_DISPLAY_GRP_SEQ Number(3,0) SMALLINT NOT NULL Group Sequence
31 CS_QUESTION Character(254) VARCHAR2(254) NOT NULL Question
32 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
33 CS_STRING_LONG Long Character CLOB Long Response