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 |