FS_MAP_DTL_TBL(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_SRC_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Source Field
Prompt Table: FS_MAP_SRC_FLD |
| 4 | FS_MAP_SEQ | Number(5,0) | INTEGER NOT NULL | Sequence |
| 5 | FS_MAP_SRC_FLD_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
A=Pad B=Audit Trail C=Code Mappings D=DateTime E=Pattern F=Envelope Footer H=Envelope Header I=Runtime INFO L=Calculate M=Trim N=Concatenate P=Complex R=Related Field S=Sequence T=XLAT V=Constant X=Extract Z=Replace |
| 6 | FS_MAP_ACT_PRM1 | Character(254) | VARCHAR2(254) NOT NULL | Parameter 1 |
| 7 | FS_MAP_ACT_PRM2 | Character(254) | VARCHAR2(254) NOT NULL | Parameter 2 |
| 8 | FS_MAP_CALC_OP | Character(1) | VARCHAR2(1) NOT NULL |
Operator
D=Divide M=Multiply |
| 9 | FS_MAP_CALC_FAT | Number(9,0) | DECIMAL(9) NOT NULL | Factor |
| 10 | FS_MAP_CONST_VAL | Character(254) | VARCHAR2(254) NOT NULL | Constant Value |
| 11 | FS_MAP_RELT_PATH | Character(5) | VARCHAR2(5) NOT NULL |
Related Field
Prompt Table: %EDITTABLE3 |
| 12 | FS_MAP_RELT_FIELD | Character(5) | VARCHAR2(5) NOT NULL |
Related Field
Prompt Table: %EDITTABLE3 |
| 13 | FS_MAP_XLAT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
XLAT Type
L=XLAT Long S=XLAT Short |
| 14 | MAPPING_GROUP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Unique identifier for the mapping group.
Prompt Table: TR_MAP_GROUP |
| 15 | MAPPING_FIELD_NAME | Character(25) | VARCHAR2(25) NOT NULL |
Identifies the field being mapped.
Prompt Table: TR_MAP_HEADER |
| 16 | FS_MAP_UPPERCASE | Character(1) | VARCHAR2(1) NOT NULL |
Uppercase Source Field
Y/N Table Edit Default Value: N |
| 17 | FS_MAP_DTF_VAL | Character(30) | VARCHAR2(30) NOT NULL | Output Target Format |
| 18 | FS_MAP_EDIT_PB | Character(1) | VARCHAR2(1) NOT NULL | Edit |
| 19 | FS_MAP_OK_PB | Character(1) | VARCHAR2(1) NOT NULL | Continue |
| 20 | FS_MAP_CANCEL_PB | Character(1) | VARCHAR2(1) NOT NULL | Cancel |