CS_RULE_BIND_VW (SQL View)	Index Back
Rule - Binds View SELECT A.SETID , A.CS_RULE_ID , A.EFFDT , B.SEQ_NBR , A.EFF_STATUS , B.CS_BIND_VAR , B.COMPARE_OPERATOR , B.VALUE_INTEGER , B.VALUE_CHAR FROM PS_CS_RULE_DTLS A , PS_CS_RULE_EXP B , PS_CS_QLIST_VALUES C , PS_CS_QUESTIONS D WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.SETID = D.SETID AND C.SETID = D.SETID AND A.CS_RULE_ID = B.CS_RULE_ID AND A.EFFDT = B.EFFDT AND C.CS_QUESTGRP = D.CS_QUESTGRP AND C.CS_QUEST_SEQ = D.CS_QUEST_SEQ AND B.CS_BIND_VAR = D.CS_BIND_VAR AND A.EFF_STATUS = 'A' AND ((B.VALUE_INTEGER = C.CS_INTEGER AND C.CS_INTEGER <> 0) OR ((B.VALUE_CHAR = C.CS_STRING_2 OR B.VALUE_CHAR = C.CS_STRING_5 OR B.VALUE_CHAR = C.CS_STRING_12 OR B.VALUE_CHAR = C.CS_STRING_30 OR B.VALUE_CHAR = C.CS_STRING_254) AND B.VALUE_CHAR <> ''))

CS_RULE_BIND_VW

(SQL View)

Rule - Binds View

SELECT A.SETID , A.CS_RULE_ID , A.EFFDT , B.SEQ_NBR , A.EFF_STATUS , B.CS_BIND_VAR , B.COMPARE_OPERATOR , B.VALUE_INTEGER , B.VALUE_CHAR FROM PS_CS_RULE_DTLS A , PS_CS_RULE_EXP B , PS_CS_QLIST_VALUES C , PS_CS_QUESTIONS D WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.SETID = D.SETID AND C.SETID = D.SETID AND A.CS_RULE_ID = B.CS_RULE_ID AND A.EFFDT = B.EFFDT AND C.CS_QUESTGRP = D.CS_QUESTGRP AND C.CS_QUEST_SEQ = D.CS_QUEST_SEQ AND B.CS_BIND_VAR = D.CS_BIND_VAR AND A.EFF_STATUS = 'A' AND ((B.VALUE_INTEGER = C.CS_INTEGER AND C.CS_INTEGER <> 0) OR ((B.VALUE_CHAR = C.CS_STRING_2 OR B.VALUE_CHAR = C.CS_STRING_5 OR B.VALUE_CHAR = C.CS_STRING_12 OR B.VALUE_CHAR = C.CS_STRING_30 OR B.VALUE_CHAR = C.CS_STRING_254) AND B.VALUE_CHAR <> ''))

SELECT A.SETID , A.CS_RULE_ID , A.EFFDT , B.SEQ_NBR , A.EFF_STATUS , B.CS_BIND_VAR , B.COMPARE_OPERATOR , B.VALUE_INTEGER , B.VALUE_CHAR FROM PS_CS_RULE_DTLS A , PS_CS_RULE_EXP B WHERE A.SETID = B.SETID AND A.CS_RULE_ID = B.CS_RULE_ID AND A.EFFDT = B.EFFDT AND A.EFFDT >= ( ( SELECT MAX(X.EFFDT) FROM PS_CS_RULE_DTLS X WHERE X.SETID = A.SETID AND X.CS_RULE_ID = A.CS_RULE_ID AND X.EFFDT <= %CurrentDateIn AND X.EFF_STATUS = 'A')) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable
Prompt Table: CS_BINDS_VW2

7 COMPARE_OPERATOR Character(3) VARCHAR2(3) NOT NULL Compare Operator
BTW=Between
EQ==
EX=Exist
GE=>=
GT=>
LE=<=
LK=Like
LT=<
NBW=Not Between
NE=<>
NEX=Not Exist
NLK=Not Like
Prompt Table: CS_COMP_OPR_VW

8 VALUE_INTEGER Signed Number(24,0) DECIMAL(23) NOT NULL Interger

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CS_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	t
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CS_BIND_VAR	Character(30)	VARCHAR2(30) NOT NULL	Bind Variable Prompt Table: CS_BINDS_VW2
7	COMPARE_OPERATOR	Character(3)	VARCHAR2(3) NOT NULL	Compare Operator BTW=Between EQ== EX=Exist GE=>= GT=> LE=<= LK=Like LT=< NBW=Not Between NE=<> NEX=Not Exist NLK=Not Like Prompt Table: CS_COMP_OPR_VW
8	VALUE_INTEGER	Signed Number(24,0)	DECIMAL(23) NOT NULL	Interger
9	VALUE_CHAR	Character(254)	VARCHAR2(254) NOT NULL	VALUE CHARACTER