FS_MAP_TRAN_FIL

(SQL Table)
Index Back

# 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_TRG_FLD Character(5) VARCHAR2(5) NOT NULL Target Field

Prompt Table: FS_MAP_TRG_FLD

3 FS_MAP_GROUP_SEQ Number(5,0) INTEGER NOT NULL Group Sequence
4 QRYCOLUMN Number(5,0) INTEGER NOT NULL Column
5 FS_MAP_SEQ Number(5,0) INTEGER NOT NULL Sequence
6 FS_MAP_SRC_FLD Character(5) VARCHAR2(5) NOT NULL Source Field

Prompt Table: FS_MAP_SRC_VW

7 FS_MAP_SRC_FLD2 Character(5) VARCHAR2(5) NOT NULL Source Field

Prompt Table: FS_MAP_SRC_VW

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

Prompt Table: %EDITTABLE

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