CS_QL_DUMMY_VW (SQL View)	Index Back
Dummy prompt view This view is used for the work field on the rule page since I needed to have a view tied to the drop down field on the page. But this view will never return anything .. and instead there is code to dynamically build the drop down list for each row based on bind type/length etc. The code is in the rule appclass.

CS_QL_DUMMY_VW

(SQL View)

Dummy prompt view

This view is used for the work field on the rule page since I needed to have a view tied to the drop down field on the page. But this view will never return anything .. and instead there is code to dynamically build the drop down list for each row based on bind type/length etc. The code is in the rule appclass.

SELECT DISTINCT A.SETID , A.CS_BIND_VAR , B.CS_STRING_5 FROM PS_CS_QUESTIONS A , PS_CS_QLIST_VALUES B WHERE A.SETID = B.SETID AND A.CS_QUESTGRP = B.CS_QUESTGRP AND A.CS_QUEST_SEQ = B.CS_QUEST_SEQ AND (A.CS_LIST_TYPE = 'C' OR A.CS_LIST_TYPE = 'D') AND 1 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

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