| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FS_MAP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Map ID
|
| 2 |
FS_MAP_NODE |
Character(220) |
VARCHAR2(220) NOT NULL |
Map Node
|
| 3 |
QRYCOLUMN |
Number(5,0) |
INTEGER NOT NULL |
Column
|
| 4 |
FS_MAP_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 5 |
FS_MAP_SRC_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Field
Prompt Table:
FS_MAP_SRC_VW
|
| 6 |
FS_MAP_TRG_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Target Field
Prompt Table:
FS_MAP_SRC_FLD
|
| 7 |
FS_MAP_LOGICAL_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Logical
A=AND
AN=AND NOT
N=NOT
O=OR
ON=OR NOT
|
| 8 |
FS_MAP_LPAREN |
Character(30) |
VARCHAR2(30) NOT NULL |
Left Paren
|
| 9 |
FS_MAP_EXP1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Expression 1
|
| 10 |
FS_MAP_EXP_DISP1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Expression 1
|
| 11 |
QRYCRIT1TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Criteria Expression 1 Type
EX=Expression
FD=Field
|
| 12 |
QRYOK |
Character(1) |
VARCHAR2(1) NOT NULL |
OK
|
| 13 |
QRYCRIT2TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Criteria Expression 2 Type
CC=Constant - Constant
CD=Current Date
CE=Constant - Expression
CF=Constant - Field
CN=Constant
EC=Expression - Constant
EE=Expression - Expression
EF=Expression - Field
ES=Effective Sequence
EX=Expression
FC=Field - Constant
FD=Field
FE=Field - Expression
FF=Field - Field
LS=List
PR=Prompt
SQ=Subquery
TR=Tree
|
| 14 |
QRYCANCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel
|
| 15 |
QRYPROMPTTABLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Prompt Table
|
| 16 |
QRYPROMPTTBLSELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select a Prompt Table
|
| 17 |
QRYCRIT2PROMPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Criteria Prompt
|
| 18 |
QRYPROMPTNUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Prompt Bind Number
|
| 19 |
FS_MAP_EXP2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Expression 2
|
| 20 |
FS_MAP_EXP_DISP2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Expression 2
|
| 21 |
FS_MAP_RPAREN |
Character(30) |
VARCHAR2(30) NOT NULL |
Right Paren
|
| 22 |
FS_MAP_REAL_VAL |
Character(254) |
VARCHAR2(254) NOT NULL |
Value
Prompt Table:
%EDITTABLE
|
| 23 |
FS_MAP_COND_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition Type
EQU=equal to
EQU-=not equal to
GRE=greater than
GRE-=not greater than
LES=less than
LES-=not less than
LIK=like
LIK-=not like
|
| 24 |
QRYEDITCRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Query Criteria
|
| 25 |
QRYADDCRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Criteria to Query
|
| 26 |
QRYCRIT2CONSTANT1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Constant Value
|