| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SRCH_CONFIG_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Search Configuration ID
|
| 2 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 3 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFLD_LABEL_VW
|
| 4 |
REQUIRED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Book is Required
Y/N Table Edit
Default Value: N
|
| 5 |
HIDDEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hidden Flag
Y/N Table Edit
Default Value: N
|
| 6 |
PROMPT_EDITTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit
2=Prompt Table
3=Translate Table
4=Yes/No
5=Currency Controlled
Default Value: 1
|
| 7 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
Prompt Table:
SRCH_KEYREC_VW
|
| 8 |
PREREQ_FIELD_01 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prerequisite Field 1
Prompt Table:
RECFLD_LABEL_VW
|
| 9 |
PREREQ_FIELD_02 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prerequisite Field 2
Prompt Table:
RECFLD_LABEL_VW
|
| 10 |
PREREQ_FIELD_03 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prerequisite Field 3
Prompt Table:
RECFLD_LABEL_VW
|
| 11 |
PROMPT_TBL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt Table 1
Prompt Table:
RECDEFN_VW
|
| 12 |
PROMPT_TBL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt Table 2
Prompt Table:
RECDEFN_VW
|
| 13 |
RECNAME_LOOKUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Lookup Record Name
Prompt Table:
RECDEFN_VW
|
| 14 |
SEARCH_KEY_01 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prompt Table Search Key 1
Prompt Table:
RECFLD_LABEL_VW
|
| 15 |
SEARCH_KEY_02 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prompt Table Search Key 2
Prompt Table:
RECFLD_LABEL_VW
|
| 16 |
SEARCH_KEY_03 |
Character(18) |
VARCHAR2(18) NOT NULL |
Prompt Table Search Key 3
Prompt Table:
RECFLD_LABEL_VW
|
| 17 |
FIELDNAME_TARGET |
Character(18) |
VARCHAR2(18) NOT NULL |
Allocations Target amount field
Prompt Table:
RECFLD_LABEL_VW
|
| 18 |
SEPARATOR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Separator Bar
Y/N Table Edit
Default Value: N
|
| 19 |
SETCNTRLFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table:
RECFLD_LABEL_VW
|
| 20 |
REC_GROUP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Group ID
Prompt Table:
REC_GROUP_TBL
|
| 21 |
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
|
| 22 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
MESSAGE_SET_VW
|
| 23 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 24 |
ADVANCED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 25 |
SECURED_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Secured Field
Y/N Table Edit
|
| 26 |
SECURED_FIELDNAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Secured Fieldname
B=Business Unit
P=Pay Cycle
S=Setid
|