| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FO_SRCH_CRIT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Search Criteria ID
|
| 2 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RECDEFN_VW
|
| 3 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFLD_LABEL_VW
|
| 4 |
ORDERNO |
Number(5,0) |
INTEGER NOT NULL |
Sort Order
|
| 5 |
SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selected Flag
N=Not Selected
Y=Seleted
Y/N Table Edit
Default Value: N
|
| 6 |
FO_SC_CRIT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines the name of the field criteria that will show up in the search criteria.
|
| 7 |
FO_SC_EDIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines editing validation method.
Used in Search Criteria.
N=No Table Edit
P=Prompt Table Edit
T=Translate Table Edit
Y=Yes/No
Default Value: N
|
| 8 |
FO_SC_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Mass Change Comparison Operator. Can assume the following values:
=, >, >=, <, <=, Between, In, Is Blank, Is not Blank, Not =, Not in, Begins With, Contains.
BL=Is Blank
BT=Between
BW=Begins With
CN=Contains
EQ=Equal To
GE=Greater Than or Equal To
GT=Greater Than
IN=In
LE=Less Than or Equal To
LT=Less Than
NB=Is not Blank
NE=Not Equal To
NI=Not In
Default Value: EQ
|
| 9 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
RECDEFN_VW
|
| 10 |
FO_SC_BLD_IN_LIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Build In List Flag.
Used in Search Criteria.
Y/N Table Edit
Default Value: N
|
| 11 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 12 |
DECIMAL_POS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Position
|
| 13 |
PARENTFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 14 |
BASE_RECORD |
Character(15) |
VARCHAR2(15) NOT NULL |
Base Record
Prompt Table:
FO_SC_SRC_RCDS
|