| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
SRCH_CONFIG_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Search Configuration ID
|
| 3 |
SRCH_CRITERIA |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Criteria
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
Default Value: A
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFLD_LABEL_VW
|
| 7 |
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
Default Value: 0
|
| 8 |
FROM_MIXED_NP |
Character(50) |
VARCHAR2(50) NOT NULL |
Equal To
|
| 9 |
FROM_MIXED_P |
Character(50) |
VARCHAR2(50) NOT NULL |
Equal To
Prompt Table:
%EDITTABLE
|
| 10 |
FROM_UPPER_NP |
Character(50) |
VARCHAR2(50) NOT NULL |
Equal To
|
| 11 |
FROM_UPPER_P |
Character(50) |
VARCHAR2(50) NOT NULL |
Equal To
Prompt Table:
%EDITTABLE
|
| 12 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 13 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 14 |
FROM_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
From Amount
|
| 15 |
TO_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
And
|
| 16 |
VALUE_XLAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate Value
0=Null
|
| 17 |
IN_LIST_STRING |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL in list string
|
| 18 |
TO_MIXED_NP |
Character(50) |
VARCHAR2(50) NOT NULL |
To Value
|
| 19 |
TO_MIXED_P |
Character(50) |
VARCHAR2(50) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 20 |
TO_UPPER_NP |
Character(50) |
VARCHAR2(50) NOT NULL |
To Value
|
| 21 |
TO_UPPER_P |
Character(50) |
VARCHAR2(50) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 22 |
TO_NUMBER_P |
Number(15,0) |
DECIMAL(15) NOT NULL |
To
Prompt Table:
%EDITTABLE
|
| 23 |
TO_NUMBER_NP |
Number(15,0) |
DECIMAL(15) NOT NULL |
To
|
| 24 |
FROM_NUMBER_P |
Number(15,0) |
DECIMAL(15) NOT NULL |
From Number
Prompt Table:
%EDITTABLE
|
| 25 |
FROM_NUMBER_NP |
Number(15,0) |
DECIMAL(15) NOT NULL |
From Number
|