SETIDDefault Value: CS_CONFIG_TBL.CS_WORD_TMPL_NAME
Prompt Table: CS_WORD_TEMPLVW
CS_UPGTMPL_VW(SQL View) |
Index Back |
|---|---|
2003 word templatesRecord view to use as prompt table to show 2003 word templates only |
| SELECT DISTINCT a.setid , a.cs_word_tmpl_name FROM PS_CS_TMPL_TBL a , ps_cs_word_templ b WHERE a.cs_word_tmpl_name = b.cs_word_tmpl_name AND b.cs_file_format = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CS_WORD_TMPL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Word Template Name
Default Value: CS_CONFIG_TBL.CS_WORD_TMPL_NAME Prompt Table: CS_WORD_TEMPLVW |