RPC_ELIGIB_TERM (SQL Table)	Index Back
AAF terms info. for elig rules Record used for storing AAF terms information for eligibility rules

RPC_ELIGIB_TERM

(SQL Table)

AAF terms info. for elig rules

Record used for storing AAF terms information for eligibility rules

# 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