CS_QL_YN_VW (SQL View)	Index Back
List of type string yes/no Used within Rule Definition app classes to determine the dropdown list of values to show for a wizard/list bind in criteria section. Values are added dynamically to a common work field on the page that is a drop down type. (so instead of having to create a lot of drop down fields for each list type.)

CS_QL_YN_VW

(SQL View)

List of type string yes/no

Used within Rule Definition app classes to determine the dropdown list of values to show for a wizard/list bind in criteria section. Values are added dynamically to a common work field on the page that is a drop down type. (so instead of having to create a lot of drop down fields for each list type.)

SELECT DISTINCT A.SETID , A.CS_BIND_VAR , B.CS_YESNO 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

# 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 CS_YESNO Character(1) VARCHAR2(1) NOT NULL Yes No Field
N=No
Y=Yes