EX_SRCH_OPRTS (SQL Table)	Index Back
Allowed operands by field type This record is used within the Summary Approvals and Modify Approved Transactions components.

EX_SRCH_OPRTS

(SQL Table)

Allowed operands by field type

This record is used within the Summary Approvals and Modify Approved Transactions components.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

2 SRCH_OPERATOR Character(4) VARCHAR2(4) NOT NULL Allowed logic operator by field type
!IN=not in
0=All Values
1=equal to
2=less than
21=before
3=greater than
31=after
4=less than or equal to
41=on or before
5=greater than or equal to
51=on or after
6=between
7=begins with
8=contains
9=in
<=<
<==<=
<>=not =
===
>=>
>==>=
A=not in
B=not equal
BEG=begins with
BTWN=between
IN=in
LIKE=contains

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
2	SRCH_OPERATOR	Character(4)	VARCHAR2(4) NOT NULL	Allowed logic operator by field type !IN=not in 0=All Values 1=equal to 2=less than 21=before 3=greater than 31=after 4=less than or equal to 41=on or before 5=greater than or equal to 51=on or after 6=between 7=begins with 8=contains 9=in <=< <==<= <>=not = === >=> >==>= A=not in B=not equal BEG=begins with BTWN=between IN=in LIKE=contains