CS_DOCBINTMP_VW

(SQL View)
 Index Back

Binds used in word template

06/30/10 RMK Changed sql view text to include executive summaries (file type = 010) 07/24/07 RMK F-AHAYT-X0ES6 Enhancement to allow binds in header and footer - this record view is used by scm_cs_wordml app package and it shows all binds used in word templates associated with contract documents. As of release 9.1, it only make sense to allow level zero binds, so seq_nbr should always be zero.

SELECT a.cs_doc_id , a.cs_doc_type , a.cs_bind_var , a.seq_nbr , b.cs_word_tmpl_name , a.cs_bind_type , a.cs_displaytype , a.cs_Field_type , a.cs_rpt_flg , a.value_char , a.value_dt , a.value_dttm , a.value_nbr , c.cs_currency , c.cs_precision , c.cs_field_length , c.cs_date_display FROM ps_cs_Doc_bind a , ps_cs_bind_usage b , ps_cs_binds c , PS_CS_DOC_HDR e , ps_cs_tmpl_tbl f WHERE a.cs_bind_var = b.cs_bind_var AND a.cs_bind_var = c.cs_bind_var AND b.cs_word_tmpl_name <> ' ' AND a.cs_doc_id = e.cs_doc_id AND ((e.cs_setid = f.setid AND e.cs_template_id = f.cs_template_id AND a.cs_doc_type = '001') OR (e.cs_setid = f.setid AND e.cs_template_amend = f.cs_template_id AND a.cs_doc_type = '002')) AND b.cs_word_tmpl_name = f.cs_word_tmpl_name

# 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_WORD_TMPL_NAME Character(30) VARCHAR2(30) NOT NULL Word Template Name
6 CS_BIND_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Type
1=Transactional
3=Wizard
7 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
8 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
9 CS_RPT_FLG Character(1) VARCHAR2(1) NOT NULL Y means this is a repeating object.
10 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
11 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
12 VALUE_DTTM DateTime(26) TIMESTAMP DateTime Value
13 VALUE_NBR Signed Number(33,8) DECIMAL(31,8) NOT NULL Numeric Value
14 CS_CURRENCY Character(1) VARCHAR2(1) NOT NULL Currency Bind
15 CS_PRECISION Number(2,0) SMALLINT NOT NULL F-AHAYT-X0ES6 new field for bindvariable/wizard masking
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
17 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