RPC_ELIG_TERMVW (SQL View)	Index Back
AAF terms info. for elig. rule View used to retreive AAF terms information for eligibility rules

RPC_ELIG_TERMVW

(SQL View)

AAF terms info. for elig. rule

View used to retreive AAF terms information for eligibility rules

SELECT a.SETID , a.RULE_ID , a.RULE_TERM_ID , a.RULE_TERM_OPR , a.RULE_TERM_EXPVALUE FROM PS_RB_RULE_ERT_TBL a WHERE EXISTS ( SELECT 1 FROM PS_RPC_ELIGIB_RULE b WHERE a.SETID = b.SETID AND a.RULE_ID = b.RULE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing rule id information

3 RULE_TERM_ID Number(31,0) DECIMAL(31) NOT NULL Field used for storing rule term id information

4 RULE_TERM_OPR Character(4) VARCHAR2(4) NOT NULL Field used for storing term option value
EMP=is empty
EQL=equals
INLS=is in list
NEMP=is not empty
NEQL=not equals
NINL=not in list

5 RULE_TERM_EXPVALUE Character(128) VARCHAR2(128) NOT NULL Field used for storing term expected value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Field used for storing rule id information
3	RULE_TERM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Field used for storing rule term id information
4	RULE_TERM_OPR	Character(4)	VARCHAR2(4) NOT NULL	Field used for storing term option value EMP=is empty EQL=equals INLS=is in list NEMP=is not empty NEQL=not equals NINL=not in list
5	RULE_TERM_EXPVALUE	Character(128)	VARCHAR2(128) NOT NULL	Field used for storing term expected value