FS_MAP_FILT_VW

(SQL View)
 Index Back

SELECT FS_MAP_ID , FS_MAP_NODE , QRYCOLUMN , FS_MAP_SRC_FLD , FS_MAP_TRG_FLD , FS_MAP_LOGICAL_OP , fs_map_lparen , fs_map_exp1 , FS_MAP_EXP_DISP1 , QRYCRIT1TYPE , QRYOK , QRYCRIT2TYPE , QRYCANCEL , QRYPROMPTTABLE , QRYPROMPTTBLSELECT , QRYCRIT2PROMPT , QRYPROMPTNUMBER , fs_map_exp2 , FS_MAP_EXP_DISP2 , fs_map_rparen , FS_MAP_REAL_VAL , FS_MAP_COND_TYPE , QRYEDITCRITERIA , QRYADDCRITERIA , QRYCRIT2CONSTANT1 FROM PS_FS_MAP_FILT_TBL WHERE QRYCRIT2TYPE='PR'

# 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_SRC_FLD Character(5) VARCHAR2(5) NOT NULL Source Field
5 FS_MAP_TRG_FLD Character(5) VARCHAR2(5) NOT NULL Target Field
6 FS_MAP_LOGICAL_OP Character(4) VARCHAR2(4) NOT NULL Logical
A=AND
AN=AND NOT
N=NOT
O=OR
ON=OR NOT
7 FS_MAP_LPAREN Character(30) VARCHAR2(30) NOT NULL Left Paren
8 FS_MAP_EXP1 Character(254) VARCHAR2(254) NOT NULL Expression 1
9 FS_MAP_EXP_DISP1 Character(254) VARCHAR2(254) NOT NULL Expression 1
10 QRYCRIT1TYPE Character(2) VARCHAR2(2) NOT NULL Criteria Expression 1 Type
EX=Expression
FD=Field
11 QRYOK Character(1) VARCHAR2(1) NOT NULL OK
12 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
13 QRYCANCEL Character(1) VARCHAR2(1) NOT NULL Cancel
14 QRYPROMPTTABLE Character(30) VARCHAR2(30) NOT NULL Prompt Table
15 QRYPROMPTTBLSELECT Character(1) VARCHAR2(1) NOT NULL Select a Prompt Table
16 QRYCRIT2PROMPT Character(5) VARCHAR2(5) NOT NULL Criteria Prompt
17 QRYPROMPTNUMBER Number(3,0) SMALLINT NOT NULL Prompt Bind Number
18 FS_MAP_EXP2 Character(254) VARCHAR2(254) NOT NULL Expression 2
19 FS_MAP_EXP_DISP2 Character(254) VARCHAR2(254) NOT NULL Expression 2
20 FS_MAP_RPAREN Character(30) VARCHAR2(30) NOT NULL Right Paren
21 FS_MAP_REAL_VAL Character(254) VARCHAR2(254) NOT NULL Value

Prompt Table: %EDITTABLE

22 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
23 QRYEDITCRITERIA Character(1) VARCHAR2(1) NOT NULL Edit Query Criteria
24 QRYADDCRITERIA Character(1) VARCHAR2(1) NOT NULL Add Criteria to Query
25 QRYCRIT2CONSTANT1 Character(100) VARCHAR2(100) NOT NULL Constant Value