CS_W_LOG_VW

(SQL View)
 Index Back

Wizard Binds Table

12/19/2007 RMK Long wizard bind enhancement - added field cs_String_long

SELECT A.CS_DOC_ID , H.CS_VERSION , A.CS_DOC_TYPE , A.CS_DISPLAY_SEQ , A.SETID , A.CS_WIZARD_ID , A.CS_QUESTGRP , A.CS_BIND_VAR , A.SEQ_NBR , A.CS_BIND_TYPE , A.CS_QUEST_SEQ , A.CS_WIZ_NAVIGATE , A.CS_GOTO_SEQ , A.CS_DISPLAY_GRP_SEQ , B.CS_NOBINDVALUE , 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 , A.CS_STRING_254 , B.CS_QUESTION , A.CS_TEMPLATE_ID , A.CS_STRING_LONG FROM PS_CS_WIZARD_BIND A , PS_CS_QUESTIONS B , PS_CS_DOC_HDR H WHERE %Join(COMMON_KEYS, CS_QUESTIONS A, CS_QUESTIONS B) AND A.CS_DOC_ID = H.CS_DOC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
3 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
4 CS_DISPLAY_SEQ Number(3,0) SMALLINT NOT NULL Display Sequence
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

6 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID
7 CS_QUESTGRP Character(30) VARCHAR2(30) NOT NULL Question Group
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_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
11 CS_QUEST_SEQ Number(15,0) DECIMAL(15) NOT NULL Sequence Number
12 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

13 CS_GOTO_SEQ Number(3,0) SMALLINT NOT NULL Navigate to Sequence
14 CS_DISPLAY_GRP_SEQ Number(3,0) SMALLINT NOT NULL Group Sequence
15 CS_NOBINDVALUE Character(1) VARCHAR2(1) NOT NULL No Bind Value

Y/N Table Edit

16 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
17 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
18 CS_STRING_2 Character(2) VARCHAR2(2) NOT NULL F-AHAYT-X0ES6 new field label
19 CS_STRING_5 Character(5) VARCHAR2(5) NOT NULL F-AHAYT-X0ES6 new field label
20 CS_STRING_12 Character(12) VARCHAR2(12) NOT NULL F-AHAYT-X0ES6 new field label
21 CS_STRING_30 Character(30) VARCHAR2(30) NOT NULL F-AHAYT-X0ES6 new field label
22 CS_NUMBER_238 Number(32,8) DECIMAL(31,8) NOT NULL Number 23 dot 8
23 CS_DATE Date(10) DATE Date Field
24 CS_DATETM DateTime(26) TIMESTAMP Date Time Field
25 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes
26 CS_INTEGER Number(23,0) DECIMAL(23) NOT NULL Integer 23
27 CS_STRING_254 Character(254) VARCHAR2(254) NOT NULL 254 Character
28 CS_QUESTION Character(254) VARCHAR2(254) NOT NULL Question
29 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
30 CS_STRING_LONG Long Character CLOB Long Response