CS_DOC_BIND_VW (SQL View)	Index Back
All binds with date format 5/15/07 RK 9.1 ICE enhancement to display decimal numbers - added cs_precision and cs_currency fields (from cs_binds record)

CS_DOC_BIND_VW

(SQL View)

All binds with date format

5/15/07 RK 9.1 ICE enhancement to display decimal numbers - added cs_precision and cs_currency fields (from cs_binds record)

SELECT a.cs_doc_id , a.cs_doc_type , a.cs_bind_var , a.seq_nbr , a.cs_bind_type , a.cs_displaytype , a.cs_field_type , a.value_char , a.value_dt , a.value_dttm , a.value_nbr , b.cs_date_display , a.cs_rpt_flg , b.cs_precision , b.cs_currency , b.cs_field_length FROM ps_cs_doc_bind a , PS_CS_BINDS b WHERE a.cs_bind_var = b.cs_bind_var

# 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_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

5 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard

6 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value

7 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

8 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER

9 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

10 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value

11 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value

12 CS_DATE_DISPLAY Character(3) VARCHAR2(3) NOT NULL Display Format
001=December 31, 2005
002=31 December 2005
003=12/31/2005
004=31/12/2005
005=Dec 31, 2005
006=31 Dec 2005
100=December 31, 2005 at 11:59 PM
102=31 December 2005 at 11:59 PM
104=12/31/2005 at 11:59 PM
106=31/12/2005 at 11:59 PM

13 CS_RPT_FLG Character(1) VARCHAR2(1) NOT NULL Y means this is a repeating object.

14 CS_PRECISION Number(2,0) SMALLINT NOT NULL F-AHAYT-X0ES6 new field for bindvariable/wizard masking

15 CS_CURRENCY Character(1) VARCHAR2(1) NOT NULL Currency Bind

16 CS_FIELD_LENGTH Character(3) VARCHAR2(3) NOT NULL Field Length 5/11/07 F-AHAYT-X0ES6 Added new Field Len of LNG
002=002
005=005
012=012
030=030
254=254
LNG=Long Char

#	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_BIND_VAR	Character(30)	VARCHAR2(30) NOT NULL	Bind Variable
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	CS_BIND_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bind Variable Type 1=Transactional 3=Wizard
6	CS_DISPLAYTYPE	Character(1)	VARCHAR2(1) NOT NULL	Display Type 1=Xlat Long Name 2=Xlat Short Name 3=Xlat Value
7	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
8	VALUE_CHAR	Character(254)	VARCHAR2(254) NOT NULL	VALUE CHARACTER
9	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
10	VALUE_DTTM	DateTime(26)	TIMESTAMP	DateTime Value
11	VALUE_NBR	Signed Number(33,8)	DECIMAL(31,8) NOT NULL	Numeric Value
12	CS_DATE_DISPLAY	Character(3)	VARCHAR2(3) NOT NULL	Display Format 001=December 31, 2005 002=31 December 2005 003=12/31/2005 004=31/12/2005 005=Dec 31, 2005 006=31 Dec 2005 100=December 31, 2005 at 11:59 PM 102=31 December 2005 at 11:59 PM 104=12/31/2005 at 11:59 PM 106=31/12/2005 at 11:59 PM
13	CS_RPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y means this is a repeating object.
14	CS_PRECISION	Number(2,0)	SMALLINT NOT NULL	F-AHAYT-X0ES6 new field for bindvariable/wizard masking
15	CS_CURRENCY	Character(1)	VARCHAR2(1) NOT NULL	Currency Bind
16	CS_FIELD_LENGTH	Character(3)	VARCHAR2(3) NOT NULL	Field Length 5/11/07 F-AHAYT-X0ES6 Added new Field Len of LNG 002=002 005=005 012=012 030=030 254=254 LNG=Long Char